public CustomerRcieptVM GetSupplierRecPayByRecpayID(int RecpayID) { CustomerRcieptVM cust = new CustomerRcieptVM(); if (RecpayID <= 0) { return(new CustomerRcieptVM()); } var query = Context1.RecPays.Find(RecpayID); if (query != null) { var item = query; cust.RecPayDate = item.RecPayDate; cust.DocumentNo = item.DocumentNo; cust.SupplierID = item.SupplierID; var supplier = Context1.SupplierMasters.Find(item.SupplierID); cust.customerName = supplier.SupplierName; cust.SupplierTypeId = Convert.ToInt32(supplier.SupplierTypeID); cust.StatusEntry = item.StatusEntry; var cashOrBankID = (from t in Context1.AcHeads where t.AcHead1 == item.BankName select t.AcHeadID).FirstOrDefault(); if (cust.StatusEntry == "CS") { cust.CashBank = (cashOrBankID).ToString(); } else { 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.AcJournalID = item.AcJournalID; if (item.TruckDetailId != null) { cust.TruckDetailId = Convert.ToInt32(item.TruckDetailId); var td = Context1.TruckDetails.Find(cust.TruckDetailId); if (td != null) { cust.TDNo = td.ReceiptNo; } } var a = (from t in Context1.RecPayDetails where t.RecPayID == RecpayID select t.CurrencyID).FirstOrDefault(); if (a.HasValue) { cust.CurrencyId = Convert.ToInt32(a.Value); } } 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 InsertRecpayDetailsForCust(int RecPayID, int InvoiceID,int JInvoiceID, decimal Amount, string Remarks, string StatusInvoice, bool StatusAdvance, string statusReceip, string InvDate, string InvNo, int CurrencyID, int invoiceStatus,int JobID) //{ // int query = Context1.SP_InsertRecPayDetailsForCustomer(RecPayID, JInvoiceID // , Amount, Remarks, StatusInvoice // , StatusAdvance, statusReceip, InvDate // , InvNo, CurrencyID, invoiceStatus, JobID); // return query; //} //public int InsertRecpayDetailsForSup(int RecPayID, int InvoiceID,int JInvoiceID, decimal Amount, string Remarks, string StatusInvoice, bool StatusAdvance, string statusReceip, string InvDate, string InvNo, int CurrencyID, int invoiceStatus, int JobID) //{ // //todo:fix to run by sethu // int query = Context1.SP_InsertRecPayDetailsForSupplier(RecPayID, InvoiceID, Amount, Remarks, StatusInvoice, StatusAdvance, statusReceip, InvDate, InvNo, CurrencyID, invoiceStatus, JobID); // return query; //} public CustomerRcieptVM GetRecPayByRecpayID(int RecpayID) { CustomerRcieptVM cust = new CustomerRcieptVM(); if (RecpayID <= 0) { return(new CustomerRcieptVM()); } var query = Context1.RecPays.Find(RecpayID); // .SP_GetCustomerRecieptByRecPayID(RecpayID); if (query != null) { var item = query; //.FirstOrDefault(); cust.RecPayDate = item.RecPayDate; cust.DocumentNo = item.DocumentNo; cust.CustomerID = item.CustomerID; cust.customerName = Context1.CustomerMasters.Find(item.CustomerID).CustomerName; var cashOrBankID = (from t in Context1.AcHeads where t.AcHead1 == item.BankName select t.AcHeadID).FirstOrDefault(); cust.StatusEntry = item.StatusEntry; if (cust.StatusEntry == "CS") { cust.CashBank = (cashOrBankID).ToString(); } else { 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.AcOPInvoiceDetailID = 0; if (item.PaymentRef != null) { cust.PaymentRef = item.PaymentRef; } else { cust.PaymentRef = ""; } if (cust.StatusEntry == "CS") { cust.CashBank = (cashOrBankID).ToString(); } else if (cust.StatusEntry == "BK") { cust.ChequeBank = (cashOrBankID).ToString(); } else { cust.OPRefNo = item.BankName; if (item.AcOPInvoiceDetailID != null) { cust.AcOPInvoiceDetailID = Convert.ToInt32(item.AcOPInvoiceDetailID); } } 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); }