public bool AddOrUpdateProduct(Product product)
{
bool success = true;
try
{
if (product.ProductId > 0)
{
Product existing = context.Products.Where(x => x.ProductId == product.ProductId).FirstOrDefault();
existing.CommissionPercentage = product.CommissionPercentage;
existing.Manufacturer = product.Manufacturer;
existing.ProductName = product.ProductName;
existing.PurchasePrice = product.PurchasePrice;
existing.QtyOnHand = product.QtyOnHand;
existing.SalePrice = product.SalePrice;
existing.Style = product.Style;
}
else
{
context.Products.Add(product);
}
context.SaveChanges();
}
catch (Exception e)
{
success = false;
}
return(success);
}
public bool AddOrUpdateSalesPerson(SalesPerson salesPerson)
{
bool success = true;
try
{
if (salesPerson.SalesPersonId > 0)
{
SalesPerson existing = context.SalesPersons.Where(x => x.SalesPersonId == salesPerson.SalesPersonId).FirstOrDefault();
existing.City = salesPerson.City;
existing.FirstName = salesPerson.FirstName;
existing.LastName = salesPerson.LastName;
existing.StartDate = salesPerson.StartDate;
existing.TerminationDate = salesPerson.TerminationDate;
existing.Manager = salesPerson.Manager;
existing.State = salesPerson.State;
existing.StreetAddress = salesPerson.StreetAddress;
existing.ZipCode = salesPerson.ZipCode;
}
else
{
context.SalesPersons.Add(salesPerson);
}
context.SaveChanges();
}
catch (Exception e)
{
success = false;
}
return(success);
}
public bool AddOrUpdateCustomer(Customer customer, DateTime?saleDate)
{
bool success = true;
try
{
if (customer.CustomerId > 0)
{
Customer existing = context.Customers.Where(x => x.CustomerId == customer.CustomerId).FirstOrDefault();
existing.City = customer.City;
existing.FirstName = customer.FirstName;
existing.LastName = customer.LastName;
existing.StartDate = saleDate != null && saleDate < existing.StartDate ? (DateTime)saleDate : existing.StartDate;
existing.State = customer.State;
existing.StreetAddress = customer.StreetAddress;
existing.ZipCode = customer.ZipCode;
}
else
{
customer.StartDate = saleDate == null ? DateTime.Now : (DateTime)saleDate;
context.Customers.Add(customer);
}
context.SaveChanges();
}
catch (Exception e)
{
success = false;
}
return(success);
}
public void CreateSale(Sale sale)
{
try
{
context.Sales.Add(sale);
context.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
