/// <summary>
/// Add new or update exist customer
/// </summary>
/// <param name="orderModel"></param>
/// <returns></returns>
public static Boolean UpdateCustomer(CustomerModel customerModel)
{
using (var db = new FasConDBEntities())
{
var customer = db.Customers.Where(c => c.CustomerId == customerModel.CustomerId).FirstOrDefault();
if (customer == null)
{
customer = new Customer
{
CustomerId = Guid.NewGuid(),
Name = customerModel.Name,
UpdatedDate = DateTime.Now,
UpdatedUserId = customerModel.UpdatedUserId,
CreatedDate = DateTime.Now,
CreatedUserId = customerModel.CreatedUserId,
StoreId = customerModel.StoreId
};
db.Customers.Add(customer);
}
else
{
customer.Name = customerModel.Name;
customer.UpdatedDate = DateTime.Now;
customer.UpdatedUserId = customerModel.UpdatedUserId;
customerModel.Deleted = customerModel.Deleted;
customer.StoreId = customerModel.StoreId;
}
db.SaveChanges();
}
return true;
}
public static CustomerModel Customer(Guid customerId)
{
CustomerModel rs = new CustomerModel();
using (var db = new FasConDBEntities())
{
rs = db.Customers.Where(c => c.Deleted == false && c.CustomerId == customerId).Select(c => new CustomerModel { CustomerId = c.CustomerId, Name = c.Name }).FirstOrDefault();
}
return rs;
}
public static Boolean DeleteCustomer(CustomerModel customerModel)
{
using (var db = new FasConDBEntities())
{
var order = db.Orders.Where(c => c.CustomerId == customerModel.CustomerId).FirstOrDefault();
if (order == null)
{
var customer = db.Customers.Where(c => c.CustomerId == customerModel.CustomerId).FirstOrDefault();
if (customer != null)
db.Customers.Remove(customer);
db.SaveChanges();
}
}
return true;
}