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); }
void txt_receipttype_LookupUpdate(object sender, EventArgs e) { txt_receipttype_id.LookupList = CReceipttype_exten.GetforLookup(new DAL()); }
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); } }