public bool queryUpdateContractSupply(ContractSupply c) { if (LoginInfo.Position == 1 || LoginInfo.Position == 3) //Начальник или Кладовщик { using (DataBaseContext db = new DataBaseContext()) { try { ContractSupply contract = db.ContractSupplys.Find(c.Id); contract.ContractorId = c.ContractorId; contract.numberOfSupply = c.numberOfSupply; contract.wasReceived = c.wasReceived; contract.Date = c.Date; db.SupplyProducts.RemoveRange(contract.SupplyProducts); contract.SupplyProducts = c.SupplyProducts; db.SaveChanges(); } catch (Exception e) { return(false); } return(true); } } return(false); }
public ContractSupply queryFindContractSupplyById(int Id) { if (LoginInfo.Position == 1 || LoginInfo.Position == 2 || LoginInfo.Position == 3) { using (DataBaseContext db = new DataBaseContext()) { ContractSupply s = db.ContractSupplys.Find(Id); //List<SupplyProduct> lsp = db.SupplyProducts.Select(it => new SupplyProduct() { Id = it.Id, ProductId = it.ProductId, Amount = it.Amount, ContractSupplyId = it.ContractSupplyId }).Where(r => r.ContractSupplyId == Id).ToList(); s.SupplyProducts = s.SupplyProducts; return(s); } } return(null); }
public bool queryAddContractSupply(ContractSupply c) { if (LoginInfo.Position == 1 || LoginInfo.Position == 3) //Начальник или Кладовщик { using (DataBaseContext db = new DataBaseContext()) { try { db.ContractSupplys.Add(c); db.SaveChanges(); } catch (Exception e) { return(false); } return(true); } } return(false); }
public bool queryDeleteContractSupply(int Id) { if (LoginInfo.Position == 1 || LoginInfo.Position == 3) //Начальник или Кладовщик { using (DataBaseContext db = new DataBaseContext()) { try { ContractSupply contract = db.ContractSupplys.Find(Id); List <SupplyProduct> sp = contract.SupplyProducts; db.SupplyProducts.RemoveRange(sp); db.ContractSupplys.Remove(contract); db.SaveChanges(); } catch (Exception e) { return(false); } return(true); } } return(false); }
public ContractSupplyTable(ContractSupply contractSupply, Contractor contractor) { this.contractSupply = contractSupply; this.contractor = contractor; }
public ContractSupplyTable(ContractSupply contractSupply, List <SupplyProduct> productList) { this.contractSupply = contractSupply; this.productList = productList; }