public bool InsertSaleDetail(SaleDetail detail)
{
using (EShopDB db = new EShopDB())
{
db.SaleDetail.Add(detail);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool InsertBookInfo(BookInfo bookInfo)
{
using (EShopDB db = new EShopDB())
{
db.BookInfo.Add(bookInfo);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool InsertCartInfo(ShoppingCart cInfo)
{
using (EShopDB db = new EShopDB())
{
db.ShoppingCart.Add(cInfo);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool InsertBookSale(BookSale bookSale)
{
using (EShopDB db = new EShopDB())
{
db.BookSale.Add(bookSale);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool InsertRecommend(Recommend recommend)
{
using (EShopDB db = new EShopDB())
{
db.Recommend.Add(recommend);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool InsertUserInfo(UserInfo userInfo)
{
using (EShopDB db = new EShopDB())
{
db.UserInfo.Add(userInfo);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool InsertOtherType(OtherType otherType)
{
using (EShopDB db = new EShopDB())
{
db.OtherType.Add(otherType);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool UpdateUserRole(UserInfo userInfo)
{
using (EShopDB db = new EShopDB())
{
var oldUserInfo = db.UserInfo.Find(userInfo.Id);
oldUserInfo.Role = userInfo.Role;
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool UpdateBookInfoStock(string id, int num)
{
using (EShopDB db = new EShopDB())
{
var bookInfo = db.BookInfo.Find(id);
if (bookInfo.Stock == null)
{
bookInfo.Stock = 0;
}
bookInfo.Stock = bookInfo.Stock + num;
return(db.SaveChanges() > 0);
}
}
public bool DeleteBookSale(string id)
{
using (EShopDB db = new EShopDB())
{
BookSale bookSale = new BookSale()
{
Id = id
};
db.BookSale.Attach(bookSale);
db.BookSale.Remove(bookSale);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool DeleteCartInfo(string id)
{
using (EShopDB db = new EShopDB())
{
ShoppingCart cInfo = new ShoppingCart()
{
Id = id
};
db.ShoppingCart.Attach(cInfo);
db.ShoppingCart.Remove(cInfo);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool DeleteUserInfo(string id)
{
using (EShopDB db = new EShopDB())
{
UserInfo userInfo = new UserInfo()
{
Id = id
};
db.UserInfo.Attach(userInfo);
db.UserInfo.Remove(userInfo);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool DeleteRecommend(string id)
{
using (EShopDB db = new EShopDB())
{
Recommend recommend = new Recommend()
{
Id = id
};
db.Recommend.Attach(recommend);
db.Recommend.Remove(recommend);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool DeleteOtherType(string id)
{
using (EShopDB db = new EShopDB())
{
OtherType otherType = new OtherType()
{
Id = id
};
db.OtherType.Attach(otherType);
db.OtherType.Remove(otherType);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool DeleteBookInfo(string id)
{
using (EShopDB db = new EShopDB())
{
BookInfo bookInfo = new BookInfo()
{
Id = id
};
db.BookInfo.Attach(bookInfo);
db.BookInfo.Remove(bookInfo);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool DeleteSaleDetail(string id)
{
using (EShopDB db = new EShopDB())
{
SaleDetail detail = new SaleDetail()
{
Id = id
};
db.SaleDetail.Attach(detail);
db.SaleDetail.Remove(detail);
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
}
public bool UpdateOtherType(OtherType otherType)
{
using (EShopDB db = new EShopDB())
{
var oldOtherType = db.OtherType.Find(otherType.Id);
if (oldOtherType != null)
{
oldOtherType.TypeCode = otherType.TypeCode;
oldOtherType.TypeContent = otherType.TypeContent;
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
else
{
return(false);
}
}
}
public bool UpdateBookType(BookType bookType)
{
using (EShopDB db = new EShopDB())
{
var oldBookType = db.BookType.Find(bookType.Id);
if (oldBookType != null)
{
oldBookType.TypeCode = bookType.TypeCode;
oldBookType.TypeName = bookType.TypeName;
oldBookType.ImgSrc = bookType.ImgSrc;
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
else
{
return(false);
}
}
}
public bool UpdateUserInfo(UserInfo userInfo)
{
using (EShopDB db = new EShopDB())
{
var oldUserInfo = db.UserInfo.Find(userInfo.Id);
if (oldUserInfo != null)
{
oldUserInfo.Name = userInfo.Name;
oldUserInfo.Phone = userInfo.Phone;
oldUserInfo.Email = userInfo.Email;
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
else
{
return(false);
}
}
}
public bool UpdateRecommend(Recommend recommend)
{
using (EShopDB db = new EShopDB())
{
var oldRecommend = db.Recommend.Find(recommend.Id);
if (oldRecommend != null)
{
oldRecommend.BookId = recommend.BookId;
oldRecommend.ShowImage = recommend.ShowImage;
oldRecommend.ShowTitle = recommend.ShowTitle;
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
else
{
return(false);
}
}
}
public bool UpdateBookSale(BookSale bookSale)
{
using (EShopDB db = new EShopDB())
{
var oldBookSale = db.BookSale.Find(bookSale.Id);
if (oldBookSale != null)
{
oldBookSale.UpdateBy = bookSale.UpdateBy;
oldBookSale.UpdateTime = DateTime.Now;
oldBookSale.State = bookSale.State;
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
else
{
return(false);
}
}
}
public bool UpdateBookInfo(BookInfo bookInfo)
{
using (EShopDB db = new EShopDB())
{
var oldBookInfo = db.BookInfo.Find(bookInfo.Id);
if (oldBookInfo != null)
{
oldBookInfo.Name = bookInfo.Name;
oldBookInfo.Author = bookInfo.Author;
oldBookInfo.Price = bookInfo.Price;
oldBookInfo.PublishDate = bookInfo.PublishDate;
oldBookInfo.Type = bookInfo.Type;
oldBookInfo.ISBN = bookInfo.ISBN;
bool isSuccess = db.SaveChanges() > 0;
return(isSuccess);
}
else
{
return(false);
}
}
}