//phần mới
public static List <PRODUCT> GetSanPham(string name)
{
using (var context = new GST_MockProjectEntities())
{
return(context.PRODUCTs.Where(x => x.ProductName.Contains(name)).AsNoTracking().ToList());
}
}
public static PagedSearchList <PRODUCT> Search(int?id, string tensanpham, decimal?Giaban, int?loaisanphamID, int pageIndex)
{
using (var context = new GST_MockProjectEntities())
{
var query = context.PRODUCTs.Include(x => x.PRODUCT_TYPE).AsNoTracking().AsQueryable().Where(x => x.Status == true);
if (id.HasValue)
{
query = query.Where(x => x.ID == id);
}
if (!string.IsNullOrEmpty(tensanpham))
{
query = query.Where(x => x.ProductName.Contains(tensanpham));
}
if (Giaban.HasValue)
{
query = query.Where(x => x.Amount == Giaban.Value);
}
if (loaisanphamID.HasValue)
{
query = query.Where(x => x.ProductType_ID == loaisanphamID);
}
query = query.OrderByDescending(x => x.ID);
int pageSize = 10;
pageIndex = pageIndex < 1 ? 1 : pageIndex;
return(new PagedSearchList <PRODUCT>(query, pageIndex, pageSize));
}
}
public static List <USER> GetNhanvien()
{
using (var context = new GST_MockProjectEntities())
{
return(context.USERs.AsNoTracking().ToList());
}
}
public static PagedSearchList <BILL> Search(int?Id, int?NhanvienId, DateTime?Tungay, DateTime?Denngay, int pageIndex)
{
using (var context = new GST_MockProjectEntities())
{
var query = context.BILLs
.Include(x => x.BILL_DETAIL)
.AsNoTracking().AsQueryable();
if (Id.HasValue)
{
query = query.Where(x => x.ID == Id);
}
if (NhanvienId.HasValue)
{
query = query.Where(x => x.CreateBy == NhanvienId);
}
if (Tungay.HasValue)
{
query = query.Where(x => x.CreateDate >= Tungay);
}
if (Denngay.HasValue)
{
query = query.Where(x => x.CreateDate <= Denngay);
}
query = query.OrderByDescending(x => x.ID);
int pageSize = 10;
pageIndex = pageIndex < 1 ? 1 : pageIndex;
return(new PagedSearchList <BILL>(query, pageIndex, pageSize));
}
}
public static CommandResult ChangePassword(string userName, string oldPassword, string newPassword)
{
using (var context = new GST_MockProjectEntities())
{
using (System.Data.Entity.DbContextTransaction dbTran = context.Database.BeginTransaction())
{
var user = context.USERs.FirstOrDefault(x => x.UserName == userName);
if (user == null)
{
return(new CommandResult(ResultCode.Fail, "User không tồn tại"));
}
else
{
var passMD5 = Encryptor.MD5Hash(oldPassword);
if (user.Password != passMD5)
{
return(new CommandResult(ResultCode.Fail, "Mật khẩu cũ không đúng"));
}
user.Password = Encryptor.MD5Hash(newPassword);
context.SaveChanges();
}
dbTran.Commit();
return(new CommandResult(ResultCode.Success, "Đổi mật khẩu thành công."));
}
}
}
public static PagedSearchList <USER> Search(string Tennv, string Taikhoan, string Sodt, string Chucvu, int pageIndex)
{
//dùng để search nhân viên
using (var context = new GST_MockProjectEntities())
{
var query = context.USERs.AsNoTracking().AsQueryable();
if (!string.IsNullOrEmpty(Tennv))
{
query = query.Where(x => x.FullName.Contains(Tennv));
}
if (!string.IsNullOrEmpty(Taikhoan))
{
query = query.Where(x => x.UserName.Contains(Taikhoan));
}
if (!string.IsNullOrEmpty(Sodt))
{
query = query.Where(x => x.PhoneNumber.Contains(Sodt));
}
query = query.OrderByDescending(x => x.ID);
int pageSize = 10;
pageIndex = pageIndex < 1 ? 1 : pageIndex;
return(new PagedSearchList <USER>(query, pageIndex, pageSize));
}
}
public static PRODUCT_TYPE GetById(long id)
{
using (var context = new GST_MockProjectEntities())
{
var query = context.PRODUCT_TYPE.Include(x => x.PRODUCTs).AsNoTracking().AsQueryable();
return(query.FirstOrDefault(x => x.ID == id));
}
}
public static BILL GetById(long id)
{
using (var context = new GST_MockProjectEntities())
{
var query = context.BILLs.AsNoTracking().AsQueryable();
return(query.FirstOrDefault(x => x.ID == id));
}
}
public static List <PRODUCT_TYPE> GetAllLoaisanpham()
{
using (var context = new GST_MockProjectEntities())
{
return(context.PRODUCT_TYPE.AsNoTracking().ToList());
}
}
public ActionResult ShowUpdateImage() //hiện trang chỉnh sửa hình ảnh
{
GST_MockProjectEntities db = new GST_MockProjectEntities();
var id = UserService.GetUserInfo().ID;
USER user = db.USERs.SingleOrDefault(s => s.ID == id);
return(View(user));
}
public static USER GetUserByUsername(string username)
{
using (var context = new GST_MockProjectEntities())
{
return
(context.USERs.Include(x => x.USER_PERMISSION).AsNoTracking()
.FirstOrDefault(x => x.UserName == username));
}
}
public static List <NOTIFY> GetNotify()
{
using (var context = new GST_MockProjectEntities())
{
var model = context.NOTIFies.AsNoTracking()
.Where(x => x.Status != Notifi_Status.AnXem).OrderByDescending(x => x.TimeCreate).ToList();
return(model);
}
}
public static CommandResult Delete(PRODUCT c)
{
using (var context = new GST_MockProjectEntities())
{
var Sanpham = context.PRODUCTs.First(x => x.ID == c.ID);
Sanpham.Status = false;
context.SaveChanges();
return(new CommandResult());
}
}
public static NOTIFY GetById(int id)
{
using (var context = new GST_MockProjectEntities())
{
var query = context.NOTIFies.Include(x => x.USER).AsNoTracking().AsQueryable();
return(query.FirstOrDefault(x => x.ID == id));
}
}
//hàm lấy các CTHD có mã hóa đơn
public static List <BILL_DETAIL> GetListCTHD(int id)
{
using (var context = new GST_MockProjectEntities())
{
return
(context.BILL_DETAIL.Include(x => x.PRODUCT).AsNoTracking()
.Where(x => x.Bill_ID == id)
.ToList());
}
}
public static CommandResult Create(PRODUCT_TYPE c)
{
using (var context = new GST_MockProjectEntities())
{
context.PRODUCT_TYPE.Add(c);
context.SaveChanges();
//TODO
//context.Log(c, LogType.BankBranch_Create, userId, "", HttpContext.Current.Request.Form);
return(new CommandResult());
}
}
public static ChartTotalThongKe GetDataChartTotalThongKe(DateTime?Tungay, DateTime?Denngay)
{
using (var context = new GST_MockProjectEntities())
{
var model = new ChartTotalThongKe();
var db = context.BILLs.AsNoTracking()
.Where(x => x.CreateDate >= Tungay.Value && x.CreateDate <= Denngay.Value).AsQueryable();
model.Ban = db.Sum(y => y.Amount);
return(model);
}
}
public static USER GetById(long id)
{
//hàm lấy nhân viên có ID = id
using (var context = new GST_MockProjectEntities())
{
var query = context.USERs.AsNoTracking().AsQueryable();
return(query.FirstOrDefault(x => x.ID == id));
}
}
public static CommandResult Create(USER c)
{
//Tạo 1 nhân viên mới
using (var context = new GST_MockProjectEntities())
{
c.Password = Encryptor.MD5Hash(c.Password);
context.USERs.Add(c);
context.SaveChanges();
return(new CommandResult());
}
}
public static void ChangeStatusNotifyId(long?id)
{
using (var context = new GST_MockProjectEntities())
{
var model = context.NOTIFies.Where(x => x.ID == id).FirstOrDefault();
if (model != null)
{
model.Status = Notifi_Status.AnXem;
context.SaveChanges();
}
}
}
//chỉnh sửa hóa đơn + ch tiết hóa đơn
//public static CommandResult Edit1(HOADON c, int userId, int flag, long? warehousePlace, List<string> fileList, string[] listProductId, string[] listQuantity, string[] listQuantityApprove, string[] listPrice)
public static CommandResult Edit1(BILL c, int userId, string[] listSanphamID, string[] listSoluong, string[] listGia)
{
using (var context = new GST_MockProjectEntities())
{
using (System.Data.Entity.DbContextTransaction dbTran = context.Database.BeginTransaction())
{
decimal?Tongtien = 0;
var HoaDon =
context.BILLs.Include(x => x.BILL_DETAIL).First(x => x.ID == c.ID);
//xóa danh sách sản phẩm cũ
var listwtdOld = HoaDon.BILL_DETAIL;
context.BILL_DETAIL.RemoveRange(listwtdOld);
//thêm danh sách sản phẩm mới
var listwtd = new List <BILL_DETAIL>();
for (int i = 0; i < listSanphamID.Length; i++)
{
var SanphamID = int.Parse(listSanphamID[i]);
var Soluong = int.Parse(listSoluong[i]);
decimal?Giaban = null;
if (listGia[i] != "")
{
Giaban = decimal.Parse(listGia[i]);
Tongtien = Tongtien + Giaban;
}
var cthd = new BILL_DETAIL()
{
Product_ID = SanphamID,
Quantity = Soluong,
Bill_ID = c.ID,
Amount = Giaban
};
listwtd.Add(cthd);
}
context.BILL_DETAIL.AddRange(listwtd);
//Chỉnh sửa lại thông tin hóa đơn khi sửa
HoaDon.UpdateBy = userId;
HoaDon.UpdateDate = DateTime.Now;
HoaDon.Amount = Tongtien;
context.SaveChanges();
dbTran.Commit();
return(new CommandResult(ResultCode.Success, "Sửa thành công"));
}
}
}
public static CommandResult Create(NOTIFY c)
{
using (var context = new GST_MockProjectEntities())
{
c.UserCreate = UserService.GetUserInfo().ID;
c.TimeCreate = DateTime.Now;
c.Status = Notifi_Status.ChuaXem;
context.NOTIFies.Add(c);
context.SaveChanges();
//TODO
//context.Log(c, LogType.BankBranch_Create, userId, "", HttpContext.Current.Request.Form);
return(new CommandResult());
}
}
public static CommandResult Edit(PRODUCT_TYPE c)
{
using (var context = new GST_MockProjectEntities())
{
var Loaisanpham = context.PRODUCT_TYPE.First(x => x.ID == c.ID);
Loaisanpham.ProductTypeName = c.ProductTypeName;
Loaisanpham.Status = c.Status;
context.SaveChanges();
//TODO
// context.Log(c, LogType.Customer_Edit, userId, "", HttpContext.Current.Request.Form);
return(new CommandResult());
}
}
public static CommandResult Edit(WAREHOUSE c)
{
using (var context = new GST_MockProjectEntities())
{
var Kho = context.WAREHOUSEs.First(x => x.ID == c.ID);
Kho.WarehouseName = c.WarehouseName;
Kho.Address = c.Address;
Kho.Status = c.Status;
context.SaveChanges();
//TODO
// context.Log(c, LogType.Customer_Edit, userId, "", HttpContext.Current.Request.Form);
return(new CommandResult());
}
}
public string GetUserNameFromId(int id)
{
string name = string.Empty;
using (var context = new GST_MockProjectEntities())
{
if (context.USERs.Any(x => x.ID == id))
{
var _users = from s in context.USERs
select s;
name = _users.Select(x => x.UserName).ToString();
}
}
return(name);
}
public static CommandResult Edit(WAREHOUSE_TRANSACTION c)
{
using (var context = new GST_MockProjectEntities())
{
var NhapXuatKho = context.WAREHOUSE_TRANSACTION.First(x => x.ID == c.ID);
NhapXuatKho.CreateDate = DateTime.Now;
NhapXuatKho.Warehouse_ID = c.Warehouse_ID;
NhapXuatKho.Type = c.Type.Value;
context.SaveChanges();
//TODO
// context.Log(c, LogType.Customer_Edit, userId, "", HttpContext.Current.Request.Form);
return(new CommandResult());
}
}
public static void ChangeStatus()
{
using (var context = new GST_MockProjectEntities())
{
var model = context.NOTIFies.Where(x => x.Status == Notifi_Status.ChuaXem);
if (model != null)
{
foreach (var item in model)
{
item.Status = Notifi_Status.DaxXem;
}
context.SaveChanges();
}
}
}
//hàm tạo mới 1 hóa đơn sẽ tự tạo các chi tiết hóa đơn
public static CommandResult Create1(BILL c, int userId, string[] listSanphamID, string[] listSoluong, string[] listGia)
{
using (var context = new GST_MockProjectEntities())
{
using (System.Data.Entity.DbContextTransaction dbTran = context.Database.BeginTransaction())
{
decimal?Tongtien = 0;
c.CreateBy = userId;
c.Amount = 0;
c.CreateDate = DateTime.Now;
context.BILLs.Add(c);
context.SaveChanges();
//luu chi tiet san pham
var listwtd = new List <BILL_DETAIL>();
for (var i = 0; i < listSanphamID.Length; i++)
{
decimal?price = null;
if (listGia[i] != "")
{
price = decimal.Parse(listGia[i]);
Tongtien = Tongtien + price;
}
var wtd = new BILL_DETAIL()
{
Bill_ID = c.ID,
Product_ID = int.Parse(listSanphamID[i]),
Quantity = int.Parse(listSoluong[i]),
Amount = price
};
listwtd.Add(wtd);
}
context.BILL_DETAIL.AddRange(listwtd);
c.Amount = Tongtien;
context.SaveChanges();
dbTran.Commit();
return(new CommandResult());
}
}
}
public static List <ChartThongKe> GetDataChartForYear(DateTime?fromDate, DateTime?toDate)
{
using (var context = new GST_MockProjectEntities())
{
var query = context.BILLs.AsNoTracking()
.Where(x => x.CreateDate >= fromDate.Value && x.CreateDate <= toDate.Value).AsQueryable();
return(query.GroupBy(x => x.CreateDate.Value.Year)
.Select(
x =>
new ChartThongKe()
{
Year = x.Key,
Month = 1,
Day = 1,
Ban = x.Sum(y => y.Amount),
}).ToList());
}
}
public static CommandResult Edit(PRODUCT c)
{
using (var context = new GST_MockProjectEntities())
{
var Sanpham = context.PRODUCTs.First(x => x.ID == c.ID);
Sanpham.ProductName = c.ProductName;
Sanpham.Amount = c.Amount;
Sanpham.Unit = c.Unit;
Sanpham.ProductType_ID = c.ProductType_ID;
context.SaveChanges();
//TODO
// context.Log(c, LogType.Customer_Edit, userId, "", HttpContext.Current.Request.Form);
return(new CommandResult());
}
}
