/* Obtain all the custom brick models which admin has set it to show */
public IQueryable<Brick> GetBricks()
{
var _db = new ZVerseBrickProject.Models.ProductContext();
IQueryable<Brick> query = _db.Bricks;
query = query.Where(b => b.isVisible == true);
return query;
}
public int AddBrick(int pid, string BrickName, string BrickDesc, string BrickIncript, string BrickPrice, string BrickImagePath, string BrickJSPath, bool BrickIsVisible, string Brickshowhide , bool BrickisStandard, string text1, string text2, string text3)
{
//Debug.WriteLine("addbrick: js path is " + BrickJSPath);
//Debug.WriteLine("addbrick: showhide is " + Brickshowhide);
var myBrick = new Brick();
//myBrick.BrickID = BrickID;
myBrick.pid = pid;
myBrick.BrickName = BrickName;
myBrick.Description = BrickDesc;
myBrick.Incription = BrickIncript;
myBrick.UnitPrice = Convert.ToDouble(BrickPrice);
myBrick.ImagePath = BrickImagePath;
myBrick.JSPath = BrickJSPath;
myBrick.isVisible = BrickIsVisible;
myBrick.showhide = Brickshowhide;
myBrick.isStandard = BrickisStandard;
myBrick.tb1 = text1;
myBrick.tb2 = text2;
myBrick.tb3 = text3;
using (ProductContext _db = new ProductContext())
{
_db.Bricks.Add(myBrick);
_db.SaveChanges();
}
int id = myBrick.BrickID;
return id;
}
public void Dispose()
{
if (_db != null)
{
_db.Dispose();
_db = null;
}
}
/* Obtain all the products in the database. If category is selected ,
obtain only products within that school category */
public IQueryable<Product> GetProducts([QueryString("id")] int? categoryId)
{
var _db = new ZVerseBrickProject.Models.ProductContext();
IQueryable<Product> query = _db.Products;
if (categoryId.HasValue && categoryId > 0)
{
query = query.Where(p => p.ProductID < 16 && p.CategoryID == categoryId);
}
else
{
query = query.Where(p => p.ProductID < 16);
}
return query;
}
protected void RemoveBrick(object sender, CommandEventArgs e)
{
int brickid = Int32.Parse(e.CommandArgument.ToString());
var _db = new ZVerseBrickProject.Models.ProductContext();
Brick thebrick;
Product theproduct;
thebrick = _db.Bricks.Find(brickid);
theproduct = _db.Products.Find(thebrick.pid);
_db.Bricks.Remove(thebrick);
_db.Products.Remove(theproduct);
_db.SaveChanges();
Response.Redirect("AdminPage.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
public IQueryable<Brick> GetBrick([QueryString("brickID")] int? brickId)
{
var _db = new ZVerseBrickProject.Models.ProductContext();
IQueryable<Brick> query = _db.Bricks;
//query = query.Where(p => p.BrickID == 1);
if (brickId.HasValue && brickId > 0)
{
query = query.Where(p => p.BrickID == brickId);
}
else
{
query = null;
}
//Debug.Write("query: " + query);
return query;
}
public int AddProduct(string ProductName, string ProductDesc, string ProductPrice, string ProductCategory, string ProductImagePath, string ProductIncript)
{
var myProduct = new Product();
myProduct.ProductName = ProductName;
myProduct.Description = ProductDesc;
myProduct.UnitPrice = Convert.ToDouble(ProductPrice);
myProduct.ImagePath = ProductImagePath;
myProduct.CategoryID = Convert.ToInt32(ProductCategory);
myProduct.Incription = ProductIncript;
using (ProductContext _db = new ProductContext())
{
_db.Products.Add(myProduct);
_db.SaveChanges();
}
int id = myProduct.ProductID;
return id;
}
protected void Page_Load(object sender, EventArgs e)
{
string rawId = Request.QueryString["ProductID"];
int productId;
if (!String.IsNullOrEmpty(rawId) && int.TryParse(rawId, out productId))
{
int currentID = Convert.ToInt16(rawId);
//create new product and brick model if it is a custom model
if((currentID < 0))
{
string text1 = Request.QueryString["tb1"];
string text2 = Request.QueryString["tb2"];
string text3 = Request.QueryString["tb3"];
string incription = string.Concat(text1, " ", text2, " ", text3);
var _db = new ZVerseBrickProject.Models.ProductContext();
Brick theproduct;
AddProducts products = new AddProducts();
AddBricks bricks = new AddBricks();
bool isStandard = false;
bool isVisible = false;
theproduct = _db.Bricks.Find(-currentID);
//Debug.WriteLine("add to cart: js path is " + theproduct.JSPath);
currentID = products.AddProduct(theproduct.BrickName, theproduct.Description,theproduct.UnitPrice.ToString(), "1", theproduct.ImagePath, incription);
bricks.AddBrick(currentID, theproduct.BrickName, theproduct.Description, incription, theproduct.UnitPrice.ToString(), theproduct.ImagePath, theproduct.JSPath, isVisible, "show", isStandard, text1, text2, text3);
}
using (ShoppingCartFunctions usersShoppingCart = new ShoppingCartFunctions())
{
usersShoppingCart.AddToCart(currentID);
}
}
else
{
Debug.Fail("ERROR : We should never get to AddToCart.aspx without a ProductId.");
throw new Exception("ERROR : It is illegal to load AddToCart.aspx without setting a ProductId.");
}
Response.Redirect("ShoppingCart.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
//This function will set the brickmodel visible property to
// be false to hide the model from tab and catalogue
//protected void Hide_Click(object sender, CommandEventArgs e)
//{
// int brickid = Int32.Parse(e.CommandArgument.ToString());
// var _db = new ZVerseBrickProject.Models.ProductContext();
// //does not work
// ListView bricklistivew = (ListView)Master.FindControl("bricklist");
// Debug.Print("bricklistivew: " + bricklistivew.ToString());
//foreach (ListViewDataItem qsnItem in bricklistivew.Items)
//{
// try {
// Debug.Print("each item " + qsnItem.ToString());
// Panel p = (Panel)qsnItem.FindControl("Panel" + brickid);
// Debug.Print(p.ToString());
// p.Visible = false;
// }
// catch (Exception ex)
// {
// Debug.Print("error message" + ex.Message);
// }
//}
//foreach (ListViewItem item in bricklistivew.Items)
//{
// if (item.ItemType == ListViewItemType.DataItem)
// {
// try
// {
// Panel p = (Panel)item.FindControl("Panel" + brickid);
// p.Visible = false;
// }
// catch (Exception ex)
// {
// StatusLabel.Text = "Task could not be completed, the following error occured: " + ex.Message;
// }
// }
//}
// Brick thebrick;
// thebrick = _db.Bricks.Find(brickid);
// thebrick.isVisible = false;
// _db.SaveChanges();
// Response.Redirect("AdminPage.aspx");
//}
//This function will set the brickmodel visible property to
// be true to reveal the model on the tab and catalogue.
protected void Show_Click(object sender, CommandEventArgs e)
{
int brickid = Int32.Parse(e.CommandArgument.ToString());
var _db = new ZVerseBrickProject.Models.ProductContext();
Brick thebrick;
thebrick = _db.Bricks.Find(brickid);
//toggle the visibility property
if (thebrick.isVisible)
{
thebrick.showhide = "Hide";
thebrick.isVisible = false;
}
else
{
thebrick.showhide = "Show";
thebrick.isVisible = true;
}
_db.SaveChanges();
Response.Redirect("AdminPage.aspx");
}
protected void lv_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName.Equals("testbrick"))
{
//TextBox t = bricklist.Items[Convert.ToInt32(e.CommandArgument)].FindControl("brickid") as TextBox;
TextBox brickid = e.Item.FindControl("brickid") as TextBox;
TextBox brickname = e.Item.FindControl("brickname") as TextBox;
TextBox brickprice = e.Item.FindControl("brickprice") as TextBox;
Debug.Print(brickid.Text + " " + brickname.Text + " " + brickprice.Text);
int bid = Int32.Parse(brickid.Text);
var _db = new ZVerseBrickProject.Models.ProductContext();
Brick thebrick;
thebrick = _db.Bricks.Find(bid);
thebrick.BrickName = brickname.Text;
thebrick.UnitPrice = Double.Parse(brickprice.Text);
_db.SaveChanges();
Response.Redirect("AdminPage.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
}
public IQueryable<Brick> GetBricks()
{
var _db = new ZVerseBrickProject.Models.ProductContext();
IQueryable<Brick> query = _db.Bricks;
return query;
}
/* Obtain all the school categories of the products */
public IQueryable<Category> GetCategories()
{
var _db = new ZVerseBrickProject.Models.ProductContext();
IQueryable<Category> query = _db.Categories;
return query;
}
/* Responsible for the hyperlink to the product or brick detail page */
protected void producturlClick(object sender, CommandEventArgs e)
{
int productid = Convert.ToInt32(e.CommandArgument.ToString());
Debug.WriteLine("shopping cart: " + productid);
if (productid > 15)
{
ProductContext _db = new ProductContext();
int brickid = (from b in _db.Bricks where b.pid == productid select b.BrickID).FirstOrDefault();
Response.Redirect("TestDisplay.aspx?brickID=" + brickid);
}else
{
Response.Redirect("ProductDetails.aspx?productID=" + productid);
}
Context.ApplicationInstance.CompleteRequest();
}
/* Update the shopping cart table in database when update check button is pressed */
public void UpdateShoppingCartDatabase(String cartId, ShoppingCartUpdates[] CartItemUpdates)
{
using (var db = new ZVerseBrickProject.Models.ProductContext())
{
try
{
int CartItemCount = CartItemUpdates.Count();
List<CartItem> myCart = GetCartItems();
foreach (var cartItem in myCart)
{
// Iterate through all rows within shopping cart list
for (int i = 0; i < CartItemCount; i++)
{
if (cartItem.Product.ProductID == CartItemUpdates[i].ProductId)
{
if (CartItemUpdates[i].PurchaseQuantity < 1 || CartItemUpdates[i].RemoveItem == true)
{
RemoveItem(cartId, cartItem.ProductId);
}
else
{
UpdateItem(cartId, cartItem.ProductId, CartItemUpdates[i].PurchaseQuantity);
}
}
}
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Update Cart Database - " + exp.Message.ToString(), exp);
}
}
}
/* Update the quantity of an item in the database */
public void UpdateItem(string updateCartID, int updateProductID, int quantity)
{
using (var _db = new ZVerseBrickProject.Models.ProductContext())
{
try
{
var myItem = (from c in _db.ShoppingCartItems where c.CartId == updateCartID && c.Product.ProductID == updateProductID select c).FirstOrDefault();
if (myItem != null)
{
myItem.Quantity = quantity;
_db.SaveChanges();
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp);
}
}
}
/* Remove an item from the cart in the databse */
public void RemoveItem(string removeCartID, int removeProductID)
{
using (var _db = new ZVerseBrickProject.Models.ProductContext())
{
try
{
var myItem = (from c in _db.ShoppingCartItems where c.CartId == removeCartID && c.Product.ProductID == removeProductID select c).FirstOrDefault();
if (myItem != null)
{
// Remove Item.
_db.ShoppingCartItems.Remove(myItem);
//remove custom models
if (removeProductID > 15)
{
Brick thebrick;
Product theproduct;
int brickid = (from b in _db.Bricks where b.pid == removeProductID select b.BrickID).FirstOrDefault();
thebrick = _db.Bricks.Find(brickid);
theproduct = _db.Products.Find(removeProductID);
_db.Bricks.Remove(thebrick);
_db.Products.Remove(theproduct);
}
_db.SaveChanges();
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Remove Cart Item - " + exp.Message.ToString(), exp);
}
}
}
protected void UploadButton_Click(object sender, EventArgs e)
{
if (FileUploadControl.HasFile)
{
try
{
if (FileUploadControl.PostedFile.ContentType == "application/javascript")
{
string fileName = Path.GetFileName(FileUploadControl.FileName);
FileUploadControl.SaveAs(Server.MapPath("~/js/") + fileName);
StatusLabel.Text = "Upload status: File uploaded!";
var _db = new ZVerseBrickProject.Models.ProductContext();
AddProducts products = new AddProducts();
AddBricks bricks = new AddBricks();
int currentID = products.AddProduct("New Product", "Newly Released Product!", "5", "2", "newUpload.jpg", "test");
bricks.AddBrick(currentID, "New Model", "admin uploaded model", "test", "5", "newUpload.jpg", fileName, false, "Show", true, "", "", "");
}
else
StatusLabel.Text = "Upload status: Only Javascript files are accepted!";
}
catch (Exception ex)
{
StatusLabel.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
}
}
}
