public ActionResult SecondStorageProcedure(Procedure2_AddCD proc) { if (ModelState.IsValid) { using (var context = new EFDbContext()) { string Name_provider = proc.Name_provider; string Name_company = proc.Name_company; int KolDetails = proc.KolDetails; float PriceDetails = proc.PriceDetails; DateTime DateDeliveryDetails = proc.DateDeliveryDetails; var data = context.Database.ExecuteSqlCommand(" EXEC [dbo].[Add_Inf_in_the_Contract_Details] @Name_provider, @Name_company, @DateDeliveryDetails," + "@KolDetails, @PriceDetails", new SqlParameter("Name_provider", Name_provider), new SqlParameter("Name_company", Name_company), new SqlParameter("DateDeliveryDetails", DateDeliveryDetails), new SqlParameter("KolDetails", KolDetails), new SqlParameter("PriceDetails", PriceDetails)); return(RedirectToAction("Rez2StopP")); } } else { // Что-то не так со значениями данных return(View()); } }
public ActionResult SecondStorageProcedure() { Procedure2_AddCD v = new Procedure2_AddCD(); v.TypeOfProviders = from var in repository.Providers select var.Name_prov; v.TypeOfCompanies = from var in repository.Companies select var.Name_C; return(View(v)); }