//this method is used to show the report.
protected void btnShow_Click(object sender, System.EventArgs e)
{
Purchase = new ArrayList();
Sales = new ArrayList();
Payment = new ArrayList();
Receipt = new ArrayList();
PartiesClass obj = new PartiesClass();
obj.DateFrom = GenUtil.str2MMDDYYYY(txtDateFrom.Text);
obj.DateTo = GenUtil.str2MMDDYYYY(txtDateTo.Text);
string str = obj.FatchCancelPurchaseInvoice();
if (str != "")
{
string[] strPur = str.Split(new char[] { ',' }, str.Length);
for (int i = 0; i < strPur.Length; i++)
{
Purchase.Add(strPur[i].ToString());
}
}
str = "";
str = obj.FatchCancelSalesInvoice();
if (str != "")
{
string[] strPur1 = str.Split(new char[] { ',' }, str.Length);
//10.07.09 for(int i=0;i<strPur1.Length;i++)
for (int i = 1; i < strPur1.Length; i++)
{
//10.07.09 Sales.Add(strPur1[i].ToString());
string sales_inv = strPur1[i].ToString();
if (sales_inv.ToString() != "" && sales_inv.ToString() != null)
{
sales_inv = sales_inv.Substring(3, (sales_inv.Length) - 3);
}
Sales.Add(sales_inv.ToString());
}
}
str = "";
str = obj.FatchCancelPaymentInvoice();
if (str != "")
{
string[] strPur2 = str.Split(new char[] { ',' }, str.Length);
for (int i = 0; i < strPur2.Length; i++)
{
Payment.Add(strPur2[i].ToString());
}
}
str = "";
//10.07.09 Comented by vikas str = obj.FatchCancelReceiptNo();
str = FatchCancelReceiptNo1(); //10.07.09 Add by vikas
if (str != "")
{
string[] strPur2 = str.Split(new char[] { ',' }, str.Length);
for (int i = 0; i < strPur2.Length; i++)
{
Receipt.Add(strPur2[i].ToString());
}
}
Flag = 1;
/*SqlDataReader rdr = obj.GetRecordSet("select receipt_no from Payment_receipt where subreceiptno='Deleted' and cast(floor(cast(cast(receipt_date as datetime) as float)) as datetime)>='"+GenUtil.str2MMDDYYYY(txtDateFrom.Text)+"' and cast(floor(cast(cast(receipt_date as datetime) as float)) as datetime)<='"+GenUtil.str2MMDDYYYY(txtDateTo.Text)+"' order by receipt_no");
* if(rdr.HasRows)
* {
* while(rdr.Read())
* {
* Receipt.Add(rdr.GetValue(0).ToString());
* }
* }
* rdr.Close();*/
}
