public ActionResult Edit(Sbor_Docum sbor_Docum, HttpPostedFileBase imgfile)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
//Список документов
ViewBag.Doc_ID = new SelectList(db.Documents, "ID_Doc", "Doc_Naim", sbor_Docum.Doc_ID);
//Список сотрудников
ViewBag.Sotr_ID = new SelectList(db.Sotrs, "ID_Sotr", "Full", sbor_Docum.Sotr_ID);
SqlCommand command;
//Если загружен файл
string path = upload(imgfile);
if (!path.Equals("-1"))
{
//Обновление данных
command = new SqlCommand(
"update Sbor_Docum " +
"set " +
"Doc_ID = '" + sbor_Docum.Doc_ID + "', " +
"Sotr_ID = '" + sbor_Docum.Sotr_ID + "', " +
"Itog = 1, " +
"Photo_Doc = '" + path + "' " +
"where ID_Sbora = " + sbor_Docum.ID_Sbora.ToString(),
Program.SqlConnection);
Program.SqlConnection.Open();
command.ExecuteScalar();
Program.SqlConnection.Close();
return(Redirect(Session["perehod"].ToString()));
}
else
{
//Обновление данных
command = new SqlCommand(
"update Sbor_Docum " +
"set " +
"Doc_ID = '" + sbor_Docum.Doc_ID + "', " +
"Sotr_ID = '" + sbor_Docum.Sotr_ID + "', " +
"Itog = 0, " +
"Photo_Doc = Photo_Doc " +
"where ID_Sbora = " + sbor_Docum.ID_Sbora.ToString(),
Program.SqlConnection);
Program.SqlConnection.Open();
command.ExecuteScalar();
Program.SqlConnection.Close();
return(Redirect(Session["perehod"].ToString()));
}
}
else
{
return(Redirect("/Error/NotRight"));
}
}
public ActionResult Edit(int?id)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
if (id == null)
{
//400 ошибка
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//Поиск по ключу
Sbor_Docum sbor_Docum = db.Sbor_Docum.Find(id);
if (sbor_Docum == null)
{
//404 ошибка
return(HttpNotFound());
}
//Получение должностей
SqlCommand command = new SqlCommand("", Program.SqlConnection);
command.CommandText = "SELECT dbo.Positions.Naim_Posit FROM dbo.Sotrs JOIN dbo.Posit_Responsibilities ON dbo.Sotrs.ID_Sotr = dbo.Posit_Responsibilities.Sotr_ID INNER JOIN dbo.Positions ON dbo.Posit_Responsibilities.Positions_ID = dbo.Positions.ID_Positions where id_Sotr = " + sbor_Docum.Sotr_ID;
Program.SqlConnection.Open();
string i = command.ExecuteScalar().ToString();
Program.SqlConnection.Close();
if (i != null && i != "")
{
ViewBag.Dolj = "Должноть: " + i;
}
else
{
ViewBag.Dolj = "";
}
//Список документов
ViewBag.Doc_ID = new SelectList(db.Documents, "ID_Doc", "Doc_Naim", sbor_Docum.Doc_ID);
//Список сотрудников
ViewBag.Sotr_ID = new SelectList(db.Sotrs, "ID_Sotr", "Full", sbor_Docum.Sotr_ID);
return(View(sbor_Docum));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
public ActionResult Delete(int?id)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
if (id == null)
{
//400 ошибка
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//Поиск по коду
Sbor_Docum sbor_Docum = db.Sbor_Docum.Find(id);
if (sbor_Docum == null)
{
//404 ошибка
return(HttpNotFound());
}
return(View(sbor_Docum));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
public ActionResult DeleteConfirmed(int id)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
//Очистка данных
Sbor_Docum sbor_Docum = db.Sbor_Docum.Find(id);
SqlCommand command;
command = new SqlCommand(
"update Sbor_Docum " +
"set " +
"Itog = 0, " +
"Photo_Doc = '' " +
"where ID_Sbora = " + sbor_Docum.ID_Sbora.ToString(),
Program.SqlConnection);
Program.SqlConnection.Open();
command.ExecuteScalar();
Program.SqlConnection.Close();
return(RedirectToAction("Index"));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
