public List <Model.Common.Customer> GetCustomer()
{
List <Model.Common.Customer> Items = new List <Model.Common.Customer>();
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Common.Customer cust;
foreach (var it in dBContext.TblCustomer)
{
cust = new Model.Common.Customer();
cust.CustomerNo = it.CustomerNo;
cust.CustomerName = it.CustomerName;
Items.Add(cust);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(Items);
}
public int AddCustomerData(Model.Common.Customer CustomerModel, string CustomerNo)
{
List <Model.Common.Customer> Items = new List <Model.Common.Customer>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Common.Customer get;
foreach (var it in dBContext.TblCustomer)
{
get = new Model.Common.Customer();
get.CustomerNo = it.CustomerNo;
get.CustomerName = it.CustomerName;
Items.Add(get);
}
TblCustomer Cust;
//Add record
Cust = new TblCustomer();
Cust.CustomerNo = CustomerModel.CustomerNo;
Cust.CustomerName = CustomerModel.CustomerName;
CustomerNo = Cust.CustomerNo;
bool CustNo = Items.Any(asd => asd.CustomerNo == CustomerNo);
if (CustNo == true)
{
returnVal = -1;
}
if (CustNo == false)
{
dBContext.TblCustomer.Add(Cust);
returnVal = dBContext.SaveChanges();
}
//returnVal = dBContext.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}