Monday, December 13, 2010

Week-15-CRM

13/12/2010

Got feedback from David. Done one part alteration.
Got all the print out of the Reports

Monday, December 6, 2010

Week-14-CRM

12/12/2010

I have finished all items of the User manual.
Done something on Documentation. And updated the testing result report respect to the supervisor advise. Added feasibility testing in system testing.
spent 8 hours.


11/12/2010

i Continued on User manual.
And i realized that i needed to change the format of the images.So i changed.
And in testing Result report, i used Testing interface part which is from design report.
spent 7 hours.

Publish Post

10/12/2010

I started to do User manual. Actually this has Case function as well.
So today i finished all functions which are involved with Case.
And Finished the reminder functions.Then started to do the Event page.
Event page is special page. Because it has only One page. And it use models.
So i used same technique to explain that how to use it.
spent 10 hours.


09/12/2010
Today i didn't do anything.We had a picnic.
I got a off day.
spent hours 0.


08/12/2010

Done Continue User Manual report.
User Manual is too long. Because of our CRM application has too many pages and functions.
So i decided to finished Client page at first.
So in there i need to capture long screen shot.
And i try to use a full screen shot capture software.
But it is gonna be new to me.
So i use Microsoft paint tool.
i realized that need good number system. Because of i need Sub numbers.
And there are some rotations with some pages. For that i just mentioned the page numbers to refer for repeat stuff.
Spent 10 hours.



07/12/2010

I continued to complete the Review procedure. asked from one of mate who done the documentation.
And i finished some of section of the documentation. Then we gone for the feedback of supervisor for the reports, we done so far.
I have known that need to both User manual and technical manual reports.
Spent 8 hours.

Monday, November 29, 2010

Week-13-CRM

06/12/2010

I continued doing documentation report.
I struggled to do Document check list for review procedure.
I have did documentation Plan.
In there i used preparation and Submit of report. For preparation used total hours of all the procedures involve with each report.

And Today i spent 8 hours

05/11/2010

I tried to researched more for complete the TestingResult report. And for Error report i used the test case details.
I full filled some parts of the report.
I started the Documentation report. It is so difficult to do many things are coming as new.
Today i spent 8 hours


04/11/2010


Started to do the documentation. So actually i have less idea about the documentation. So i referred the report which have to complete by myself.
And my job is TestingResult report and documentation of reports.
So i researched from internet for making reports.
i tried to referred other reports elements as well.Because of testingresult report and testplan has close relationship.
And Today i spent 8 hours


03/11/2010

Today we done our marvelous presentation.Our each contribution vast enough.
Actually our presentation structure is
  • First explain about Project team and client,
  • technology tools we used,
  • and Real system,
  • Final part is that what we got from the project.Acknowledgment.
We got good feedback from the Supervisors panel.And ask about the Invoice page Total after add discount.
And i spent 7 hours


02/11/2010

Even final day we got some bugs.Tried to fix those which are relate each other like a web.
I tried to use activity structure for track each needs for each sub function.
Anyway we got rehearsal presentation in front of david.
So i got good feedback. he told me that i need more confidence. and ask why you have less confidence.because you done good work.
And Today i spent 10 hours


01/12/2010

I learned how Firefox SQL Injection for the Testing.
I gone through the documentation. because i have documentation and testing report.
And i tried to do many rehearsals of presentation.
I revealed that i less confidence and small voice. I believed that i need to make voice louder and do religious work before leave the home before the presentation.

And Today i spent 9 hours

30/11/2010


Today we got some trouble with internet connection for the server which we gonna use.
As other group we also postponed the presentation to Friday.
i done some error fixing.These are coming from auto post back.Because i tried to update the amount text box in description part by calculation which is in Timesheet portion. But it given error when we insert value in Amount,it auto post back and again need to insert. So i did set auto post back as false .
And i got some trouble from null value of GST and Discount values. We decided to use default value as 0.

And Today i spent 8 hours


29/11/2010

I have done testing on View Invoice Page.Because of i got some errors when it retrieving from database (Invoice detail table).
So tried to solve problem testing by using another grid view. It got same error.
At last i changed the version of program and data base.
I changed some store procedures.Some store procedures are new.
I done rehearsal for presentation with using script.
Actually i got extra topic which is Reminder page. So i need to go through that thoroughly.
Altogether i gone do Super Accountant activities.

And Today i spent 10 hours

Tuesday, November 23, 2010

Week-12-CRM

28/11/2010

  1. Have done Invoice system Test case as well as payment system Test case.In Payment function also i used the Expression validator. And i used the calender to use for select the date for payment date.
  2. In Payment form strongly text payment amount and Bank reference No text box.Because it allow to use Slash mark and dot which are symbols.
  3. In Payment Top page i found the table which show incomplete Invoice details.And it has Paid date. But when invoice create it has not any paid date in the Invoice table.So List does not show which has null value. So i had overcome by using grid view column property called NulDisplayText as "N/A".
  4. After that i got almost finished Invoice system and payment tracking system


27/10/2010

Today Done the Testing for Invoice System.
It done using Updating TimeSheet.Actually i used the Dat Table For keep the TimeSheetID and after confirm it goes to database and InvoiceFlag of timeSheet goes to true.
So it use session keep the Data table .


26/11/2010

Done Test case for each input items. Some time i used new validation.Actually it is expression validations.
For search client in Invoice page, with out input it shows every client.We think it is more convenient for the user.
Other thing is i succeeded the add the selected timesheetID to data table.But still doing coding for remove the TimeSheetID when uncheck.
I finished the testing for Top page of Invoice system,


25/11/2010

Today i done extra coding for TimeSheet updating.i used the data table keep the TimesheetID.
But when it unchecked it not remove from the data table.

Started to do the Test case document.But it not too easy.
Because of we need to finish all the stuff by next week.that is our target.
And i checked the SQL Injection.So there is a add-on tool in FireFox.So i tried it.It give result for each testing element.
This is the link.

https://addons.mozilla.org/en-US/firefox/addon/7597/


24/11/2010

I have done the all errors.Even come back from confirm page to create page for purpose of edit data it works.
Basically i use the class for transfer the data to confirm page and when come back to create page it use the session and same time i need to remove the sessions which are use in create invoice page.
I started to work on updating TimeSheet when it using.So still i 'm doing these coding.
And i doing coding for auto complete feature for the Search text box.

23/11/2010

I done the Testing part for the Invoice page.there were some conflicts.
Because of i use Class parameters and session.
Some time i need separate and sometime both.
So at first done normal floor.That's mean with out Edit button.And Even for that i got some trouble from coding because i changed the structure.
I realize some sessions going to assign to the control and just after that sessions going to null value...



22/11/2010
Used This link for count the sum of specific columns;

http://programming.top54u.com/post/ASP-Net-DataTable-Compute-Column-Sum-using-C-sharp.aspx

I used the coding for compare the date as below;
if (DateTime.Now < Convert.ToDateTime(txtIssueDate.Text))

And i realized i need two labels for same values.One for calculating purpose and other is display purpose.
I tried to finished main functions of invoice..But still remaining time sheet update.

Monday, November 15, 2010

Week-11-CRM

22/11/2010
Used This link for count the sum of specific columns;

http://programming.top54u.com/post/ASP-Net-DataTable-Compute-Column-Sum-using-C-sharp.aspx

21/11/2010

Today i succeeded the remove function for the Data table.
So this is the coding,

DataTable Table = (DataTable)Session["Table"];

DataRow row = Table.Rows[0];
Table.Rows.Remove(row);

Table.AcceptChanges();


Then i check functionality of each elements further.
After that i realized that even after remove the all rows of the description table, SubAmount has previous value. So still work on that.
And i got the coding to change the Amount value into currency value when i use the label for display.
And I tried on after edit button keep all the records as it is.Only check box doesn't get the value.
I think it is in panel and those have complex coding.So still doing on that.



20/11/2010

Today also done testing part of the Payment page and Invoice page.
In Testing got many faults as usual.
And i have error in address choosing table. Because i need to pop up the each address each choosing.
So i used the separate USP. And it has validation when user create invoice form.
And i changed the elements of confirm page.
Besides that i used the Ajax tools for choosing dates and type correct data format.
And there are many panels use for controls to visibility of the elements.
Then i used the function check the insert Invoice No is available or not.That is doing by Availability button.

19/10/2010

Done unit testing for each sub functions of Payment and Invoice.
  1. At first i got some trouble of EDIT button.because of when user needs to edit the Invoice form,he needs same previous values to edit.But i did not get the all values like details description and sub amount.
  2. And Issuedate.Issuedate i use as default value current date. So even user change the current value to desired date, in the Invoice confirm form get the current date value.
  3. Last element of the invoice is confirm button. So it has long store procedure and it giving some error in coding for execute .



18/11/2010

I started the rearranged the Invoice page as well as Payment page.
So in Invoice Page i have Invoice form for print purpose and PDF format. So i use the one main table to group all the elements. Otherwise all are scatted in everywhere.
I got some advise from the Tokio for beautify the each page.That's mean i have a good structure.
So i need to use main topics in top page.Then other are going as links.

17/10/2010

Today i done final coding for the payment and invoice functions.So i realized now i achieved the real client requirements.
But i got some difficulties in Sql statements.Because i need the data from two tables. i resolved using Right join statement.
Actually i focused on page designed as well.
And i doubt about the panel. I used the panel for GST flag, Discount.After visible changed to false in property.It is not visible permanently in Design page.
Still didn't get the result.
And also we can't use one Update panel for whole the elements


16/11/2010

Today while doing design on the Invoice page.suddenly changed the size of date sources and script manager box.I tried my best. even my mate Reiko couldn't find the solution.
So i again checkout from the subversion.Done the coding again using previous version.
I used the class for Create Invoice page and confirm invoice page.It is easy to handle the coding well.
When i executed it getting error from the coding which are Invoice detail data table.
I realized the reason of the error.Because of the method for create the data table has been removed. So i fixed it.

15/11/2010

  1. I done most of the Payment function.And i got one problem which is data binding.But in the page i hadn't any data binding. So then we found that previous setting one drop down list got past setting.So i chosen the data source.
  2. In the Invoice pages i changed the front page use the search function for client. And i rearranged the elements of the Invoice template.
  3. We done client meeting in client desk. Basically we discussed my work. I got got response.Actually he need to input payment details for selected invoices.

Tuesday, November 9, 2010

Weeh-10-CRM

14/11/2010

I got my mates from the Library. And Tokio suggested me to changed the idea of payment function.
So it gonna be only a form for the payment details and it show the updated payment balance basically.
But there are coding for the select the old invoice to check as complete.
So in the evening i done up to crucial part.
Still i have some trouble with the design of the Payment page.
And redesigned the invoice form with invoice format which is finalized by the group members


13/11/2010

I done the Payment page with using the grid view to do the manual selection for each payment.
And final output comes on labels which are relate to Payment Balance,Invoice payment status like whether invoice is paid completely or partially.
I designed the Invoice form for the Invoice page. And i expect to use the different page to show the PDF page.So it would be easy.


12/11/2010

I changed my mind that working with updating grid view which has data bind.
Because of it is like impossible rebind the data.
So i decided to do the updating Pay invoice grid view details with using coding.
I done the coding almost,which involve with updating.
I focus on the payment and respect to that update the invoice table details and update Client payment balance.


11/11/2010


Today i started to design the pages with using my draft.There were many alterations.Because this should be matched with the client requirements. Some times i got some idea from the Tokio.
So now i implementing Invoice list,Create Invoice and Confirm Invoice Pages.
In Confirm Invoice Page i have the Invoice form which has Invoice details and Tax payer details.
Any way i need some extra information from the client for verify some items of the Invoice functions.
So i expect to go for the client meeting tomorrow.


10/11/2010

Done the Payment function with remaining Grid View.Still need to complete last step.
But i need focus on other stuff.So i started the design of Invoice function.
Basically there are three pages.That's mean i need much coding than the payment function.
So at first i transferred the coding and design what i did in previous version to new version.
So i draft rest of other items.



09/11/2010

Today i started to worked on the new version of the system.We are using subversion software to deal with all our system versions.
And i realized i can use the data table for the payment page.when i need to transfer the selected items to another table.
So using the data table i bind the details with new grid view.But i need to update the this details which are bind with the grid view.
So currently i am researching for this matter.



08/11/2010

I still worked on the payment page.Because of that much it is difficult to understand the process of the real payment.
And i changed my first idea. And got a advice from my mate.
Besides that i knew that i need an associate table between invoice table and payment table.
Because of one payment may has many invoice amount and also one invoice has many payment.
So i tried to do the payment page with using two Grid view tables.when user select the invoice it goes to payment table. Then there is the confirm feature.

Monday, November 1, 2010

Week-09-CRM

06/11/2010

Today i done the payment page.Still i have no clear idea about their payment.
So i thought some setups. And So my logic is first search by client name,client IRD or Invoice no.
Then show the invoice detail which is not completed.
As an option show the all payment which are relate to particular client.
s do this i done dummy data and table structure for the payment.Done the coding for the isert payment details.

05/11/2010

We discussed about the ER Diagram.
So we decided to continue the work for finishing function.And i am creating payment page.
So i try to use the gridview for show the payment records for each client.And use the lightbox
for the insert form.
For the report function i go to use the same PDF function with more improvements.
And invoice page i am doing to use format for the create invoice.
04/11/2010

At very first i done the Log out function with my mate after more effort.Because of i have referred more coding to handle the cache and session, but never succeeded.This time we got key coding.
And i updated the Invoice page with using some details.
In the evening, we got the client meeting.There we showed our each work.John mention some suggestions which are different what we thought. Because of last time we got the client meeting with the Sherli. And she have got different mind than him.Anyway he appreciated us about the system.
So after meeting i finished the client meeting for tomorrow discussion among the project team.


03/11/2010

Today morning i started the coding for the Pdf function and print function for the invoice.
So completed the invoice page for prototype.
And i focused on the login function.got some advise from the mate and reviewed what i done so far in the login function.Then i realized that every page need to clear the Cache. And every page except login page,need to check whether has the session or not. If has not redirect to login page.
But thing is i need to refresh for every time.
So i need further solution.


02/11/2010

Finally succeeded the grid view of client invoice list, which use drop down list to choose the year and month.And use the button for the redirect to the create invoice for the particular user's..
according to the client, TimeSheet table also get the vale.Create invoice only get the value of the user's strongly
In create invoice page,we need the contact person or not...
In the create page i use the session for clientID show client name
And in the form we need to use the predefined the rate for the client .Still not confirm.S needed to confirm from the client side


01/11/2010

In the morning i tried to solve the checkbox issue and finally succeeded.So i can use the check box using select all function.And same time total hours going to change respect to the checked checkbox.
And i done coding for the client invoice list with using drop down list.that's mean respect year in drop down list client list gonna be changed.but when i use store procedure for that in the client list gridview, it can not show in the page.I need to solve it.
And we got the group meeting in the morning.we discussed about the Client contact in the
ER Diagram.In our project Mt.Roskill accountant sort out every thing by the client name.And in the business they never use many contact channel.So depend on the business denormalization is suited.
And supervisor asked us that better thing is not do the presentation.So we are not going to do.
finally i done the meeting minute for the group meeting.