public ActionResult FirstStorageProcedure(Procedure1_AddCP proc, TContract_product v)
{
if (ModelState.IsValid)
{
using (var context = new EFDbContext())
{
string Name_customer = proc.CustomerName;
string Name_company = proc.CompanyName;
int KolProduct = proc.Kolvo_Products;
float PriceProduct = proc.Price_Product;
DateTime DateDeliveryProduct = proc.Date_delivery_product;
var data = context.Database.ExecuteSqlCommand(" EXEC [dbo].[Add_Inf_in_the_Contract_Product] @Name_customer, @Name_company, @KolProduct," +
"@PriceProduct, @DateDeliveryProduct",
new SqlParameter("Name_customer", Name_customer),
new SqlParameter("Name_company", Name_company),
new SqlParameter("KolProduct", KolProduct),
new SqlParameter("PriceProduct", PriceProduct),
new SqlParameter("DateDeliveryProduct", DateDeliveryProduct));
return(RedirectToAction("Rez1StopP"));
}
}
else
{
// Что-то не так со значениями данных
return(View());
}
}
public ActionResult FirstStorageProcedure()
{
Procedure1_AddCP v = new Procedure1_AddCP();
v.TypeOfCustomers = from var in repository.Customers select var.Name_Customer;
v.TypeOfCompanies = from var in repository.Companies select var.Name_C;
return(View(v));
}
