/* DELETE BOOK */
public static void Delete_Book(int Id)
{
using (var db = new DBShop())
{
var book = db.DbBook.Find(Id);
book.flag = true;
db.Entry(book).State = EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
}
/* RESTORE BOOK */
public static void Restore_Book(int Id)
{
using (var db = new DBShop())
{
var tmp = db.DbBook.Find(Id);
tmp.flag = false;
db.Entry(tmp).State = EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
}
/* UPDATE IMAGE BOOK */
public static void Update_Img(int Id, string Hinh)
{
using (var db = new DBShop())
{
var book = db.DbBook.Find(Id);
book.hinh = Hinh;
db.Entry(book).State = EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
}
/* DELETE CUSTOMER */
public static void Delete_Customer(int Id)
{
if (Id != 0)
{
using (var db = new DBShop())
{
var customer = db.DbCustomer.Find(Id);
customer.flag = true;
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
}
}
/* RESTORE CUSTOMER ACCOUNT */
public static void UnLock(int Id)
{
using (var db = new DBShop())
{
var kh = db.DbCustomer.Find(Id);
if (kh.flag)
{
kh.flag = false;
db.Entry(kh).State = EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
}
}
/* EDIT BOOK */
public static void Edit_Book(int Id, string Ten_Sach, string Tac_Gia, string The_Loai, string Nha_Xuat_Ban, string Mo_Ta, double Gia_Ban)
{
using (var db = new DBShop())
{
var book = db.DbBook.Find(Id);
book.ten_sach = Ten_Sach;
book.tac_gia = Tac_Gia;
book.the_loai = The_Loai;
book.nha_xuat_ban = Nha_Xuat_Ban;
book.mo_ta = Mo_Ta;
book.gia_ban = Gia_Ban;
db.Entry(book).State = EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
}
/* Auto Delete Record After N Days */
public static void Auto_Delete_Record(int Day_Delete)
{
using (var db = new DBShop())
{
var record = db.DbRecord.ToList();
for(int i = 0; i < record.Count(); i++)
{
int day = DateTime.Now.Date.Subtract(record[i].date_action).Days;
if ( day > Day_Delete)
{
db.Entry(record[i]).State = EntityState.Deleted;
db.SaveChanges();
}
}
db.Dispose();
}
}
/* EDIT CUSTOMER */
public static void Edit_Customer(int Id, string Email, string First_name, string Last_name, string Password, string Phone, string Date, string Gender,
string Address)
{
try
{
using (var db = new DBShop())
{
Customer customer = db.DbCustomer.Find(Id);
customer.email = Email;
customer.first_name = First_name;
customer.last_name = Last_name;
customer.password = Password;
customer.address = Address;
customer.date = Date;
customer.phone = Phone;
customer.gender = Gender;
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join(";", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, "The validation errors are: " + fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
}
