public CustomerRcieptVM GetRecPayByRecpayID(int RecpayID) { CustomerRcieptVM cust = new CustomerRcieptVM(); if (RecpayID <= 0) { return(new CustomerRcieptVM()); } var query = Context1.SP_GetCustomerRecieptByRecPayID(RecpayID); if (query != null) { var item = query.FirstOrDefault(); cust.RecPayDate = item.RecPayDate; cust.DocumentNo = item.DocumentNo; cust.CustomerID = item.CustomerID; var cashOrBankID = (from t in Context1.AcHeads where t.AcHead1 == item.BankName select t.AcHeadID).FirstOrDefault(); cust.CashBank = (cashOrBankID).ToString(); cust.ChequeBank = (cashOrBankID).ToString(); cust.ChequeNo = item.ChequeNo; cust.ChequeDate = item.ChequeDate; cust.Remarks = item.Remarks; cust.EXRate = item.EXRate; cust.FMoney = item.FMoney; cust.RecPayID = item.RecPayID; cust.SupplierID = item.SupplierID; cust.AcJournalID = item.AcJournalID; cust.StatusEntry = item.StatusEntry; var a = (from t in Context1.RecPayDetails where t.RecPayID == RecpayID select t.CurrencyID).FirstOrDefault(); cust.CurrencyId = Convert.ToInt32(a.HasValue ? a.Value : 0); } else { return(new CustomerRcieptVM()); } return(cust); }
public int EditSupplierRecPay(CustomerRcieptVM RecPy, string UserID) { if (RecPy.RecPayID > 0) { try { //Edit Code RecPay objRecPay = Context1.RecPays.Where(item => item.RecPayID == RecPy.RecPayID).FirstOrDefault(); objRecPay.BankName = RecPy.BankName; objRecPay.ChequeDate = RecPy.ChequeDate; objRecPay.ChequeNo = RecPy.ChequeNo; objRecPay.EXRate = RecPy.EXRate; objRecPay.FMoney = RecPy.FMoney; objRecPay.RecPayDate = RecPy.RecPayDate; objRecPay.Remarks = RecPy.Remarks; objRecPay.FYearID = RecPy.FYearID; objRecPay.AcJournalID = RecPy.AcJournalID; objRecPay.SupplierID = RecPy.SupplierID; objRecPay.UserID = Convert.ToInt32(UserID); if (RecPy.CashBank != null) { objRecPay.BankName = RecPy.CashBank; } else { objRecPay.BankName = RecPy.ChequeBank; } Context1.Entry(objRecPay).State = EntityState.Modified; Context1.SaveChanges(); } catch (Exception) { return(0); } } return(1); }
public int AddCustomerRecieptPayment(CustomerRcieptVM RecPy, string UserID) { int query = Context1.SP_InsertRecPay(RecPy.RecPayDate, RecPy.DocumentNo, RecPy.CustomerID, RecPy.SupplierID, RecPy.BusinessCentreID, RecPy.BankName, RecPy.ChequeNo, RecPy.ChequeDate, RecPy.Remarks, RecPy.AcJournalID, RecPy.StatusRec, RecPy.StatusEntry, RecPy.StatusOrigin, RecPy.FYearID, RecPy.AcCompanyID, RecPy.EXRate, RecPy.FMoney, Convert.ToInt32(UserID)); return(query); }