public async Task <ActionResult> Create([Bind(Include = "ID_Pos_Res,Sotr_ID,Positions_ID,Rates_ID")] Posit_Responsibilities posit_Responsibilities)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
//Если валидация успешно прошла
if (ModelState.IsValid)
{
//Добавление данных
db.Posit_Responsibilities.Add(posit_Responsibilities);
//Сохранение
await db.SaveChangesAsync();
return(Redirect(Session["perehod"].ToString()));
}
//Список должностей
ViewBag.Positions_ID = new SelectList(db.Positions.Where(p => p.Vak_Mest > 0), "ID_Positions", "Naim_Posit", posit_Responsibilities.Positions_ID);
//Список ставок
ViewBag.Rates_ID = new SelectList(db.Rates, "ID_Rate", "Rate", posit_Responsibilities.Rates_ID);
string constr = ConfigurationManager.ConnectionStrings["PersonalContext"].ToString();
SqlConnection _con = new SqlConnection(constr);
//Поиск сотрудников, которым не назначены должностные инструкции
SqlDataAdapter _da = new SqlDataAdapter("SELECT ID_Sotr, Surname_Sot + ' ' + Name_Sot + ' ' + Petronumic_Sot + ' (' + Login_Acc + ')' as FIO FROM Sotrs LEFT JOIN Posit_Responsibilities ON Sotrs.ID_Sotr=Posit_Responsibilities.Sotr_ID WHERE Guest = 'false' and [fired] = 'false' and Posit_Responsibilities.Sotr_ID IS NULL", constr);
DataTable _dt = new DataTable();
_da.Fill(_dt);
//Список сотрудников
ViewBag.Sotr_ID = ToSelectList(_dt, "ID_Sotr", "FIO", posit_Responsibilities.Sotr_ID);
return(View(posit_Responsibilities));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
public async Task <ActionResult> Edit([Bind(Include = "ID_Pos_Res,Sotr_ID,Positions_ID,Rates_ID")] Posit_Responsibilities posit_Responsibilities)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
//Если валидация успешно прошла
if (ModelState.IsValid)
{
//Сохранение данных
db.Entry(posit_Responsibilities).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
//Список должностей
ViewBag.Positions_ID = new SelectList(db.Positions, "ID_Positions", "Naim_Posit", posit_Responsibilities.Positions_ID);
//Список ставок
ViewBag.Rates_ID = new SelectList(db.Rates, "ID_Rate", "Rate", posit_Responsibilities.Rates_ID);
//Список сотрудников
ViewBag.Sotr_ID = new SelectList(db.Sotrs, "ID_Sotr", "Surname_Sot", posit_Responsibilities.Sotr_ID);
return(View(posit_Responsibilities));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
public async Task <ActionResult> Edit(int?id)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
if (id == null)
{
//400 ошибка
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//Поиск по ключу
Posit_Responsibilities posit_Responsibilities = await db.Posit_Responsibilities.FindAsync(id);
if (posit_Responsibilities == null)
{
//404 ошибка
return(HttpNotFound());
}
//Список должностей
ViewBag.Positions_ID = new SelectList(db.Positions, "ID_Positions", "Naim_Posit", posit_Responsibilities.Positions_ID);
//Список ставок
ViewBag.Rates_ID = new SelectList(db.Rates, "ID_Rate", "Rate", posit_Responsibilities.Rates_ID);
//Список сотрудников
ViewBag.Sotr_ID = new SelectList(db.Sotrs, "ID_Sotr", "Surname_Sot", posit_Responsibilities.Sotr_ID);
return(View(posit_Responsibilities));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
Posit_Responsibilities posit_Responsibilities = await db.Posit_Responsibilities.FindAsync(id);
//Удаление записи
db.Posit_Responsibilities.Remove(posit_Responsibilities);
//Сохранение
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
// GET: Posit_Responsibilities/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
if (id == null)
{
//400 ошибка
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//Поиск по ключу
Posit_Responsibilities posit_Responsibilities = await db.Posit_Responsibilities.FindAsync(id);
if (posit_Responsibilities == null)
{
//404 ошибка
return(HttpNotFound());
}
return(View(posit_Responsibilities));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
