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.