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