[SRC c#]@model MvcApplication3.Models.o_klient


@{
    ViewBag.Title = "Redaktor";
    Layout = "~/Views/Shared/_Layout.cshtml";
    string value = "";
    //string test = "ssss";
    ////string city = "";
    MvcApplication3.Models.info_klient_second data = new MvcApplication3.Models.info_klient_second();
}


<div  style="padding:10px;border:1px solid #0094ff; background-color:#d9fffb;border-radius:10px;margin-top:150px;">

@using (Html.BeginForm("Redaktor", "Pervii", new { id_redaktor = ViewBag.id }, FormMethod.Post))
{
    foreach (MvcApplication3.Models.info_klient_second data_new in ViewBag.Data)
    {
      
   <table>
 <tr><td><p>Город:</p></td><td>@Html.TextBoxFor(x => x.GOROD, new { @Value = data_new.GOROD }) @Html.ValidationMessageFor(model => model.GOROD)</td></tr>
 <tr><td><p>ФИО:</p></td><td>@Html.TextBoxFor(x => x.FIO, new { @Value = data_new.FIO }) @Html.ValidationMessageFor(model => model.FIO)</td></tr>
 <tr><td><p>Сорт:</p></td><td>@Html.TextBoxFor(x => x.sort1, new { @Value = data_new.sort1 }) @Html.ValidationMessageFor(model => model.sort1)</td></tr>
 <tr><td><p>Наименование:</p></td><td>@Html.TextBoxFor(x => x.naimenovanie1, new { @Value = data_new.naimenovanie1 }) @Html.ValidationMessageFor(model => model.naimenovanie1)</td></tr>
 <tr><td><p>Дата покупки:</p></td><td>@Html.TextBoxFor(x => x.DATA_POKUPKI, new { @Value = data_new.DATA_POKUPKI }) @Html.ValidationMessageFor(model => model.DATA_POKUPKI)</td></tr>
 <tr><td><p>Цена:</p></td><td>@Html.TextBoxFor(x => x.CENA, new { @Value = data_new.CENA }) @Html.ValidationMessageFor(model => model.CENA)</td></tr>
  </table> 
 <input type="hidden" name="change" value="change" />@* 
  <input type="hidden" name="id_redaktor" value ="" />*@   
 <input type="submit" class="button" value="Сохранить" />
    }
}
    </div>

public ActionResult Redaktor(o_klient model, string id_redaktor, string change, int? page)//редактирование записей в бд
        {
            string day;
            string month;
            string year;
            string data_result;

            day = model.DATA_POKUPKI.ToString().Substring(0, 2).Replace(".","");
            month = model.DATA_POKUPKI.ToString().Substring(2, 3).Replace(".", "");
            year = model.DATA_POKUPKI.ToString().Substring(5, 6).Replace(" ", "").Replace(".", "");
            data_result = day + month + year;
            ViewBag.id = id_redaktor;//для сохранения ид_редактор для др представления т.к. он обычно обнуляется при переходе в др представление
            if (change == "change")
            {
            var query = // выбираем таблицу клиент_нью  где ид = переданному ид(с представления в качестве параметра)
                    from a in db.klient_new
                    where a.id == Convert.ToInt32(id_redaktor)
                    select a;

                    foreach (var a in query)//
                    {
                        a.fio=model.FIO;
                        a.gorod = model.GOROD;
                        a.tovar.naimenovanie = model.naimenovanie1;
                        a.tovar.sort = model.sort1;
                        a.tovar.cena.cena1 = model.CENA;
                        a.tovar.cena.Data_pokupki = Convert.ToDateTime(year+"-"+month+"-"+day);
                    }
                    try
                    {
                       
                    }
                    catch (Exception ex) {};
                    
                    db.SubmitChanges();
                    db = new DataClasses1DataContext();
                    List<o_klient> item = new List<o_klient>();
                    int pageNumber = page ?? 1;
                    int pageSize = 10;
                    execute();
                    ViewBag.data = spisok;
                    ViewBag.value = "1";
                    return View("Index", spisok.ToPagedList(pageNumber, pageSize));                  
                }