public int UpdateCustomer(Customer CustomerModel, string CustomerNo, string CustomerName)
{
List <Customer> Items = new List <Customer>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Customer get;
foreach (var it in dBContext.TblCustomer)
{
get = new Customer();
get.CustomerNo = it.CustomerNo;
get.CustomerName = it.CustomerName;
Items.Add(get);
}
Model.Entity.TblCustomer Cust = new Model.Entity.TblCustomer();
//Add record
Cust = dBContext.TblCustomer.FirstOrDefault(asd => asd.CustomerNo == CustomerModel.CustomerNo);
//emp = new Employes();
Cust.CustomerNo = CustomerModel.CustomerNo;
Cust.CustomerName = CustomerModel.CustomerName;
dBContext.TblCustomer.Update(Cust);
//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);
}
public int DeleteCustomer(string CustomerNo)
{
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Entity.TblCustomer emp = new Model.Entity.TblCustomer();
Model.Entity.TblInvoices inv = new Model.Entity.TblInvoices();
//Customer DeleteItem = new Customer();
//Add record
{
emp = dBContext.TblCustomer.FirstOrDefault(asd => asd.CustomerNo == CustomerNo);
inv = dBContext.TblInvoices.FirstOrDefault(asd => asd.CustomerNo == CustomerNo);
if (inv == null)
{
if (emp != null)
{
//emp = new Employes();
//emp.Id = EmployesModel.Id;
dBContext.TblCustomer.Remove(emp);
returnVal = dBContext.SaveChanges();
}
}
else
{
returnVal = -1;
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
