public static bool addOrder(List <Order_Received> listOrder_Received) { try { string conn = @"Data Source=LAPTOP\SQLEXPRESS;Initial Catalog=Sample;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; POSDBDataContext DB = new POSDBDataContext(conn); Order order = new Order(); order.Date = DateTime.Now; foreach (var item in listOrder_Received) { Order_Detail details = new Order_Detail(); //{ Product_ID = item.Product_ID, Quantity = item.Quantity, Order = order };\ details.Product_ID = item.Product_ID; details.Quantity = item.Quantity; details.Order = order; DB.Order_Details.InsertOnSubmit(details); } DB.SubmitChanges(); return(true); } catch (Exception ex) { throw new Exception(ex.Message); } }
public static bool addFood(Product product) { try { string conn = @"Data Source=LAPTOP\SQLEXPRESS;Initial Catalog=Sample;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; POSDBDataContext DB = new POSDBDataContext(conn); DB.Products.InsertOnSubmit(product); DB.SubmitChanges(); return(true); } catch (Exception ex) { throw new Exception(ex.Message); } }
public static bool removeFood(int productID) { try { POSDBDataContext DB = new POSDBDataContext(conn); var pro = (from ee in DB.Products where ee.ID == productID select ee).ToList(); if (pro.Count == 1) { DB.Products.DeleteOnSubmit(pro.First()); DB.SubmitChanges(); } return(true); } catch (Exception ex) { throw new Exception(ex.Message); } }