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