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));
}
