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