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; } }