public static CommandResult UpdateSoLuongSanPham(int KhoId, int SanphamId, decimal Soluong) { using (var context = new GST_MockProjectEntities()) { try { var CTKho = context.WAREHOUSE_DETAIL.First(x => x.Warehouse_ID == KhoId && x.Product_ID == SanphamId); CTKho.Quantity = CTKho.Quantity + Soluong; context.SaveChanges(); } catch (Exception e) { var c = new WAREHOUSE_DETAIL(); c.Warehouse_ID = KhoId; c.Product_ID = SanphamId; c.Quantity = Soluong; context.WAREHOUSE_DETAIL.Add(c); context.SaveChanges(); } return(new CommandResult()); } }
public static List <WAREHOUSE> GetAllKho() { using (var context = new GST_MockProjectEntities()) { return(context.WAREHOUSEs.AsNoTracking().ToList()); } }
public static PagedSearchList <WAREHOUSE_TRANSACTION> Search(int?Id, int?Khoid, WarehouseTransaction_Type?Loaiphieu, int pageIndex) { using (var context = new GST_MockProjectEntities()) { var query = context.WAREHOUSE_TRANSACTION .Include(x => x.USER) .Include(x => x.WAREHOUSE).AsNoTracking().AsQueryable(); if (Id.HasValue) { query = query.Where(x => x.ID == Id); } if (Khoid.HasValue) { query = query.Where(x => x.Warehouse_ID == Khoid); } if (Loaiphieu.HasValue) { query = query.Where(x => x.Type == Loaiphieu); } query = query.OrderByDescending(x => x.ID); int pageSize = 10; pageIndex = pageIndex < 1 ? 1 : pageIndex; return(new PagedSearchList <WAREHOUSE_TRANSACTION>(query, pageIndex, pageSize)); } }
//lấy tất cã các sản phẩm public static List <PRODUCT> GetSanPham() { using (var context = new GST_MockProjectEntities()) { return(context.PRODUCTs.AsNoTracking().ToList()); } }
public static WAREHOUSETRANSACTION_DETAIL GetByIdCT(int idSP, int idPNXK) { using (var context = new GST_MockProjectEntities()) { var query = context.WAREHOUSETRANSACTION_DETAIL.AsNoTracking().AsQueryable(); return(query.FirstOrDefault(x => x.Product_ID == idSP && x.WarehouseTransaction_ID == idPNXK)); } }
public static WAREHOUSE_TRANSACTION GetById(long id) { using (var context = new GST_MockProjectEntities()) { var query = context.WAREHOUSE_TRANSACTION.AsNoTracking().AsQueryable(); return(query.FirstOrDefault(x => x.ID == id)); } }
//hàm lấy các CTPhieuNhapXuatKho có mã Nhapxuat public static List <WAREHOUSETRANSACTION_DETAIL> GetListCTNXK(int id) { using (var context = new GST_MockProjectEntities()) { return (context.WAREHOUSETRANSACTION_DETAIL.Include(x => x.PRODUCT).AsNoTracking() .Where(x => x.WarehouseTransaction_ID == id) .ToList()); } }
// CreateCTPNX public static CommandResult CreateCTPNX(WAREHOUSETRANSACTION_DETAIL c) { using (var context = new GST_MockProjectEntities()) { c.WarehouseTransaction_ID = 1; context.WAREHOUSETRANSACTION_DETAIL.Add(c); context.SaveChanges(); return(new CommandResult()); } }
public static CommandResult UpdateSoLuongSanPham2(int KhoId, int SanphamId, decimal Soluong) { using (var context = new GST_MockProjectEntities()) { var CTKho = context.WAREHOUSE_DETAIL.First(x => x.Warehouse_ID == KhoId && x.Product_ID == SanphamId); CTKho.Quantity = CTKho.Quantity - Soluong; context.SaveChanges(); return(new CommandResult()); } }
public static CommandResult Create(WAREHOUSE_TRANSACTION c) { using (var context = new GST_MockProjectEntities()) { c.CreateDate = DateTime.Now; c.CreateBy = UserService.GetUserInfo().ID; context.WAREHOUSE_TRANSACTION.Add(c); context.SaveChanges(); //TODO //context.Log(c, LogType.BankBranch_Create, userId, "", HttpContext.Current.Request.Form); return(new CommandResult()); } }
public static CommandResult EditCTPNX(WAREHOUSETRANSACTION_DETAIL c) { using (var context = new GST_MockProjectEntities()) { var CTPHIEUNHAPXUATKHO = context.WAREHOUSETRANSACTION_DETAIL.First(x => x.WarehouseTransaction_ID == c.WarehouseTransaction_ID && x.Product_ID == c.Product_ID); CTPHIEUNHAPXUATKHO.Quantity = c.Quantity; CTPHIEUNHAPXUATKHO.Amount = c.Amount; context.SaveChanges(); return(new CommandResult()); } }
//hàm tạo mới 1 hóa đơn sẽ tự tạo các chi tiết trong nhập xuất kho public static CommandResult Create1(WAREHOUSE_TRANSACTION 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.CreateDate = DateTime.Now; context.WAREHOUSE_TRANSACTION.Add(c); context.SaveChanges(); //luu chi tiet san pham var listwtd = new List <WAREHOUSETRANSACTION_DETAIL>(); for (var i = 0; i < listSanphamID.Length; i++) { var SanphamID = int.Parse(listSanphamID[i]); var Soluong = decimal.Parse(listSoluong[i]); decimal?price = null; if (listGia[i] != "") { price = decimal.Parse(listGia[i]); Tongtien = Tongtien + price; } if (listSoluong[i] != "") { UpdateSoLuongSanPham(c.Warehouse_ID, SanphamID, Soluong); } var wtd = new WAREHOUSETRANSACTION_DETAIL() { WarehouseTransaction_ID = c.ID, Product_ID = SanphamID, Quantity = Soluong, Amount = price }; listwtd.Add(wtd); } context.WAREHOUSETRANSACTION_DETAIL.AddRange(listwtd); context.SaveChanges(); dbTran.Commit(); return(new CommandResult()); } } }
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.UpdateDate = DateTime.Now; NhapXuatKho.UpdateBy = UserService.GetUserInfo().ID; 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 PagedSearchList <WAREHOUSETRANSACTION_DETAIL> SearchCTPNX(int?Id, int pageIndex) { using (var context = new GST_MockProjectEntities()) { var query = context.WAREHOUSETRANSACTION_DETAIL .Include(x => x.PRODUCT) .Include(x => x.WAREHOUSE_TRANSACTION).AsNoTracking().AsQueryable(); if (Id.HasValue) { query = query.Where(x => x.WarehouseTransaction_ID == Id); } query = query.OrderByDescending(x => x.WarehouseTransaction_ID); int pageSize = 10; pageIndex = pageIndex < 1 ? 1 : pageIndex; return(new PagedSearchList <WAREHOUSETRANSACTION_DETAIL>(query, pageIndex, pageSize)); } }
//chỉnh sửa hóa đơn + ch tiết hóa đơn public static CommandResult Edit1(WAREHOUSE_TRANSACTION c, int userId, string[] listSanphamID, string[] listSoluong, string[] listGia) { using (var context = new GST_MockProjectEntities()) { using (System.Data.Entity.DbContextTransaction dbTran = context.Database.BeginTransaction()) { var Nhapxuatkho = context.WAREHOUSE_TRANSACTION.Include(x => x.WAREHOUSETRANSACTION_DETAIL).First(x => x.ID == c.ID); //xóa số lượng sản phẩm đang được chỉnh sửa ở trong chi tiết kho for (int i = 0; i < listSanphamID.Length; i++) { var SanphamID = int.Parse(listSanphamID[i]); var Soluong = context.WAREHOUSETRANSACTION_DETAIL.Where(y => y.WarehouseTransaction_ID == c.ID && y.Product_ID == SanphamID).First().Quantity; //var Soluong2 = int.Parse(Soluong); UpdateSoLuongSanPham2(c.Warehouse_ID, SanphamID, Soluong.Value); } //xóa danh sách sản phẩm cũ var listwtdOld = Nhapxuatkho.WAREHOUSETRANSACTION_DETAIL; context.WAREHOUSETRANSACTION_DETAIL.RemoveRange(listwtdOld); var listSoluongOld = context.WAREHOUSETRANSACTION_DETAIL.Where(x => x.WarehouseTransaction_ID == c.ID).ToList(); //thêm danh sách sản phẩm mới var listwtd = new List <WAREHOUSETRANSACTION_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]); } var cthd = new WAREHOUSETRANSACTION_DETAIL() { Product_ID = SanphamID, Quantity = Soluong, WarehouseTransaction_ID = c.ID, Amount = Giaban }; listwtd.Add(cthd); } context.WAREHOUSETRANSACTION_DETAIL.AddRange(listwtd); //Chỉnh sửa lại thông tin hóa đơn khi sửa Nhapxuatkho.UpdateBy = userId; Nhapxuatkho.UpdateDate = DateTime.Now; Nhapxuatkho.Type = c.Type; context.SaveChanges(); dbTran.Commit(); return(new CommandResult(ResultCode.Success, "Sửa thành công")); } } }