/* Create Record */ public static void Create_Record(string Username, string Action, DateTime Date_Action) { using (var db = new DBShop()) { db.DbRecord.Add(new Record { username = Username, action = Action, date_action = Date_Action}); db.SaveChanges(); db.Dispose(); } }
/* INCREATE VIEWS COUNTING */ public static void Change_Visit(int Visit_Count, int Month) { using (var db = new DBShop()) { var visit = db.DbVisit.Where(item => item.month == Month).FirstOrDefault(); visit.total_view = visit.total_view + Visit_Count; db.Entry(visit).State = EntityState.Modified; db.SaveChanges(); db.Dispose(); } }
/* CREATE VIEWS COUNTING */ public static void Create_Visit(int Visit_Count, int Month) { using (var db = new DBShop()) { db.DbVisit.Add(new TotalVisit { total_view = Visit_Count, month = Month }); db.SaveChanges(); db.Dispose(); } }
/* CREATE ORDER */ public static void Create_Order(int Id_Customer, string Date_Create) { using (var db = new DBShop()) { db.DbOrder.Add(new Order { id_customer = Id_Customer, date_create = Date_Create }); db.SaveChanges(); db.Dispose(); } }
/* SET ROLE FOR USER */ public static void Create_Staff(int Id, string Role) { using (var db = new DBShop()) { var staff = db.DbCustomer.Find(Id); staff.role = Role; db.Entry(staff).State = EntityState.Modified; db.SaveChanges(); db.Dispose(); } }
/* 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(); } }
/* CREATE BOOK */ public static void Create_Book(string Ten_Sach, string Tac_Gia, string The_Loai, string Nha_Xuat_Ban, string Mo_Ta, double Gia_Ban, string Hinh) { using (var db = new DBShop()) { db.DbBook.Add(new Book { ten_sach = Ten_Sach, tac_gia = Tac_Gia, the_loai = The_Loai, nha_xuat_ban = Nha_Xuat_Ban, mo_ta = Mo_Ta, gia_ban = Gia_Ban, hinh = Hinh, flag = false }); db.SaveChanges(); db.Dispose(); } }
/* CREATE BILL */ public static void Create_Bill(int Id_Order, int Id_Sach, string Ten_Sach, string Tac_Gia, int So_Luong, double Don_Gia, double Thanh_Tien) { string day = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year; using (var db = new DBShop()) { db.DbBill.Add(new OrderDetail { id_order = Id_Order, id_sach = Id_Sach, ten_sach = Ten_Sach, tac_gia = Tac_Gia, so_luong = So_Luong, don_gia = Don_Gia, thanh_tien = Thanh_Tien, date_buy = day }); 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); } }
/* CREATE CUSTOMER */ public static void Create_Customer(string Email, string First_name, string Last_name, string Address, string Phone, string Password, string Date, string Gender) { Customer customer = new Customer { email = Email, first_name = First_name, last_name = Last_name, password = Password, address = Address, date = Date, gender = Gender, phone = Phone, flag = false, role = "guest" }; using (var db = new DBShop()) { db.DbCustomer.Add(customer); db.SaveChanges(); db.Dispose(); } }