public void ToInsertUserSpecifics(UserSpecific info)
{
ElectronicaEntities db = new ElectronicaEntities();
db.UserSpecifics.Add(info);
db.SaveChanges();
}
public string UpdateCart(int id, Cart cart)
{
try
{
ElectronicaEntities db = new ElectronicaEntities();
//Fetch objects from the database
Cart n = db.Carts.Find(id);
n.DatePurchased = cart.DatePurchased;
n.ClientID = cart.ClientID;
n.Amount = cart.Amount;
n.IsInCart = cart.IsInCart;
n.ProductID = cart.ProductID;
db.SaveChanges();
return(cart.DatePurchased + "was successfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Session["Name"] = User.Identity.Name;
SetupPage();
//testing
if (!this.IsPostBack)
{
var db = new ElectronicaEntities();
{
var productType = db.ProductTypes
.Select(x => new { typeId = x.Id, Name = x.Name }).ToList();
ddlTypes.DataValueField = "typeId";
ddlTypes.DataTextField = "Name";
ddlTypes.DataSource = productType;
ddlTypes.DataBind();
}
}
}
public UserSpecific GetUserInformation(string dgk)
{
ElectronicaEntities db = new ElectronicaEntities();
UserSpecific info = (from x in db.UserSpecifics
where x.DGK == dgk
select x).FirstOrDefault();
return(info);
}
public void UpdateCartQuantity(int id, int quantity)
{
ElectronicaEntities db = new ElectronicaEntities();
Cart n = db.Carts.Find(id);
n.Amount = quantity;
db.SaveChanges();
}
public List <Cart> ObtainCartOrders(string userId)
{
ElectronicaEntities db = new ElectronicaEntities();
List <Cart> purchases = (from x in db.Carts
where x.ClientID == userId &&
x.IsInCart
orderby x.DatePurchased descending
select x).ToList();
return(purchases);
}
public void RecordOrdersAsPaidfor(List <Cart> carts)
{
ElectronicaEntities db = new ElectronicaEntities();
if (carts != null)
{
foreach (Cart cart in carts)
{
Cart exCart = db.Carts.Find(cart.ID);
exCart.DatePurchased = DateTime.Now;
exCart.IsInCart = false;
}
db.SaveChanges();
}
}
public Product Get_Prod(int id)
{
try
{
using (ElectronicaEntities db = new ElectronicaEntities())
{
Product product = db.Products.Find(id);
return(product);
}
}
catch (Exception)
{
return(null);
}
}
public string InsertProductType(ProductType productType)
{
try
{
ElectronicaEntities db = new ElectronicaEntities();
db.ProductTypes.Add(productType);
db.SaveChanges();
return(productType.Name + "was successfully inserted into the database");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string InsertCart(Cart cart)
{
try
{
ElectronicaEntities db = new ElectronicaEntities();
db.Carts.Add(cart);
db.SaveChanges();
return("was successfully added to the cart");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public List <Product> GetAlloftheProducts()
{
try
{
using (ElectronicaEntities db = new ElectronicaEntities())
{
List <Product> products = (from x in db.Products
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
//Set child control properties
//GetProductsByType function looks like this, you insert it in ProductModel
public List <Product> GetAlloftheProductsByType(int typeId)
{
try
{
using (ElectronicaEntities db = new ElectronicaEntities())
{
List <Product> products = (from x in db.Products
where x.TypeId == typeId
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public int ObtainAmtofOrders(string userId)
{
try
{
ElectronicaEntities db = new ElectronicaEntities();
int billamt = (from x in db.Carts
where x.ClientID == userId &&
x.IsInCart
select x.Amount).Sum();
return(billamt);
}
catch
{
return(0);
}
}
public string DeleteProductType(int id)
{
try
{
ElectronicaEntities db = new ElectronicaEntities();
ProductType productType = db.ProductTypes.Find(id);
db.ProductTypes.Attach(productType);
db.ProductTypes.Remove(productType);
db.SaveChanges();
return(productType.Name + "was successfully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string DeleteCart(int id)
{
try
{
ElectronicaEntities db = new ElectronicaEntities();
Cart cart = db.Carts.Find(id);
db.Carts.Attach(cart);
db.Carts.Remove(cart);
db.SaveChanges();
return(cart.DatePurchased + "was successfully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateProductType(int id, ProductType productType)
{
try
{
ElectronicaEntities db = new ElectronicaEntities();
//Fetch objects from the database
ProductType n = db.ProductTypes.Find(id);
n.Name = productType.Name;
db.SaveChanges();
return(productType.Name + "was successfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateProduct(int id, Product product)
{
try
{
ElectronicaEntities db = new ElectronicaEntities();
//Fetch objects from the database
Product n = db.Products.Find(id);
n.Name = product.Name;
n.Price = product.Price;
n.TypeId = product.TypeId;
n.Description = product.Description;
n.Image = product.Image;
db.SaveChanges();
return(product.Name + "was successfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
