public long AddReceive(receive receive)
{
try
{
//Get Party type Prefix by party Id :Kiron:27/10/2016
var partyTypePrefix = (from ptype in _entities.party_type
join par in _entities.parties on ptype.party_type_id equals par.party_type_id
where par.party_id == receive.party_id
select new
{
party_prefix = ptype.party_prefix
}).FirstOrDefault();
int prnSerial = _entities.receives.Max(po => (int?)po.receive_id) ?? 0;
if (prnSerial != 0)
{
prnSerial++;
}
else
{
prnSerial++;
}
var prnString = prnSerial.ToString().PadLeft(7, '0');
string prnNo = "MRN-" + partyTypePrefix.party_prefix + "-" + prnString;
receive insert_payment = new receive
{
receipt_no = prnNo,
receive_date = System.DateTime.Now,//receive.receive_date,
party_id = receive.party_id,
payment_method_id = receive.payment_method_id,
cheque_no = receive.cheque_no,
bank_id = receive.bank_id,
bank_branch_id = receive.bank_branch_id,
last_invoice_balance = receive.last_invoice_balance,
bank_account_id = receive.bank_account_id,
amount = receive.amount,
invoice_no = receive.invoice_no,
representative = receive.representative,
remarks = receive.remarks,
payment_req_id = receive.payment_req_id,
document_attachment = receive.document_attachment,
bank_charge = receive.bank_charge,
is_varified = receive.is_varified,
created_date = System.DateTime.Now,
created_by = receive.created_by,
is_active = true,
is_deleted = false,
};
_entities.receives.Add(insert_payment);
long saved = _entities.SaveChanges();
long receiveId = insert_payment.receive_id;
//mohi uddin(18.05.2017) start
long rqId = 0;
var paymentRequestData = _entities.payment_request.Find(receive.payment_req_id);
if (paymentRequestData != null)
{
rqId = paymentRequestData.requisition_master_id ?? 0;
if (rqId != 0)
{
receive rcvData = _entities.receives.Find(receiveId);
rcvData.requisition_master_id = rqId;
_entities.SaveChanges();
}
}
//end(18.05.2017)
if (saved > 0)
{
PaymentRequestRepository paymentRequest = new PaymentRequestRepository();
paymentRequest.UpdateStatus(insert_payment.payment_req_id, insert_payment.created_by);
}
long last_insert_id = insert_payment.receive_id;
return(last_insert_id);
}
catch (Exception ex)
{
return(0);
}
}