public static void GetUpdated(string OldDB, string newDB) { string tablename = INVOICE.INVOICE_TBL; int count = GetCount(tablename, OldDB); for (int i = 944; i <= count; i++) { Invoice.Const.Invoice obj = GetOldData(i, OldDB); if (obj != null) { List <Invoiceitems> list = GetOldItemsData(i, OldDB); InsertData(obj, list, newDB); } } }
private static bool CheckData(Invoice.Const.Invoice obj, string newDB) { string q = "USE " + newDB + "; "; q += "SELECT * FROM " + INVOICE.INVOICE_TBL + " WHERE " + INVOICE.UNIQUENO + " = '" + obj.Uniqueno + "'; "; using (IDataReader redr = new DAL().Listreader(q)) { while (redr.Read() == true) { obj.Invoice_id = redr[INVOICE.INVOICE_ID].ToString(); // CTex_Invoice.Update(obj, new DAL()); return(true); } return(false); } }
private static Invoice.Const.Invoice GetOldData(int id, string OldDB) { string q = "USE " + OldDB + "; "; q += " SELECT " + INVOICE.INVOICE_TBL + ".* \r\n"; q += ", " + PARTY.PARTY_TBL + "." + PARTY.PARTY_NAME + " \r\n"; q += ", " + TAXTYPE.TAXTYPE_TBL + "." + TAXTYPE.TAXTYPE_NAME + " \r\n"; q += ", " + SALESTYPE.SALESTYPE_TBL + "." + SALESTYPE.SALESTYPE_NAME + " \r\n"; q += ", " + TRANSPORT.TRANSPORT_TBL + "." + TRANSPORT.TRANSPORT_NAME + " \r\n"; q += ", " + DELIVEREDTO.DELIVEREDTO_TBL + "." + DELIVEREDTO.DELIVEREDTO_NAME + " \r\n"; q += " FROM " + INVOICE.INVOICE_TBL + " \r\n"; q += " INNER JOIN " + PARTY.PARTY_TBL + "\r\n"; q += " ON(" + INVOICE.INVOICE_TBL + "." + INVOICE.PARTY_ID + " = " + PARTY.PARTY_TBL + "." + PARTY.PARTY_ID + " )\r\n"; q += " INNER JOIN " + TAXTYPE.TAXTYPE_TBL + "\r\n"; q += " ON(" + INVOICE.INVOICE_TBL + "." + INVOICE.TAXTYPE_ID + " = " + TAXTYPE.TAXTYPE_TBL + "." + TAXTYPE.TAXTYPE_ID + " )\r\n"; q += " INNER JOIN " + SALESTYPE.SALESTYPE_TBL + "\r\n"; q += " ON(" + INVOICE.INVOICE_TBL + "." + INVOICE.SALESTYPE_ID + " = " + SALESTYPE.SALESTYPE_TBL + "." + SALESTYPE.SALESTYPE_ID + " )\r\n"; q += " INNER JOIN " + TRANSPORT.TRANSPORT_TBL + "\r\n"; q += " ON(" + INVOICE.INVOICE_TBL + "." + INVOICE.TRANSPORT_ID + " = " + TRANSPORT.TRANSPORT_TBL + "." + TRANSPORT.TRANSPORT_ID + " )\r\n"; q += " INNER JOIN " + DELIVEREDTO.DELIVEREDTO_TBL + "\r\n"; q += " ON(" + INVOICE.INVOICE_TBL + "." + INVOICE.DELIVEREDTO_ID + " = " + DELIVEREDTO.DELIVEREDTO_TBL + "." + DELIVEREDTO.DELIVEREDTO_ID + " )\r\n"; q += " WHERE " + INVOICE.INVOICE_TBL + "." + INVOICE.INVOICE_ID + " = '" + id + "'; \r\n"; using (IDataReader redr = new DAL().Listreader(q)) { while (redr.Read() == true) { Invoice.Const.Invoice obj = new Invoice.Const.Invoice { Uniqueno = redr[INVOICE.UNIQUENO].ToString(), Company_id = redr[INVOICE.COMPANY_ID].ToString(), Acy_id = redr[INVOICE.ACY_ID].ToString(), Order_id = "1", Invoice_no = redr[INVOICE.INVOICE_NO].ToString(), Invoice_date = redr[INVOICE.INVOICE_DATE].ToString(), Party_id = redr[PARTY.PARTY_NAME].ToString(), Taxtype_id = redr[TAXTYPE.TAXTYPE_NAME].ToString(), Salestype_id = redr[SALESTYPE.SALESTYPE_NAME].ToString(), Transport_id = redr[TRANSPORT.TRANSPORT_NAME].ToString(), Deliveredto_id = redr[DELIVEREDTO.DELIVEREDTO_NAME].ToString(), Bundel = redr[INVOICE.BUNDEL].ToString(), Total_qty = redr[INVOICE.TOTAL_QTY].ToString(), Total_taxable_amount = ConvertTO.Decimal(redr[INVOICE.TOTAL_TAXABLE_AMOUNT].ToString()), Total_cgst = ConvertTO.Decimal(redr[INVOICE.TOTAL_CGST].ToString()), Total_sgst = ConvertTO.Decimal(redr[INVOICE.TOTAL_SGST].ToString()), Total_igst = ConvertTO.Decimal(redr[INVOICE.TOTAL_IGST].ToString()), Gsttotal = ConvertTO.Decimal(redr[INVOICE.GSTTOTAL].ToString()), Ledger_id = redr[INVOICE.LEDGER_ID].ToString(), Additional = ConvertTO.Decimal(redr[INVOICE.ADDITIONAL].ToString()), Rounds = ConvertTO.Decimal(redr[INVOICE.ROUNDS].ToString()), Grandtotal = ConvertTO.Decimal(redr[INVOICE.GRANDTOTAL].ToString()), Refered_amt = ConvertTO.Decimal(redr[INVOICE.REFERED_AMT].ToString()), Locked = redr[INVOICE.LOCKED].ToString(), Notes = redr[INVOICE.NOTES].ToString(), Active_id = redr[INVOICE.ACTIVE_ID].ToString(), User_id = "1" }; obj.Uniqueno = obj.Acy_id + "~" + obj.Company_id + "~" + obj.Invoice_no; return(obj); } 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); } }