private void BtnViewReport_Click(object sender, EventArgs e)
{
try
{
// strfinalarray = new string[LVDayBook.CheckedItems.Count];
for (int i = 0; i < LVDayBook.Items.Count; i++)
{
if (Convert.ToBoolean(LVDayBook.Items[i].Checked) == true)
{
if (LVDayBook.Items[i].SubItems[1].Text == "Sale")
{
rewritedata = "True";
string[] strfinalarray = new string[5] {
"S", "D", "Sale", "S", ""
};
DataTable dt = conn.getdataset("select b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,sum(b.totaltax + isnull(bc.sgst,0)+isnull(bc.cgst,0)+isnull(bc.igst,0)) as totaltax,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt,b.ClientID from billmaster b left join Billchargesmaster bc on bc.billno=b.billno and bc.isactive=1 inner join clientmaster c on c.clientid=b.clientid where c.isactive=1 and b.isactive=1 and b.BillType='" + strfinalarray[0] + "' and b.Bill_Date>='" + Convert.ToDateTime(DTPFrom.Text).ToString(Master.dateformate) + "' and b.Bill_Date<='" + Convert.ToDateTime(DTPTo.Text).ToString(Master.dateformate) + "'group by b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt,b.clientID order by b.bill_date asc");
for (int j = 0; j < dt.Rows.Count; j++)
{
try
{
String str = dt.Rows[j]["billno"].ToString();
DataTable dt1 = conn.getdataset("select * from FormFormat where isactive=1 and type='" + strfinalarray[0] + "' and setdefault=1");
DefaultSale bd = new DefaultSale(master, tabControl, strfinalarray);
// Sale p = new Sale(this, master, tabControl);
if (dt1.Rows[0]["formname"].ToString() == bd.Text)
{
bd.updatemode(str, dt.Rows[j]["billno"].ToString(), Convert.ToInt32(dt.Rows[j]["ClientID"].ToString()), strfinalarray);
master.AddNewTab(bd);
bd.BtnPayment_Click(sender, e);
master.RemoveCurrentTab();
}
}
catch
{
}
finally
{
}
}
}
else if (LVDayBook.Items[i].SubItems[1].Text == "Sale Return")
{
rewritedata = "True";
string[] strfinalarray = new string[5] {
"SR", "C", "SaleReturn", "SR", ""
};
DataTable dt = conn.getdataset("select b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,sum(b.totaltax + isnull(bc.sgst,0)+isnull(bc.cgst,0)+isnull(bc.igst,0)) as totaltax,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt from billmaster b left join Billchargesmaster bc on bc.billno=b.billno and bc.isactive=1 inner join clientmaster c on c.clientid=b.clientid where c.isactive=1 and b.isactive=1 and b.BillType='" + strfinalarray[0] + "' and b.Bill_Date>='" + Convert.ToDateTime(DTPFrom.Text).ToString(Master.dateformate) + "' and b.Bill_Date<='" + Convert.ToDateTime(DTPTo.Text).ToString(Master.dateformate) + "'group by b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt order by b.bill_date asc");
for (int j = 0; j < dt.Rows.Count; j++)
{
try
{
String str = dt.Rows[j]["billno"].ToString();
DataTable dt1 = conn.getdataset("select * from FormFormat where isactive=1 and type='" + strfinalarray[0] + "' and setdefault=1");
DefaultSale bd = new DefaultSale(master, tabControl, strfinalarray);
// Sale p = new Sale(this, master, tabControl);
if (dt1.Rows[0]["formname"].ToString() == bd.Text)
{
bd.updatemode(str, dt.Rows[j]["billno"].ToString(), 1, strfinalarray);
master.AddNewTab(bd);
bd.BtnPayment_Click(sender, e);
master.RemoveCurrentTab();
}
}
catch
{
}
finally
{
}
}
}
else if (LVDayBook.Items[i].SubItems[1].Text == "Sale Order")
{
rewritedata = "True";
string[] strfinalarray = new string[5] {
"SO", "D", "Sale Order", "SO", ""
};
DataTable dt = conn.getdataset("select b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,sum(b.totaltax + isnull(bc.sgst,0)+isnull(bc.cgst,0)+isnull(bc.igst,0)) as totaltax,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt from SaleOrderMaster b left join SaleOrderchargesmaster bc on bc.billno=b.billno and bc.isactive=1 inner join clientmaster c on c.clientid=b.clientid where c.isactive=1 and b.isactive=1 and b.BillType='" + strfinalarray[0] + "' and b.Bill_Date>='" + Convert.ToDateTime(DTPFrom.Text).ToString(Master.dateformate) + "' and b.Bill_Date<='" + Convert.ToDateTime(DTPTo.Text).ToString(Master.dateformate) + "'group by b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt order by b.bill_date asc");
for (int j = 0; j < dt.Rows.Count; j++)
{
try
{
String str = dt.Rows[j]["billno"].ToString();
DataTable dt1 = conn.getdataset("select * from FormFormat where isactive=1 and type='" + strfinalarray[0] + "' and setdefault=1");
DefaultSaleOrder bd = new DefaultSaleOrder(master, tabControl, strfinalarray);
// Sale p = new Sale(this, master, tabControl);
if (dt1.Rows[0]["formname"].ToString() == bd.Text)
{
bd.updatemode(str, dt.Rows[j]["billno"].ToString(), 1, strfinalarray);
master.AddNewTab(bd);
bd.BtnPayment_Click(sender, e);
master.RemoveCurrentTab();
}
}
catch
{
}
finally
{
}
}
}
else if (LVDayBook.Items[i].SubItems[1].Text == "Sale Challan")
{
rewritedata = "True";
string[] strfinalarray = new string[5] {
"SC", "D", "Sale Challan", "SC", ""
};
DataTable dt = conn.getdataset("select b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,sum(b.totaltax + isnull(bc.sgst,0)+isnull(bc.cgst,0)+isnull(bc.igst,0)) as totaltax,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt from SaleOrderMaster b left join SaleOrderchargesmaster bc on bc.billno=b.billno and bc.isactive=1 inner join clientmaster c on c.clientid=b.clientid where c.isactive=1 and b.isactive=1 and b.BillType='" + strfinalarray[0] + "' and b.Bill_Date>='" + Convert.ToDateTime(DTPFrom.Text).ToString(Master.dateformate) + "' and b.Bill_Date<='" + Convert.ToDateTime(DTPTo.Text).ToString(Master.dateformate) + "'group by b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt order by b.bill_date asc");
for (int j = 0; j < dt.Rows.Count; j++)
{
try
{
String str = dt.Rows[j]["billno"].ToString();
DataTable dt1 = conn.getdataset("select * from FormFormat where isactive=1 and type='" + strfinalarray[0] + "' and setdefault=1");
DefaultSaleOrder bd = new DefaultSaleOrder(master, tabControl, strfinalarray);
// Sale p = new Sale(this, master, tabControl);
if (dt1.Rows[0]["formname"].ToString() == bd.Text)
{
bd.updatemode(str, dt.Rows[j]["billno"].ToString(), 1, strfinalarray);
master.AddNewTab(bd);
bd.BtnPayment_Click(sender, e);
master.RemoveCurrentTab();
}
}
catch
{
}
finally
{
}
}
}
else if (LVDayBook.Items[i].SubItems[1].Text == "Purchase")
{
rewritedata = "True";
string[] strfinalarray = new string[5] {
"P", "C", "Purchase", "P", ""
};
DataTable dt = conn.getdataset("select b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,sum(b.totaltax + isnull(bc.sgst,0)+isnull(bc.cgst,0)+isnull(bc.igst,0)) as totaltax,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt,b.clientID from billmaster b left join Billchargesmaster bc on bc.billno=b.billno and bc.isactive=1 inner join clientmaster c on c.clientid=b.clientid where c.isactive=1 and b.isactive=1 and b.BillType='" + strfinalarray[0] + "' and b.Bill_Date>='" + Convert.ToDateTime(DTPFrom.Text).ToString(Master.dateformate) + "' and b.Bill_Date<='" + Convert.ToDateTime(DTPTo.Text).ToString(Master.dateformate) + "'group by b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt,b.clientID order by b.bill_date asc");
for (int j = 0; j < dt.Rows.Count; j++)
{
try
{
String str = dt.Rows[j]["billno"].ToString();
DataTable dt1 = conn.getdataset("select * from FormFormat where isactive=1 and type='" + strfinalarray[0] + "' and setdefault=1");
DefaultSale bd = new DefaultSale(master, tabControl, strfinalarray);
// Sale p = new Sale(this, master, tabControl);
if (dt1.Rows[0]["formname"].ToString() == bd.Text)
{
bd.updatemode(str, dt.Rows[j]["billno"].ToString(), Convert.ToInt32(dt.Rows[j]["ClientID"].ToString()), strfinalarray);
master.AddNewTab(bd);
bd.BtnPayment_Click(sender, e);
master.RemoveCurrentTab();
}
}
catch
{
}
finally
{
}
}
}
else if (LVDayBook.Items[i].SubItems[1].Text == "Purchase Return")
{
rewritedata = "True";
string[] strfinalarray = new string[5] {
"PR", "D", "PurchaseReturn", "PR", ""
};
DataTable dt = conn.getdataset("select b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,sum(b.totaltax + isnull(bc.sgst,0)+isnull(bc.cgst,0)+isnull(bc.igst,0)) as totaltax,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt from billmaster b left join Billchargesmaster bc on bc.billno=b.billno and bc.isactive=1 inner join clientmaster c on c.clientid=b.clientid where c.isactive=1 and b.isactive=1 and b.BillType='" + strfinalarray[0] + "' and b.Bill_Date>='" + Convert.ToDateTime(DTPFrom.Text).ToString(Master.dateformate) + "' and b.Bill_Date<='" + Convert.ToDateTime(DTPTo.Text).ToString(Master.dateformate) + "'group by b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt order by b.bill_date asc");
for (int j = 0; j < dt.Rows.Count; j++)
{
try
{
String str = dt.Rows[j]["billno"].ToString();
DataTable dt1 = conn.getdataset("select * from FormFormat where isactive=1 and type='" + strfinalarray[0] + "' and setdefault=1");
DefaultSale bd = new DefaultSale(master, tabControl, strfinalarray);
// Sale p = new Sale(this, master, tabControl);
if (dt1.Rows[0]["formname"].ToString() == bd.Text)
{
bd.updatemode(str, dt.Rows[j]["billno"].ToString(), 1, strfinalarray);
master.AddNewTab(bd);
bd.BtnPayment_Click(sender, e);
master.RemoveCurrentTab();
}
}
catch
{
}
finally
{
}
}
}
else if (LVDayBook.Items[i].SubItems[1].Text == "Purchase Order")
{
rewritedata = "True";
string[] strfinalarray = new string[5] {
"PO", "C", "Purchase Order", "PO", ""
};
DataTable dt = conn.getdataset("select b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,sum(b.totaltax + isnull(bc.sgst,0)+isnull(bc.cgst,0)+isnull(bc.igst,0)) as totaltax,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt from SaleOrderMaster b left join SaleOrderchargesmaster bc on bc.billno=b.billno and bc.isactive=1 inner join clientmaster c on c.clientid=b.clientid where c.isactive=1 and b.isactive=1 and b.BillType='" + strfinalarray[0] + "' and b.Bill_Date>='" + Convert.ToDateTime(DTPFrom.Text).ToString(Master.dateformate) + "' and b.Bill_Date<='" + Convert.ToDateTime(DTPTo.Text).ToString(Master.dateformate) + "'group by b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt order by b.bill_date asc");
for (int j = 0; j < dt.Rows.Count; j++)
{
try
{
String str = dt.Rows[j]["billno"].ToString();
DataTable dt1 = conn.getdataset("select * from FormFormat where isactive=1 and type='" + strfinalarray[0] + "' and setdefault=1");
DefaultSaleOrder bd = new DefaultSaleOrder(master, tabControl, strfinalarray);
// Sale p = new Sale(this, master, tabControl);
if (dt1.Rows[0]["formname"].ToString() == bd.Text)
{
bd.updatemode(str, dt.Rows[j]["billno"].ToString(), 1, strfinalarray);
master.AddNewTab(bd);
bd.BtnPayment_Click(sender, e);
master.RemoveCurrentTab();
}
}
catch
{
}
finally
{
}
}
}
else if (LVDayBook.Items[i].SubItems[1].Text == "Purchase Challan")
{
rewritedata = "True";
string[] strfinalarray = new string[5] {
"PC", "C", "Purchase Challan", "PC", ""
};
DataTable dt = conn.getdataset("select b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,sum(b.totaltax + isnull(bc.sgst,0)+isnull(bc.cgst,0)+isnull(bc.igst,0)) as totaltax,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt from SaleOrderMaster b left join SaleOrderchargesmaster bc on bc.billno=b.billno and bc.isactive=1 inner join clientmaster c on c.clientid=b.clientid where c.isactive=1 and b.isactive=1 and b.BillType='" + strfinalarray[0] + "' and b.Bill_Date>='" + Convert.ToDateTime(DTPFrom.Text).ToString(Master.dateformate) + "' and b.Bill_Date<='" + Convert.ToDateTime(DTPTo.Text).ToString(Master.dateformate) + "'group by b.billno, b.bill_date, b.po_no, c.accountname,b.refno,b.totalcharges,b.totalbasic,b.totalnet,c.GstNo,b.cgatamt,b.sgstamt order by b.bill_date asc");
for (int j = 0; j < dt.Rows.Count; j++)
{
try
{
String str = dt.Rows[j]["billno"].ToString();
DataTable dt1 = conn.getdataset("select * from FormFormat where isactive=1 and type='" + strfinalarray[0] + "' and setdefault=1");
DefaultSaleOrder bd = new DefaultSaleOrder(master, tabControl, strfinalarray);
// Sale p = new Sale(this, master, tabControl);
if (dt1.Rows[0]["formname"].ToString() == bd.Text)
{
bd.updatemode(str, dt.Rows[j]["billno"].ToString(), 1, strfinalarray);
master.AddNewTab(bd);
bd.BtnPayment_Click(sender, e);
master.RemoveCurrentTab();
}
}
catch
{
}
finally
{
}
}
}
}
}
}
catch
{
}
}
