private async void OnRemoveSpecialty()
{
var specialityStudents = await _sRepo.GetFilteredStudentsAsync(st =>
st.SpecialityId == SelectedSpeciality.SpecialtyId);
if (specialityStudents.Count > 0)
{
var result = MessageBox.Show(
"Вы точно хотите удалить специальность вместе с прикреплёнными студентами?",
"К этой специальности прикреплены студенты.",
MessageBoxButton.YesNo);
switch (result)
{
case MessageBoxResult.Yes:
break;
case MessageBoxResult.No:
return;
default:
return;
}
}
await _repo.DeleteSpecialtyWithStudentsAsync(SelectedSpeciality.SpecialtyId);
var specialty = Specialities.FirstOrDefault(s => s.SpecialtyId == SelectedSpeciality.SpecialtyId);
if (specialty != null)
{
Specialities.Remove(specialty);
}
}
public Student(
string firstName,
string middleName,
string lastName,
int ssnNum,
string permAdress,
string phoneNumber,
string email,
string course,
Specialities speciality,
Universities university,
Faculties faculty)
{
this.FirstName = firstName;
this.MiddleName = middleName;
this.LastName = lastName;
this.SSN = ssnNum;
this.PermanentAdress = permAdress;
this.PhoneNumber = phoneNumber;
this.Email = email;
this.Course = course;
this.Speciality = speciality;
this.University = university;
this.Faculty = faculty;
}
public ActionResult DeleteConfirmed(int id)
{
Specialities specialities = db.Specialities.Find(id);
db.Specialities.Remove(specialities);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void SelectLastChanged(Speciality spec)
{
if (!Specialities.Contains(spec))
{
Specialities.Add(spec);
}
SelectedSpeciality = spec;
}
public SpecialityListViewModel()
{
Title = "Специальности";
var specs = EntityQuery <Speciality> .All(Session)();
Specialities.SyncWith(specs);
}
public SpecialitiesListModel(int ApplicationID, int?GroupID = null)
{
Application = db.Applications.Find(ApplicationID);
PaymentType = Application.PaymentType;
User = Application.User;
ApplicationSetting ApplicationSetting = Application.ApplicationSettings.First();
if (ApplicationSetting.ApplicationGroupID != null)
{
Group Group = db.Groups.Find(ApplicationSetting.ApplicationGroupID);
List <int> GroupsPriority = new List <int>();
GroupsPriority.Add(Group.GroupID);
List <int> interRes = Group.GroupFriendships.OrderBy(gf => gf.Rang).Select(gf => gf.AccessibleGroupID).ToList();
GroupsPriority.AddRange(interRes);
List <IGrouping <int, SpecialityApplication> > GroupedNotOrderedSpecialities = Application.SpecialityApplications.GroupBy(sa => sa.GroupedSpeciality.GroupID).ToList();
List <int> GroupedNotOrderdID = GroupedNotOrderedSpecialities.Select(gnos => gnos.Key).ToList();
foreach (int priorityIndex in GroupsPriority)
{
if (GroupedNotOrderdID.Contains(priorityIndex))
{
GroupedChosenSpecialities.Add(GroupedNotOrderedSpecialities.First(gnos => gnos.Key == priorityIndex));
}
}
}
ChosenSpecialities = Application.SpecialityApplications.OrderBy(sa => sa.Priority).ToList();
if (ChosenSpecialities.Count <= 10)
{
if (GroupID == null)
{
IQueryable <IGrouping <int, GroupedSpeciality> > groups = db.GroupedSpecialities.Where(gs => gs.PaymentTypeID == PaymentType.PaymentTypeID /*&& Date*/).GroupBy(gs => gs.SpecialityID);
foreach (IGrouping <int, GroupedSpeciality> group in groups)
{
Specialities.Add(db.Specialities.Find(group.Key));
}
}
else
{
Group = db.Groups.Find(GroupID);
List <GroupedSpeciality> AvailableSpecialities = Group.GroupedSpecialities.ToList();
foreach (Group friend in Group.GroupFriendships.Select(gf => gf.Group1))
{
AvailableSpecialities.AddRange(friend.GroupedSpecialities);
}
IEnumerable <IGrouping <int, GroupedSpeciality> > groups = AvailableSpecialities.Where(gs => gs.PaymentTypeID == PaymentType.PaymentTypeID).Except(Application.SpecialityApplications.Select(sa => sa.GroupedSpeciality)).GroupBy(gs => gs.SpecialityID);
foreach (IGrouping <int, GroupedSpeciality> group in groups)
{
Specialities.Add(db.Specialities.Find(group.Key));
}
}
}
}
public ActionResult Edit([Bind(Include = "Id,Icon,Title,Text")] Specialities specialities)
{
if (ModelState.IsValid)
{
db.Entry(specialities).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(specialities));
}
private async void OnUpdateSpecialty()
{
SelectedSpeciality.Faculty = Faculties.FirstOrDefault(f => f.FacultyId == SelectedSpeciality.FacultyId);
var result = await _repo.UpdateSpecialtyAsync(SelectedSpeciality);
var specialty = Specialities.FirstOrDefault(s => s.SpecialtyId == SelectedSpeciality.SpecialtyId);
specialty.CopyProperties(SelectedSpeciality);
}
private async void OnUpdateStudent()
{
SelectedStudent.Specialty = Specialities.FirstOrDefault(s => s.SpecialtyId == SelectedStudent.SpecialityId);
var result = await _repo.UpdateStudentAsync(SelectedStudent);
var student = Students.FirstOrDefault(s => s.StudentId == SelectedStudent.StudentId);
student.CopyProperties(SelectedStudent);
}
public static Specialities getSpecialityObject(string Code, string ShortName, string FullName, string shortFacultyName, string qualification)
{
Specialities spec = new Specialities();
spec.Code = Code;
spec.ShortFacultyName = shortFacultyName;
spec.ShortName = ShortName;
spec.FullName = FullName;
spec.Qualification = qualification;
return(spec);
}
public async Task <IEnumerable <Doctor> > GetBySpecialityAsync(int tenantId, Specialities specialty, int count)
{
var doctors = await _context.Doctors
.Where(d => d.TenantId == tenantId && !d.Deleted)
.Where(d => d.Speciality == specialty)
.OrderBy(d => d.Name)
.Take(count)
.ToListAsync();
return(doctors.Select(c => Build(c)).ToList());
}
public ActionResult Create([Bind(Include = "Id,Icon,Title,Text")] Specialities specialities)
{
if (ModelState.IsValid)
{
db.Specialities.Add(specialities);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(specialities));
}
public async Task<IEnumerable<Doctor>> GetBySpecialityAsync(int tenantId, Specialities specialty, int count)
{
var doctors = await _context.Doctors
.Where(d => d.TenantId == tenantId && !d.Deleted)
.Where(d => d.Speciality == specialty)
.OrderBy(d => d.Name)
.Take(count)
.ToListAsync();
return doctors.Select(c => Build(c)).ToList();
}
// удаление документа
public async Task Remove(string code)
{
var filter = new BsonDocument("Code", new BsonDocument("$eq", code));
await Specialities.DeleteOneAsync(filter);
await Specialities_Proffesions.DeleteManyAsync(filter);
await Specialities_Subjects.DeleteManyAsync(filter);
await Comment_Specialities.DeleteManyAsync(filter);
}
private void LoadSpecialtyData()
{
Specialities oSpecialities = new Specialities();
cboSpecialty.DataBindings.Clear();
m_oDS = oSpecialities.GetData();
cboSpecialty.DataSource = m_oDS.Tables["Specialities"];
cboSpecialty.DisplayMember = "Name";
cboSpecialty.ValueMember = "Name";
cboSpecialty.SelectedValue = "General";
}
private void ValidateResponseSpecialities(ResponseSpecialities responseSpecialities)
{
if (responseSpecialities.Success)
{
Specialities.Clear();
foreach (Speciality speciality in responseSpecialities.MedicalSpecialites)
{
Specialities.Add(speciality);
}
}
}
public string Remove(Specialities speciality)
{
if (IsExist(speciality))
{
if (IsRemoved(speciality))
{
return("Удаление произошло успешно!");
}
return("Данный объект не был удален!");
}
return("Данный объект не существует!");
}
internal async void GetDoctorsForSpecialty(Specialities speciality)
{
if (allDoctors == null)
{
await GetDoctors();
}
var filtered = from d in allDoctors
where d.Speciality == specialty
select d;
FilteredDoctors = new ObservableCollection <Doctor>(filtered.ToList());
}
public string Add(Specialities speciality)
{
if (!IsExist(speciality))
{
context.InsertSpeciality(speciality.Code, speciality.ShortFacultyName, speciality.ShortName, speciality.FullName, speciality.Qualification);
return("Объект успешно добавлен!");
}
else
{
return("Данный объект уже существует!");
}
}
public string Change(Specialities changedSpeciality, Specialities newSpeciality)
{
if (IsExist(changedSpeciality))
{
context.UpdateSpeciality(changedSpeciality.Code, newSpeciality.ShortFacultyName, newSpeciality.ShortName, newSpeciality.FullName, newSpeciality.Qualification);
return("Объект успешно изменен!");
}
else
{
return("Данного объекта не существует!");
}
}
public Student()
{
this.firstName = null;
this.midleName = null;
this.lastName = null;
this.course = 0;
this.speciality = 0;
this.university = 0;
this.eMail = null;
this.phoneNumber = null;
studentsCount++;
}
// GET: Admin/Specialities/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Specialities specialities = db.Specialities.Find(id);
if (specialities == null)
{
return(HttpNotFound());
}
return(View(specialities));
}
public bool IsRemoved(Specialities speciality)
{
switch (MessageBox.Show("При удалении специальности, все ее группы и занятия будут удалены!",
null, MessageBoxButton.OKCancel, MessageBoxImage.Question))
{
case MessageBoxResult.OK:
context.DeleteSpeciality(speciality.Code);
return(true);
case MessageBoxResult.Cancel:
return(false);
}
return(false);
}
public async Task <List <Speciality> > GetSpecialitiesAll()
{
List <Speciality> results = null;
var filter = new BsonDocument("Code", new BsonDocument("$ne", ""));
results = await Specialities.Find <Speciality>(filter).ToListAsync();
if (results != null)
{
return(results);
}
else
{
return(null);
}
}
public Student(string firstName,
string midleName,
string lastName,
byte course,
Specialities speciality,
Universities university,
string eMail,
string phoneNumber)
: this(firstName, midleName, lastName)
{
this.course = course;
this.speciality = speciality;
this.university = university;
this.eMail = eMail;
this.phoneNumber = phoneNumber;
}
/*public async Task<User> GetUsersAsync(string email, string pass)
* {
*
* List<User> results = null;
* var filter = new BsonDocument("$and", new BsonArray{
*
* new BsonDocument("Email",new BsonDocument("$eq", email)),
* new BsonDocument("Password", pass)
* });
* results = await Users.Find<User>(filter).ToListAsync();
* if (results != null)
* return results.FirstOrDefault();
* else return null;
* }*/
// получаем один документ по id
/*public async Task<User> GetUser(string id)
* {
* return await Users.Find(new BsonDocument("_id", new ObjectId(id))).FirstOrDefaultAsync();
* }*/
public async Task <Speciality> GetSpecialityCode(string code)
{
List <Speciality> results = null;
var filter = new BsonDocument("Code", new BsonDocument("$eq", code));
results = await Specialities.Find <Speciality>(filter).ToListAsync();
if (results != null)
{
return(results.FirstOrDefault());
}
else
{
return(null);
}
}
public AspirantSelectLists(Aspirant aspirant, AspiranturaContext context)
{
Statuses = Helper.GetStatuses();
Studyforms = Helper.GetStudyForms();
Specialities = Helper.GetSpecialities(context);
Departments = Helper.GetDepartments(context);
Prepods = Helper.GetPrepods(context);
if (aspirant != null)
{
selectedStatus = Statuses.FirstOrDefault(k => k.Value == (int)aspirant.StatusType);
selectedStudyform = Studyforms.FirstOrDefault(k => k.Value == (int)aspirant.StudyForm);
selectedSpeciality = Specialities.FirstOrDefault(k => k.Value == aspirant.SpecialityId); // возможно нужна проверка на null
selectedDepartment = Departments.FirstOrDefault(k => k.Value == aspirant.DepartmentId);
selectedPrepod = Prepods.FirstOrDefault(k => k.Value == aspirant.PrepodId);
}
}
public Student(string fname, string mname, string lname,
string ssn, string address, string phone,
string email, byte course, Specialities spec,
Universities uni, Faculties fac)
{
this.FirstName = fname;
this.MiddleName = mname;
this.LastName = lname;
this.SSN = ssn;
this.Address = address;
this.MobilePhone = phone;
this.Email = email;
this.Course = course;
this.Speciality = spec;
this.University = uni;
this.Faculty = fac;
}
private async void OnAddSpecialty()
{
SelectedSpeciality.SpecialtyId = 0;
var allSpecialities = await _repo.GetSpecialtiesAsync();
if (allSpecialities.Any(s =>
s.Name == SelectedSpeciality.Name &&
s.FacultyId == SelectedSpeciality.FacultyId))
{
MessageBox.Show("Специальность с таким именем уже существует на этом факультете.", "Ошибка");
return;
}
var result = await _repo.AddSpecialtyAsync(SelectedSpeciality);
Specialities.Add(result);
}
public Student(string firstName, string middleName,
string lastName, string ssn, string address,
string mobilePhone, string email, int course,
Universities university, Faculties faculty,
Specialities speciality)
{
this.FirstName = firstName;
this.MiddleName = middleName;
this.LastName = lastName;
this.SSN = ssn;
this.PermanentAddress = address;
this.MobilePhone = mobilePhone;
this.EMail = email;
this.Course = course;
this.University = university;
this.Faculty = faculty;
this.Speciality = speciality;
}
private void FilterSpecialities()
{
TimetableCourseProject Context = new TimetableCourseProject();
SpecialitiesDatabase = new ObservableCollection <Specialities>(Context.Specialities.ToList());
context.Specialities.Load();
if (Specialities != null)
{
Specialities.Clear();
foreach (var obj in SpecialitiesDatabase)
{
if (FilterSpecialities(obj))
{
Specialities.Add(obj);
}
}
}
}
public async Task<List<Doctor>> GetBySpecialityAsync(Specialities speciality, int count)
{
string url = $"{_UrlPrefix}api/doctors/speciality/{speciality}/?count={count}";
return await GetAsync<List<Doctor>>(url);
}
async Task GetDoctorsForSpecialtyAsync(Specialities speciality)
{
try
{
IsBusy = true;
Doctors.Clear();
var doctors = await client.DoctorsService.GetBySpecialityAsync(
speciality,
AmountOfDoctors);
Doctors.AddRange(doctors);
}
finally
{
IsBusy = false;
}
}
public async Task<IEnumerable<Doctor>> GetBySpecialityAsync(Specialities speciality, int count)
{
return await _DoctorsRepository.GetBySpecialityAsync(Request.GetTenant(), speciality, count);
}
internal async void GetDoctorsForSpecialty(Specialities speciality)
{
if (allDoctors == null)
await GetDoctors();
var filtered = from d in allDoctors
where d.Speciality == specialty
select d;
FilteredDoctors = new ObservableCollection<Doctor>(filtered.ToList());
}
