Week-08-CRM

31/10/2010

I done the coding for use the check box in the TimeSheet.
I have got the select all function also.
Whatever you select it show the total hours of selected date.but when use the select all check box it shows nothing.That is the problem i got recently.
So I try to solve that.And i think about the structure have to use in the invoice page.

30/10/2010

I done the TimeSheet with using check box.But didn't finalized because of still i need to think about the function requirements.Any way i will try to do that.Because of we need to show our suggestions about the TimeSheet.TimeSheet is very much useful if are there many employees.
So i have create invoice page which has create invoice form and TimeSheet(as a reference for the create invoice and able to tick).
One thing is i used new master page.because of i need equal width of content holders.



29/10/2010

I again started to do the Invoice page.And i created the table for TimeSheet for show the date and end time, start time and total hours of particular event.
I need some SQL statements (SP) for get the total of total hours and current duration of all the events.So i need to get first row 'date' column value and last row 'date' column value.
i used select option in twice in same store procedure.But it didn't given the two values.
So i used output parameters.that also didn't work.
So i needed to research that one.
In the evening we got our group meeting with the supervisor.And we have got valuable advice about the IT life and how to the Project strongly.

28/10/2010

Today i done the my invoice page using light box. But could not work at first. So again i checked it and realized i should not change the css properties of the light box.
And used two drop down lists in the create invoice form. And i tried to use first drop down list selection effect to the next drop down list.It has some asp.net properties.So my mate has helped me to archive it.
And i tried to use the PDF function in the invoice page. But it doesn't work.


27/10/2010

I done the logout function. But still have some issues with the function.
And i started to work on Invoice page.So i done Two pages using grid view and light box.
But i need to use the check box for the grid view.So i need some research for that.


26/10/2010

In the morning i prepared for the presentation.So i got first part of the presentation.
Which is about the page of client for the accountant.i need to explain client detail management and case with the case history.
We done the presentation secondly.So i felt that i didn't get good voice.So i need to increase the voice next time presentation.
And after presentation i got new task which is a work on Invoice.Rest parts are implement the back button,PDF function for crucial functions which need that.


25/10/2010

I worked on Store Procedures for the prototype system.
And i did understand that with out html pages.
So i refereed the mates work.And i created the Store procedures fro class as well.
Then i tried to attached the PDF function in the Client home page. But i realized it's not show the table border.So i need to solve it.
Other thing is login function.In login function,when go to log out,using back button can't go back.
but even after login back button doesn't not work.So i have tried on that.

Week-07-CRM

24/10/2010

Today i started to continue Store Procedures for Client page functions.
i refereed the client page view for create the Store Procedures.
I done the join store procedure for Case details and Case history.And my mate has helped me.
i refereed the dummy data for checking purpose.
Tried to understand the Jquerry which are used in the application.


23/10/2010

I done the Store procedure for the login function for both users client and accountant.
and Forgot Password function for both users.
I used dummy data for the table.because i need the dummy data for build my store Procedures.
Then i tried to continued to do the Store procedures for client side functions like client list,client detail and case detail.


22/10/2010

Today in the morning again i started to fix the asp.net problem.
finally i asked my mate for help.Then she also reinstalled the software but couldn't solve it.Then so he checked the host system file.It has changed the localhost address to 0.0.0.0. So we changed it to 127.0.0.1 , then problem is solved.
After that i tried to do the PDF function for the panel.at first i used the AJAX update panel.It didn't work.because of the AJAX is a client side control.So i used the panel control which is in standard tool.So i succeeded.
But i need some extra coding for giving more usability.
At 6.00 pm we got our group meeting with the supervisor.We finished that at 6.30 pm .we realized what are things we need to achieve.

21/10/2010

Today i tried on the PDF converter.So i spend whole the morning for the function.
finally i succeeded the PDF function.
There i use itextsharp latest version x.504.but asp.net support only past versions.
So i used x.401 version itextsharp.
After that i try to use this function with panel.but asp.net debug suddenly broken.So i have to fix this problem tonight doing re-installation.


20/10/2010

Today i worked on searching the PDF converter function. It has to use a object for the convert the html or report to PDF format.
So there is itextsharp application.So i try on that for making the PDF function.
and search a javascript function which can help for the PDF asction.
And i changed my operting system to windows 7 professional.because of some errors occured on previous operating system.



19/10/2010

First i finished the meeting minutes for the yesterday group meeting.
And i worked on the coding for the print report function.actually there is a print function in the report viewer control.but it can use only in IE browser.
And i try to search coding for separate print function.but very difficult to find that kind of examples.
in the afternoon we got our presentation.we doe as our supervisor said.And got many comments from supervisors.Their suggestions mostly came from invoice,reminder,case and timesheet.So i kept the records of the comments.After finished the presentation,we reviewed the ER Diagram with using my records.
Finally i tried to use JavaScript.But that function from the JavaScript is just a print function for print the page view.But we need to print specific report.


18/10/2010

Today we reviewed about meeting agenda before the client meeting.
And we have met client at noon.we asked questions which are mostly related to the invoice, Function list and UserID.
After that meeting came back and done the meeting minutes.Again discussed about the presentation flow.
And we participated to the group meeting with supervisor.So he asked us to just explain the ER Diagram same time distribute the ER Diagram and ask about comments from the audience.If any question relate to the UML diagrams then only go to explain the UML diagram.otherwise presentation make audience be fed up.
So we finalized to do the presentation with only ER Diagram and confirm the ER Diagram first.

Week-06-CRM

17/10/2010

Today we discussed about the presentation.i got doubt about the sequence diagram for the create new case history. Because of after display case list we need to choose the the case.
Again updated the ER Diagram by adding the active flag for each table.because of we have deactivate option for each function.Put send email flag in the reminder table
Then i realized still we have no idea about the report table.so i removed it from the Class diagram.and put client type in to different table but not in generalization.
Finally we decided that i do the presentation, first at the sequence diagram for the create new case history. Then explain about the class diagram.So i done the script for my role.



16/10/2010

I have worked on the print report function.and help of my mate, i solved the problem with footer and the report window.We used same height for each item.
We have done the basic template for invoice.There is function called "accountant can refer time sheet to create invoice". I thought that idea is good,but we need another way to explain the function.So it will be changed by Tokio.
we discussed that issue the invoice depend on the client contract.In the invoice page template we use drop down list for the month.So we can use every invoice of the client choosing the month.
I mentioned that View time card function for not only individuals but also system admin.So here we need a assumption that system admin is the employer and he is doing calculating the salaries.
In the presentation i have chosen class diagram and sequence diagram.Because of i need to familiar with these UML diagrams.
I got rough idea about the diagrams.But i think it is not enough for the presentation.So i must prepare the slides and script well.


15/10/2010

Today i started to reveal the report function.and i got a tool called firebug from my mate.i think i can use it for that.And we discussed about the sequence diagram.
And i didn't get the idea about the interface.after discussion i knew that interface means web browser and web server.
At 5.00p.m we got group meeting with supervisor.And we got good feedback from him.And he asked us to do advanced approach.specially asked me about coding progress.So told him i already done login function and now i focus on print report.
He mentioned about next face called "testing" too.ask us to ready for that like preparing test case template.
After finished the minute minute.I done the document for that and asked my mate to checked that.then i have kept in share folder.
And i installed CS5 for web design purpose.

14/10/2010

Today i followed many suggestions which are from the internet research.So i used name spaces like System.Drawing Microsoft.Reporting.winforms.
But still not solved.So i think it is the problem with CSS file.
Anyway i continued to do on print report function.So i need the extra coding for activate print function in the report.So i have used external c# coding there.So it is under construction.
Discussed about the presentation and done coding for the print report function.


13/10/2010

Worked on coding for the login and Researched the print report function.
Then i revealed that also embedded in the ASP.NET and it has report function, export as a excel, PDF and print features.
But i got one issue with the function.Because of when i use the report control that report going through the footer.that's mean report is going behind the footer.
So sill i try to mitigate the problem.
Then done the discussion of use case diagram for actors.
And updated the ER Diagram.

12/10/2010

Specially i researched login function and i found that ASP.NET has embedded login function which has authentication.But it didn't work.Then i refereed the ASP.NET video tutorial.So i changed the authentication from windows to form in web config.
And the function it use cookies.So i realized we don't want the remember me function.anyway i implemented that also.
i drafted other tasks for the search and print report.

Week-05-CRM

11/10/2010

We done our discussion about the ER Diagram.And we got our group meeting with the supervisor.
In there i got the answer for the UserID.It must one UserID for particular Client unless he has different accounts for his business.
And supervisor mentioned the address table may expand to some tables.But i think that is depend on the client requirement.So we gone ask from the client meeting.
We realized from the supervisor that member name must be in full. And logo name must be in front page without in the footer.
After that i done the meeting minutes for the group meeting.Decided our individual tasks of the system implementation.


10/10/2010

Today i got the doubt User-ID must be one or many for the client.So we put that issue in to the meeting agenda for the group meeting.
we done discussion for the Email reminder and created the drafts for activity diagrams and done the templates of email reminder.So we used every possibilities.that's mean in there we can use either existing reminder template or new reminder template.Because we think that way has good usability.
And did works with JavaScript.

09/10/2010

we discussed the activity diagrams and template for the tax case update and delete functions.And about the reminder for the case history.
Besides that i got some issues in ER Diagram.That is whether Time-sheet is independent or dependent from the case history.So i finalized with the members that Time-sheet must be connect to the Client table and we need Client-Taxtype associate table for mention the contract.
And for any reopen of the case must be a amendment which is use new case.
i done java script excise for practice.


08/10/2010

We given our ER Diagram and UML diagram and Meeting minutes to supervisor to check.
and we continued the activity diagram for the manage the client and done relevant templates concurrently.
But i got some doubt about the flow of the activity diagrams specially in the order of search client and create event,So i resolved by discussed with mates.So have activity diagrams for the Client details and Events.



07/10/2010

i got the college at 12.30 p.m. So i done the practice on the JavaScript.After the lunch we got our discussion on the activity diagram of Search function and the Event list using the updated ER Diagram and we finished it at 4.30 p.m.And we discussed the UML class diagram.So there are composition,aggregation and generalization.So we confused about the generalization and composition.Because they are very much similar.So we expect more idea.So we searched the public drive for some resource.
Then we got rough idea about the class diagram about the system.At 18.15 p.m i left from there.

06/10/2010

In the morning we reviewed the things which we gonna ask from the client.and we have got the client meeting .And i got draft about the meeting .
Basically client agreed with our templates and we got some restrictions must be in the system.
I came back to the college then wrote the client meeting minute.
And we got deep discussion about ER Diagram.but also Search function.tomorrow gonna do on UML diagrams .

05/10/2010

i prepared for the presentation.and we done many rehearsal.by the time we got our chance and done the presentation.but it got less figures in the slides.So i struggled to continued my speech.anyway our time was over.
And we done small meeting with the supervisor.And we determined to use mainly ER Diagram
and other UML diagrams.Tomorrow we will do the client meeting in the morning.Hopefully we will solve our issues with the client.

04/10/2010

First-day of the week so we done our own task to make sure it's finished or not.i done my work on slides for presentation.
And we got the meeting with Supervisor. After his comments about presentation.we changed our structure and we explain with using paper prototype and template.Today i started to do the meeting minutes instead of doing Gantt Chart.