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