public ActionResult EditNews() { DiplomEntities5 dc = new DiplomEntities5(); List<News> ListNews = new List<News>(); ListNews = dc.News.OrderByDescending(a => a.Id).ToList(); return View(ListNews); }
// // GET: /Profile/ public ActionResult Index() { if(Session["LogedUserRole"].ToString().Equals("4")) { return RedirectPermanent("~/Profile/Methodist"); } DiplomEntities5 dc = new DiplomEntities5(); ViewBag.news = dc.News.OrderByDescending(a => a.Id); return View(); }
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 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 ShowAvatar() { DiplomEntities5 dc = new DiplomEntities5(); int Login; if(Request["id"] != null) { Login = Convert.ToInt32(Request["id"]); } else { Login = Convert.ToInt32(Session["LogedUserId"]); } var v = dc.Users.Where(a => a.UserId.Equals(Login)).FirstOrDefault(); byte[] AvatarBytes = v.Avatar; Stream mc = new MemoryStream(AvatarBytes); Image avka = Image.FromStream(mc); avka.Save(this.Response.OutputStream, ImageFormat.Jpeg); avka.Dispose(); return null; }
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 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 FileContentResult getWeekStatistics(int isStudent = 0, int isDean = 0) { DiplomEntities5 dc = new DiplomEntities5(); DateTime[] weeks = new DateTime[52]; int isSaved = 0; int numWeeks = 0; foreach (HtmlInputs.Models.Missings item in dc.Missings.OrderByDescending(a => a.Id)) //Разбиваем записи таблицы на недели. В массив записываем дату понедельника { if (isStudent == 0 && isDean == 0) { if (item.Users.Group.ToString() != Session["LogedUserGroup"].ToString() || item.Users.Course.ToString() != Session["LogedUserCourse"].ToString()) { continue; } } else if(isDean == 1 && isStudent == 0) { if (item.Users.Group.ToString() != Session["NumGroup"].ToString() || item.Users.Course.ToString() != Session["NumCourse"].ToString()) { continue; } } else if(isStudent == 1 && isDean == 0) { int student = Convert.ToInt32(Session["LogedUserId"]); if (item.Users.Group.ToString() != Session["LogedUserGroup"].ToString() || item.Users.Course.ToString() != Session["LogedUserCourse"].ToString() || item.Users.UserId != student) { continue; } } DateTime temp; temp = item.Date; while(temp.DayOfWeek != System.DayOfWeek.Monday) { temp = temp.AddDays(-1); } foreach (DateTime savedWeeks in weeks) { if (savedWeeks == temp) { isSaved = 1; break; } } if (isSaved == 0) { weeks[numWeeks++] = temp; } else { isSaved = 0; } } int[] IsValidGroupMiss = new int[50]; //Массив определяет количество недель, ключ - ИД стдуента, значение - кол-во пропусков int[] IsNotValidGroupMiss = new int[50]; List<DateTime> ListWeeks = new List<DateTime>(); int group; int course; int StudentId = 0; if(Session["LogedUserGroup"].ToString().Equals("0") && Session["LogedUserCourse"].ToString().Equals("0")) { group = Convert.ToInt32(Session["NumGroup"]); course = Convert.ToInt32(Session["NumCourse"]); } else { group = Convert.ToInt32(Session["LogedUserGroup"]); course = Convert.ToInt32(Session["LogedUserCourse"]); } if(isStudent == 1) { StudentId = Convert.ToInt32(Session["LogedUserId"]); } foreach (HtmlInputs.Models.Missings item in dc.Missings) { if (item.Users.Course.Equals(course) && item.Users.Group.Equals(group)) { if (isStudent == 1 && item.Users.UserId != StudentId) { continue; } DateTime recWeek = item.Date; while(recWeek.DayOfWeek != System.DayOfWeek.Monday) { recWeek = recWeek.AddDays(-1); } for (int i = 0; i < numWeeks; i++) { if (recWeek == weeks[i]) { if (item.IsValid == 1) { IsValidGroupMiss[i] += 2; break; } else { IsNotValidGroupMiss[i] += 2; break; } } } } } for (int i = 0; i < numWeeks; i++) { ListWeeks.Add(weeks[i]); } FileContentResult chart = CreateChart(IsValidGroupMiss, IsNotValidGroupMiss, ListWeeks); return chart; }
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 ChangesForMethodist() { DiplomEntities5 dc = new DiplomEntities5(); ViewBag.chan = dc.Changes.OrderByDescending(a => a.Id); return View(); }
public ActionResult ExportToWord() { DiplomEntities5 dc = new DiplomEntities5(); var MissLim = dc.Utility.Where(a => a.Id.Equals(1)).FirstOrDefault(); int numMonth = Convert.ToInt32(Request.QueryString["month"]); Dictionary<int, int> StudentsIsValidMiss = new Dictionary<int, int>(); //Массив определяет количество недель, ключ - ИД стдуента, значение - кол-во пропусков Dictionary<int, int> StudentsIsNotValidMiss = new Dictionary<int, int>(); foreach (Users user in dc.Users.OrderBy(a => a.Sirname)) { var student = dc.Missings.Where(a => a.StudentId.Equals(user.UserId)).FirstOrDefault(); //Ищем студента, у которого есть пропуски if (student != null) { if (student.Users.Group.ToString() != Session["NumGroup"].ToString() || student.Users.Course.ToString() != Session["NumCourse"].ToString()) { continue; } StudentsIsValidMiss.Add(user.UserId, 0); StudentsIsNotValidMiss.Add(user.UserId, 0); } } foreach (HtmlInputs.Models.Missings item in dc.Missings) { if (item.Users.Group.ToString() != Session["NumGroup"].ToString() || item.Users.Course.ToString() != Session["NumCourse"].ToString()) { continue; } int recMonth = item.Date.Month; if (recMonth == numMonth) { if (item.IsValid == 1) { StudentsIsValidMiss[item.StudentId] += 2; break; } else { StudentsIsNotValidMiss[item.StudentId] += 2; break; } } } Table data = new Table(); int numRow = 1; foreach (Users user in dc.Users) { int num = 0; if (StudentsIsNotValidMiss.TryGetValue(user.UserId, out num)) { if (num == 0 && StudentsIsValidMiss[user.UserId] == 0) { continue; } TableRow tr = new TableRow(); TableCell number = new TableCell(); TableCell sirname = new TableCell(); TableCell name = new TableCell(); TableCell patername = new TableCell(); TableCell isValid = new TableCell(); TableCell isNotValid = new TableCell(); number.Controls.Add(new LiteralControl(numRow.ToString())); sirname.Controls.Add(new LiteralControl(user.Sirname)); name.Controls.Add(new LiteralControl(user.Name)); patername.Controls.Add(new LiteralControl(user.Patername)); isValid.Controls.Add(new LiteralControl(StudentsIsValidMiss[user.UserId].ToString())); isNotValid.Controls.Add(new LiteralControl(StudentsIsNotValidMiss[user.UserId].ToString())); tr.Cells.Add(number); tr.Cells.Add(sirname); tr.Cells.Add(name); tr.Cells.Add(patername); tr.Cells.Add(isValid); tr.Cells.Add(isNotValid); data.Rows.Add(tr); } } // get the data from database // instantiate the GridView control from System.Web.UI.WebControls namespace // set the data source GridView gridview = new GridView(); gridview.DataSource = data; gridview.DataBind(); // Clear all the content from the current response Response.ClearContent(); Response.Buffer = true; // set the header Response.AddHeader("content-disposition", "attachment;filename=\"itfunda.doc\""); Response.ContentType = "application/ms-word"; Response.Charset = ""; // create HtmlTextWriter object with StringWriter using (StringWriter sw = new StringWriter()) { using (System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw)) { // render the GridView to the HtmlTextWriter gridview.RenderControl(htw); // Output the GridView content saved into StringWriter Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); } } return Redirect("MonthReportForZDean"); }
public ActionResult AddMiss() { List<SelectListItem> StudentList = new List<SelectListItem>(); List<SelectListItem> IsValidList = new List<SelectListItem>(); List<SelectListItem> listOfForms = new List<SelectListItem>(); List<SelectListItem> listOfDiss = new List<SelectListItem>(); var isValid = new SelectListItem { Text = "Есть", Value = "1" }; var isNotValid = new SelectListItem { Text = "Отсутствует", Value = "0" }; IsValidList.Add(isValid); IsValidList.Add(isNotValid); HtmlInputs.Models.DiplomEntities5 dc1 = new HtmlInputs.Models.DiplomEntities5(); int group = Convert.ToInt32(Session["LogedUserGroup"].ToString()); foreach (HtmlInputs.Models.Users item in dc1.Users.OrderBy(a => a.Sirname)) { if (item.Group.Equals(group) && item.RoleId.Equals(1)) { var newReceiver = new SelectListItem { Text = item.Sirname + " " + item.Name + " " + item.Patername, Value = item.UserId.ToString() }; StudentList.Add(newReceiver); } } var lecture = new SelectListItem { Text = "лекция", Value = "лекция" }; var seminar = new SelectListItem { Text = "семинар", Value = "семинар" }; var laboratory = new SelectListItem { Text = "лабораторная", Value = "лабораторная" }; listOfForms.Add(lecture); listOfForms.Add(seminar); listOfForms.Add(laboratory); foreach(Discipline item in dc1.Discipline) { var element = new SelectListItem { Text = item.FullName, Value = item.DisId.ToString() }; listOfDiss.Add(element); } ViewBag.ListOfStudent = StudentList; ViewBag.ValidList = IsValidList; ViewBag.ListOfForm = listOfForms; ViewBag.ListOfDis = listOfDiss; return View(); }
public List<Applications> GetAppOfGroup(int numGroup) { DiplomEntities5 dc = new DiplomEntities5(); int course = Convert.ToInt32(Session["CourseApp"]); var Group = dc.Applications.Where(a => a.Users.Group == numGroup && a.Users.Course == course).OrderByDescending(a => a.Id).ToList<Applications>(); return Group; }
public ActionResult EditMiss() { List<Missings> MissingDb = new List<Missings>(); DiplomEntities5 dc = new DiplomEntities5(); 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 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 MissForStudents() { DiplomEntities5 dc = new DiplomEntities5(); ViewBag.miss = dc.Missings; return View(); }
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 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 SearchForm() { DiplomEntities5 dc = new DiplomEntities5(); if (!Request["Form"].ToString().Equals("")) { string form = Request["Form"].ToString(); int group = Convert.ToInt32(Session["LogedUserGroup"]); int course = Convert.ToInt32(Session["LogedUserCourse"]); var Db = dc.Missings.Where(a => a.Form.Equals(form) && a.Users.Group.Equals(group) && a.Users.Course.Equals(course)).ToList(); return View("EditMiss", Db); } else { int group = Convert.ToInt32(Session["LogedUserGroup"]); int course = Convert.ToInt32(Session["LogedUserCourse"]); var Db = dc.Missings.Where(a => a.Users.Group.Equals(group) && a.Users.Course.Equals(course)).ToList(); return View("EditMiss", Db); } }
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 SearchDis() { DiplomEntities5 dc = new DiplomEntities5(); if (!Request["Dis"].ToString().Equals("")) { string dis = Request["Dis"].ToString(); int group = Convert.ToInt32(Session["LogedUserGroup"]); int course = Convert.ToInt32(Session["LogedUserCourse"]); var Db = dc.Missings.Where(a => a.Discipline1.ShortName.Equals(dis) && a.Users.Group.Equals(group) && a.Users.Course.Equals(course)).ToList(); return View("EditMiss", Db); } else { int group = Convert.ToInt32(Session["LogedUserGroup"]); int course = Convert.ToInt32(Session["LogedUserCourse"]); var Db = dc.Missings.Where(a => a.Users.Group.Equals(group) && a.Users.Course.Equals(course)).ToList(); return View("EditMiss", Db); } }
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 EditGroup() { List<Users> GroupDb = new List<Users>(); HtmlInputs.Models.DiplomEntities5 dc = new HtmlInputs.Models.DiplomEntities5(); foreach (HtmlInputs.Models.Users item in dc.Users.OrderBy(a => a.Sirname)) { if (item.Group.ToString().Equals(Session["NumGroup"].ToString()) && item.Course.ToString().Equals(Session["NumCourse"].ToString()) && item.RoleId != 3) { GroupDb.Add(item); } } return View("GroupListEdit",GroupDb); }
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 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 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 int NumAllowedApp() { DiplomEntities5 dc = new DiplomEntities5(); var AppLimit = dc.Utility.Where(a => a.Id.Equals(2)).FirstOrDefault().Limit; DateTime date = DateTime.Now; DateTime startWeek = date; DateTime endWeek = date; int numApp = 0; int AllowAmountApp = 0; while (startWeek.DayOfWeek != System.DayOfWeek.Monday) { startWeek = startWeek.AddDays(-1); } foreach (Applications item in dc.Applications) { DateTime temp = item.DateOfCreation; while (temp.DayOfWeek != System.DayOfWeek.Monday) { temp = temp.AddDays(-1); } if (temp.Date == startWeek.Date && item.Users.Group.Equals(Convert.ToInt32(Session["LogedUserGroup"])) && item.Users.Course.Equals(Convert.ToInt32(Session["LogedUserCourse"]))) { numApp++; } } AllowAmountApp = AppLimit - numApp; if (AllowAmountApp < 0) { return 0; } else { return AllowAmountApp; } }
public ActionResult WhoIsUserMiss() { DiplomEntities5 dc = new DiplomEntities5(); int SessionRole = Convert.ToInt32(Session["LogedUserRole"].ToString()); var userRole = dc.Roles.Where(a => a.RoleId.Equals(SessionRole)).FirstOrDefault(); switch(userRole.RoleId.ToString()) { case "1": return Redirect("~/Profile/MissForStudents"); case "2": return Redirect("~/Profile/MissForPraepostor"); case "3": return Redirect("~/Profile/MissForModerator"); case "4": return Redirect("~/Profile/MissForMethodist"); case "5": return Redirect("~/Profile/MissForZDean"); case "6": return Redirect("~/Profile/MissForZDean"); } return Redirect("~/Home/Index"); }
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"); }