protected void save_cateMenu_Click(object sender, EventArgs e)
{
eWorldEntities db = new eWorldEntities();
var t = db.CategoryMenus;
db.CategoryMenus.RemoveRange(t);
db.SaveChanges();
foreach (ListItem item in MenuCategory.Items)
{
if (item.Selected)
{
var tmp = db.Categories.Where(z => z.CategoryID.ToString() == item.Value).FirstOrDefault();
CategoryMenu cm = new CategoryMenu();
cm.CategoryID = tmp.CategoryID;
db.CategoryMenus.Add(cm);
}
}
db.SaveChanges();
MenuCategory.DataSource = GetCategories();
MenuCategory.DataBind();
}
protected void order_status_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList btn = (DropDownList)sender;
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
string id = gvr.Cells[0].Text;
db = new eWorldEntities();
var tmp = (from o in db.Orders where o.OrderID.ToString() == id select o).FirstOrDefault();
if (btn.SelectedIndex == 0)
tmp.paid = true;
else tmp.paid = false;
db.SaveChanges();
}
protected void del_cat_Click(object sender, EventArgs e)
{
int catID = Convert.ToInt16(list_cat.SelectedValue);
using (db = new eWorldEntities())
{
var cat = (from c in db.Categories where c.CategoryID == catID select c).FirstOrDefault();
if (cat != null)
{
var cat_pro = from pc in db.ProductInCategories where pc.CategoryID == catID select pc;
if (cat_pro != null)
{
var tmp = cat_pro.ToList();
int count = tmp.Count;
for (int i = 0; i < count; i++)
db.ProductInCategories.Remove(tmp[i]);
}
var cat_menu = from cm in db.CategoryMenus where cm.CategoryID == catID select cm;
if (cat_pro != null)
{
var tmp = cat_menu.ToList();
int count = tmp.Count;
for (int i = 0; i < count; i++)
db.CategoryMenus.Remove(tmp[i]);
}
db.Categories.Remove(cat);
db.SaveChanges();
delate_cat_status.Text = "Xóa nhóm sản phẩm thành công.";
delate_cat_status.Visible = true;
update_cat_status.Visible = false;
add_cat_status.Visible = false;
data_blind();
}
else
{
delate_cat_status.Text = "Có lỗi xảy ra, vui lòng thử lại.";
update_cat_status.Visible = false;
delate_cat_status.Visible = true;
add_cat_status.Visible = false;
}
}
new_name_cat.Text = "";
}
protected void add_cat_Click(object sender, EventArgs e)
{
cat = new Category();
cat.Name = add_name_cat.Text;
cat.KeyWord = add_name_cat.Text;
using (db = new eWorldEntities())
{
db.Categories.Add(cat);
db.SaveChanges();
}
add_cat_status.Text = "Thêm nhóm sản phẩm thành công.";
delate_cat_status.Visible = false;
update_cat_status.Visible = false;
add_cat_status.Visible = true;
add_name_cat.Text = "";
data_blind();
}
protected void save_info_Click(object sender, EventArgs e)
{
eWorldEntities db = new eWorldEntities();
var tmp = db.ShopInfoes;
db.ShopInfoes.RemoveRange(tmp);
ShopInfo s = new ShopInfo();
s.InfoContact = info_contact.Text;
s.Warranty = warranty.Text;
s.Showroom = showroom.Text;
db.ShopInfoes.Add(s);
db.SaveChanges();
}
public void UpdateItem(string updateCartID, int updateProductID, int quantity)
{
using (var _db = new eWorldEntities())
{
try
{
var myItem = (from c in _db.Carts 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);
}
}
}
public void RemoveItem(string removeCartID, int removeProductID)
{
using (var _db = new eWorldEntities())
{
try
{
var myItem = (from c in _db.Carts where c.CartID == removeCartID && c.Product.ProductID == removeProductID select c).FirstOrDefault();
if (myItem != null)
{
_db.Carts.Remove(myItem);
_db.SaveChanges();
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Remove Cart Item - " + exp.Message.ToString(), exp);
}
}
}
protected void update_cat_Click(object sender, EventArgs e)
{
int catID = Convert.ToInt16(list_cat.SelectedValue);
using (db = new eWorldEntities())
{
var cat = (from c in db.Categories where c.CategoryID == catID select c).FirstOrDefault();
if (cat != null)
{
cat.Name = new_name_cat.Text;
db.SaveChanges();
update_cat_status.Text = "Sửa nhóm sản phẩm thành công.";
delate_cat_status.Visible = false;
update_cat_status.Visible = true;
add_cat_status.Visible = false;
data_blind();
}
else
{
delate_cat_status.Text = "Có lỗi xảy ra, vui lòng thử lại.";
update_cat_status.Visible = true;
delate_cat_status.Visible = false;
add_cat_status.Visible = false;
}
}
new_name_cat.Text = "";
}