public bool Insert(OderDetail detail)
{
using (ThucLop db = new ThucLop())
{
db.OderDetails.Add(detail);
db.SaveChanges();
return true;
}
}
public int Insert(Order order)
{
using(ThucLop db = new ThucLop())
{
db.Orders.Add(order);
db.SaveChanges();
return order.ID;
}
}
/// <summary>
/// Thêm Người Dùng
/// </summary>
/// <param name="user">Danh Sách Người Dùng</param>
/// <returns></returns>
public int Insert(User user)
{
using (ThucLop db = new ThucLop())
{
db.Users.Add(user);//Thêm Người Dùng
db.SaveChanges();
return user.ID;
}
}
/// <summary>
/// Thêm Sản Phẩm
/// </summary>
/// <param name="user">Danh Sách Sản Phẩm</param>
/// <returns></returns>
public int Insert(Product product)
{
using (ThucLop db = new ThucLop())
{
db.Products.Add(product);//Thêm Sản Phẩm
db.SaveChanges();
return product.ID;
}
}
/// <summary>
/// Sửa Người Dùng
/// </summary>
/// <param name="user">Người Dùng</param>
/// <returns></returns>
public bool Update(User user)
{
using (ThucLop db = new ThucLop())
{
var model= db.Users.Find(user.ID);
if(model!=null)
{
model.Name = user.Name;
if (!string.IsNullOrEmpty(user.Password))
{
model.Password = user.Password;
}
model.Address = user.Address;
model.Email = user.Email;
model.ModifiedBy = user.ModifiedBy;
model.ModifiedDate = DateTime.Now;
db.SaveChanges();
return true;
}
else
{ return false; }
}
}
public bool Signup(User user)
{
using (ThucLop db = new ThucLop())
{
if (user != null)
{
var User = db.Users.Add(user);
db.SaveChanges();
return true;
}
else
return false;
}
}
public bool Delete(int ID)
{
using (ThucLop db = new ThucLop())
{
var user= db.Users.Find(ID);
db.Users.Remove(user);
db.SaveChanges();
return true;
}
}
/// <summary>
/// Sửa Người Dùng
/// </summary>
/// <param name="user">Người Dùng</param>
/// <returns></returns>
public bool Update(Product product)
{
using (ThucLop db = new ThucLop())
{
var model = db.Products.Find(product.ID);
if (model != null)
{
model.Name = product.Name;
model.Detail = product.Detail;
model.Price = product.Price;
model.ModifiedBy = product.ModifiedBy;
model.ModifiedDate = DateTime.Now;
model.PromotionPrice = product.PromotionPrice;
model.Image = product.Image;
model.MoreImages = product.MoreImages;
model.Quantity = product.Quantity;
model.Status = product.Status;
model.Code = product.Code;
model.Warranty = product.Warranty;
model.MetaTitle = product.MetaTitle;
model.ModifiedBy = product.ModifiedBy;
model.Description = model.Description;
model.MetaKeywords = product.MetaKeywords;
model.MetaDescriptions = product.MetaDescriptions;
model.CategoryID = product.CategoryID;
model.IncludedVAT = product.IncludedVAT;
model.TopHot = product.TopHot;
db.SaveChanges();
return true;
}
else
{ return false; }
}
}
public bool Delete(int ID)
{
using (ThucLop db = new ThucLop())
{
var product = db.Products.Find(ID);
db.Products.Remove(product);
db.SaveChanges();
return true;
}
}