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