public int DeletePayment(string PaymentNo)
{
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Entity.TblPayment emp = new Model.Entity.TblPayment();
Customer DeleteItem = new Customer();
//Add record
{
emp = dBContext.TblPayment.FirstOrDefault(asd => asd.PaymentNo == PaymentNo);
if (emp != null)
{
//emp = new Employes();
//emp.Id = EmployesModel.Id;
dBContext.TblPayment.Remove(emp);
}
}
returnVal = dBContext.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
public int DeleteInvoice(string InvoiceNo)
{
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Entity.TblPayment inv = new Model.Entity.TblPayment();
Model.Entity.TblInvoices emp = new Model.Entity.TblInvoices();
//Customer DeleteItem = new Customer();
//Add record
{
emp = dBContext.TblInvoices.FirstOrDefault(asd => asd.InvoiceNo == InvoiceNo);
inv = dBContext.TblPayment.FirstOrDefault(asd => asd.InvoiceNo == InvoiceNo);
if (inv == null)
{
if (emp != null)
{
dBContext.TblInvoices.Remove(emp);
returnVal = dBContext.SaveChanges();
}
}
else
{
returnVal = -1;
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
public int UpdatePayment(Payment PaymentModel, string PaymentNo, string PaymentName)
{
List <Payment> Items = new List <Payment>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Payment get;
foreach (var it in dBContext.TblPayment)
{
get = new Payment();
get.PaymentNo = it.PaymentNo;
get.InvoiceNo = it.InvoiceNo;
get.PaymentDate = it.PaymentDate;
get.PaymentAmount = it.PaymentAmount;
Items.Add(get);
}
Model.Entity.TblPayment Cust = new Model.Entity.TblPayment();
//Add record
Cust = dBContext.TblPayment.FirstOrDefault(asd => asd.PaymentNo == PaymentModel.PaymentNo);
//emp = new Employes();
Cust.PaymentNo = PaymentModel.PaymentNo;
Cust.InvoiceNo = PaymentModel.InvoiceNo;
Cust.PaymentDate = PaymentModel.PaymentDate;
Cust.PaymentAmount = PaymentModel.PaymentAmount;
dBContext.TblPayment.Update(Cust);
PaymentNo = Cust.PaymentNo;
bool Invoicexist = Items.Any(asd => asd.PaymentNo == PaymentNo);
if (Invoicexist == true)
{
returnVal = -1;
}
else
{
returnVal = dBContext.SaveChanges();
}
//CustomerNo = Cust.CustomerNo;
//CustomerName = Cust.CustomerName;
//bool departmentsame = Items.Any(asd => asd.CustomerName == CustomerName);
//bool departmentexist = Items.Any(asd => (asd.CustomerNo == CustomerNo) && (asd.CustomerName == CustomerName));
//if (departmentexist == true)
//{
// returnVal = dBContext.SaveChanges();
//}
//else if (departmentsame == true)
//{
// returnVal = -1;
//}
//else
//{
// returnVal = dBContext.SaveChanges();
//}
returnVal = dBContext.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
