public int Login(string userName, string passWord)
{
using (var db = new SieuThiDienMayDbContext())
{
var result = db.Employees.SingleOrDefault(t => t.UserName == userName);
if (result == null)
{
return(0);
}
else
{
if (result.Status == false)
{
return(-1);
}
else
{
if (result.Password == passWord)
{
return(1);
}
else
{
return(-2);
}
}
}
}
}
public List <Employee> GetAll()
{
using (var db = new SieuThiDienMayDbContext())
{
return(db.Employees.ToList());
}
}
public Employee getByID(string username)
{
using (var db = new SieuThiDienMayDbContext())
{
return(db.Employees.SingleOrDefault(t => t.UserName == username));
}
}
public static Product getByID(int id)
{
using (var db = new SieuThiDienMayDbContext())
{
return(db.Products.SingleOrDefault(t => t.ID_Product == id));
}
}
public IEnumerable <Product> GetAll(int page, int pageSize)
{
using (var db = new SieuThiDienMayDbContext())
{
return(db.Products.OrderByDescending(x => x.MaSp).ToPagedList(page, pageSize));
}
}
// SieuThiDienMayDbContext db = null;
public long Insert(Employee model
)
{
using (var db = new SieuThiDienMayDbContext())
{
db.Employees.Add(model);
db.SaveChanges();
return(model.ID_Employee);
}
}
public void Delete(string id)
{
using (var db = new SieuThiDienMayDbContext())
{
var emp = db.Employees.FirstOrDefault(l => l.ID_Employee.Equals(id));
if (emp == null)
{
throw new Exception("Mã nhân viên không tồn tại");
}
db.Employees.Remove(emp);
db.SaveChanges();
}
}
public static void Delete(int id)
{
using (var db = new SieuThiDienMayDbContext())
{
var pro = db.Products.FirstOrDefault(l => l.ID_Product.Equals(id));
if (pro == null)
{
throw new Exception("Mã sản phẩm không tồn tại");
}
db.Products.Remove(pro);
db.SaveChanges();
}
}
public static void Insert(Product model
)
{
using (var db = new SieuThiDienMayDbContext())
{
var key = db.Products.FirstOrDefault(m => m.MaSp == model.MaSp);
if (key != null)
{
throw new Exception("Mã sản phẩm đã tồn tại");
}
else
{
db.Products.Add(model);
db.SaveChanges();
}
}
}
public static void Update(Product model)
{
using (var db = new SieuThiDienMayDbContext())
{
var pro = db.Products.FirstOrDefault(l => l.MaSp.Equals(model.MaSp));
if (pro == null)
{
throw new Exception("Mã sản phẩm không tồn tại");
}
pro.MaSp = model.MaSp;
pro.TenSP = model.TenSP;
pro.Mota = model.Mota;
pro.GiaBan = model.GiaBan;
pro.GiaKM = model.GiaKM;
pro.Quantity = model.Quantity;
pro.ID_Bill = model.ID_Bill;
pro.NhaCungCap = model.NhaCungCap;
db.SaveChanges();
}
}
public void Update(Employee model)
{
using (var db = new SieuThiDienMayDbContext())
{
var emp = db.Employees.FirstOrDefault(l => l.ID_Employee.Equals(model.ID_Employee));
if (emp == null)
{
throw new Exception("Mã nhân viên không tồn tại");
}
emp.UserName = model.UserName;
emp.Password = emp.Password;
emp.Phone = model.Phone;
emp.Address = model.Address;
emp.Email = model.Email;
emp.Status = model.Status;
emp.ModifiedBy = model.ModifiedBy;
emp.CreateBy = model.CreateBy;
emp.CreateDate = model.CreateDate;
emp.ModifiedDate = model.ModifiedDate;
emp.Type_Emp = model.Type_Emp;
db.SaveChanges();
}
}
public NhaCungCapDao()
{
db = new SieuThiDienMayDbContext();
}
