protected void btnSave_Click(object sender, EventArgs e) { string proName = txtProductName.Text; decimal price = decimal.Parse(txtUnitPrice.Text); string dvt = cbxDonVi.SelectedValue; string image = fileUp.FileName; int slton = Int32.Parse(txtSoLuongTon.Text); DateTime date = DateTime.Parse(txtDate.Text); string mota = txtDetails.Text; int cateID = Convert.ToInt32(cbxCate.SelectedItem.Value); int suppID = Convert.ToInt32(cbxSupplier.SelectedItem.Value); Product p = new Product { ProductName = proName, UnitPrice = price, Unit = dvt, LinkImage = image, Discount = slton, DateReceived = date, Details = mota, CategoryID = cateID, SupplierID = suppID }; db.Products.Add(p); db.SaveChanges(); if (fileUp.HasFile) { string path = Server.MapPath("~/images/product"); string filename = Path.Combine(path, fileUp.FileName); fileUp.SaveAs(filename); } logger.Info("Add Product " + p.ProductName); LoadProduct(); }
public static object UpdateProduct(Product record, bool flag) { try { var db = new DBEcommerceEntities(); var p = db.Products.SingleOrDefault(c => c.ProductID == record.ProductID); p.ProductName = record.ProductName; p.UnitPrice = record.UnitPrice; p.Unit = record.Unit; if (flag == true) { p.LinkImage = record.LinkImage; } p.Discount = record.Discount; p.NumViews = record.NumViews; p.DateReceived = record.DateReceived; p.SupplierID = record.SupplierID; p.CategoryID = record.CategoryID; p.Details = record.Details; p.NumInventory = record.NumInventory; db.SaveChanges(); return(new { Result = "OK" }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
//Product #region "Product" public static object CreateProduct(Product record) { try { var db = new DBEcommerceEntities(); var addProc = db.Products.Add(record); db.SaveChanges(); return(new { Result = "OK", Record = addProc }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public static object CreateDetail(OrderDetail record) { try { var db = new DBEcommerceEntities(); var addCate = db.OrderDetails.Add(record); db.SaveChanges(); return(new { Result = "OK", Record = addCate }); } catch (Exception ex) { logger.Error(ex); return(new { Result = "ERROR", Message = ex.Message }); } }
public static object CreateAccount(Account record) { try { var db = new DBEcommerceEntities(); record.PassWord = helpers.StringUltils.MD5(record.PassWord); var addCate = db.Accounts.Add(record); db.SaveChanges(); return(new { Result = "OK", Record = addCate }); } catch (Exception ex) { logger.Error(ex); return(new { Result = "ERROR", Message = ex.Message }); } }
public static object UpdateCate(Category record) { try { var db = new DBEcommerceEntities(); var cate = db.Categories.SingleOrDefault(c => c.CategoryID == record.CategoryID); cate.CategoryName = record.CategoryName; cate.Description = record.Description; cate.ParentId = record.ParentId; db.SaveChanges(); return(new { Result = "OK" }); } catch (Exception ex) { logger.Error(ex); return(new { Result = "ERROR", Message = ex.Message }); } }
public static object DeleteDetail(int OrderID, int ProductID) { try { var db = new DBEcommerceEntities(); var cate = db.OrderDetails.SingleOrDefault(c => c.OrderID == OrderID && c.ProductID == ProductID); if (cate != null) { db.OrderDetails.Remove(cate); db.SaveChanges(); } return(new { Result = "OK" }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public static object DeleteProduct(int ProductID) { try { var db = new DBEcommerceEntities(); var p = db.Products.SingleOrDefault(c => c.ProductID == ProductID); if (p != null) { db.Products.Remove(p); db.SaveChanges(); } return(new { Result = "OK" }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public static object DeleteCate(int CategoryID) { try { var db = new DBEcommerceEntities(); var cate = db.Categories.SingleOrDefault(c => c.CategoryID == CategoryID); if (cate != null) { db.Categories.Remove(cate); db.SaveChanges(); } return(new { Result = "OK" }); } catch (Exception ex) { logger.Error(ex); return(new { Result = "ERROR", Message = ex.Message }); } }
public static object UpdateDetail(OrderDetail record) { try { var db = new DBEcommerceEntities(); var cate = db.OrderDetails.SingleOrDefault(c => c.OrderID == record.OrderID && c.ProductID == record.ProductID); cate.Quantity = record.Quantity; cate.TotalMoney = Convert.ToDouble(record.UnitPrice * record.Quantity); db.SaveChanges(); return(new { Result = "OK" }); } catch (Exception ex) { logger.Error(ex); return(new { Result = "ERROR", Message = ex.Message }); } }
public static object UpdateAccount(Account record) { try { var db = new DBEcommerceEntities(); var cate = db.Accounts.SingleOrDefault(c => c.AccountID == record.AccountID); cate.UserName = record.UserName; cate.PassWord = helpers.StringUltils.MD5(record.PassWord); cate.RoleID = record.RoleID; cate.Enabled = record.Enabled; db.SaveChanges(); return(new { Result = "OK" }); } catch (Exception ex) { logger.Error(ex); return(new { Result = "ERROR", Message = ex.Message }); } }
protected void btnSave_Click(object sender, EventArgs e) { Account acc = db.Accounts.SingleOrDefault(m => m.AccountID == 2); if (txtPassword.Text != "") { acc.PassWord = this.txtPassword.Text; } Employee em = db.Employees.SingleOrDefault(m => m.AccountID == acc.AccountID); em.FullName = txtFullName.Text; em.Sex = cbxSex.SelectedValue; em.Phone = txtPhone.Text; em.Address = txtAddress.Text; em.BirthDate = DateTime.Parse(txtBirthDay.Text); db.SaveChanges(); BiddingEdit(acc, em); BiddingText(acc, em); }
public static object UpdateOrder(Order record) { try { var db = new DBEcommerceEntities(); var cate = db.Orders.SingleOrDefault(c => c.OrderID == record.OrderID); cate.CustomerID = record.CustomerID; cate.EmployeeID = record.EmployeeID; cate.DateBuy = record.DateBuy; cate.Status = record.Status; cate.Payments = record.Payments; db.SaveChanges(); return(new { Result = "OK" }); } catch (Exception ex) { logger.Error(ex); return(new { Result = "ERROR", Message = ex.Message }); } }