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(); } }