public bool Add(ProductModel product)
{
try
{
using (var bikestorecontext = new SampleAutomotiveEntities())
{
Product proobj = new Product();
proobj.product_name = product.ProductName;
proobj.model_year = (short)product.ModelYear;
proobj.list_price = product.ListPrice;
proobj.brand_id = product.BrandID;
proobj.category_id = product.CategoryID;
bikestorecontext.Products.Add(proobj);
bikestorecontext.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool Update(CustomerModel customer)
{
using (var bikestoreContext = new SampleAutomotiveEntities())
{
Customer ucustomer = bikestoreContext.Customers.Where(x => x.customer_id == customer.CustomerId).FirstOrDefault();
if (ucustomer != null)
{
ucustomer.first_name = customer.FirstName;
ucustomer.last_name = customer.LastName;
ucustomer.phone = customer.Phone;
ucustomer.zip_code = customer.ZipCode;
bikestoreContext.SaveChanges();
return(true);
}
}
return(false);
}
public bool Delete(int brandId)
{
try
{
using (var bikestoreContext = new SampleAutomotiveEntities())
{
Brand brand = bikestoreContext.Brands.Where(x => x.brand_id == brandId).FirstOrDefault();
if (brand != null)
{
brand.IsActive = false;
bikestoreContext.SaveChanges();
}
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool Delete(int customerId)
{
try
{
using (var bikestoreContext = new SampleAutomotiveEntities())
{
Customer customer = bikestoreContext.Customers.Where(x => x.customer_id == customerId).FirstOrDefault();
if (customer != null)
{
customer.IsActive = false;
bikestoreContext.SaveChanges();
}
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool Add(CustomerModel customer)
{
try
{
using (var bikestoreContext = new SampleAutomotiveEntities())
{
Customer custObj = new Customer();
custObj.first_name = customer.FirstName;
custObj.last_name = customer.LastName;
custObj.phone = customer.Phone;
custObj.email = customer.Email;
custObj.IsActive = true;
custObj.zip_code = customer.ZipCode;
bikestoreContext.Customers.Add(custObj);
bikestoreContext.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
