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