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 });
}
}
