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