protected void btnLogin_Click(object sender, EventArgs e) { string username = txtUsernameLogin.Text; string enc_pwd = StringUtils.MD5(txtPassLogin.Text); using (SaleCarsEntities ctx = new SaleCarsEntities()) { User us = ctx.Users .Where(u => u.f_Username == username && u.f_Password == enc_pwd) .FirstOrDefault(); if (us != null) { Session["IsLogin"] = 1; Session["CurUser"] = us; if (chkRemember.Checked) { Response.Cookies["Username"].Value = username; Response.Cookies["Username"].Expires = DateTime.Now.AddDays(7); } string retUrl = Request.QueryString["retUrl"]; if (string.IsNullOrEmpty(retUrl)) { retUrl = "~/admin/admproducts.aspx"; } Response.Redirect(retUrl); } else { lbThongBao.Text = "Username hoặc mật khẩu không đúng!"; } } }
protected void lvwProducts_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.CommandName == "EditProduct") { int proID = Convert.ToInt32(e.CommandArgument); tempProID = proID; using (SaleCarsEntities ctx = new SaleCarsEntities()) { Product pro = ctx.Products.Where (p => p.ProID == proID).FirstOrDefault(); txtPricee.Text = pro.Price.ToString(); txtProNamee.Text = pro.ProName; txtFullDese.Text = HttpUtility.HtmlDecode(pro.FullDes); txtQuantitye.Text = pro.Quantity.ToString(); txtTinyDese.Text = HttpUtility.HtmlDecode(pro.TinyDes); ddlCategorye.SelectedValue = pro.CatID.ToString(); } //string script = "$('#modalEdit').modal('show')"; //if (ClientScript.IsStartupScriptRegistered("editProduct") == false) //{ // ClientScript.RegisterStartupScript // ( // this.GetType(), "editProduct", script, true // ); //} } }
public bool Add(CartItems item) { CartItems existedItem = Items.Where(i => i.ProID == item.ProID).FirstOrDefault(); using (SaleCarsEntities ctx = new SaleCarsEntities()) { Product pro = ctx.Products.Where(p => p.ProID == item.ProID).FirstOrDefault(); if (existedItem != null) { if (pro.Quantity < (existedItem.Quantity + item.Quantity)) { return(false); } existedItem.Quantity += item.Quantity; } else//existedItem == null { if (pro.Quantity == 0 || pro.Quantity < item.Quantity) { return(false); } Items.Add(item); } return(true); } }
protected void btnUpdate_Click(object sender, EventArgs e) { int proid = tempProID; if (proid != -1) { using (SaleCarsEntities ctx = new SaleCarsEntities()) { Product p = ctx.Products.Where(pro => pro.ProID == proid).FirstOrDefault(); if (p != null) { p.ProName = txtProNamee.Text;; p.CatID = Convert.ToInt32(ddlCategorye.SelectedItem.Value); p.Quantity = Convert.ToInt32(txtQuantitye.Text); p.Price = Convert.ToInt32(txtPricee.Text); p.TinyDes = txtTinyDese.Text; p.FullDes = txtFullDese.Text; ctx.Entry(p).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); if (FileUpload1.HasFile && FileUpload11.HasFile && FileUpload2.HasFile && FileUpload22.HasFile) { string spDirPath = Server.MapPath("~/images/products"); string targetDirPath = Path.Combine(spDirPath, p.ProID.ToString()); if (Directory.Exists(targetDirPath) == false) { Directory.CreateDirectory(targetDirPath); } //copy hình lên //hinh 1 string mainFileName = Path.Combine(targetDirPath, "1.jpg"); FileUpload1.SaveAs(mainFileName); string thumbsFileName = Path.Combine(targetDirPath, "1_thumbs.jpg"); FileUpload11.SaveAs(thumbsFileName); //hình 2 mainFileName = Path.Combine(targetDirPath, "2.jpg"); FileUpload2.SaveAs(mainFileName); thumbsFileName = Path.Combine(targetDirPath, "2_thumbs.jpg"); FileUpload22.SaveAs(thumbsFileName); } } } ClientScript.RegisterStartupScript(this.GetType(), "swal", "alert('Đã Chỉnh sửa');", true ); ClearProductInfo(); tempProID = -1; LoadProducts(); } }
protected void btnSavePro_Click(object sender, EventArgs e) { string proName = txtProName.Text; int catID = Convert.ToInt32(ddlCategory.SelectedItem.Value); int quantity = Convert.ToInt32(txtQuantity.Text); int price = Convert.ToInt32(txtPrice.Text); string tinyDes = txtTinyDes.Text; string fullDes = txtFullDes.Text; Product p = new Product { DOR = DateTime.Now, ProName = proName, CatID = catID, Quantity = quantity, Price = price, TinyDes = tinyDes, FullDes = fullDes }; using (SaleCarsEntities ctx = new SaleCarsEntities()) { ctx.Products.Add(p); ctx.SaveChanges(); } if (fuPhotoL1.HasFile && fuPhotoN1.HasFile) { //tạo thư mục chứa hình string spDirPath = Server.MapPath("~/images/products"); string targetDirPath = Path.Combine(spDirPath, p.ProID.ToString()); Directory.CreateDirectory(targetDirPath); //copy hình lên //hinh 1 string mainFileName = Path.Combine(targetDirPath, "1.jpg"); fuPhotoL1.SaveAs(mainFileName); string thumbsFileName = Path.Combine(targetDirPath, "1_thumbs.jpg"); fuPhotoN1.SaveAs(thumbsFileName); //hình 2 mainFileName = Path.Combine(targetDirPath, "2.jpg"); fuPhotoL2.SaveAs(mainFileName); thumbsFileName = Path.Combine(targetDirPath, "2_thumbs.jpg"); fuPhotoN2.SaveAs(thumbsFileName); } ClientScript.RegisterStartupScript(this.GetType(), "swal", "alert('Đã thêm');", true ); ClearProductInfo(); LoadProducts(); }
private void LoadCats() { using (SaleCarsEntities ctx = new SaleCarsEntities()) { List <Category> list = ctx.Categories.ToList(); lvwCats.DataSource = list; lvwCats.DataBind(); } }
private void LoadOrders() { using (SaleCarsEntities ctx = new SaleCarsEntities()) { List <Order> list = ctx.Orders.ToList(); lvwOrders.DataSource = list; lvwOrders.DataBind(); } }
private void LoadProducts() { using (SaleCarsEntities ctx = new SaleCarsEntities()) { List <Product> list = ctx.Products.Include("Category").ToList(); lvwProducts.DataSource = list; lvwProducts.DataBind(); } }
private void LoadBrands() { using (SaleCarsEntities ctx = new SaleCarsEntities()) { List <Type> list = ctx.Types.ToList(); lvwBrands.DataSource = list; lvwBrands.DataBind(); } }
protected void lvwProducts_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e) { DataPagerViewProducts.SetPageProperties(e.StartRowIndex, e.MaximumRows, false); using (SaleCarsEntities ctx = new SaleCarsEntities()) { List <Product> list = ctx.Products.Include("Category").ToList(); lvwProducts.DataSource = list; lvwProducts.DataBind(); } }
private void LoadCategoryForEdit() { using (SaleCarsEntities ctx = new SaleCarsEntities()) { List <Category> list = ctx.Categories.ToList(); ddlCategorye.DataSource = list; ddlCategorye.DataTextField = "CatName"; ddlCategorye.DataValueField = "CatID"; ddlCategorye.DataBind(); } }
//phan trang protected void lvwBrands_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e) { DataPagerView.SetPageProperties(e.StartRowIndex, e.MaximumRows, false); using (SaleCarsEntities ctx = new SaleCarsEntities()) { List <Category> list = ctx.Categories.ToList(); lvwBrands.DataSource = list; lvwBrands.DataBind(); } }
protected void lvwBrands_ItemDeleting(object sender, ListViewDeleteEventArgs e) { var typeID = Convert.ToInt32(e.Keys["TypeID"]); using (SaleCarsEntities ctx = new SaleCarsEntities()) { Type type = ctx.Types.Where(c => c.TypeID == typeID).FirstOrDefault(); if (type != null) { ctx.Types.Remove(type); ctx.SaveChanges(); LoadBrands(); } } }
protected void lvwProducts_ItemDeleting(object sender, ListViewDeleteEventArgs e) { var proID = Convert.ToInt32(e.Keys["ProID"]); using (SaleCarsEntities ctx = new SaleCarsEntities()) { Product pro = ctx.Products.Where(c => c.ProID == proID).FirstOrDefault(); if (pro != null) { ctx.Products.Remove(pro); ctx.SaveChanges(); LoadProducts(); } } }
protected void lvwOrders_ItemDeleting(object sender, ListViewDeleteEventArgs e) { var orderID = Convert.ToInt32(e.Keys["OrderID"]); using (SaleCarsEntities ctx = new SaleCarsEntities()) { Order order = ctx.Orders.Where(c => c.OrderID == orderID).FirstOrDefault(); if (order != null) { ctx.Orders.Remove(order); ctx.SaveChanges(); LoadOrders(); } } }
protected void lvwCats_ItemDeleting(object sender, ListViewDeleteEventArgs e) { var catID = Convert.ToInt32(e.Keys["CatID"]); using (SaleCarsEntities ctx = new SaleCarsEntities()) { Category cat = ctx.Categories.Where(c => c.CatID == catID).FirstOrDefault(); if (cat != null) { ctx.Categories.Remove(cat); ctx.SaveChanges(); LoadCats(); } } }
protected void lvwBrands_ItemUpdating(object sender, ListViewUpdateEventArgs e) { var typeID = Convert.ToInt32(e.Keys["TypeID"]); string typeName = e.NewValues["TypeName"].ToString(); using (SaleCarsEntities ctx = new SaleCarsEntities()) { Type type = ctx.Types.Where(c => c.TypeID == typeID).FirstOrDefault(); if (type != null) { type.TypeName = typeName; ctx.SaveChanges(); } } lvwBrands.EditIndex = -1; LoadBrands(); }
protected void lvwCats_ItemUpdating(object sender, ListViewUpdateEventArgs e) { var catID = Convert.ToInt32(e.Keys["CatID"]); string catName = e.NewValues["CatName"].ToString(); using (SaleCarsEntities ctx = new SaleCarsEntities()) { Category cat = ctx.Categories.Where(c => c.CatID == catID).FirstOrDefault(); if (cat != null) { cat.CatName = catName; //ctx.Entry(cat).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); } } lvwCats.EditIndex = -1; LoadCats(); }
protected void btnAdd_Click(object sender, EventArgs e) { using (SaleCarsEntities ctx = new SaleCarsEntities()) { Category cat = new Category { CatName = txtProName.Text }; txtProName.Text = string.Empty; ctx.Categories.Add(cat); ctx.SaveChanges(); ClientScript.RegisterStartupScript(this.GetType(), "swal", "alert('Đã thêm');", true ); LoadCats(); } }
protected void btnAdd_Click(object sender, EventArgs e) { using (SaleCarsEntities ctx = new SaleCarsEntities()) { Type cat = new Type { TypeName = txtNameBrands.Text }; txtNameBrands.Text = string.Empty; ctx.Types.Add(cat); ctx.SaveChanges(); ClientScript.RegisterStartupScript(this.GetType(), "swal", "alert('Đã thêm');", true ); LoadBrands(); } }
protected void lvwOrders_ItemUpdating(object sender, ListViewUpdateEventArgs e) { var orderID = Convert.ToInt32(e.Keys["OrderID"]); string typeName = e.NewValues["Shipment"].ToString(); ClientScript.RegisterStartupScript(this.GetType(), "swal", "alert(" + typeName + ");", true ); using (SaleCarsEntities ctx = new SaleCarsEntities()) { Order order = ctx.Orders.Where(c => c.OrderID == orderID).FirstOrDefault(); if (order != null) { int shipment = Convert.ToInt32(e.NewValues["Shipment"]); order.Shipment = shipment; ctx.SaveChanges(); } } lvwOrders.EditIndex = -1; LoadOrders(); }
public static bool IsLogged() { if ((int)HttpContext.Current.Session["IsLogin"] == 1) { return(true); } if (HttpContext.Current.Request.Cookies["Username"] != null) { string username = HttpContext.Current.Request.Cookies["Username"].Value; HttpContext.Current.Session["IsLogin"] = 1; using (SaleCarsEntities ctx = new SaleCarsEntities()) { User us = ctx.Users .Where(u => u.f_Username == username) .FirstOrDefault(); HttpContext.Current.Session["CurUser"] = us; } return(true); } return(false); }