Автоматизация учета иностранных студентов в условиях филиала КузГТУ в г Прокопьевске

cs
public class DataService

{


public IList GetFaculties()
{
using (var dbContext = new ForeignStudentsDbContext())
return dbContext.Faculties.ToList();
}

public IList GetSpecialities(Guid facultyId)
{
using (var dbContext = new ForeignStudentsDbContext())
return dbContext.Specialities.Include("Faculty").Where(x=>x.Faculty.Id == facultyId).ToList();
}
public IList GetStudents()
{
using (var dbContext = new ForeignStudentsDbContext())
return dbContext.Students.Include("Faculty").Include("Speciality").ToList();
}

public void SaveStudent(string name, string surName, string fathersName, Guid facultyId, Guid specialityId, string address, DateTime birthDay, int year, string county, bool hasHostel)
{
using (var dbContext = new ForeignStudentsDbContext())
{
var faculty = dbContext.Faculties.Find(facultyId);
var speciality = dbContext.Specialities.Find(specialityId);
dbContext.Students.Add(new Student
{
Id = Guid.NewGuid(),
Name = name,
Surname = surName,
FathersName = fathersName,
Faculty = faculty,
Speciality = speciality,
Address = address,
BirthDate = birthDay,
HasStudentsHostelRoom = hasHostel,
NativeCountry = county,
StudentYear = year

});
dbContext.SaveChanges();
}

}

public void SaveSpeicality(string name, Guid facultyId)
{
using (var dbContext = new ForeignStudentsDbContext())
{
var faculty = dbContext.Faculties.Find(facultyId);
dbContext.Specialities.Add(new Speciality() { Id = Guid.NewGuid(), Faculty = faculty, Name = name });
dbContext.SaveChanges();
}
}

public void SaveFaculty(string name)
{
using (var dbContext = new ForeignStudentsDbContext())
{
dbContext.Faculties.Add(new Faculty() { Id = Guid.NewGuid(), Name = name });
dbContext.SaveChanges();
}
}

public void UpdateStudent(Guid studentId, Guid conferenceId)
{
using (var dbContext = new ForeignStudentsDbContext())
{
var student = dbContext.Students.Include("Conferences").First(x=>x.Id == studentId);
var conference = dbContext.Conferences.Find(conferenceId);
student.Conferences.Add(conference);
dbContext.SaveChanges();
}
}

public IList GetConferences()
{
using (var dbContext = new ForeignStudentsDbContext())
return dbContext.Conferences.ToList();
}
public Student GetStudent(Guid id)
{
using (var dbContext = new ForeignStudentsDbContext())
return dbContext.Students.Include("Conferences").First(x => x.Id == id);
}
}

Слой пользовательского интерфейса
public partial class ForeignStudentsMainView : Form
{
private DataService _dataService;
private List _list;
public ForeignStudentsMainView()
{
InitializeComponent();
_dataService = new DataService();
// _dataService.InitData();
_list = _dataService.GetStudents().OrderBy(x => x.Surname).ToList();
var source = new BindingList(_list);
studentsGrid.DataSource = source;
studentsGrid.Columns["Id"].Visible = false;
facultyCb.DataSource = _dataService.GetFaculties();
}

private void facultyCb_SelectedIndexChanged(object sender, EventArgs e)
{
var cb = sender as ComboBox;
if (cb == null)
return;
var faculty = cb.SelectedItem as ForeignStudents.Domain.Faculty;
if (faculty == null)
return;
specialityComboBox.DataSource = _dataService.GetSpecialities(faculty.Id);
}

private void saveBtn_Click(object sender, EventArgs e)
{
var faculty = facultyCb.SelectedItem as ForeignStudents.Domain.Faculty;
if (faculty == null)
{
MessageBox.Show("Не выбран факультет");
return;
}

var specality = specialityComboBox.SelectedItem as ForeignStudents.Domain.Speciality;
if (specality == null)
{
MessageBox.Show("Не выбрана специальность");
return;
}
_dataService.SaveStudent(studentNametb.Text, Surnametb.Text, FatherNametb.Text, faculty.Id, specality.Id, addressTxb.Text, BirthdayDateTimePicker.Value, (int)yearNumeric.Value, nativeCountryTbx.Text, checkBox1.Checked);

//refresh grid data
_list = _dataService.GetStudents().OrderBy(x => x.Surname).ToList();
var source = new BindingList(_list);
studentsGrid.DataSource = source;

}

private void saveFaculty_Click(object sender, EventArgs e)
{
_dataService.SaveFaculty(addFacultyTb.Text);
selectFacultyForSpecialityCb.DataSource = _dataService.GetFaculties();
facultyCb.DataSource = _dataService.GetFaculties();

}


private void saveConferencebnt_Click(object sender, EventArgs e)
{
_dataService.SaveConference(conferenceName.Text, conferenceDateTimePicker.Value);
}

private void studentsGrid_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
var student = (studentsGrid.DataSource as IList)[e.RowIndex] as ForeignStudents.Domain.Student;
if (student == null)
return;
new StudentDetailsForm(student.Id).Show();
}
}

public partial class StudentDetailsForm : Form
{
private DataService _dataService;
private Guid _studentId;
public StudentDetailsForm(Guid studentId)
{
_studentId = studentId;
InitializeComponent();
_dataService = new DataService();
var student = _dataService.GetStudent(studentId);
FullNametxt.Text = string.Format("{0} {1} {2}", student.Surname, student.Name, student.FathersName);
FullNametxt.Enabled = false;
conferencesCombo.DataSource = _dataService.GetConferences();
conferencesTxb.Text = string.Join(", \n", student.Conferences
.Select(p =>string.Format("{0} дата проведения {1}", p.ConferenceName, p.Date.ToShortDateString())));
}

private void updateStudentBtn_Click(object sender, EventArgs e)
{
var conference = conferencesCombo.SelectedValue as ForeignStudents.Domain.Conference;
if(conference!=null)

_dataService.UpdateStudent(_studentId, conference.Id);
MessageBox.Show("Данные успешно сохранены");
this.Close();
}
}










Изм. Лист № докум. Подп. Дата Выполнил Пояснительная записка к курсовому проекту Лит. Лист Листов Проверил У 3 34



Лист 35 Изм. Лист № докум. Подп. Дата