public bool queryUpdateTechCard(TechnologicalCard c) { if (LoginInfo.Position == 1 || LoginInfo.Position == 2 || LoginInfo.Position == 3) { using (DataBaseContext db = new DataBaseContext()) { try { int IdCard = c.Id; TechnologicalCard card = db.TechnologicalCards.Find(IdCard); card.Date = c.Date; card.Title = c.Title; db.ProductTechCards.RemoveRange(card.ProductTechCards); card.ProductTechCards = c.ProductTechCards; db.SaveChanges(); } catch (Exception e) { return(false); } return(true); } } return(false); }
public TechCardsTable queryFindTechCardById(int Id) { if (LoginInfo.Position == 1 || LoginInfo.Position == 2 || LoginInfo.Position == 3) { using (DataBaseContext db = new DataBaseContext()) { TechnologicalCard s = db.TechnologicalCards.Find(Id); //List<ProductTechCard> lsp = db.ProductTechCards.Select(it => new ProductTechCard() { Id = it.Id, ProductId = it.ProductId, Amount = it.Amount, Type = it.Type }).Where(r => r.TechCardId == Id).ToList(); List <ProductTechCard> lsp = s.ProductTechCards; TechCardsTable table = new TechCardsTable(s, lsp); return(table); } } return(null); }
public bool queryAddTechCard(TechnologicalCard c) { if (LoginInfo.Position == 1 || LoginInfo.Position == 2 || LoginInfo.Position == 3) { using (DataBaseContext db = new DataBaseContext()) { try { db.TechnologicalCards.Add(c); db.SaveChanges(); } catch (Exception e) { return(false); } return(true); } } return(false); }
public bool queryDeleteTechCard(int Id) { if (LoginInfo.Position == 1 || LoginInfo.Position == 2 || LoginInfo.Position == 3) { using (DataBaseContext db = new DataBaseContext()) { try { TechnologicalCard card = db.TechnologicalCards.Find(Id); List <ProductTechCard> lsp = card.ProductTechCards; db.ProductTechCards.RemoveRange(lsp); db.TechnologicalCards.Remove(card); db.SaveChanges(); } catch (Exception e) { return(false); } return(true); } } return(false); }
public TechCardsTable(TechnologicalCard technologicalCard, List <ProductTechCard> productTechCard) { this.technologicalCard = technologicalCard; this.productTechCard = productTechCard; }