public void ShowLookupForm() { FrmLookup_LookupHide(null, null); frmLookup = new LookupForm(); switch (lookupColName) { case QUOTATIONITEMS.PRODUCT_ID: { frmLookup.LookupColNames = new string[] { PRODUCT.PRODUCT_NAME }; frmLookup.SelectedPkValue = editgrid[QUOTATIONITEMS.PRODUCT_ID, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; if (txt_party_id.Text != "") { frmLookup.LookupList = CProduct_exten.GetforLookup(new DAL()); frmLookup.LoadLookupList(); } } break; case QUOTATIONITEMS.SIZES_ID: frmLookup.LookupColNames = new string[] { SIZES.SIZES_NAME }; frmLookup.SelectedPkValue = editgrid[QUOTATIONITEMS.SIZES_ID, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = CSizes_exten.GetforLookup(new DAL()); frmLookup.LoadLookupList(); break; default: throw new Exception("'" + lookupColName + "' Not Found"); } frmLookup.LookupSelected += new EventHandler(FrmLookup_LookupSelected); frmLookup.AfterSelection += new EventHandler(FrmLookup_AfterSelection); frmLookup.LookupHide += new EventHandler(FrmLookup_LookupHide); frmLookup.NewEntryNeeded += new LookupForm.NewEntryHandler(FrmLookup_NewEntryNeeded); frmLookup.Owner = this.FindForm(); ////////// frmLookup.Show(); ////////// int vWidth = frmLookup.GetAutoWidth(); int vCellWidth = editgrid.Columns[lookupColName].Width; if (vWidth < vCellWidth) { vWidth = vCellWidth; } frmLookup.AutoFillLastColumn(); int vHeight = frmLookup.GetAutoHeight(); Rectangle screenRect = Global.GetScreenRect(editgrid); frmLookup.Bounds = Global.GetSnapRect(screenRect, vWidth, vHeight); }
private List <Outwarditems> Collectitems(string vId) { List <Outwarditems> list = new List <Outwarditems>(); for (int r = 0; r < editgrid.RowCount; r++) { Outwarditems obj = new Outwarditems(); if ( (editgrid[OUTWARDITEMS.PRODUCT_ID, r].Value + "") == "" || (editgrid[OUTWARDITEMS.COLOURS_ID, r].Value + "") == "" || (editgrid[OUTWARDITEMS.SIZES_ID, r].Value + "") == "" || (editgrid[OUTWARDITEMS.QTY, r].Value + "") == "" ) { //==LEAVE IT(the empty row). } else { obj.Outwarditems_id = ""; obj.Outward_id = vId; obj.Style_id = CStyle_exten.GetId_Name(Checks.Escape(editgrid[OUTWARDITEMS.STYLE_ID, r].Value + "")); obj.Article_id = CArticle_exten.GetId_Name(Checks.Escape(editgrid[OUTWARDITEMS.ARTICLE_ID, r].Value + "")); obj.Product_id = CProduct_exten.GetId_Name(Checks.Escape(editgrid[OUTWARDITEMS.PRODUCT_ID, r].Value + "")); obj.Sizes_id = CSizes_exten.GetId_Name(editgrid[OUTWARDITEMS.SIZES_ID, r].Value + ""); obj.Colours_id = CColours_exten.GetId_Name(editgrid[OUTWARDITEMS.COLOURS_ID, r].Value + ""); obj.Qty = (editgrid[OUTWARDITEMS.QTY, r].Value + ""); //obj.Refered_id = ""; obj.Locked = Core.Unlocked; list.Add(obj); } } if (list.Count != 0) { return(list); } return(null); }
private List <Styleitems> Collectitems(string vId) { List <Styleitems> list = new List <Styleitems>(); for (int r = 0; r < editgrid.RowCount; r++) { Styleitems obj = new Styleitems(); if ( (editgrid[STYLEITEMS.PRODUCT_ID, r].Value + "") == "" || (editgrid[STYLEITEMS.QTY, r].Value + "") == "" || (editgrid[STYLEITEMS.PRICE, r].Value + "") == "" ) { //==LEAVE IT(the empty row). } else { obj.Styleitems_id = ""; obj.Style_id = vId; obj.Style_no = txt_style_no.Text; obj.Article_id = CArticle_exten.GetId_Name(editgrid[STYLEITEMS.ARTICLE_ID, r].Value + ""); obj.Product_id = CProduct_exten.GetId_Name(editgrid[STYLEITEMS.PRODUCT_ID, r].Value + ""); obj.Colours_id = CColours_exten.GetId_Name(editgrid[STYLEITEMS.COLOURS_ID, r].Value + ""); obj.Sizes_id = CSizes_exten.GetId_Name(editgrid[STYLEITEMS.SIZES_ID, r].Value + ""); obj.Qty = (editgrid[STYLEITEMS.QTY, r].Value + ""); obj.Price = ConvertTO.Decimal(editgrid[STYLEITEMS.PRICE, r].Value + ""); obj.Refered_id = ""; obj.Locked = Core.Unlocked; list.Add(obj); } } if (list.Count != 0) { return(list); } return(null); }
private Article CollectData() { Article fobj = new Article() { Article_id = vId, Po_id = CPo_exten.GetId_Name(txt_po_id.Text), Article_no = txt_article_no.Text, Product_id = CProduct_exten.GetId_Name(txt_product_id.Text), Hsncode_id = CHsncode_exten.GetId_Name(txt_hsncode_id.Text), Sizes_id = CSizes_exten.GetId_Name(txt_sizes_id.Text), Colours_id = CColours_exten.GetId_Name(txt_colours_id.Text), Qty = txt_qty.Text, Price = ConvertTO.Decimal(txt_price.Text), Barcode = txt_barcode.Text, Active_id = Core.Stative, Notes = txt_notes.Text, User_id = Current.User }; return(fobj); }
private List <Quotationitems> Collectitems(string vId) { List <Quotationitems> list = new List <Quotationitems>(); for (int r = 0; r < editgrid.RowCount; r++) { Quotationitems obj = new Quotationitems(); if ( (editgrid[QUOTATIONITEMS.PRODUCT_ID, r].Value + "") == "" || (editgrid[QUOTATIONITEMS.QTY, r].Value + "") == "" || (editgrid[QUOTATIONITEMS.PRICE, r].Value + "") == "" ) { //==LEAVE IT(the empty row). } else { obj.Quotationitems_id = ""; obj.Quotation_id = vId; obj.Product_id = CProduct_exten.GetId_Name(Checks.Escape(editgrid[QUOTATIONITEMS.PRODUCT_ID, r].Value + "")); obj.Sizes_id = CSizes_exten.GetId_Name(editgrid[QUOTATIONITEMS.SIZES_ID, r].Value + ""); obj.Qty = (editgrid[QUOTATIONITEMS.QTY, r].Value + ""); obj.Price = ConvertTO.Decimal(editgrid[QUOTATIONITEMS.PRICE, r].Value + ""); obj.Refered_id = ""; obj.Locked = Core.Unlocked; list.Add(obj); } } if (list.Count != 0) { return(list); } return(null); }
private static void InsertData(Invoice.Const.Invoice obj, List <Invoiceitems> items, string newDB) { DAL dalsession; try { dalsession = new DAL(); dalsession.BeginTransaction(); List <Invoiceitems> list_new = new List <Invoiceitems>(); if (obj != null) { if (CheckData(obj, newDB) != true) { Invoice.Const.Invoice obj_new = new Invoice.Const.Invoice { Uniqueno = obj.Uniqueno, Company_id = obj.Company_id, Acy_id = obj.Acy_id, Order_id = "1", Invoice_no = obj.Invoice_no, Invoice_date = obj.Invoice_date, Party_id = CParty_exten.GetId_Name(obj.Party_id), Taxtype_id = CTaxtype_exten.GetId_Name(obj.Taxtype_id), Salestype_id = CSalestype_exten.GetId_Name(obj.Salestype_id), Transport_id = CTransport_exten.GetId_Name(obj.Transport_id), Deliveredto_id = CDeliveredto_exten.GetId_Name(obj.Deliveredto_id), Bundel = obj.Bundel, Total_qty = obj.Total_qty, Total_taxable_amount = obj.Total_taxable_amount, Total_cgst = obj.Total_cgst, Total_sgst = obj.Total_sgst, Total_igst = obj.Total_igst, Gsttotal = obj.Gsttotal, Ledger_id = CLedger_exten.GetName_Id(obj.Ledger_id), Additional = obj.Additional, Rounds = obj.Rounds, Grandtotal = obj.Grandtotal, Refered_amt = obj.Refered_amt, Locked = obj.Locked, Notes = obj.Notes, Active_id = obj.Active_id, User_id = "1" }; //switch (obj.Company_id) //{ // case "1": // obj_new.Company_id = "1"; // obj_new.Acy_id = "1"; // break; // case "3": // obj_new.Company_id = "1"; // obj_new.Acy_id = "2"; // break; // case "4": // obj_new.Company_id = "1"; // obj_new.Acy_id = "3"; // break; //} obj_new.Uniqueno = obj_new.Acy_id + "~" + obj_new.Company_id + "~" + obj_new.Invoice_no; Invoice.Class.CInvoice.Insert(obj_new, dalsession); var vId = DAL.GetIdentity(dalsession); for (int k = 0; k < items.Count; k++) { Invoiceitems v = new Invoiceitems() { Invoice_id = vId, Po_no = "", Dc_no = "", Product_id = CProduct_exten.GetId_Name(items[k].Product_id), Sizes_id = CSizes_exten.GetId_Name(items[k].Sizes_id), Colours_id = "1", Qty = items[k].Qty, Price = items[k].Price, Cgst_percent = items[k].Cgst_percent, Sgst_percent = items[k].Sgst_percent, Igst_percent = items[k].Igst_percent, Refered_id = items[k].Refered_id, Locked = items[k].Locked }; list_new.Add(v); } Invoice.Class.CInvoiceitems.Insert(list_new, dalsession); dalsession.Commit(); } } } catch (Exception ex) { MessageBox.Show("error : " + ex); } }
public void ShowLookupForm() { FrmLookup_LookupHide(null, null); frmLookup = new LookupForm(); switch (lookupColName) { //case INVOICEITEMS.PO_ID: // { // //if (Customise.Invoice_poid_dcid == true) // //{ // // frmLookup.LookupColNames = new string[] { PO.PO_NO, DC.DC_NO, DCITEMS.PRODUCT_ID, DCITEMS.QTY, DCITEMS.REFERED_QTY, POITEMS.PRICE }; // // frmLookup.SelectedPkValue = editgrid[INVOICEITEMS.PO_ID, lookupRow].Value; // // frmLookup.AllowNewEntry = true; // // frmLookup.AllowEmptySelection = true; // // // // // if (txt_party_id.Text != "") // // { // // frmLookup.LookupList = CPo_lookup.LookupbyPono(txt_party_id.Text); // // //frmLookup.LookupList = CPo_lookup.LookupPObyPartyforInvoice(CParty_exten.GetId_Name(txt_party_id.Text)); // // frmLookup.LoadLookupList(); // // } // // // // //} // } // break; // //case INVOICEITEMS.DC_ID: // { // if (Customise.Invoice_poid_dcid == true) // { // //frmLookup.LookupColNames = new string[] { DC.DC_NO, DCITEMS.PRODUCT_ID, DCITEMS.QTY, DCITEMS.REFERED_QTY, POITEMS.PRICE }; // //frmLookup.SelectedPkValue = editgrid[INVOICEITEMS.DC_ID, lookupRow].Value; // //frmLookup.AllowNewEntry = true; // //frmLookup.AllowEmptySelection = true; // //// // //if (txt_party_id.Text != "") // //{ // // if (editgrid[DCITEMS.PO_ID, lookupRow].Value != null) // // { // // if (editgrid[DCITEMS.PO_ID, lookupRow].Value.ToString() != "") // // { // // if (editgrid[DCITEMS.PO_ID, lookupRow].Value.ToString() != Core.Without_Po) // // { } // // else // // { // // frmLookup.LookupList = CDc_Lookup.LookupDC_Party_forInvoice(CParty_exten.GetId_Name(txt_party_id.Text)); // // frmLookup.LoadLookupList(); // // } // // } // // else // // { // // frmLookup.LookupList = CDc_Lookup.LookupDC_Party_forInvoice(CParty_exten.GetId_Name(txt_party_id.Text)); // // frmLookup.LoadLookupList(); // // } // // } // // else // // { // // frmLookup.LookupList = CDc_Lookup.LookupDC_Party_forInvoice(CParty_exten.GetId_Name(txt_party_id.Text)); // // frmLookup.LoadLookupList(); // // } // //} // // // } // } // break; case INVOICEITEMS.PRODUCT_ID: { frmLookup.LookupColNames = new string[] { PRODUCT.PRODUCT_NAME }; frmLookup.SelectedPkValue = editgrid[INVOICEITEMS.PRODUCT_ID, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; if (txt_party_id.Text != "") { //if (Customise.Invoice_poid_dcid == true) //{ //if (editgrid[DCITEMS.PO_ID, lookupRow].Value != null) //{ // if (editgrid[DCITEMS.DC_ID, lookupRow].Value != null) // { // if (editgrid[DCITEMS.PO_ID, lookupRow].Value.ToString() == Core.Without_Po) // { // if (editgrid[DCITEMS.DC_ID, lookupRow].Value.ToString() == Core.Without_Dc) // { // frmLookup.LookupList = CProduct_exten.GetforLookup(new DAL()); // frmLookup.LoadLookupList(); // } // } // } // else // { // frmLookup.LookupList = CProduct_exten.GetforLookup(new DAL()); // frmLookup.LoadLookupList(); // } //} //else //{ // frmLookup.LookupList = CProduct_exten.GetforLookup(new DAL()); // frmLookup.LoadLookupList(); // //} //} //if ((Customise.Invoice_pono_dcno == true) || (Customise.Invoice_Without_podc == true)) //{ frmLookup.LookupList = CProduct_exten.GetforLookup(new DAL()); frmLookup.LoadLookupList(); //} } } break; case INVOICEITEMS.SIZES_ID: frmLookup.LookupColNames = new string[] { SIZES.SIZES_NAME }; frmLookup.SelectedPkValue = editgrid[INVOICEITEMS.SIZES_ID, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = CSizes_exten.GetforLookup(new DAL()); frmLookup.LoadLookupList(); break; case INVOICEITEMS.COLOURS_ID: frmLookup.LookupColNames = new string[] { COLOURS.COLOURS_NAME }; frmLookup.SelectedPkValue = editgrid[INVOICEITEMS.COLOURS_ID, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = CColours_exten.GetforLookup(); frmLookup.LoadLookupList(); break; default: throw new Exception("'" + lookupColName + "' Not Found"); } frmLookup.LookupSelected += new EventHandler(FrmLookup_LookupSelected); frmLookup.AfterSelection += new EventHandler(FrmLookup_AfterSelection); frmLookup.LookupHide += new EventHandler(FrmLookup_LookupHide); frmLookup.NewEntryNeeded += new LookupForm.NewEntryHandler(FrmLookup_NewEntryNeeded); frmLookup.Owner = this.FindForm(); ////////// frmLookup.Show(); ////////// int vWidth = frmLookup.GetAutoWidth(); int vCellWidth = editgrid.Columns[lookupColName].Width; if (vWidth < vCellWidth) { vWidth = vCellWidth; } frmLookup.AutoFillLastColumn(); int vHeight = frmLookup.GetAutoHeight(); Rectangle screenRect = Global.GetScreenRect(editgrid); frmLookup.Bounds = Global.GetSnapRect(screenRect, vWidth, vHeight); }
void Txt_sizes_LookupUpdate(object sender, EventArgs e) { txt_sizes_id.LookupList = CSizes_exten.GetforLookup(new DAL()); }
private List <Creditnoteitems> Collectitems(string vId) { List <Creditnoteitems> list = new List <Creditnoteitems>(); for (int r = 0; r < editgrid.RowCount; r++) { Creditnoteitems obj = new Creditnoteitems(); if ( (editgrid[CREDITNOTEITEMS.PRODUCT_ID, r].Value + "") == "" || (editgrid[CREDITNOTEITEMS.QTY, r].Value + "") == "" || (editgrid[CREDITNOTEITEMS.PRICE, r].Value + "") == "" ) { //==LEAVE IT(the empty row). } else { obj.Creditnoteitems_id = ""; obj.Creditnote_id = vId; if (Customised.WithPo == true) { obj.Po_no = Checks.Escape(editgrid[CREDITNOTEITEMS.PO_NO, r].Value + ""); } else { obj.Po_no = "0"; } if (Customised.WithDc == true) { obj.Dc_no = Checks.Escape(editgrid[CREDITNOTEITEMS.DC_NO, r].Value + ""); } else { obj.Dc_no = "0"; } obj.Product_id = CProduct_exten.GetId_Name(Checks.Escape(editgrid[CREDITNOTEITEMS.PRODUCT_ID, r].Value + "")); if (Customised.WithSizes == true) { obj.Sizes_id = CSizes_exten.GetId_Name(editgrid[CREDITNOTEITEMS.SIZES_ID, r].Value + ""); } else { obj.Sizes_id = "1"; } if (Customised.WithColours == true) { obj.Colours_id = CColours_exten.GetId_Name(editgrid[CREDITNOTEITEMS.COLOURS_ID, r].Value + ""); } else { obj.Colours_id = "1"; } obj.Qty = (editgrid[CREDITNOTEITEMS.QTY, r].Value + ""); obj.Price = ConvertTO.Decimal(editgrid[CREDITNOTEITEMS.PRICE, r].Value + ""); obj.Cgst_percent = ConvertTO.Decimal(editgrid[CREDITNOTEITEMS.CGST_PERCENT, r].Value + ""); obj.Sgst_percent = ConvertTO.Decimal(editgrid[CREDITNOTEITEMS.SGST_PERCENT, r].Value + ""); obj.Igst_percent = ConvertTO.Decimal(editgrid[CREDITNOTEITEMS.IGST_PERCENT, r].Value + ""); obj.Refered_id = ""; obj.Locked = Core.Unlocked; list.Add(obj); } } if (list.Count != 0) { return(list); } return(null); }