private Creditnote CollectData() { Creditnote fobj = new Creditnote() { Creditnote_id = vId, Uniqueno = Current.Acy_id + "~" + Current.Company_id + "~" + txt_invoice_no.Text, Company_id = Current.Company_id, //Div_id = Current.Div_id, Acy_id = Current.Acy_id, Order_id = COrder_exten.GetId_Name(txt_order_id.Text, "", "", ""), Creditnote_no = txt_invoice_no.Text, Creditnote_date = txt_invoice_date.Text, Party_id = CParty_exten.GetId_Name(txt_party_id.Text), Taxtype_id = CTaxtype_exten.GetId_Name(txt_taxtype_id.Text), Salestype_id = CSalestype_exten.GetId_Name(txt_salestype_id.Text), Total_qty = txt_total_qty.Text, Total_taxable_amount = ConvertTO.Decimal(vTotTaxable.ToString()), Total_cgst = ConvertTO.Decimal(vTotCgst.ToString()), Total_sgst = ConvertTO.Decimal(vTotSgst.ToString()), Total_igst = ConvertTO.Decimal(vTotIgst.ToString()), Gsttotal = ConvertTO.Decimal(txt_gsttotal.Text), Ledger_id = CLedger_exten.GetId_Name(txt_ledger_id.Text), Additional = ConvertTO.Decimal(txt_additional.Text), Rounds = ConvertTO.Decimal(vRoundoff.ToString()), Grandtotal = ConvertTO.Decimal(txt_grandtotal.Text), Refered_amt = ConvertTO.Decimal(txt_grandtotal.Text), Locked = Core.Unlocked, Active_id = Core.Stative, Notes = txt_notes.Text, User_id = Current.User }; return(fobj); }
private Voucher CollectData() { Voucher fobj = new Voucher() { Voucher_id = vId, Company_id = Current.Company_id, Voucher_no = txt_voucher_no.Text, Voucher_date = txt_voucher_date.Text, Vouchertype_id = CVouchertype_exten.GetId_Name(txt_vouchertype_id.Text), Order_id = COrder_exten.GetId_Name(txt_order_id.Text), Ledger_id = CLedger_exten.GetId_Name(txt_ledger_id.Text), Party_id = CParty_exten.GetId_Name(txt_party_id.Text), Purpose = txt_purpose.Text, Credit = "", Debit = "", Active_id = Core.Stative, Notes = txt_notes.Text, User_id = Current.User }; var method = CVouchertype_exten.GetMethodid_Name(txt_vouchertype_id.Text); if (method == "1")// 1 payment { fobj.Credit = txt_credit.Text; } else if (method == "2") // receipt { fobj.Debit = txt_debit.Text; } return(fobj); }
private Quotation CollectData() { Quotation fobj = new Quotation() { Quotation_id = vId, Uniqueno = Current.Acy_id + "~" + Current.Company_id + "~" + txt_quotation_no.Text, Company_id = Current.Company_id, Acy_id = Current.Acy_id, Order_id = "1", Quotation_no = txt_quotation_no.Text, Quotation_date = txt_quotation_date.Text, Party_id = CParty_exten.GetId_Name(txt_party_id.Text), Total_qty = ConvertTO.Decimal(totalQty), Total_taxable_amount = ConvertTO.Decimal(vTotTaxable.ToString()), Ledger_id = txt_ledger_id.Text, Additional = ConvertTO.Decimal(txt_additional.Text), Rounds = ConvertTO.Decimal(vRoundoff.ToString()), Grandtotal = ConvertTO.Decimal(txt_grandtotal.Text), Refered_amt = ConvertTO.Decimal(txt_grandtotal.Text), Locked = Core.Unlocked, Active_id = Core.Stative, Notes = txt_notes.Text, User_id = Current.User }; return(fobj); }
public void List_Option(ListOption pAction) { fAction = pAction; switch (fAction) { case ListOption.active: if (chk_notactive.Checked == true) { LoadData(CVoucher_exten.NotActive(new DAL())); } else { LoadData(CVoucher_exten.Active(new DAL())); } break; case ListOption.notactive: if (chk_notactive.Checked == true) { LoadData(CVoucher_exten.NotActive(new DAL())); } else { LoadData(CVoucher_exten.Active(new DAL())); } break; case ListOption.Search: List <Voucher> list = CVoucher_exten.Searchfilter( txt_voucher_no.Text , txt_voucher_no_1.Text , txt_voucher_date.Text , txt_voucher_date_1.Text , CVouchertype_exten.GetId_Name(txt_vouchertype.Text) , COrder_exten.GetId_Name(txt_orderref.Text) , CLedger_exten.GetId_Name(txt_ledger.Text) , CParty_exten.GetId_Name(txt_party.Text) , txt_purpose.Text , new DAL()); LoadData(list); break; default: LoadData(CVoucher_exten.Active(new DAL())); break; } }
private Cash_receipt CollectData() { Cash_receipt fobj = new Cash_receipt() { Cash_receipt_id = vId, Receipt_date = txt_receipt_date.Text, Party_id = CParty_exten.GetId_Name(txt_party_id.Text), Purpose = txt_purpose.Text, Receipt_amount = ConvertTO.Decimal(txt_receipt_amount.Text), Active_id = Core.Stative, Notes = txt_notes.Text, User_id = Current.User }; return(fobj); }
private void LoadData(Quotation obj) { vId = obj.Quotation_id; txt_quotation_no.Text = obj.Quotation_no.ToString(); txt_quotation_date.Text = obj.Quotation_date; txt_party_id.Text = obj.Party_id; //txt_total_qty.Text = obj.Total_qty.ToString(); //txt_total_taxable_amount.Text = obj.Total_taxable_amount; //txt_gsttotal.Text = obj.Gsttotal.ToString(); txt_ledger_id.Text = obj.Ledger_id; txt_additional.Text = obj.Additional.ToString(); txt_grandtotal.Text = obj.Grandtotal.ToString(); txt_balance.Text = CQuotation_exten.GetBalance(CParty_exten.GetId_Name(txt_party_id.Text)).ToString(); txt_notes.Text = obj.Notes; Core.Stative = obj.Active_id; Setactives(); }
private Cash_payment CollectData() { Cash_payment fobj = new Cash_payment() { Cash_payment_id = vId, Order_id = COrder_exten.GetId_Name(txt_order_id.Text, "", "", ""), Payment_date = txt_payment_date.Text, Ledger_id = CLedger_exten.GetId_Name(txt_ledger_id.Text), Purpose = txt_purpose.Text, Party_id = CParty_exten.GetId_Name(txt_party_id.Text), Payment_amount = ConvertTO.Decimal(txt_payment_amount.Text), Active_id = Core.Stative, Notes = txt_notes.Text, User_id = Current.User }; return(fobj); }
private void LoadData(Creditnote obj) { vId = obj.Creditnote_id; txt_order_id.Text = obj.Order_id; txt_invoice_no.Text = obj.Creditnote_no.ToString(); txt_invoice_date.Text = obj.Creditnote_date; txt_party_id.Text = obj.Party_id; txt_taxtype_id.Text = obj.Taxtype_id; SetTaxtype(); txt_salestype_id.Text = obj.Salestype_id; txt_total_qty.Text = obj.Total_qty.ToString(); //txt_total_taxable_amount.Text = obj.Total_taxable_amount; txt_gsttotal.Text = obj.Gsttotal.ToString(); txt_ledger_id.Text = CLedger_exten.GetName_Id(obj.Ledger_id); txt_additional.Text = obj.Additional.ToString(); txt_grandtotal.Text = obj.Grandtotal.ToString(); txt_balance.Text = CCreditnote_exten.GetBalance(CParty_exten.GetId_Name(txt_party_id.Text)).ToString(); txt_notes.Text = obj.Notes; Core.Stative = obj.Active_id; Setactives(); }
private Order CollectData() { Order fobj = new Order() { Order_id = vId, Uniqueno = Current.Acy_id + "~" + Current.Company_id + "~" + txt_order_no.Text, Company_id = Current.Company_id, Acy_id = Current.Acy_id, Order_no = txt_order_no.Text, Order_date = txt_order_date.Text, Ordertype_id = COrdertype_exten.GetId_Name(txt_ordertype_id.Text), Party_id = CParty_exten.GetId_Name(txt_party_id.Text), Party_ref = txt_party_ref.Text, Refered_no = "", Locked = Core.Unlocked, Active_id = Core.Stative, Notes = txt_notes.Text, User_id = Current.User }; return(fobj); }
private Outward CollectData() { Outward fobj = new Outward() { Inward_id = vId, Uniqueno = Current.Acy_id + "~" + Current.Company_id + "~" + txt_outward_no.Text, Company_id = Current.Company_id, Acy_id = Current.Acy_id, Order_id = COrder_exten.GetId_Name(txt_order_id.Text, "", "", ""), Outward_no = txt_outward_no.Text, Outward_date = txt_outward_date.Text, Party_dcno = txt_party_dcno.Text, Party_id = CParty_exten.GetId_Name(txt_party_id.Text), Total_qty = txt_total_qty.Text, Total_bundel = txt_total_bundel.Text, Delivredthrough = txt_deliveredthrough.Text, Locked = Core.Unlocked, Notes = txt_notes.Text, Active_id = Core.Stative, User_id = Current.User }; return(fobj); }
private Upvc_Quotation CollectData() { Upvc_Quotation fobj = new Upvc_Quotation() { Upvc_Quotation_id = vId, Uniqueno = Current.Acy_id + "~" + Current.Company_id + "~" + txt_invoice_no.Text, Company_id = Current.Company_id, Acy_id = Current.Acy_id, Taxtype_id = CTaxtype_exten.GetId_Name(txt_taxtype_id.Text), Salestype_id = CSalestype_exten.GetId_Name(txt_salestype_id.Text), Quotation_no = txt_invoice_no.Text, Quotation_date = txt_invoice_date.Text, Party_id = CParty_exten.GetId_Name(txt_party_id.Text), Delivered_id = CParty_exten.GetId_Name(txt_Delivered_id.Text), Transport_id = CTransport_exten.GetId_Name(txt_transport_id.Text), Vehicle_no = txt_vehicle_no.Text, Total_qty = ConvertTO.Decimal(txt_total_qty.Text), Total_areasq = ConvertTO.Decimal(vTotAreasq.ToString()), Total_taxable_amount = ConvertTO.Decimal(vTotTaxable.ToString()), Total_cgst = ConvertTO.Decimal(vTotCgst.ToString()), Total_sgst = ConvertTO.Decimal(vTotSgst.ToString()), Total_igst = ConvertTO.Decimal(vTotIgst.ToString()), Gsttotal = ConvertTO.Decimal(txt_gsttotal.Text), Ledger_id = CLedger_exten.GetId_Name(txt_ledger_id.Text + ""), Additional = ConvertTO.Decimal(txt_additional.Text), Rounds = ConvertTO.Decimal(vRoundoff.ToString()), Grandtotal = ConvertTO.Decimal(txt_grandtotal.Text), Refered_no = ConvertTO.Decimal(txt_grandtotal.Text), Locked = Core.Unlocked, Active_id = Core.Stative, Notes = txt_notes.Text, User_id = Current.User }; return(fobj); }
private Receipt CollectData() { Receipt fobj = new Receipt() { Receipt_id = vId, Uniqueno = Current.Acy_id + "~" + Current.Company_id + "~" + txt_receipt_no.Text, Company_id = Current.Company_id, Acy_id = Current.Acy_id, Receipt_no = txt_receipt_no.Text, Receipt_date = txt_receipt_date.Text, Party_id = CParty_exten.GetId_Name(txt_party_id.Text), Receipttype_id = CReceipttype_exten.GetId_Name(txt_receipttype_id.Text), Cheq_no = txt_cheq_no.Text, Receipt_amount = ConvertTO.Decimal(txt_receipt_amount.Text), Cheq_date = txt_cheq_date.Text, Bank_id = GetBankid, Total_amount = ConvertTO.Decimal(txt_total_amount.Text), Active_id = Core.Stative, Notes = txt_notes.Text, User_id = Current.User }; return(fobj); }
private void Txt_party_TextChanged(object sender, EventArgs e) { txt_balance.Text = CQuotation_exten.GetBalance(CParty_exten.GetId_Name(txt_party_id.Text)).ToString(); }
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); } }
private static Receipt GetOldData(int id, string OldDB) { string q = "USE " + OldDB + "; "; q += " SELECT " + RECEIPT.RECEIPT_TBL + ".* \r\n"; q += ", " + PARTY.PARTY_TBL + "." + PARTY.PARTY_NAME + " \r\n"; q += ", " + RECEIPTTYPE.RECEIPTTYPE_TBL + "." + RECEIPTTYPE.RECEIPTTYPE_NAME + " \r\n"; q += ", " + BANK.BANK_TBL + "." + BANK.BANK_NAME + " \r\n"; q += " FROM " + RECEIPT.RECEIPT_TBL + " \r\n"; q += " INNER JOIN " + PARTY.PARTY_TBL + "\r\n"; q += " ON(" + RECEIPT.RECEIPT_TBL + "." + RECEIPT.PARTY_ID + " = " + PARTY.PARTY_TBL + "." + PARTY.PARTY_ID + " )\r\n"; q += " INNER JOIN " + RECEIPTTYPE.RECEIPTTYPE_TBL + "\r\n"; q += " ON(" + RECEIPT.RECEIPT_TBL + "." + RECEIPT.RECEIPTTYPE_ID + " = " + RECEIPTTYPE.RECEIPTTYPE_TBL + "." + RECEIPTTYPE.RECEIPTTYPE_ID + " )\r\n"; q += " INNER JOIN " + BANK.BANK_TBL + "\r\n"; q += " ON(" + RECEIPT.RECEIPT_TBL + "." + RECEIPT.BANK_ID + " = " + BANK.BANK_TBL + "." + BANK.BANK_ID + " )\r\n"; q += " WHERE " + RECEIPT.RECEIPT_TBL + "." + RECEIPT.RECEIPT_ID + " = '" + id + "' \r\n"; using (IDataReader redr = new DAL().Listreader(q)) { while (redr.Read() == true) { Receipt obj = new Receipt { Receipt_id = "", Uniqueno = "", Company_id = redr[RECEIPT.COMPANY_ID].ToString(), Acy_id = "1", Receipt_no = redr[RECEIPT.RECEIPT_NO].ToString(), Receipt_date = redr[RECEIPT.RECEIPT_DATE].ToString(), Party_id = CParty_exten.GetId_Name(redr[PARTY.PARTY_NAME].ToString()), Receipttype_id = CReceipttype_exten.GetId_Name(redr[RECEIPTTYPE.RECEIPTTYPE_NAME].ToString()), Cheq_no = redr[RECEIPT.CHEQ_NO].ToString(), Receipt_amount = ConvertTO.Decimal(redr[RECEIPT.RECEIPT_AMOUNT].ToString()), Cheq_date = redr[RECEIPT.CHEQ_DATE].ToString(), Bank_id = "1", Total_amount = ConvertTO.Decimal(redr[RECEIPT.TOTAL_AMOUNT].ToString()), Notes = redr[RECEIPT.NOTES].ToString(), Active_id = redr[RECEIPT.ACTIVE_ID].ToString(), User_id = "1", }; switch (obj.Company_id) { case "1": obj.Company_id = "1"; obj.Acy_id = "1"; break; case "3": obj.Company_id = "1"; obj.Acy_id = "2"; break; case "4": obj.Company_id = "1"; obj.Acy_id = "3"; break; } obj.Uniqueno = obj.Acy_id + "~" + obj.Company_id + "~" + obj.Receipt_no; return(obj); } return(null); } }
private static Print_QuotationList GetData(string p_id) { Quotation quotation = CQuotation_exten.PKId(p_id, new DAL()); Print_QuotationList list = new Print_QuotationList(); Print_QuotationRow row = new Print_QuotationRow(); Company obj = CCompany_exten.PKId(Current.Company_id); row.COMPANY_NAME = obj.Display_name.ToUpper(); row.ADDRESS1 = obj.Street1 + " , " + obj.Street2; row.ADDRESS2 = obj.City_id + " - " + obj.Pincode_id + " , " + obj.State_id + ". Code -33, Email : " + obj.Email; row.COMPANY_TIN = " GSTIN : " + obj.Gstin + "";// , Cell : " + obj.Cell1 + " "; row.QUOTATION_ID = p_id; row.QUOTATION_NO = "NO : " + quotation.Quotation_no.ToString(); row.QUOTATION_DATE = "DATE : " + ConvertTO.Date2S(quotation.Quotation_date); row.PARTY_NAME = quotation.Party_id; Party _party_list = CParty_exten.SearchName(quotation.Party_id, new DAL()); if (_party_list.Party_name != null) { row.STREET1 = _party_list.Street_1 + ", " + _party_list.Street_2; row.STREET2 = ""; row.CITY = _party_list.City_id + " - " + _party_list.Pincode_id + " ,"; //row.STATE = _party_list.State_id + " - " + CState_exten.GetStateCode(_party_list.State_id); row.COUNTRY = _party_list.Country_id; row.PINCODE = ""; if (_party_list.Gstin.Trim().Length != 0) { row.GSTIN += "GSTIN No : " + _party_list.Gstin; } } row.TOTAL_QTY = ConvertTO.DecimalToS(quotation.Total_qty.ToString()); row.TAXABLE_VALUE = ConvertTO.Decimal2d(quotation.Total_taxable_amount.ToString()); List <Quotationitems> klist = CQuotationitems_exten.FKId(p_id, new DAL()); row.TOTAL_SUB = (Global.ToDecimal(row.TAXABLE_VALUE).ToString()); if (quotation.Ledger_id != null) { if (quotation.Ledger_id.Trim() != "") { row.LEDGER = "Add TAX Invoice " + quotation.Ledger_id; } else { row.LEDGER = ""; } } row.ADDITIONAL = quotation.Additional.ToString(); row.OUTSTANDING = "Total Outstanding Amount : " + CQuotation_exten.GetBalance(CParty_exten.GetId_Name(quotation.Party_id)); row.GRANDTOTAL = quotation.Grandtotal.ToString(); row.AMOUNT_IN_WORDS = "Rupees : " + Global.AmountInWords(Convert.ToDecimal(quotation.Grandtotal)); list.Add(row); return(list); }