public void Update(int productID, int quantity)
{
StoreManagerDBContext db = new StoreManagerDBContext();
WareHouse wh = db.WareHouses.SingleOrDefault(x => x.ProductID == productID);
wh.Quantity += quantity;
db.SaveChanges();
}
public void UpdatePasswordChange(string username, string password)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Account a = db.Accounts.SingleOrDefault(x => x.username == username);
a.password = password;
db.SaveChanges();
}
public void UpdateStatusByID(int orderID)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Order o = db.Orders.SingleOrDefault(x => x.ID == orderID);
o.StatusID = 2;
db.SaveChanges();
}
public void UpdatePasswordDeleteEmployee(string username)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Account a = db.Accounts.SingleOrDefault(x => x.username == username);
a.password = "******";
db.SaveChanges();
}
public void ChangeStatus(int productID)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Product p = db.Products.SingleOrDefault(x => x.ID == productID);
p.StatusID = 2;
db.SaveChanges();
}
public void UpdateStatusAndPassword(int employeeID)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Employee e = db.Employees.SingleOrDefault(x => x.ID == employeeID);
new ModifyAccount().UpdatePasswordDeleteEmployee(e.username);
e.StatusID = 2;
db.SaveChanges();
}
public void Insert(int productID)
{
StoreManagerDBContext db = new StoreManagerDBContext();
WareHouse wh = new WareHouse();
wh.ProductID = productID;
wh.Quantity = 0;
db.WareHouses.Add(wh);
db.SaveChanges();
}
public void Insert(string username, string password)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Account a = new Account();
a.username = username;
a.password = password;
a.PositionID = 2;
db.Accounts.Add(a);
db.SaveChanges();
}
public void Update(string name, string address, string gender, DateTime birth, string phone)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Customer c = db.Customers.SingleOrDefault(x => x.Phone == phone);
c.Name = name;
c.Gender = gender;
c.Birth = birth;
c.Address = address;
db.SaveChanges();
}
public void Update(ModifyEmployee model)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Employee e = db.Employees.SingleOrDefault(x => x.ID == model.ID);
e.Name = model.Name;
e.Birth = new DateTime(model.Year, model.Month, model.Day);
e.Address = model.Address;
e.Gender = model.Gender;
e.Phone = model.Phone;
db.SaveChanges();
}
public void Insert(string customerPhone)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Order o = new Order();
o.ID = 0;
o.ModifyDay = DateTime.Now;
o.CustomerPhone = customerPhone;
o.StatusID = 1;
db.Orders.Add(o);
db.SaveChanges();
}
public void Insert(int productID, int quantity, int ID)
{
StoreManagerDBContext db = new StoreManagerDBContext();
ExportWareHouseDetail ewhd = new ExportWareHouseDetail();
ewhd.ID = 0;
ewhd.ProductID = productID;
ewhd.Quantity = quantity;
ewhd.ExportWareHouseID = ID;
db.ExportWareHouseDetails.Add(ewhd);
db.SaveChanges();
}
public void UpdateStatus(int ImportID, int statusID, int supplierID)
{
StoreManagerDBContext db = new StoreManagerDBContext();
ImportWareHouse iwh = db.ImportWareHouses.SingleOrDefault(x => x.ID == ImportID);
iwh.StatusID = statusID;
if (supplierID != 0)
{
iwh.SupplierID = supplierID;
}
db.SaveChanges();
}
public void Insert(int employeeID, string customerPhone)
{
StoreManagerDBContext db = new StoreManagerDBContext();
ExportWareHouse ewh = new ExportWareHouse();
ewh.ID = 0;
ewh.ModifyDay = DateTime.Now;
ewh.EmployeeID = employeeID;
ewh.CustomerPhone = customerPhone;
db.ExportWareHouses.Add(ewh);
db.SaveChanges();
}
public void Insert(int orderID, int productID, int quantity)
{
StoreManagerDBContext db = new StoreManagerDBContext();
OrderDetail od = new OrderDetail();
od.ID = 0;
od.OrderID = orderID;
od.ProductID = productID;
od.Quantity = quantity;
db.OrderDetails.Add(od);
db.SaveChanges();
}
public void Insert(int employeeID)
{
StoreManagerDBContext db = new StoreManagerDBContext();
ImportWareHouse iwh = new ImportWareHouse();
iwh.ID = 0;
iwh.ModifyDay = DateTime.Now;
iwh.StatusID = 1;
iwh.EmployeeID = employeeID;
iwh.SupplierID = null;
db.ImportWareHouses.Add(iwh);
db.SaveChanges();
}
public string CheckAccount(string username, string password)
{
Account acc = new StoreManagerDBContext().Accounts.SingleOrDefault(x => x.username == username && x.password == password);
if (acc == null)
{
return("false");
}
else
{
return(acc.Position.Name);
}
}
public void Insert(int billID, int productID, int quantity, decimal price)
{
StoreManagerDBContext db = new StoreManagerDBContext();
BillDetail bd = new BillDetail();
bd.ID = 0;
bd.BillID = billID;
bd.ProductID = productID;
bd.Quantity = quantity;
bd.Price = price;
db.BillDetails.Add(bd);
db.SaveChanges();
}
public void Insert(string name, string address, string gender, DateTime birth, string phone)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Customer c = new Customer();
c.Name = name;
c.Address = address;
c.Gender = gender;
c.Birth = birth;
c.Phone = phone;
db.Customers.Add(c);
db.SaveChanges();
}
public void Insert(int productID, int quantity, decimal price, int employeeID)
{
StoreManagerDBContext db = new StoreManagerDBContext();
ImportWareHouseDetail iwhd = new ImportWareHouseDetail();
iwhd.ID = 0;
iwhd.ImportWareHouseID = new ModifyImportWareHouse().GetLastIDByEmployeeID(employeeID);
iwhd.ProductID = productID;
iwhd.Quantity = quantity;
iwhd.Price = price;
db.ImportWareHouseDetails.Add(iwhd);
db.SaveChanges();
}
public void Insert(int employeeID, string customerPhone, int orderID, int exportWareHouseID)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Bill b = new Bill();
b.ID = 0;
b.ModifyDay = DateTime.Now;
b.EmployeeID = employeeID;
b.CustomerPhone = customerPhone;
b.OrderID = orderID;
b.ExportWareHouseID = exportWareHouseID;
db.Bills.Add(b);
db.SaveChanges();
}
public bool CheckExistCustomerByPhone(string phone)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Customer c = db.Customers.SingleOrDefault(x => x.Phone == phone);
if (c == null)
{
return(false);
}
else
{
return(true);
}
}
public string GetInfo(int ID)
{
Product p = new StoreManagerDBContext().Products.SingleOrDefault(x => x.ID == ID);
if (p.ProductImage != null)
{
string imagesrc = Convert.ToBase64String(p.ProductImage);
return(p.Name + "-" + p.ProducerID + "-" + p.ProductTypeID + "-" + double.Parse(p.OriginalPrice.ToString()) + "-" + double.Parse(p.SellPrice.ToString()) + "-" + "data:image;base64," + imagesrc);
}
else
{
return(p.Name + "-" + p.ProducerID + "-" + p.ProductTypeID + "-" + double.Parse(p.OriginalPrice.ToString()) + "-" + double.Parse(p.SellPrice.ToString()) + "-" + "/Content/Image/null_img.jpg");
}
}
public void Update(ListProduct model)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Product p = db.Products.SingleOrDefault(x => x.ID == model.ID);
p.Name = model.Name;
p.ProducerID = int.Parse(model.Producer);
p.ProductTypeID = int.Parse(model.ProductType);
p.OriginalPrice = model.OriginalPrice;
p.SellPrice = model.SellPrice;
if (model.Image != null)
{
p.ProductImage = model.Image;
}
db.SaveChanges();
}
public void Insert(ModifyEmployee model)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Employee e = new Employee();
e.ID = GetNextID();
e.Name = model.Name;
e.StatusID = 1;
e.Birth = new DateTime(model.Year, model.Month, model.Day);
e.Gender = model.Gender;
e.Address = model.Address;
e.username = model.Username;
e.Phone = model.Phone;
db.Employees.Add(e);
db.SaveChanges();
}
public void Insert(ListProduct model)
{
StoreManagerDBContext db = new StoreManagerDBContext();
Product p = new Product();
int ID = GetNextID();
p.ID = GetNextID();
p.Name = model.Name;
p.ProducerID = int.Parse(model.Producer);
p.ProductTypeID = int.Parse(model.ProductType);
p.StatusID = 1;
p.OriginalPrice = model.OriginalPrice;
p.SellPrice = model.SellPrice;
p.ProductImage = model.Image;
db.Products.Add(p);
db.SaveChanges();
new ModifyWareHouse().Insert(ID);
}
public int GetNextID()
{
List <Product> list = new StoreManagerDBContext().Products.OrderByDescending(x => x.ID).Take(1).ToList();
return(list[0].ID + 1);
}
public int GetLastIDByEmployeeIDAndCustomerPhone(int employeeID, string customerPhone)
{
List <ExportWareHouse> list = new StoreManagerDBContext().ExportWareHouses.Where(x => x.EmployeeID == employeeID && x.CustomerPhone == customerPhone).OrderByDescending(x => x.ID).Take(1).ToList();
return(list[0].ID);
}
public List <Product> GetList()
{
StoreManagerDBContext db = new StoreManagerDBContext();
return(db.Products.Where(x => x.StatusID == 1).ToList());
}
public int GetLastIDByEmployeeID(int employeeID)
{
List <ImportWareHouse> list = new StoreManagerDBContext().ImportWareHouses.Where(x => x.EmployeeID == employeeID).OrderByDescending(x => x.ID).Take(1).ToList();
return(list[0].ID);
}
