public ChargesPnl(TextBox txtcharamt, DefaultSaleOrder defaultSaleOrder, string[] strfinalarray) { // TODO: Complete member initialization InitializeComponent(); this.txtcharamt = txtcharamt; this.defaultSaleOrder = defaultSaleOrder; this.strfinalarray = strfinalarray; }
public Batch(DefaultSaleOrder defaultSaleOrder, string[] strfinalarray, string activecontroal) { // TODO: Complete member initialization InitializeComponent(); this.defaultSaleOrder = defaultSaleOrder; this.strfinalarray = strfinalarray; pvc = activecontroal; a = 1; }
public SaleOrder(string p, DefaultSaleOrder defaultSaleOrder, string[] strfinalarray) { // TODO: Complete member initialization InitializeComponent(); loadpage(); this.p = p; this.defaultSaleOrder = defaultSaleOrder; this.strfinalarray = strfinalarray; binddata(p); }
public void setform() { this.Close(); String str = LVFO.Items[LVFO.FocusedItem.Index].SubItems[1].Text; DataTable dt1 = conn.getdataset("select * from FormFormat where isactive=1 and type='" + strfinalarray[0] + "' and setdefault=1"); DefaultSale bd = new DefaultSale(this, master, LVFO.Items[LVFO.FocusedItem.Index].SubItems[3].Text); DefaultSaleOrder bd1 = new DefaultSaleOrder(this, master, LVFO.Items[LVFO.FocusedItem.Index].SubItems[3].Text); SalePurchaseOrderSimpleformate bd2 = new SalePurchaseOrderSimpleformate(this, master, LVFO.Items[LVFO.FocusedItem.Index].SubItems[3].Text); Stockinout bd3 = new Stockinout(this, master, LVFO.Items[LVFO.FocusedItem.Index].SubItems[3].Text); // Sale p = new Sale(this, master, tabControl); string[] a = new string[LVFO.CheckedItems.Count]; string[] b = new string[LVFO.CheckedItems.Count]; string[] c = new string[LVFO.CheckedItems.Count]; for (int i = 0, j = 0; i < LVFO.Items.Count; i++) { //if (LVFO.Items[i].Checked == true) //{ if (Convert.ToBoolean(LVFO.Items[i].Checked) == true) { lvid = LVFO.Items[i].SubItems[8].Text; lvid1 = LVFO.Items[i].SubItems[1].Text; type = LVFO.Items[i].SubItems[3].Text; clientid = Convert.ToInt32(LVFO.Items[i].SubItems[7].Text); a[j] = lvid; b[j] = type; c[j] = lvid1; j++; } } if (dt1.Rows[0]["formname"].ToString() == bd.Text) { defaultSale.getdata(a, a, clientid, b, c); // master.AddNewTab(bd); } else if (dt1.Rows[0]["formname"].ToString() == bd1.Text) { defaultSaleOrder.getdata(a, a, clientid, b, c); } else if (dt1.Rows[0]["formname"].ToString() == bd2.Text) { salePurchaseOrderSimpleformate.getdata(a, a, clientid, b, c); } else if (dt1.Rows[0]["formname"].ToString() == bd3.Text) { stockinout.getdata(a, a, clientid, b, c); } //else if (dt1.Rows[0]["formname"].ToString() == p.Text) //{ // // p.updatemode(str, LVFO.Items[LVFO.FocusedItem.Index].SubItems[1].Text, 1); // // master.AddNewTab(p); //} }
public SaletypeEntry(DefaultSaleOrder defaultSaleOrder, Master master, TabControl tabControl, string activecontroal) { // TODO: Complete member initialization InitializeComponent(); this.defaultSaleOrder = defaultSaleOrder; this.master = master; this.tabControl = tabControl; bindgroup(); bindtaxtype(); label11.Visible = false; pvc = activecontroal; }
public ChargesHead(DefaultSaleOrder defaultSaleOrder, string p, Master master, TabControl tabControl, string activecontroal) { // TODO: Complete member initialization InitializeComponent(); this.defaultSaleOrder = defaultSaleOrder; this.p = p; this.master = master; this.tabControl = tabControl; pageLoad(); pvc = activecontroal; flagforbind = 1; }
public PurchaseTypeEntry(DefaultSaleOrder defaultSaleOrder, Master master, TabControl tabControl, string activecontroal) { // TODO: Complete member initialization InitializeComponent(); bindgroup(); bindtaxtype(); purchaseid = 1; this.defaultSaleOrder = defaultSaleOrder; this.master = master; this.tabControl = tabControl; pvc = activecontroal; }
public void setformstockout() { //this.Enabled = false; string[] strfinalarray = new string[lvstockout.Items.Count]; if (lvstockout.Items[lvstockout.FocusedItem.Index].SubItems[1].Text == "S") { strfinalarray = new string[5] { "S", "D", "Sale", "S", "" }; } else if (lvstockout.Items[lvstockout.FocusedItem.Index].SubItems[1].Text == "P") { strfinalarray = new string[5] { "P", "C", "Purchase", "P", "" }; } else if (lvstockout.Items[lvstockout.FocusedItem.Index].SubItems[1].Text == "SC") { strfinalarray = new string[5] { "SC", "D", "Sale Challan", "SC", "" }; } else if (lvstockout.Items[lvstockout.FocusedItem.Index].SubItems[1].Text == "PR") { strfinalarray = new string[5] { "PR", "D", "PurchaseReturn", "PR", "" }; } String str = lvstockout.Items[lvstockout.FocusedItem.Index].SubItems[2].Text; DataTable dt1 = conn.getdataset("select * from FormFormat where isactive=1 and type='" + strfinalarray[0] + "' and setdefault=1"); DefaultSale bd = new DefaultSale(this, master, tabControl, strfinalarray); DefaultSaleOrder bd1 = new DefaultSaleOrder(this, master, tabControl, strfinalarray); // Sale p = new Sale(this, master, tabControl); if (dt1.Rows[0]["formname"].ToString() == bd.Text) { bd.updatemode(str, lvstockout.Items[lvstockout.FocusedItem.Index].SubItems[2].Text, Convert.ToInt32(lvstockout.Items[lvstockout.FocusedItem.Index].SubItems[10].Text), strfinalarray); master.AddNewTab(bd); } else if (dt1.Rows[0]["formname"].ToString() == bd1.Text) { bd1.updatemode(str, lvstockout.Items[lvstockout.FocusedItem.Index].SubItems[2].Text, Convert.ToInt32(lvstockout.Items[lvstockout.FocusedItem.Index].SubItems[10].Text), strfinalarray); master.AddNewTab(bd1); } }
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 { } }