public static void AddWines(Wine wine)//This is Add method.
{
try
{
using (WineShopEntities db = new WineShopEntities())
{
db.Wines.Add(wine);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void SaveCustomers(Customer Obj_Customer_Save)//This is Add method.
{
try
{
using (WineShopEntities db = new WineShopEntities())
{
db.Customers.Add(Obj_Customer_Save);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void AddRateLists(RateList rateList)//Add method.
{
try
{
using (WineShopEntities db = new WineShopEntities())
{
db.RateLists.Add(rateList);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void AddCustomers(Customer customer)//Add method.
{
try
{
using (WineShopEntities db = new WineShopEntities())
{
db.Customers.Add(customer);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void SaveRateLists(RateList Obj_RateList_Save)//This is Add method.
{
try
{
using (WineShopEntities db = new WineShopEntities())
{
db.RateLists.Add(Obj_RateList_Save);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int UpdateRateList(RateList rateList)
{
try
{
using (WineShopEntities db = new WineShopEntities())
{
//Lambda expression
RateList r = db.RateLists.SingleOrDefault(x => x.ID == rateList.ID);
r.Price = rateList.Price;
db.SaveChanges();
return(rateList.ID);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int UpdateWine(Wine Obj_Wine_Update)
{
try
{
using (WineShopEntities db = new WineShopEntities())
{
//Lambda expression
Wine c = db.Wines.SingleOrDefault(x => x.ID == Obj_Wine_Update.ID);
c.Name = Obj_Wine_Update.Name;
db.SaveChanges();
return(Obj_Wine_Update.ID);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void DeleteWine(string wineID)
{
try
{
using (WineShopEntities db = new WineShopEntities())
{
//Lambda expression
Wine w = db.Wines.SingleOrDefault(x => x.ID.ToString().Trim() == wineID.Trim());
if (w != null)
{
db.Wines.Remove(w);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void DeleteRateList(string rateListID)
{
try
{
using (WineShopEntities db = new WineShopEntities())
{
//Lambda expression
RateList r = db.RateLists.SingleOrDefault(x => x.ID.ToString().Trim() == rateListID.Trim());
if (r != null)
{
db.RateLists.Remove(r);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void DeleteCustomer(string Obj_Customer_Delete)
{
try
{
using (WineShopEntities db = new WineShopEntities())
{
//Lambda expression
Customer c = db.Customers.SingleOrDefault(x => x.ID.ToString().Trim() == Obj_Customer_Delete.Trim());
if (c != null)
{
db.Customers.Remove(c);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int UpdateCustomer(Customer Obj_Customer_Update)
{
try
{
using (WineShopEntities db = new WineShopEntities())
{
//Lambda expression
Customer c = db.Customers.SingleOrDefault(x => x.ID == Obj_Customer_Update.ID);
c.Name = Obj_Customer_Update.Name;
c.Age = Obj_Customer_Update.Age;
c.Email = Obj_Customer_Update.Email;
c.RateListID = Obj_Customer_Update.RateListID;
c.WineID = Obj_Customer_Update.WineID;
db.SaveChanges();
return(Obj_Customer_Update.ID);
}
}
catch (Exception ex)
{
throw ex;
}
}