public ActionResult AddNews(News getNews) { if(ModelState.IsValid == true) { DiplomEntities5 dc = new DiplomEntities5(); dc.News.Add(getNews); dc.SaveChanges(); getNews = null; ViewBag.Message = "Новость успешно опубликована"; } return View(getNews); }
public ActionResult MessagesStaff(Messages newMessage) { using (DiplomEntities5 dc = new DiplomEntities5()) { if (ModelState.IsValid == true) { dc.Messages.Add(newMessage); dc.SaveChanges(); ModelState.Clear(); newMessage = null; } } return View(newMessage); }
public ActionResult SaveChangesApp(List<Applications> getChanges) { DiplomEntities5 dc = new DiplomEntities5(); foreach(Applications app in getChanges) { if(app.isRead == 0) { var appToChange = dc.Applications.Where(a => a.Id.Equals(app.Id)).FirstOrDefault(); appToChange.isConfirmed = app.isConfirmed; appToChange.DateOfRead = DateTime.Now; appToChange.isRead = 1; appToChange.Reader = Session["LogedUserSname"].ToString() + " " + Session["LogedUserName"].ToString().First() + ". " + Session["LogedUserPname"].ToString().First(); dc.SaveChanges(); } } ViewBag.Message = "Изменения успешно сохранены"; int course = Convert.ToInt32(Session["CourseApp"]); int group = Convert.ToInt32(Session["GroupApp"]); var Group = dc.Applications.Where(a => a.Users.Group == group && a.Users.Course == course).OrderByDescending(a => a.Id).ToList<Applications>(); return View("ViewApplications", Group); }
public ActionResult Appliance(ApplicationView getApp) { Applications newApp = new Applications(); newApp.StudentId = Convert.ToInt32(Session["LogedUserId"].ToString()); newApp.Head = "Декану факультета инновационной подготовки Зеневич А. М. "; if(getApp.isMale == 1) { newApp.Head += "Студента "; } else { newApp.Head += "Студентки "; } newApp.Head += Session["LogedUserCourse"].ToString(); newApp.Head += " курса дневной формы обучения "; newApp.Head += "специальности управление информационными ресурсами "; newApp.Head += "Института управленческих кадров"; newApp.Reason = getApp.Reason; newApp.isRead = 0; newApp.DateOfCreation = DateTime.Now; newApp.DateOfMiss = getApp.DateOfMiss; DiplomEntities5 dc = new DiplomEntities5(); dc.Applications.Add(newApp); dc.SaveChanges(); ViewBag.Message = "Заявление успешно отправлено."; ViewBag.NumAllowApp = NumAllowedApp(); return View(); }
public ActionResult Index(LogedUser user) { using(DiplomEntities5 dc = new DiplomEntities5()) { if(ModelState.IsValid) { var v = dc.Users.Where(a => a.Login.Equals(user.Login) && a.Password.Equals(user.Password)).FirstOrDefault(); if(v != null) { if ((v.RoleId == 1 || v.RoleId == 2) && v.RoleId != 7 ) { //Itterate number of user course DateTime now = DateTime.Now; int CountCourseInDb = now.Year - (Convert.ToInt32(v.Login.ToString().Substring(0, 2)) + 2000); int CourseValueDb = Convert.ToInt32(v.Course); if (now.Month >= 9) { CountCourseInDb++; } if (CountCourseInDb != CourseValueDb) { v.Course = CountCourseInDb; if (CountCourseInDb == 5) { v.RoleId = 7; } dc.SaveChanges(); Session["NewCourse"] = 1; } } if (v.RoleId == 7) { ViewBag.Message = "Вы отчислены из университета. Доступ закрыт"; return View(user); } if (v.RoleId == 4) { DateTime now = DateTime.Now; int numStud = 0; int numStudToBeRased = 0; foreach(Users student in dc.Users) { //If there is October now or late, skip this function if (now.Month != 9) { dc.Utility.Where(a => a.Id.Equals(3)).FirstOrDefault().Limit = 0; break; } if(student.RoleId == 1 || student.RoleId == 2) { numStud++; int CountCourseInDb = now.Year - (Convert.ToInt32(student.Login.ToString().Substring(0, 2)) + 2000); int CourseValueDb = Convert.ToInt32(student.Course); if (now.Month >= 9) { CountCourseInDb++; } if (CountCourseInDb != CourseValueDb) { numStudToBeRased++; } } } Session["NumStudent"] = numStud; Session["NumStudentToRase"] = numStudToBeRased; int isNewYear = dc.Utility.Where(a => a.Id.Equals(3)).FirstOrDefault().Limit; if(isNewYear == 0 && now.Month == 9) { Session["NewStudYear"] = 1; } } Session["LogedUserId"] = v.UserId.ToString(); Session["LogedUserName"] = v.Name.ToString(); Session["LogedUserSname"] = v.Sirname.ToString(); Session["LogedUserPname"] = v.Patername.ToString(); Session["LogedUserRole"] = v.RoleId.ToString(); Session["LogedUserGroup"] = v.Group.ToString(); Session["LogedUserCourse"] = v.Course.ToString(); return RedirectPermanent("Profile/Index"); } else { ViewBag.Message = "Ошибка авторизации"; } } } return View(user); }
public ActionResult EditGroup(List<Users> getStudent) { DiplomEntities5 dc = new DiplomEntities5(); foreach (Users stud in getStudent) { var DbStud = dc.Users.Where(a => a.UserId.Equals(stud.UserId)).FirstOrDefault(); if (!DbStud.RoleId.Equals(stud.RoleId)) { DbStud.RoleId = stud.RoleId; } } ViewBag.Message = "Изменения успешно сохранены"; dc.SaveChanges(); if(Session["NumGroup"].ToString().Equals("1")) { return Redirect("~/Profile/GroupOneMethodist"); } else if (Session["NumGroup"].ToString().Equals("2")) { return Redirect("~/Profile/GroupTwoMethodist"); } else if (Session["NumGroup"].ToString().Equals("3")) { return Redirect("~/Profile/GroupThreeMethodist"); } return null; }
public ActionResult Erase() { DiplomEntities5 dc = new DiplomEntities5(); foreach (Missings item in dc.Missings) { dc.Missings.Remove(item); } foreach (Applications item in dc.Applications) { dc.Applications.Remove(item); } foreach (News item in dc.News) { dc.News.Remove(item); } foreach (Changes item in dc.Changes) { dc.Changes.Remove(item); } dc.Utility.Where(a => a.Id.Equals(3)).FirstOrDefault().Limit = 1; dc.SaveChanges(); return View("Methodist"); }
public ActionResult Changes() { if(Session["LogedUserRole"].ToString().Equals("4")) { return Redirect("~/Profile/ChangesForMethodist"); } DiplomEntities5 dc = new DiplomEntities5(); foreach(Changes item in dc.Changes) { if(item.isRead == 0 && item.UserId.ToString().Equals(Session["LogedUserId"].ToString())) { item.isRead = 1; } } dc.SaveChanges(); ViewBag.chan = dc.Changes.OrderByDescending(a => a.Id); return View(); }
public ActionResult SetLim() { try { int numAppInWeek = Convert.ToInt32(Request["numApp"]); DiplomEntities5 dc = new DiplomEntities5(); var Row = dc.Utility.Where(a => a.Id.Equals(2)).FirstOrDefault(); Row.Limit = numAppInWeek; dc.SaveChanges(); } catch { goto metka; } metka: string num = Session["GroupApp"].ToString(); if (Session["GroupApp"].ToString().Equals("1")) { return View("ViewApplications",GetAppOfGroup(1)); } else if (Session["GroupApp"].ToString().Equals("2")) { return View("ViewApplications", GetAppOfGroup(2)); } else if (Session["GroupApp"].ToString().Equals("3")) { return View("ViewApplications", GetAppOfGroup(3)); } return null; }
public ActionResult SetLimMiss() { try { int numMissInMonth = Convert.ToInt32(Request["numMiss"]); DiplomEntities5 dc = new DiplomEntities5(); var Row = dc.Utility.Where(a => a.Id.Equals(1)).FirstOrDefault(); Row.Limit = numMissInMonth; dc.SaveChanges(); } catch { return Redirect("MonthReportForZDean"); } return Redirect("MonthReportForZDean"); }
public ActionResult Rase() { DateTime now = DateTime.Now; DiplomEntities5 dc = new DiplomEntities5(); foreach (Users student in dc.Users) { if (student.RoleId == 1 || student.RoleId == 2) { int year = Convert.ToInt32(student.Login.ToString().Substring(0, 2)); int CountCourseInDb = now.Year - (year + 2000); int CourseValueDb = Convert.ToInt32(student.Course); if (now.Month >= 9) { CountCourseInDb++; } if (CountCourseInDb != CourseValueDb) { if (CountCourseInDb == 5) { student.RoleId = 7; } else { student.Course = CountCourseInDb; } } } } dc.SaveChanges(); return View("Methodist"); }
public ActionResult ChangeAvatar(HttpPostedFileBase NewAvatar) { if(NewAvatar != null) { DiplomEntities5 dc = new DiplomEntities5(); MemoryStream memory = new MemoryStream(); string fileName = System.IO.Path.GetFileName(NewAvatar.FileName); NewAvatar.SaveAs(Server.MapPath("~/Content/Avatars/" + fileName)); NewAvatar.InputStream.CopyTo(memory); int userId = Convert.ToInt32(Session["LogedUserId"]); var UserToSave = dc.Users.Where(a => a.UserId.Equals(userId)).FirstOrDefault(); UserToSave.Avatar = memory.GetBuffer(); dc.SaveChanges(); } return Redirect("~/Profile/Index"); }
public ActionResult RegisterDean(RegDean FormRegUser, HttpPostedFileBase Avatar) { using (DiplomEntities5 dc = new DiplomEntities5()) { var anyUserEmail = dc.Users.Any(a => a.Email.Equals(FormRegUser.Email)); if (anyUserEmail) { ModelState.AddModelError("Email", "Пользователь с таким email уже зарегистрирован"); } var anyUserLogin = dc.Users.Any(a => a.Login.Equals(FormRegUser.Login)); if (anyUserLogin) { ModelState.AddModelError("Login", "Пользователь с таким логином уже зарегистрирован"); } if (FormRegUser.Captcha != (string)Session[CaptchaImage.CaptchaValueKey]) { ModelState.AddModelError("Captcha", "Текст с картинки введён не верно"); return View(FormRegUser); } if (ModelState.IsValid == true) { MemoryStream memory = new MemoryStream(); if (Avatar == null) { Bitmap avatar = new Bitmap(Server.MapPath("~/Content/Avatars/default_avatar.gif")); avatar.Save(memory, ImageFormat.Gif); } else { string fileName = System.IO.Path.GetFileName(Avatar.FileName); Avatar.SaveAs(Server.MapPath("~/Content/Avatars/" + fileName)); Avatar.InputStream.CopyTo(memory); } Users UserToSave = new Users(); UserToSave.Name = FormRegUser.Name; UserToSave.Sirname = FormRegUser.Sirname; UserToSave.Patername = FormRegUser.Patername; UserToSave.Password = FormRegUser.Password; UserToSave.RoleId = FormRegUser.RoleId; UserToSave.Group = FormRegUser.Group; UserToSave.Login = FormRegUser.Login; UserToSave.Course = FormRegUser.Course; UserToSave.Email = FormRegUser.Email; UserToSave.Avatar = memory.GetBuffer(); UserToSave.Birthday = FormRegUser.Birthday; dc.Users.Add(UserToSave); dc.SaveChanges(); ModelState.Clear(); FormRegUser = null; ViewBag.Message = "Регистрация прошла успешно"; } } return View(FormRegUser); }
public ActionResult AddMiss(AddMiss getMiss) { if(ModelState.IsValid == true) { DiplomEntities5 dc = new DiplomEntities5(); Missings newRow = new Missings(); newRow.StudentId = getMiss.StudentId; newRow.Form = getMiss.Form; newRow.Discipline = getMiss.Discipline; newRow.IsRead = getMiss.IsRead; newRow.IsValid = getMiss.IsValid; newRow.Date = getMiss.Date; dc.Missings.Add(newRow); dc.SaveChanges(); ViewBag.Message = "Запись добавлена"; getMiss = null; } return View(getMiss); }
public ActionResult DeleteMiss() { int Id = Convert.ToInt32(Request["id"]); DiplomEntities5 dc = new DiplomEntities5(); Missings RowToDel = dc.Missings.Where(a => a.Id.Equals(Id)).FirstOrDefault(); dc.Missings.Remove(RowToDel); dc.SaveChanges(); return View("MissForPraepostor"); }
public ActionResult EditNews(List<News> getChanges) { DiplomEntities5 dc = new DiplomEntities5(); foreach(News item in getChanges) { var DbItem = dc.News.Where(a => a.Id.Equals(item.Id)).FirstOrDefault(); if(DbItem != item) { DbItem.Title = item.Title; DbItem.Content = item.Content; DbItem.Date = item.Date; dc.SaveChanges(); } } string mess = "Изменения успешно сохранены"; return Redirect("~/Profile/Methodist?Message=" + mess); }
public ActionResult EditMiss(List<Missings> getChanges) { DiplomEntities5 dc = new DiplomEntities5(); foreach (Missings miss in getChanges) { var DbMiss = dc.Missings.Where(a => a.Id.Equals(miss.Id)).FirstOrDefault(); if (!DbMiss.IsValid.Equals(miss.IsValid)) { DbMiss.IsValid = miss.IsValid; } } ViewBag.Message = "Изменения успешно сохранены"; dc.SaveChanges(); List<Missings> MissingDb = new List<Missings>(); foreach (HtmlInputs.Models.Missings item in dc.Missings.OrderByDescending(a => a.Id)) { if (item.Users.Group.ToString().Equals(Session["LogedUserGroup"].ToString()) && item.Users.Course.ToString().Equals(Session["LogedUserCourse"].ToString())) { MissingDb.Add(item); } } return View(MissingDb); }
public ActionResult AddChanges(Changes getChanges) { DiplomEntities5 dc = new DiplomEntities5(); List<Changes> RecordSet = new List<Changes>(); foreach(Users item in dc.Users) { if(item.RoleId == 1 || item.RoleId == 2 || item.RoleId == 4) { var obj = new Changes(); obj.UserId = item.UserId; if(item.RoleId != 4) { obj.isRead = 0; } else { obj.isRead = 1; } obj.Date = DateTime.Now; obj.Content = getChanges.Content; RecordSet.Add(obj); } } foreach(Changes item in RecordSet) { dc.Changes.Add(item); dc.SaveChanges(); } getChanges = null; ViewBag.Message = "Изменение успешно опубликовано"; return View(getChanges); }
public ActionResult Register(RegUser FormRegUser, HttpPostedFileBase Avatar) { using (DiplomEntities5 dc = new DiplomEntities5()) { var anyUserEmail = dc.Users.Any(a => a.Email.Equals(FormRegUser.Email)); if (anyUserEmail) { ModelState.AddModelError("Email", "Пользователь с таким email уже зарегистрирован"); } var anyUserLogin = dc.Users.Any(a => a.Login.Equals(FormRegUser.Login)); if (anyUserLogin) { ModelState.AddModelError("Login", "Пользователь с таким логином уже зарегистрирован"); } if (FormRegUser.Captcha != (string)Session[CaptchaImage.CaptchaValueKey]) { ModelState.AddModelError("Captcha", "Текст с картинки введён не верно"); return View(FormRegUser); } DateTime now = DateTime.Now; int RegUserCourse = now.Year - (Convert.ToInt32(FormRegUser.Login.ToString().Substring(0, 2)) + 2000); foreach (Users student in dc.Users) { int yearFromLogin = Convert.ToInt32(student.Login.ToString().Substring(0, 2)); if ((yearFromLogin != RegUserCourse) && (FormRegUser.Course == student.Course)) { ModelState.AddModelError("Login", "Ошибка системы. Для решения проблемы обратитесь к методисту"); return View(FormRegUser); } } if(ModelState.IsValid == true) { MemoryStream memory = new MemoryStream(); if (Avatar == null) { Bitmap avatar = new Bitmap(Server.MapPath("~/Content/Avatars/default_avatar.gif")); avatar.Save(memory, ImageFormat.Gif); } else { string fileName = System.IO.Path.GetFileName(Avatar.FileName); Avatar.SaveAs(Server.MapPath("~/Content/Avatars/" + fileName)); Avatar.InputStream.CopyTo(memory); } Users UserToSave = new Users(); UserToSave.Name = FormRegUser.Name; UserToSave.Sirname = FormRegUser.Sirname; UserToSave.Patername = FormRegUser.Patername; UserToSave.Password = FormRegUser.Password; UserToSave.RoleId = FormRegUser.RoleId; UserToSave.Group = FormRegUser.Group; UserToSave.Login = FormRegUser.Login; UserToSave.Course = FormRegUser.Course; UserToSave.Email = FormRegUser.Email; UserToSave.Avatar = memory.GetBuffer(); UserToSave.Birthday = FormRegUser.Birthday; dc.Users.Add(UserToSave); dc.SaveChanges(); ModelState.Clear(); FormRegUser = null; ViewBag.Message = "Регистрация прошла успешно"; } } return View(FormRegUser); }