// Subject specialities list.
public async Task <ActionResult> SubjectSpecialities(int?id)
{
// Check id.
if (!int.TryParse(id.ToString(), out int intId))
{
return(RedirectToAction("Index"));
}
// Get SubjectDTO.
SubjectDTO subjectDTO = await SubjectService.GetAsync(intId);
if (subjectDTO == null)
{
return(RedirectToAction("Index"));
}
// Set ViewBag properties.
ViewBag.ParentId = intId;
ViewBag.SubjectName = subjectDTO.SubjectName;
// AutoMapper Setup.
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <SpecialityDTO, SpecialityViewModel>()
.ForMember("Id", opt => opt.MapFrom(obj => obj.SpecialityId))
.ForMember("Name", opt => opt.MapFrom(obj => obj.SpecialityName));
});
IMapper iMapper = config.CreateMapper();
List <SpecialityDTO> source = SpecialityService.Find(dto => dto.SubjectId == intId).OrderBy(o => o.SpecialityName).OrderBy(o => o.IsApproved).ToList();
IEnumerable <SpecialityViewModel> specialityOrderedList = iMapper.Map <IEnumerable <SpecialityDTO>, IEnumerable <SpecialityViewModel> >(source);
return(View(specialityOrderedList));
}
static int SpecialScript0()
{
var teacher = TeacherService.Read(new Teacher()
{
Name = "Random Teacher", PassportData = 555190
}, 1, 0).First();
var speciality = SpecialityService.Read(new Speciality()
{
Name = "Random Speciality"
}, 1, 0).First();
DateTime startTime = DateTime.Now;
Timetable model = new Timetable()
{
TeacherId = teacher.Id, SpecialityId = speciality.Id
};
var models = TimetableService.Read(model);
foreach (var timetable in models)
{
Console.WriteLine("{0}: {1} {2} {3} {4}", timetable.Id, timetable.ExamDate.Value.ToString("dd.MM.yyyy"), timetable.Lesson, timetable.TeacherId, timetable.SpecialityId);
}
DateTime finishTime = DateTime.Now;
return((int)(finishTime - startTime).TotalMilliseconds);
}
// Delete a speciality.
public async Task <ActionResult> DeleteSpeciality(int?id)
{
// Check id.
if (!int.TryParse(id.ToString(), out int intId))
{
return(RedirectToAction("Index"));
}
// Get SpecialityDTO object.
SpecialityDTO specialityDTO = await SpecialityService.GetAsync(intId);
if (specialityDTO == null)
{
return(RedirectToAction("Index"));
}
ViewBag.SubjectName = specialityDTO.Subject.SubjectName;
ViewBag.ParentId = specialityDTO.SubjectId;
// AutoMapper Setup.
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <SpecialityDTO, SpecialityViewModel>()
.ForMember("Id", opt => opt.MapFrom(obj => obj.SpecialityId))
.ForMember("Name", opt => opt.MapFrom(obj => obj.SpecialityName));
});
IMapper iMapper = config.CreateMapper();
SpecialityViewModel speciality = iMapper.Map <SpecialityDTO, SpecialityViewModel>(specialityDTO);
return(PartialView("~/Views/Admin/Speciality/DeleteSpeciality.cshtml", speciality));
}
public async Task <ActionResult> CreateSpeciality(SpecialityViewModel speciality)
{
string currentUserId = System.Web.HttpContext.Current.User.Identity.GetUserId();
if (currentUserId == null)
{
return(new HttpUnauthorizedResult());
}
ViewBag.SubjectName = (await SubjectService.GetAsync(speciality.SubjectId)).SubjectName;
ViewBag.ParentId = speciality.SubjectId;
ViewBag.Action = "SubjectSpecialities";
if (ModelState.IsValid)
{
SpecialityDTO specialityDTO = new SpecialityDTO
{
SubjectId = speciality.SubjectId,
SpecialityName = speciality.Name,
Description = speciality.Description,
IsApproved = speciality.IsApproved
};
OperationDetails operationDetails = await SpecialityService.CreateAsync(specialityDTO, currentUserId);
if (operationDetails.Succedeed)
{
return(PartialView("Report", operationDetails));
}
else
{
ModelState.AddModelError(operationDetails.Property, operationDetails.Message);
return(PartialView("Report", operationDetails));
}
}
ViewBag.Message = "Non valid";
return(PartialView("~/Views/Admin/Speciality/CreateSpeciality.cshtml", speciality));
}
private void SearchSpeciality(int code, string value)
{
if (code == 13 && cmBox_search.SelectedIndex == 0 && value != "" && EntitiesIndex == 3)
{
var specialityService = new SpecialityService(_unit, _unit);
var speciality = specialityService.GetSpecialityById(Convert.ToInt32(_tBox_searchValue));
specialityGV.DataSource = new List <Speciality>()
{
speciality
};
}
if (code == 13 && cmBox_search.SelectedIndex == 1 && value != "")
{
var specialityService = new SpecialityService(_unit, _unit);
var speciality = specialityService.GetSpecialitiesByName(_tBox_searchValue);
specialityGV.DataSource = speciality.ToList();
}
if (code == 13 && cmBox_search.SelectedIndex == 2 && value != "")
{
var specialityService = new SpecialityService(_unit, _unit);
var formEducationService = new FormEducationService(_unit, _unit);
var formEducation = formEducationService.GetFormEducationByName(_tBox_searchValue);
var speciality = specialityService.GetSpecialitiesByFormEducation(formEducation.Id);
specialityGV.DataSource = speciality.ToList();
}
}
public async Task <ActionResult> DeleteSpeciality(int id)
{
string currentUserId = System.Web.HttpContext.Current.User.Identity.GetUserId();
if (currentUserId == null)
{
return(new HttpUnauthorizedResult());
}
SpecialityDTO specialityDTO = await SpecialityService.GetAsync(id);
ViewBag.SubjectName = specialityDTO.Subject.SubjectName;
ViewBag.ParentId = specialityDTO.SubjectId;
ViewBag.Action = "SubjectSpecialities";
if (specialityDTO != null)
{
OperationDetails operationDetails = await SpecialityService.DeleteAsync(id, currentUserId);
if (operationDetails.Succedeed)
{
return(PartialView("Report", operationDetails));
}
else
{
ModelState.AddModelError(operationDetails.Property, operationDetails.Message);
return(PartialView("Report", operationDetails));
}
}
ViewBag.Message = "Non valid";
return(PartialView("~/Views/Admin/Speciality/DeleteSpeciality.cshtml", specialityDTO));
}
private void GetSpecialityFromDb()
{
var specialityService = new SpecialityService(_unit, _unit);
var speciality = specialityService.GetAllSpeciality();
cmBox_speciality.DataSource = speciality.ToList();
}
public async Task <ActionResult> CreateCourse(int?specialityId)
{
try
{
// I. Checks.
// Check id.
if (!int.TryParse(specialityId.ToString(), out int intSpecialityId))
{
return(RedirectToAction("Index"));
}
// Get a SpecialityDTO object.
SpecialityDTO speciality = await SpecialityService.GetAsync(intSpecialityId);
if (speciality == null)
{
return(RedirectToAction("Index"));
}
// II. Set ViewBag properties.
ViewBag.ParentId = intSpecialityId;
ViewBag.SpecialityName = speciality.SpecialityName;
// III.
return(PartialView());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
static int UpdateScript2()
{
var teacher = TeacherService.Read(new Teacher()
{
Name = "Random Teacher", PassportData = 555190
}, 1, 0).First();
var speciality = SpecialityService.Read(new Speciality()
{
Name = "Random Speciality"
}, 1, 0).First();
// Предполагается, что действия до создания модели - это моделирование выбора пользователя
var models = TimetableService.Read(new Timetable()
{
TeacherId = teacher.Id, SpecialityId = speciality.Id
});
DateTime startTime = DateTime.Now;
foreach (var model in models)
{
model.ClassroomId = 1;
TimetableService.Update(model);
}
DateTime finishTime = DateTime.Now;
return((int)(finishTime - startTime).TotalMilliseconds);
}
static int AddScript2()
{
var teacher = TeacherService.Read(new Teacher()
{
Name = "Random Teacher", PassportData = 456278
}, 1, 0).First();
var speciality = SpecialityService.Read(new Speciality()
{
Name = "Random Speciality"
}, 1, 0).First();
Timetable[] models = new Timetable[30];
for (int i = 0; i < models.Length; i++)
{
models[i] =
new Timetable()
{
Lesson = 5,
ExamDate = DateTime.Now.AddDays(i),
TeacherId = teacher.Id,
SpecialityId = speciality.Id,
ClassroomId = 5,
DisciplineId = 5
};
}
DateTime startTime = DateTime.Now;
foreach (var model in models)
{
TimetableService.Create(model);
}
DateTime finishTime = DateTime.Now;
return((int)(finishTime - startTime).TotalMilliseconds);
}
private void DeleteSpeciality(object sender, EventArgs e)
{
var specialityService = new SpecialityService(_unit, _unit);
specialityService.RemoveSpeciality((Speciality)specialityGV.CurrentRow.DataBoundItem);
_unit.Commit();
_unit = new UnitOfWork(_context);
this.SearchSpeciality(13, _tBox_searchValue);
}
// Subject specialities list.
public async Task <ActionResult> SubjectSpecialities(int?id)
{
try
{
// I. Checks.
// Get Id for the current user.
string currentUserId = System.Web.HttpContext.Current.User.Identity.GetUserId();
if (currentUserId == null)
{
return(RedirectToAction("Login", "Account"));
}
// Check id.
if (!int.TryParse(id.ToString(), out int intId))
{
return(RedirectToAction("Index"));
}
// Get SubjectDTO.
SubjectDTO subjectDTO = await SubjectService.GetAsync(intId);
if (subjectDTO == null)
{
return(RedirectToAction("Index"));
}
// II. Set ViewBag properties.
PLRepository.SetViewBagProperiesForModeratorSubscription(UserService, currentUserId,
SubscriptionForModeratorService,
out bool?viewBagIsAllowedToSuggest,
out bool?viewBagGoToTrialSubscription,
out bool?viewBagGoToSubscription);
ViewBag.IsAllowedToSuggest = viewBagIsAllowedToSuggest;
ViewBag.GoToTrialSubscription = viewBagGoToTrialSubscription;
ViewBag.GoToSubscription = viewBagGoToSubscription;
ViewBag.ParentId = intId;
ViewBag.SubjectName = subjectDTO.SubjectName;
// III. AutoMapper Setup.
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <SpecialityDTO, SpecialityViewModel>()
.ForMember("Id", opt => opt.MapFrom(obj => obj.SpecialityId))
.ForMember("Name", opt => opt.MapFrom(obj => obj.SpecialityName));
});
IMapper iMapper = config.CreateMapper();
// IV. Get data for a view.
List <SpecialityDTO> source = SpecialityService.Find(dto => dto.SubjectId == intId && dto.IsApproved).OrderBy(o => o.SpecialityName).ToList();
IEnumerable <SpecialityViewModel> specialityOrderedList = iMapper.Map <IEnumerable <SpecialityDTO>, IEnumerable <SpecialityViewModel> >(source);
// V.
return(View(specialityOrderedList));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void btn_add_Click(object sender, EventArgs e)
{
var specialityService = new SpecialityService(_unit, _unit);
var speciality = specialityService.CreateSpeciality(NameText, TermNumberText, (FormEducation)comboBox1.SelectedItem);
_unit.Commit();
_context.Dispose();
this.Close();
}
public async Task <ActionResult> CreateCourse(CourseViewModel course)
{
try
{
// I. Checks.
string currentUserId = System.Web.HttpContext.Current.User.Identity.GetUserId();
if (currentUserId == null)
{
return(new HttpUnauthorizedResult());
}
// II. Set ViewBag properties.
ViewBag.SpecialityName = (await SpecialityService.GetAsync(course.SpecialityId)).SpecialityName;
ViewBag.ParentId = course.SpecialityId;
ViewBag.Action = "SpecialityCourses";
// III. Create a new course.
if (ModelState.IsValid)
{
CourseDTO courseDTO = new CourseDTO
{
UserProfileId = currentUserId,
SpecialityId = course.SpecialityId,
CourseTitle = course.Name,
Description = course.Description,
CourseTestQuestionsNumber = course.CourseTestQuestionsNumber,
TopicTestQuestionsNumber = course.TopicTestQuestionsNumber,
TimeToAnswerOneQuestion = course.TimeToAnswerOneQuestion,
AttemptsNumber = course.AttemptsNumber,
PassingScore = course.PassingScore,
IsApproved = course.IsApproved,
IsFree = course.IsFree
};
OperationDetails operationDetails = await CourseService.CreateAsync(courseDTO, currentUserId);
if (operationDetails.Succedeed)
{
return(PartialView("Report", operationDetails));
}
else
{
ModelState.AddModelError(operationDetails.Property, operationDetails.Message);
return(PartialView("Report", operationDetails));
}
}
// IV.
ViewBag.Message = "Non valid";
return(PartialView(course));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void GetAllDataFromDb()
{
var specialityService = new SpecialityService(_unit, _unit);
var speciality = specialityService.GetSpecialityById(_entityId);
IdText = speciality.Id.ToString();
NameText = speciality.Name;
TermNumberText = speciality.TermNumber;
this.GetFormEducationFromDb();
comboBox1.Text = speciality.FormEducation.Name;
}
public async Task <List <SpecialityInfoDto> > GetAllSpecialitys(string departmentId)
{
using (IDAL.ISpecialityService specialityService = new SpecialityService())
{
return(await specialityService.GetAllAsync().Where(m => m.DepartmentId == departmentId).Select(m => new Dto.SpecialityInfoDto()
{
SpecialityId = m.SpecialityId,
SpecialityName = m.SpecialityName
}).ToListAsync());
}
}
/// <summary>
/// Метод инициализации сервисов данных
/// </summary>
private void InitializeDataAccessServices()
{
// Получение строки подключения
logger.Info("Получение строки подключения к источнику данных.");
string connectionString = ConfigurationManager.ConnectionStrings["EnrolleeContext"].ConnectionString;
// Инициализации сервисов данных
logger.Info("Инициализация сервисов получения данных.");
facultyService = new FacultyService(connectionString);
formOfStudyService = new FormOfStudyService(connectionString);
specialityService = new SpecialityService(connectionString);
}
private void btn_update_Click(object sender, EventArgs e)
{
var specialityService = new SpecialityService(_unit, _unit);
var speciality = specialityService.GetSpecialityById(_entityId);
speciality.Name = NameText;
speciality.TermNumber = TermNumberText;
specialityService.SetFormEducationOfSpeciality((FormEducation)comboBox1.SelectedItem, speciality);
specialityService.UpdateSpeciality(speciality);
_unit.Commit();
_context.Dispose();
this.Close();
}
static int AddScript1()
{
Speciality model = new Speciality()
{
Name = "Random Speciality"
};
DateTime startTime = DateTime.Now;
SpecialityService.Create(model);
DateTime finishTime = DateTime.Now;
return((int)(finishTime - startTime).TotalMilliseconds);
}
static int ReadScript0()
{
Speciality model = new Speciality()
{
Name = "Random Speciality"
};
DateTime startTime = DateTime.Now;
Speciality mod = SpecialityService.Read(model, 1, 0).First();
DateTime finishTime = DateTime.Now;
Console.WriteLine("{0}: {1}", mod.Id, mod.Name);
return((int)(finishTime - startTime).TotalMilliseconds);
}
/// <summary>
/// Метод инициализации сервисов доступа к данным
/// </summary>
private void InitializeDataAccessServices()
{
// Получение строки подключения
logger.Info($"Получаем строку подключения к источнику данных");
connectionString = ConfigurationManager.ConnectionStrings["EnrolleeContext"].ConnectionString;
// Инициализация сервисов получения данных
logger.Info($"Инициализация сервисов получения данных");
facultyService = new FacultyService(connectionString);
formOfStudyService = new FormOfStudyService(connectionString);
specialityService = new SpecialityService(connectionString);
priorityOfSpecialityService = new PriorityOfSpecialityService(connectionString);
decreeService = new DecreeService(connectionString);
enrolleeService = new EnrolleeService(connectionString);
viewService = new ViewService(connectionString);
}
public async Task <ActionResult> SuggestSpeciality(SpecialityViewModel speciality)
{
try
{
// I. Checks.
string currentUserId = System.Web.HttpContext.Current.User.Identity.GetUserId();
if (currentUserId == null)
{
return(new HttpUnauthorizedResult());
}
// II. Set ViewBag properties.
ViewBag.SubjectName = (await SubjectService.GetAsync(speciality.SubjectId)).SubjectName;
ViewBag.ParentId = speciality.SubjectId;
ViewBag.Action = "SubjectSpecialities";
// III. Create a new speciality.
if (ModelState.IsValid)
{
SpecialityDTO specialityDTO = new SpecialityDTO
{
SubjectId = speciality.SubjectId,
SpecialityName = speciality.Name,
Description = speciality.Description,
IsApproved = false
};
OperationDetails operationDetails = await SpecialityService.CreateAsync(specialityDTO, currentUserId);
if (operationDetails.Succedeed)
{
return(PartialView("Report", operationDetails));
}
else
{
ModelState.AddModelError(operationDetails.Property, operationDetails.Message);
return(PartialView("Report", operationDetails));
}
}
// IV.
ViewBag.Message = "Non valid";
return(PartialView(speciality));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// Инициализация сервисов доступа данных
/// </summary>
private void InitializeDataAccessServices()
{
// Инициализация строки подключения данных
logger.Info($"Получение строки подключения к источнику данных");
string connectionString = ConfigurationManager.ConnectionStrings["EnrolleeContext"].ConnectionString;
// Инициализация сервисов доступа данных
assessmentService = new AssessmentService(connectionString);
enrolleeService = new EnrolleeService(connectionString);
examSchemaService = new ExamSchemaService(connectionString);
disciplineService = new DisciplineService(connectionString);
facultyService = new FacultyService(connectionString);
formOfStudyService = new FormOfStudyService(connectionString);
specialityService = new SpecialityService(connectionString);
viewService = new ViewService(connectionString);
}
// Create a course.
public async Task <ActionResult> CreateCourse(int?specialityId)
{
// Check id.
if (!int.TryParse(specialityId.ToString(), out int intId))
{
return(RedirectToAction("Index"));
}
// Get SpecialityDTO object.
SpecialityDTO speciality = await SpecialityService.GetAsync(intId);
if (speciality == null)
{
return(RedirectToAction("Index"));
}
ViewBag.ParentId = intId;
ViewBag.SpecialityName = speciality.SpecialityName;
return(PartialView("~/Views/Admin/Course/CreateCourse.cshtml"));
}
static int UpdateScript1()
{
Speciality speciality = SpecialityService.Read(new Speciality()
{
Name = "Random Speciality"
}, 1, 0).First();
Timetable mod = new Timetable()
{
Id = speciality.Id, Lesson = 6
};
DateTime startTime = DateTime.Now;
TimetableService.Update(mod);
DateTime finishTime = DateTime.Now;
return((int)(finishTime - startTime).TotalMilliseconds);
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.
Columns[e.ColumnIndex].
HeaderText.
ToLower() == "delete")
{
if (MessageBox.Show
("Are you sure you want to delete this record?",
"Confirm",
MessageBoxButtons.YesNo)
== DialogResult.Yes)
{
int specialityId = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value);
ISpecialityService specialityService = new SpecialityService();
specialityService.DeleteSpeciality(specialityId);
this.specialityTableAdapter.Fill(this.finalAppWebDataSet.speciality);
}
}
}
// Speciality courses list.
public async Task <ActionResult> SpecialityCourses(int?id)
{
// I. Checks.
// Check id.
if (!int.TryParse(id.ToString(), out int intId))
{
return(RedirectToAction("Index"));
}
// Get SpecialityDTO object.
SpecialityDTO specialityDTO = await SpecialityService.GetAsync(intId);
if (specialityDTO == null)
{
return(RedirectToAction("Index"));
}
// II. Set ViewBag properties and Session[ParentParentIdForAdminController].
ViewBag.ParentId = intId;
ViewBag.SpecialityName = specialityDTO.SpecialityName;
ViewBag.ParentParentId = specialityDTO.SubjectId;
// Set Session[ParentParentIdForAdminController].
Session["ParentParentIdForAdminController"] = intId;
// III. Get data for a view.
// AutoMapper Setup.
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <CourseDTO, CourseViewModel>()
.ForMember("Id", opt => opt.MapFrom(obj => obj.CourseId))
.ForMember("Name", opt => opt.MapFrom(obj => obj.CourseTitle));
});
IMapper iMapper = config.CreateMapper();
List <CourseDTO> source = CourseService.Find(dto => dto.SpecialityId == intId)
.OrderBy(o => o.CourseTitle)
.OrderBy(o => o.IsApproved).ToList();
IEnumerable <CourseViewModel> courseOrderedList = iMapper.Map <IEnumerable <CourseDTO>, IEnumerable <CourseViewModel> >(source);
return(View(courseOrderedList));
}
private void btnAdd_Click(object sender, EventArgs e)
{
ISpecialityService specialityService = new SpecialityService();
String description = txtSpeciality.Text.ToString().Trim();
speciality objSpeciality = new speciality();
objSpeciality.description = description;
if (description.Length == 0)
{
MessageBox.Show("Type an speciality");
}
else if (specialityService.GetSpecialityByDescription(description) != null)
{
MessageBox.Show("This speciality is already saved. Try another");
}
else
{
specialityService.CreateSpeciality(objSpeciality);
MessageBox.Show("Speciality saved");
}
this.specialityTableAdapter.Fill(this.finalAppWebDataSet.speciality);
}
static int ReadScript1()
{
Speciality speciality = SpecialityService.Read(new Speciality()
{
Name = "Random Speciality"
}, 1, 0).First();
// Предполагается, что действия до создания модели - это моделирование выбора пользователя
Timetable time = new Timetable()
{
SpecialityId = speciality.Id
};
DateTime startTime = DateTime.Now;
Timetable model = TimetableService.Read(time, 1, 0).First();
var count = DB.Timetables.Count(t => model.SpecialityId == speciality.Id);
DateTime finishTime = DateTime.Now;
Console.WriteLine("{0}: {1}", model.SpecialityId, count);
return((int)(finishTime - startTime).TotalMilliseconds);
}
private void AdditionalForSpeciality(object sender, EventArgs e)
{
if (specialityGV.CurrentRow != null)
{
var speciality = (Speciality)specialityGV.CurrentRow.DataBoundItem;
var form = new Form4(1, speciality.Id, 3, this);
form.ShowDialog();
if (DeccisionIndex == 0)
{
var form1 = new Form11(speciality);
form1.ShowDialog();
}
if (DeccisionIndex == 1)
{
this.groupAGV.Visible = true;
this.specialityAGV.Visible = false;
this.groupAGV.DataSource = speciality.Groups.ToList();
}
}
else
{
var form = new Form4(2, 0, 3, this);
form.ShowDialog();
var specialityService = new SpecialityService(_unit, _unit);
if (DeccisionIndex == 0)
{
this.specialityAGV.Visible = true;
var allSpeciality = specialityService.GetAllSpeciality();
specialityAGV.DataSource = allSpeciality.ToList();
}
if (DeccisionIndex == 1)
{
MessageBox.Show(@"dsgsdgs");
}
}
DeccisionIndex = -1;
}
