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