public void bind_data()
{
eWorldEntities db = new eWorldEntities();
var tmp = db.ShopInfoes.FirstOrDefault();
info_contact.Text = tmp.InfoContact;
warranty.Text = tmp.Warranty;
showroom.Text = tmp.Showroom;
var tmp2 = db.ImageBanners.ToList();
foreach (ImageBanner im in tmp2)
{
listofuploadedfiles.Text += String.Format("<br />{0}", im.Path);
}
var tmp3 = db.ImageSlides.ToList();
foreach (ImageSlide im in tmp3)
{
list_upload_slide.Text += String.Format("<br />{0}", im.Path);
}
var tmp4 = db.CategoryMenus.ToList();
foreach (CategoryMenu cm in tmp4)
{
foreach (ListItem lt in MenuCategory.Items)
{
if (cm.CategoryID.ToString() == lt.Value)
{
lt.Selected = true;
break;
}
}
}
}
public List<Product> GetProduct()
{
using (db = new eWorldEntities())
{
var result = db.Products.ToList();
return result;
}
}
public List<Order> GetOrder()
{
using (db = new eWorldEntities())
{
var result = db.Orders.ToList();
return result;
}
}
public void Dispose()
{
if (db != null)
{
db.Dispose();
db = null;
}
}
public List<Category> GetCategories()
{
using (db = new eWorldEntities())
{
var tmp = from c in db.Categories
select c;
var result = tmp.ToList<Category>();
return result;
}
}
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 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 List<Order> GetOrder()
{
string email = HttpContext.Current.User.Identity.Name;
using (db = new eWorldEntities())
{
var result = db.Orders.Where(z => z.Email == email).ToList();
if(result.Count == 0)
{
Title_EmptyOrder.Visible = true;
}
return result;
}
}
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 Page_PreRender(object sender, EventArgs e)
{
db = new eWorldEntities();
var tmp = db.Orders.ToList();
for (int i = 0; i < OrderList.Rows.Count; i++)
{
DropDownList status = new DropDownList();
status = (DropDownList)OrderList.Rows[i].FindControl("order_status");
if (tmp[i].paid == true)
{
//OrderList.Rows[i].Cells[4].Text = "DDax";
status.SelectedIndex = 0;
}
else
{
//OrderList.Rows[i].Cells[4].Text = "Chuaw";
status.SelectedIndex = 1;
}
}
}
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();
}
public List<OrderDetail> GetOrderDetail()
{
db = new eWorldEntities();
return db.OrderDetails.Where(z => z.OrderID == order_id).ToList();
}
protected void submit_banner_Click(object sender, EventArgs e)
{
eWorldEntities db = new eWorldEntities();
var tmp = db.ImageBanners;
db.ImageBanners.RemoveRange(tmp);
if (banner.HasFiles)
{
foreach (HttpPostedFile uploadedFile in banner.PostedFiles)
{
uploadedFile.SaveAs(MapPath("~/style/image/banner/") + uploadedFile.FileName);
listofuploadedfiles.Text += String.Format("<br />{0}", uploadedFile.FileName);
ImageBanner im = new ImageBanner();
im.Path = uploadedFile.FileName;
db.ImageBanners.Add(im);
}
}
}
public IQueryable GetCategories()
{
var _db = new eWorldEntities();
IQueryable query = _db.Categories;
return query;
}
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);
}
}
}
public decimal GetTotal()
{
using (db = new eWorldEntities())
{
ShoppingCartId = GetCartId();
decimal? total = decimal.Zero;
total = (decimal?)(from cartItems in db.Carts
where cartItems.CartID == ShoppingCartId
select (int?)cartItems.Quantity *
cartItems.Product.Price).Sum();
return total ?? decimal.Zero;
}
}
public List<Cart> GetCartItems()
{
ShoppingCartId = GetCartId();
db = new eWorldEntities();
// var tmp = from c in db.Carts
// where c.CartID == ShoppingCartId
// select c;
// var result = tmp.ToList();
// return result;
return db.Carts.Where(
c => c.CartID == ShoppingCartId).ToList();
}
protected void Page_Load(object sender, EventArgs e)
{
string productAction = Request.QueryString["ProductAction"];
if (productAction == "edit")
{
LabelAddStatus.Text = "Sản phẩm đã được sửa thành công.";
}
if (!IsPostBack)
{
pro_id = Convert.ToInt32(Session["edit_pro_id"].ToString());
db = new eWorldEntities();
p = db.Products.Where(z => z.ProductID == pro_id).FirstOrDefault();
bind_data(p);
}
}
public List<Category> GetCategories()
{
var db = new eWorldEntities();
return db.Categories.ToList();
}
public IQueryable GetStock()
{
var _db = new eWorldEntities();
IQueryable query = _db.ProductStocks;
return query;
}
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 = "";
}
