public Material GetMaterial(int id) { using (var dbContext = new BasisDataDbContext()) { return dbContext.Find<Material>(id); } }
public Classification GetClassification(int id) { using (var dbContext = new BasisDataDbContext()) { return dbContext.Find<Classification>(id); } }
public void DeleteClassification(List<int> ids) { using (var dbContext = new BasisDataDbContext()) { dbContext.Materials.Where(u => ids.Contains(u.ClassificationID ?? 0)).Delete(); dbContext.Classifications.Where(u => ids.Contains(u.ID)).Delete(); } }
public void DeleteMaterial(List<int> ids) { using (var dbContext = new BasisDataDbContext()) { dbContext.MaterialSuppliers.Where(u => ids.Contains(u.MaterialID)).Delete(); dbContext.Materials.Where(u => ids.Contains(u.ID)).Delete(); } }
public IEnumerable<Classification> GetClassificationList(ClassificationRequest request = null) { request = request ?? new ClassificationRequest(); using (var dbContext = new BasisDataDbContext()) { IQueryable<Classification> classification = dbContext.Classifications; if (!string.IsNullOrEmpty(request.Name)) classification = classification.Where(u => u.Name.Contains(request.Name)); if (!string.IsNullOrEmpty(request.Code)) classification = classification.Where(u => u.Code == request.Code); return classification.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize); } }
public IEnumerable<Material> GetMaterialList(MaterialRequest request = null) { request = request ?? new MaterialRequest(); using (var dbContext = new BasisDataDbContext()) { IQueryable<Material> material = dbContext.Materials; if (!string.IsNullOrEmpty(request.Name)) material = material.Where(u => u.Name.Contains(request.Name)); if (request.ClassificationID > 0) material = material.Where(u => u.ClassificationID == request.ClassificationID); if (request.IsAvailability != null) { material = material.Where(u => u.IsAvailability == request.IsAvailability); } return material.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize); } }
public void SaveMaterialSupplier(MaterialSupplier materialSupplier) { using (var dbContext = new BasisDataDbContext()) { MaterialSupplier supplier = GetMaterialSupplier(materialSupplier.MaterialID, materialSupplier.SupplierID); if (supplier != null) { materialSupplier.ID = supplier.ID; dbContext.Update<MaterialSupplier>(materialSupplier); } else { dbContext.Insert<MaterialSupplier>(materialSupplier); } } }
public IEnumerable<MaterialSupplier> GetMaterialSupplierList(MaterialSupplierRequest request = null) { request = request ?? new MaterialSupplierRequest(); using (var dbContext = new BasisDataDbContext()) { IQueryable<MaterialSupplier> supplier = dbContext.MaterialSuppliers; if (request.MaterialID > 0) supplier = supplier.Where(u => u.MaterialID == request.MaterialID); if (request.SupplierID > 0) supplier = supplier.Where(u => u.SupplierID == request.SupplierID); if (!string.IsNullOrEmpty(request.MaterialName)) supplier = supplier.Where(u => u.MaterialName.Contains(request.MaterialName)); if (!string.IsNullOrEmpty(request.SupplierName)) supplier = supplier.Where(u => u.SupplierName.Contains(request.SupplierName)); if (request.Price > 0.0) supplier = supplier.Where(u => u.Price >= request.Price); return supplier.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize); } }
public MaterialSupplier GetMaterialSupplier(int mid, int sid) { using (var dbContext = new BasisDataDbContext()) { IQueryable<MaterialSupplier> materialSupplier = dbContext.MaterialSuppliers; materialSupplier = materialSupplier.Where(u => u.MaterialID == mid && u.SupplierID == sid); return materialSupplier.FirstOrDefault(); } }
public void DeleteMaterialSupplier(int mid, int sid) { using (var dbContext = new BasisDataDbContext()) { dbContext.MaterialSuppliers.Where(u => u.SupplierID == sid && u.MaterialID == mid).Delete(); } }
public void SaveSupplier(Supplier supplier) { using (var dbContext = new BasisDataDbContext()) { if (supplier.ID > 0) { dbContext.Update<Supplier>(supplier); } else { dbContext.Insert<Supplier>(supplier); } } }
public void SaveMaterial(Material material) { using (var dbContext = new BasisDataDbContext()) { if (material.ID > 0) { dbContext.Update<Material>(material); } else { dbContext.Insert<Material>(material); } } }
public void SaveClassification(Classification classification) { using (var dbContext = new BasisDataDbContext()) { if (classification.ID > 0) { dbContext.Update<Classification>(classification); } else { dbContext.Insert<Classification>(classification); } } }
public IEnumerable<Supplier> GetSupplierList(SupplierRequest request = null) { request = request ?? new SupplierRequest(); using (var dbContext = new BasisDataDbContext()) { IQueryable<Supplier> supplier = dbContext.Suppliers; if (!string.IsNullOrEmpty(request.Name)) supplier = supplier.Where(u => u.Name.Contains(request.Name)); if (!string.IsNullOrEmpty(request.Contact)) supplier = supplier.Where(u => u.Contact.Contains(request.Contact)); if (!string.IsNullOrEmpty(request.Address)) supplier = supplier.Where(u => u.Address.Contains(request.Address)); return supplier.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize); } }
public Supplier GetSupplier(int id) { using (var dbContext = new BasisDataDbContext()) { return dbContext.Find<Supplier>(id); } }