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);
}
