public ActionResult Edit(ComponentsElements componentsElements) { if (ModelState.IsValid) { _componentsElements.InsertOrUpdate(componentsElements); _componentsElements.Save(); } return(RedirectToAction("Index")); }
public ActionResult Create(ComponentsElements componentsElements) { if (ModelState.IsValid) { componentsElements.Owner = _users.CurrentUser; _componentsElements.InsertOrUpdate(componentsElements); _componentsElements.Save(); } return(RedirectToAction("Index")); }
void IComponentsElementsRepository.InsertOrUpdate(ComponentsElements componentsElements) { if (componentsElements.ID_ComponentElements == default(int)) { _context.ComponentsElements.Add(componentsElements); } else { _context.Entry(componentsElements).State = System.Data.Entity.EntityState.Modified; } }
public ActionResult Index(ComponentsElements componentsElements) { #region --- Ввод тестовых данных в базу данных // компонент 1 - "Чугун литейный хромоникелевый" ComponentsElements val_11 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун литейный хромоникелевый" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Si" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 2.95, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_11); _componentsElements.Save(); ComponentsElements val_12 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун литейный хромоникелевый" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Mn" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.55, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_12); _componentsElements.Save(); ComponentsElements val_13 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун литейный хромоникелевый" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Cr" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 2.45, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_13); _componentsElements.Save(); ComponentsElements val_14 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун литейный хромоникелевый" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Ni" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 1.20, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_14); _componentsElements.Save(); // компонент 2 - "Чугун литейный коксовый" ComponentsElements val_21 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун литейный коксовый" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Si" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 3.64, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_21); _componentsElements.Save(); ComponentsElements val_22 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун литейный коксовый" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Mn" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.78, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_22); _componentsElements.Save(); ComponentsElements val_23 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун литейный коксовый" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Cr" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_23); _componentsElements.Save(); ComponentsElements val_24 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун литейный коксовый" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Ni" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_24); _componentsElements.Save(); // компонент 3 - "Чугун зеркальный" ComponentsElements val_31 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун зеркальный" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Si" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 2.00, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_31); _componentsElements.Save(); ComponentsElements val_32 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун зеркальный" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Mn" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 23.4, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_32); _componentsElements.Save(); ComponentsElements val_33 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун зеркальный" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Cr" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_33); _componentsElements.Save(); ComponentsElements val_34 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Чугун зеркальный" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Ni" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_34); _componentsElements.Save(); // компонент 4 - "Лом чугунный" ComponentsElements val_41 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Лом чугунный" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Si" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 1.5, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_41); _componentsElements.Save(); ComponentsElements val_42 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Лом чугунный" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Mn" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.7, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_42); _componentsElements.Save(); ComponentsElements val_43 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Лом чугунный" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Cr" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_43); _componentsElements.Save(); ComponentsElements val_44 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Лом чугунный" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Ni" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_44); _componentsElements.Save(); // компонент 5 - "Лом стальной" ComponentsElements val_51 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Лом стальной" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Si" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.5, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_51); _componentsElements.Save(); ComponentsElements val_52 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Лом стальной" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Mn" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.5, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_52); _componentsElements.Save(); ComponentsElements val_53 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Лом стальной" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Cr" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_53); _componentsElements.Save(); ComponentsElements val_54 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Лом стальной" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Ni" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_54); _componentsElements.Save(); // компонент 6 - "Возврат" ComponentsElements val_61 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Возврат" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Si" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.4, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_61); _componentsElements.Save(); ComponentsElements val_62 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Возврат" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Mn" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.65, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_62); _componentsElements.Save(); ComponentsElements val_63 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Возврат" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Cr" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_63); _componentsElements.Save(); ComponentsElements val_64 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Возврат" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Ni" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_64); _componentsElements.Save(); // компонент 7 - "Ферромарганец" ComponentsElements val_71 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Ферромарганец" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Si" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 2.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_71); _componentsElements.Save(); ComponentsElements val_72 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Ферромарганец" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Mn" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 84.5, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_72); _componentsElements.Save(); ComponentsElements val_73 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Ферромарганец" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Cr" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_73); _componentsElements.Save(); ComponentsElements val_74 = new ComponentsElements { ID_Component = _components.All.First(p => p.NameComponent == "Ферромарганец" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Component, ID_Element = _elements.All.First(p => p.NameElement == "Ni" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Element, ID_Variant = _variants.All.First(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant, Val = 0.0, IsSolve = true, Owner = _users.CurrentUser }; _componentsElements.InsertOrUpdate(val_74); _componentsElements.Save(); #endregion --- Ввод тестовых данных в базу данных return(RedirectToAction("Index")); }
void IComponentsElementsRepository.Remove(ComponentsElements componentsElements) { _context.Entry(componentsElements).State = System.Data.Entity.EntityState.Deleted; }