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