public void UpdateQ(int id, int quantity) { db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities(); tblPurchase p = db.tblPurchases.Find(id); p.LP_price = quantity; db.SaveChanges(); }
public List <tblPurchase> GetOrdersInCart(string custID) { db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities(); List <tblPurchase> orders = (from x in db.tblPurchases where x.cust_ID == custID && x.in_Cart orderby x.LP_date descending select x).ToList(); return(orders); }
public string InsertLaptopType(tblLaptop product) { try { db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities(); db.tblLaptops.Add(product); db.SaveChanges(); return(product.LP_name + "-Succesfully Add"); } catch (Exception e) { return("Error:" + e); } }
public tblProduct GetProduct(int ID) { try { using (db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities()) { tblProduct product = db.tblProducts.Find(ID); return(product); } } catch (Exception) { return(null); } }
public string InsertPurchase(tblPurchase product) { try { db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities(); db.tblPurchases.Add(product); db.SaveChanges(); return(product.LP_date + "-Succesfully Add"); } catch (Exception e) { return("Error:" + e); } }
public void MOAPaid(List <tblPurchase> carts) { db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities(); if (carts != null) { foreach (tblPurchase cart in carts) { tblPurchase oldCart = db.tblPurchases.Find(cart.ID); oldCart.LP_date = DateTime.Now; oldCart.in_Cart = false; } db.SaveChanges(); } }
public List <tblProduct> GetAllProducts() { try { using (db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities()) { List <tblProduct> products = (from x in db.tblProducts select x).ToList(); return(products); } } catch (Exception) { return(null); } }
public List <tblProduct> GetProductsByType(int type_ID) { try { using (db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities()) { List <tblProduct> products = (from x in db.tblProducts where x.Type_ID == type_ID select x).ToList(); return(products); } } catch (Exception) { return(null); } }
public int GAOrder(string custID) { try { db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities(); int amount = (from x in db.tblPurchases where x.cust_ID == custID && x.in_Cart select x.LP_price).Sum(); return(amount); } catch { return(0); } }
public string DeleteLaptopType(int id) { try { db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities(); tblLaptop product = db.tblLaptops.Find(id); db.tblLaptops.Attach(product); db.tblLaptops.Remove(product); db.SaveChanges(); return(product.LP_name + "-Succesfully deleted"); } catch (Exception e) { return("Error:" + e); } }
public string UpdateLaptopType(int id, tblLaptop product) { try { db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities(); //get the table from db tblLaptop pro = db.tblLaptops.Find(id); pro.LP_name = product.LP_name; db.SaveChanges(); return(product.LP_name + "-Succesfully updated"); } catch (Exception e) { return("Error:" + e); } }
public string UpdatePurchase(int id, tblPurchase product) { try { db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities(); //ge the table from db tblPurchase pro = db.tblPurchases.Find(id); pro.cust_ID = product.cust_ID; pro.LP_ID = product.LP_ID; pro.LP_price = product.LP_price; pro.LP_date = product.LP_date; pro.in_Cart = product.in_Cart; db.SaveChanges(); return(product.LP_date + "-Succesfully updated"); } catch (Exception e) { return("Error:" + e); } }