public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
Accounts user = null;
user = db.Accounts.FirstOrDefault(u => u.Login == model.Login);
if (user == null)
{
db.Accounts.Add(new Accounts {
Login = model.Login, Password = model.Password, Id_Role = 3
});
db.SaveChanges();
db.Klient.Add(new Klient {
Login_Kl = model.Login, Familiya = model.Familiya, Imya = model.Imya, Otchestvo = model.Otchestvo, Data_Rojd = model.Data_Rojd, Adres = model.Adres, phone = model.phone, email = model.email, Photo = model.Photo
});
db.SaveChanges();
user = db.Accounts.Where(u => u.Login == model.Login && u.Password == model.Password).FirstOrDefault();
if (user != null)
{
Session["kn"] = 1;
FormsAuthentication.SetAuthCookie(model.Login, true);
return(RedirectToAction("Index", "Home"));
}
}
else
{
ModelState.AddModelError("", "Пользователя с данным логином и паролем не существует");
}
}
return(View(model));
}
public ActionResult Create([Bind(Include = "ID_Role,Naim_Role,Request,Work_for_Request,Work_for_Doc")] Role role)
{
if (ModelState.IsValid)
{
db.Role.Add(role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(role));
}
public ActionResult Create([Bind(Include = "ID_Dolj,Naim_Dolj")] Doljs doljs)
{
if (ModelState.IsValid)
{
db.Dolj.Add(doljs);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(doljs));
}
public ActionResult Create([Bind(Include = "ID_Sposob,Naim_Sposob")] Playment playment)
{
if (ModelState.IsValid)
{
db.Playment.Add(playment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(playment));
}
public ActionResult Create([Bind(Include = "ID_Stat,Naim_Stat")] Status status)
{
if (ModelState.IsValid)
{
db.Status.Add(status);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(status));
}
public ActionResult Create([Bind(Include = "ID_Type,Naim_Type,Description_Type")] Type_Request type_Request)
{
if (ModelState.IsValid)
{
db.Type_Request.Add(type_Request);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(type_Request));
}
public ActionResult Create([Bind(Include = "Login,Password,Id_Role")] Accounts accounts)
{
if (ModelState.IsValid)
{
db.Accounts.Add(accounts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id_Role = new SelectList(db.Role, "ID_Role", "Naim_Role", accounts.Id_Role);
return(View(accounts));
}
public ActionResult Create([Bind(Include = "ID_Pas,Ser_Pas,Nom_Pas,Login_St")] Pas_Dan pas_Dan)
{
if (ModelState.IsValid)
{
db.Pas_Dan.Add(pas_Dan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Login_St = new SelectList(db.Sotrudniki, "Login_St", "Familiya", pas_Dan.Login_St);
return(View(pas_Dan));
}
public ActionResult Create([Bind(Include = "Id_Review,Description,Login_Kl")] Review review)
{
if (ModelState.IsValid)
{
db.Review.Add(review);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Login_Kl = new SelectList(db.Klient, "Login_Kl", "Familiya", review.Login_Kl);
return(View(review));
}
public ActionResult Create([Bind(Include = "id_Dog,Id_Request")] Dogovor dogovor)
{
if (ModelState.IsValid)
{
db.Dogovor.Add(dogovor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id_Request = new SelectList(db.Reqyests, "Id_Request", "Description", dogovor.Id_Request);
return(View(dogovor));
}
public ActionResult Create([Bind(Include = "Login_St,Familiya,Imya,Otchestvo,DateOfRojd,Pol,Adres,Num_Phone,Email,Photo,Dolj_ID")] Sotrudniki sotrudniki)
{
if (ModelState.IsValid)
{
db.Sotrudniki.Add(sotrudniki);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Dolj_ID = new SelectList(db.Dolj, "ID_Dolj", "Naim_Dolj", sotrudniki.Dolj_ID);
return(View(sotrudniki));
}
public void Add(Personal t)
{
try
{
_context.Personals.Add(t);
_context.SaveChanges();
}
catch (Exception e)
{
_logger.LogDebug(e.Message);
}
}
public IActionResult savePayType(PayType type)
{
if (_personalContext.PayType.Contains(type))
{
_personalContext.Update(type);
}
else
{
_personalContext.Add(type);
}
_personalContext.SaveChanges();
return(Ok());
}
public ActionResult Create([Bind(Include = "ID_Positions,Naim_Posit,Salary,Depart_ID,Kol_Vo_Pers,Kol_Vo_On_Isp,Vak_Mest,Logical_Delete")] Positions positions)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
SqlCommand command = new SqlCommand("", Program.SqlConnection);
//Проверка на повторения
command.CommandText = "Select count(*) from Positions where Naim_Posit = '" + positions.Naim_Posit + "'";
Program.SqlConnection.Open();
int co = (int)command.ExecuteScalar();
ViewBag.m = "";
Program.SqlConnection.Close();
if (co == 0)
{
//Если валидация прошла успешно
if (ModelState.IsValid)
{
if (idpos == 0)
{
//Добавление записи
db.Positions.Add(positions);
//Сохранение
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
//Добавление записи при известном id
positions.Depart_ID = Convert.ToInt32(idpos);
//Добавление
db.Positions.Add(positions);
//Сохранение
db.SaveChanges();
//Переадресация
return(Redirect("/Positions/Index/" + idpos.ToString()));
}
}
}
else
{
//Вывод текста, что такая должность уже существует
ViewBag.m = "Такая должность уже существует!";
}
//Список отделов
ViewBag.Depart_ID = new SelectList(db.Departments, "ID_Depart", "Naim_Depart", positions.Depart_ID);
return(View(positions));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
public bool AddLink(LinkDto link)
{
try
{
_context.Links.Add(Mapper.Map <LinkDto, Link>(link));
_context.SaveChanges();
return(true);
}
catch (Exception e)
{
_logger.Error(e.ToString);
throw new Exception("Ошибка при добавлении ссылки");
}
}
public ActionResult Create([Bind(Include = "Id_Request,Description,Comment,Date,Time,Sum,ID_Type,Login_Kl,ID_Sposob,ID_Stat")] Reqyests reqyests)
{
if (ModelState.IsValid)
{
db.Reqyests.Add(reqyests);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Login_Kl = new SelectList(db.Klient, "Login_St", "F_Kl", reqyests.Login_Kl);
ViewBag.ID_Sposob = new SelectList(db.Playment, "ID_Sposob", "Naim_Sposob", reqyests.ID_Sposob);
ViewBag.ID_Stat = new SelectList(db.Status, "ID_Stat", "Naim_Stat", reqyests.ID_Stat);
ViewBag.ID_Type = new SelectList(db.Type_Request, "ID_Type", "Naim_Type", reqyests.ID_Type);
return(View(reqyests));
}
public IActionResult saveCustomRecord(CustomRecord record)
{
if (_personalContext.CustomRecord.Contains(record))
{
_personalContext.Update(record);
}
else
{
record.CreatedOn = DateTime.Now;
record.UserId = new Guid(_httpContextAccessor.HttpContext.User.FindFirst("userid").Value);
_personalContext.CustomRecord.Add(record);
}
_personalContext.SaveChanges();
return(Ok());
}
public IActionResult saveWages(Wages wage)
{
if (_personalContext.Wages.Contains(wage))
{
_personalContext.Update(wage);
}
else
{
wage.CreatedOn = DateTime.Now;
wage.UserId = new Guid(_httpContextAccessor.HttpContext.User.FindFirst("userid").Value);
_personalContext.Wages.Add(wage);
}
_personalContext.SaveChanges();
return(Ok());
}
public ActionResult Edit([Bind(Include = "ID_Obr,Sotr_ID,Data_Sob,Vremya_Sob,Kommnt,reshenie,nomerzay")] Obrabotka obrabotka)
{
if ((bool)Session["Manip_Tests"] == true && Session["Manip_Tests"] != null)
{
//Если валидация успешно прошла
if (ModelState.IsValid)
{
//Проверка на время
if (Convert.ToInt32(obrabotka.Vremya_Sob[0].ToString() + obrabotka.Vremya_Sob[1].ToString()) <= 23 && Convert.ToInt32(obrabotka.Vremya_Sob[3].ToString() + obrabotka.Vremya_Sob[4].ToString()) <= 59)
{
//Изменение данных
db.Entry(obrabotka).State = EntityState.Modified;
//Сохранение
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.Sotr_ID = new SelectList(db.Sotrs, "ID_Sotr", "Full", obrabotka.Sotr_ID);
//Вывод сообщения, что время указано некорректно
ModelState.AddModelError("Vremya_Sob", "Некорректное указано время");
return(View(obrabotka));
}
}
ViewBag.Sotr_ID = new SelectList(db.Sotrs, "ID_Sotr", "Full", obrabotka.Sotr_ID);
return(View(obrabotka));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
public ContentResult Save(int?id, FormCollection actionValues)
{
var action = new DataAction(actionValues);
try
{
var changedEvent = (Events)DHXEventsHelper.Bind(typeof(Events), actionValues);
switch (action.Type)
{
case DataActionTypes.Insert:
Events EV = new Events();
EV.Id = changedEvent.Id;
EV.Start_date = changedEvent.Start_date;
EV.End_date = changedEvent.End_date;
EV.Text = changedEvent.Text;
db.Events.Add(EV);
db.SaveChanges();
break;
case DataActionTypes.Delete:
var details = db.Events.Where(x => x.Id == id).FirstOrDefault();
db.Events.Remove(details);
db.SaveChanges();
break;
default: // "update"
var data = db.Events.Where(x => x.Id == id).FirstOrDefault();
data.Start_date = changedEvent.Start_date;
data.End_date = changedEvent.End_date;
data.Text = changedEvent.Text;
db.SaveChanges();
break;
}
}
catch
{
action.Type = DataActionTypes.Error;
}
return((ContentResult) new AjaxSaveResponse(action));
}
public ActionResult Create([Bind(Include = "Login_Kl,Familiya,Imya,Otchestvo,Data_Rojd,Adres,phone,email,Photo")] Klient klient)
{
if (ModelState.IsValid)
{
//if (Convert.ToDateTime(klient.Data_Rojd) >= DateTime.Now.AddYears(-18))
//{
db.Klient.Add(klient);
db.SaveChanges();
return(RedirectToAction("Index"));
//}
//else
//{
// return Json("Вы неверно указали даты", JsonRequestBehavior.AllowGet);
//}
}
return(View(klient));
}
public ActionResult Settings(Sotrs sotrs)
{
if (User.Identity.IsAuthenticated)
{
//Если картинка загружена
if (sotrs.ImageUpload != null)
{
string filename = Path.GetFileNameWithoutExtension(sotrs.ImageUpload.FileName);
string extension = Path.GetExtension(sotrs.ImageUpload.FileName);
filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
sotrs.Photo = "/Content/Photo/st/" + filename;
sotrs.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/Content/Photo/st/"), filename));
}
try
{
//Обновление данных
//Изменение данных
sotrs.Address = Shifrovanie.Encryption(sotrs.Address);
db.Entry(sotrs).State = EntityState.Modified;
Session["FIO"] = sotrs.Surname_Sot + " " + sotrs.Name_Sot + " " + sotrs.Petronumic_Sot;
Session["Email"] = sotrs.Email;
Session["Num_Phone"] = sotrs.Num_Phone;
Session["Address"] = sotrs.Address;
Session["Day_Of_Birth"] = sotrs.Day_Of_Birth;
Session["Photo"] = sotrs.Photo;
Session["Dolj"] = "Статус: Гость";
var s = db.Sotrs.Include(sot => sot.Accounts).Where(sot => sot.Login_Acc == User.Identity.Name).FirstOrDefault();
Session["Guest"] = s.Guest;
//Если не гость, не заблокирован, не уволен
if ((bool)Session["Guest"] == false && s.Accounts.Block == false && s.fired == false)
{
Session["Manip_Sotrs"] = s.Accounts.Roles.Manip_Sotrs;
Session["Manip_Roles"] = s.Accounts.Roles.Manip_Roles;
Session["Manip_Tests"] = s.Accounts.Roles.Manip_Tests;
Session["Manip_Department"] = s.Accounts.Roles.Manip_Department;
}
//Сохранение
db.SaveChanges();
//сообщение об изменении данных
ViewBag.Suc = true;
ViewBag.SucMes = "Ваши данные аккаунта успешно изменены";
return(View(sotrs));
}
catch
{
//список аккаунтов
ViewBag.Login_Acc = new SelectList(db.Accounts, "Login", "Password", sotrs.Login_Acc);
return(View(sotrs));
}
}
else
{
return(Redirect("/Error/NotAuth"));
}
}
public ActionResult AddEstudante(GruposDetalhes gruposDetalhes)
{
if (ModelState.IsValid)
{
var existe = db.GruposDetalhes.Where(gd => gd.GrupoId == gruposDetalhes.GrupoId && gd.UserId == gruposDetalhes.UserId).FirstOrDefault();
if (existe == null)
{
db.GruposDetalhes.Add(gruposDetalhes);
db.SaveChanges();
return(RedirectToAction(string.Format("Details/{0}", gruposDetalhes.GrupoId)));
}
ModelState.AddModelError(string.Empty, "Aluno já matriculado");
}
ViewBag.UserId = new SelectList(db.Usuarios.Where(u => u.Estudante).OrderBy(u => u.Nome).ThenBy(u => u.Sobrenome), "UserId", "NomeCompleto", gruposDetalhes.UserId);
return(View(gruposDetalhes));
}
public IHttpActionResult PutUsuario(int id, Usuario usuario)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != usuario.UserId)
{
return(BadRequest());
}
var db2 = new PersonalContext();
var oldUser = db2.Usuarios.Find(usuario.UserId);
db2.Dispose();
db.Entry(usuario).State = EntityState.Modified;
try
{
db.SaveChanges();
if (oldUser != null && oldUser.UserName != usuario.UserName)
{
Uteis.ChangeEmailUserAsp(oldUser.UserName, usuario.UserName);
}
}
catch (DbUpdateConcurrencyException)
{
if (!UsuarioExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(this.Ok(usuario));
}
public ActionResult Create([Bind(Include = "ID_Rate,Rate")] Rates rates)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
//если валидайия пройдена успешно
if (ModelState.IsValid)
{
//Добавление данных
db.Rates.Add(rates);
//Сохранение
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rates));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
public void Delete(string id)
{
PersonalContext pc = new PersonalContext();
FundAllocation fa = (from p in pc.FundAllocation where p.Symbol == id select p).FirstOrDefault();
if (fa != null)
{
pc.FundAllocation.Remove(fa);
pc.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "ID_Doc,Doc_Naim")] Documents documents, List <string> Doc, List <string> Doc2)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
//Поиск документа с наименованием, которое уже существует
SqlCommand command = new SqlCommand("", Program.SqlConnection);
command.CommandText = "Select count(*) from Documents where Doc_Naim = '" + documents.Doc_Naim + "'";
Program.SqlConnection.Open();
int co = (int)command.ExecuteScalar();
Program.SqlConnection.Close();
var s = db.Posit_Responsibilities.OrderBy(m => m.Sotr_ID).GroupBy(m => m.Sotr_ID).ToList();
ViewBag.s = s;
if (co == 0)
{
//Перебор всех докуентов
for (int i = 0; i < Doc.Count; i++)
{
if (Doc[i] != null && Doc[i] != "")
{
//Добавление данных
documents.Doc_Naim = Doc[i];
db.Documents.Add(documents);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
else
{
//Вывод сообщения, что такой документ уже существует
ViewBag.m = "Такой документ уже существует!";
}
return(View(documents));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
public ActionResult Create(UsuarioView view)
{
if (ModelState.IsValid)
{
db.Usuarios.Add(view.Usuario);
try
{
if (view.Foto != null)
{
var pic = Uteis.UploadPhoto(view.Foto);
if (!string.IsNullOrEmpty(pic))
{
view.Usuario.Photo = string.Format("~/Content/Fotos/{0}", pic);
}
}
db.SaveChanges();
Uteis.CreateUserASP(view.Usuario.UserName);
if (view.Usuario.Estudante)
{
Uteis.AddRoleToUser(view.Usuario.UserName, "Aluno");
}
if (view.Usuario.Professor)
{
Uteis.AddRoleToUser(view.Usuario.UserName, "Professor");
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
}
return(View(view));
}
static void Main(string[] args)
{
using (var ctx = new PersonalContext())
{
var location1 = ctx.Locations.FirstOrDefault(x => x.City.Equals("Craiova"));
if (location1 != null)
{
location1.PostalCode = "123456";
ctx.Locations.AddOrUpdate(location1);
}
ctx.SaveChanges();
var location2 = ctx.Locations.FirstOrDefault(x => x.City.Equals("Bucuresti"));
if (location2 != null)
{
ctx.Locations.Remove(location2);
}
ctx.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "ID_Depart,Naim_Depart")] Departments departments)
{
if ((bool)Session["Manip_Sotrs"] == true && Session["Manip_Sotrs"] != null)
{
//Добавление команды
SqlCommand command = new SqlCommand("", Program.SqlConnection);
//Поиск отделов с таким же наименованием
command.CommandText = "Select count(*) from Departments where Naim_Depart = '" + departments.Naim_Depart + "'";
//Открытие подключения
Program.SqlConnection.Open();
//Выполнение команды
int co = (int)command.ExecuteScalar();
//Закрытие подключения
Program.SqlConnection.Close();
if (co == 0)
{
//Если валидация успешно прошла
if (ModelState.IsValid)
{
//Добавление новой записи
db.Departments.Add(departments);
//Сохранение
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
//Вывод сообщения, что отдел такой уже существует
ViewBag.m = "Такой отдел уже существует!";
}
return(View(departments));
}
else
{
return(Redirect("/Error/NotRight"));
}
}
static void Main(string[] args)
{
using (var ctx = new PersonalContext())
{
var location1 = ctx.Locations.FirstOrDefault(x => x.City.Equals("Craiova"));
if (location1 != null)
{
location1.PostalCode = "123456";
ctx.Locations.AddOrUpdate(location1);
}
ctx.SaveChanges();
var location2 = ctx.Locations.FirstOrDefault(x => x.City.Equals("Bucuresti"));
if (location2 != null)
{
ctx.Locations.Remove(location2);
}
ctx.SaveChanges();
}
}
