private void FilterTopics(string topic)
{
try
{
if (topic != null && topic != String.Empty)
{
var topicList = db.Topics.Where(a => a.Name.Contains(topic) && a.CourseId == group.CourseId).OrderBy(a => a.Name).ToList();
lbTopics.DataSource = topicList;
lbTopics.DisplayMember = "Name";
lbTopics.ValueMember = "Id";
}
else
{
var topicList = db.Topics.Where(a => a.CourseId == group.CourseId).OrderBy(a => a.Name).ToList();
lbTopics.DataSource = topicList;
lbTopics.DisplayMember = "Name";
lbTopics.ValueMember = "Id";
}
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void AuthForm_Load(object sender, EventArgs e)
{
try
{
cbHousing.DataSource = db.Housings.Where(a => a.IsRemoved == false).OrderBy(a => a.Name).ToList();
cbHousing.DisplayMember = "Name";
cbHousing.ValueMember = "Id";
cbLogin.DataSource = db.Workers.Where(a => a.IsRemoved != true).OrderBy(a => a.Lastname).ToList();
cbLogin.DisplayMember = "Login";
cbLogin.ValueMember = "Id";
//выбор значений по умолчанию
cbHousing.SelectedValue = Convert.ToInt32(Registry.GetValue(keyName, "Branch", -1));
cbLogin.SelectedValue = Convert.ToInt32(Registry.GetValue(keyName, "User", -1));
btnOK.Focus();
}
catch (Exception ex)
{
string methodName = ex.TargetSite + ";\r\n" + ex.StackTrace;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public RemoveStudentForm(int enrollId)
{
InitializeComponent();
try
{
enroll = db.Enrollments.Find(enrollId);
var causes = db.Causes.OrderBy(a => a.Name).ToList();
cbList.DataSource = causes;
cbList.DisplayMember = "Name";
cbList.ValueMember = "Id";
var months = db.Months.ToList();
cbMonths.DataSource = months;
cbMonths.DisplayMember = "Name";
cbMonths.ValueMember = "Id";
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btCleanFilter_Click(object sender, EventArgs e)
{
try
{
dtpBegin.Value = dtpEnd.Value = DateTime.Now;
tbLastname.Clear();
tbGroup.Clear();
cbWorkers.SelectedIndex = -1;
isPickedDateBegin = isPickedDateEnd = false;
label2.Enabled = dtpEnd.Enabled = false;
payments = GetPaymentsList();
dgvPayments.DataSource = payments.ToList();
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ArchiveForm()
{
InitializeComponent();
try
{
//загрузка фильтра групп
var actGroups = db.Groups.ToList();
cbGroups.DataSource = actGroups;
cbGroups.DisplayMember = "Name";
cbGroups.ValueMember = "Id";
cbGroups.SelectedIndex = -1;
//загрузка фильтра тип обучения
var type = db.Years.Where(a => a.IsRemoved == false).OrderBy(a => a.SortIndex).ToList();
cbTypeGroup.DataSource = type;
cbTypeGroup.DisplayMember = "Name";
cbTypeGroup.ValueMember = "Id";
cbTypeGroup.SelectedIndex = -1;
}
catch (Exception ex)
{
string methodName = ex.TargetSite + ";\r\n" + ex.StackTrace;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
try
{
cbList.DataSource = null;
cbList.Items.Clear();
cbMonths.SelectedIndex = -1;
cbMonths.Enabled = cbList.Enabled = false;
cbGroups.Enabled = chbSaveGrades.Enabled = true;
var enrollsStudent = db.Enrollments.Where(a => a.StudentId == enroll.StudentId && a.DateExclusion == null).Select(a => a.GroupId).ToList();
var groups = db.Groups.Include("Activity").OrderBy(a => a.Name).Where(a => (a.Activity.Name == "Текущие" || a.Activity.Name == "В наборе") && a.Course.Name != "Индивид." &&
!enrollsStudent.Contains(a.Id)).Select(a => new { Id = a.Id, Name = a.Name + " | " + a.Year.Name }).ToList();
cbGroups.DataSource = groups;
cbGroups.DisplayMember = "Name";
cbGroups.ValueMember = "Id";
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dgvListStudents_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == dgvListStudents.Columns["btn"].Index)
{
//определяем не записан ли уже студент в группу
int idStudent = Convert.ToInt32(dgvListStudents.Rows[e.RowIndex].Cells["StudentId"].Value);
var validatingStudent = db.Enrollments.FirstOrDefault(a => a.GroupId == groupId && a.StudentId == idStudent);
if (validatingStudent == null)
{
db.Enrollments.Add(new Enrollment {
StudentId = idStudent, GroupId = groupId, DateEnrollment = DateTime.Now, EnrollId = CurrentSession.CurrentUser.Id
});
db.SaveChanges();
}
else
{
MessageBox.Show("Выбранный учащийся уже записан в эту группу", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//обновляем список, очищаем textbox
tbLastname.Text = "";
Filter(null);
}
}
catch (Exception ex)
{
string methodName = ex.TargetSite + ";\r\n" + ex.StackTrace;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void SectionForm_Load(object sender, EventArgs e)
{
try
{
Text = "Добавление нового раздела";
var lessonsDates = db.Lessons.Where(Lesson => (group.Id == Lesson.GroupId)).ToList();
cbLesson.DataSource = lessonsDates;
cbLesson.DisplayMember = "Date";
cbLesson.ValueMember = "Id";
if (Section == null)
{
return;
}
Text = $"Редактирование раздела №{sectionIndex} за {Section.Lesson.Date.ToShortDateString()}";
cbCredit.Checked = Section.IsCredit;
cbTypeGrade.Checked = Section.IsTypeGrade;
tbName.Text = Section.Name;
tbDuration.Text = Section.Duration.ToString();
cbLesson.SelectedItem = lessonsDates.FirstOrDefault(Lesson => (Section.Lesson.Date == Lesson.Date));
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void WorkerForm_Load(object sender, EventArgs e)
{
try
{
if (worker.Id != 0)
{
tbLastname.Text = worker.Lastname;
tbFirstname.Text = worker.Firstname;
tbMiddlename.Text = worker.Middlename;
tbLastnameEn.Text = worker.LastnameEn;
tbFirstnameEn.Text = worker.FirstnameEn;
tbMiddlenameEn.Text = worker.MiddlenameEn;
cbRoles.SelectedValue = worker.RoleId;
tbLogin.Text = worker.Login;
cbDepartment.SelectedValue = worker.DepartmentId;
chbAllAccessGroups.Checked = worker.AllAccessGroups;
if (worker.PostId == null)
{
cbPosts.SelectedIndex = -1;
}
else
{
cbPosts.SelectedValue = worker.PostId;
}
}
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void SelectStatus(int?idStatus)
{
try
{
if (idStatus != null)
{
schools = db.Schools.Where(a => a.StatusId == idStatus && a.IsRemoved == false).ToList();
}
else
{
schools = db.Schools.Where(a => a.IsRemoved == false).ToList();
}
if (schools.Count != 0)
{
cbSchools.Enabled = cbClasses.Enabled = cbShifts.Enabled = true;
cbSchools.DataSource = schools;
cbSchools.DisplayMember = "Name";
cbSchools.ValueMember = "Id";
cbSchools.SelectedIndex = -1;
}
else
{
cbSchools.Enabled = cbClasses.Enabled = cbShifts.Enabled = false;
}
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
var login = db.Workers.Count(a => a.Login == cbLogin.Text && a.Password == tbPassword.Text);
if (login == 1)
{
var r = db.Roles.ToList();
CurrentSession.CurrentUser = db.Workers.FirstOrDefault(a => a.Login == cbLogin.Text);
CurrentSession.CurrentRole = db.Roles.Find(CurrentSession.CurrentUser.RoleId);
int idHousing = Convert.ToInt32(cbHousing.SelectedValue);
CurrentSession.CurrentHousing = db.Housings.FirstOrDefault(a => a.Id == idHousing);
CurrentSession.TimeRun = DateTime.Now;
//запись данных последнего входа в реестр
Registry.SetValue(keyName, "Branch", cbHousing.SelectedValue, RegistryValueKind.DWord);
Registry.SetValue(keyName, "User", cbLogin.SelectedValue, RegistryValueKind.DWord);
Close();
}
else
{
tbPassword.Text = "";
label2.Text = "Ошибка! Вход не выполнен";
}
}
catch (Exception ex)
{
string methodName = ex.TargetSite + ";\r\n" + ex.StackTrace;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void подробныйСписокToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dgvListGroups.Rows.Count != 0)
{
try
{
var total = (from groups in db.Groups
join courses in db.Courses on groups.CourseId equals courses.Id
join directions in db.Directions on courses.DirectionId equals directions.Id
join teachers in db.Workers on groups.TeacherId equals teachers.Id into outerTeacher
from teachers in outerTeacher.DefaultIfEmpty()
join activity in db.ActivityGroups on groups.ActivityId equals activity.Id
join classes in db.Classes on groups.ClassId equals classes.Id into outerClass
from classes in outerClass.DefaultIfEmpty()
join branches in db.Housings on classes.HousingId equals branches.Id into outerBranch
from branches in outerBranch.DefaultIfEmpty()
join years in db.Years on groups.YearId equals years.Id into g
from years in g.DefaultIfEmpty()
where (activity.Name == "Текущие" || activity.Name == "В наборе")
select new ListGroupFull
{
Id = groups.Id,
Direction = directions.Name,
Course = courses.Name,
Group = groups.Name,
StatusGroup = activity.Name,
Branch = branches.Name,
Class = classes.Name,
Days = groups.Days,
Begin = groups.Begin,
DurationLesson = groups.DurationLesson,
DurationCourse = groups.DurationCourse,
CountLesson = (groups.DurationLesson != 0) ? (int)(groups.DurationCourse / groups.DurationLesson) : 0,
PassedLesson = groups.Lessons.Count,
Teacher = teachers.Lastname + " " + teachers.Firstname.Substring(0, 1) + "." + teachers.Middlename.Substring(0, 1) + ".",
TwoTeachers = groups.TwoTeachers,
Students = groups.Enrollments.Where(a => a.GroupId == groups.Id && a.DateExclusion == null).Count(),
Year = years.Name,
SchedSumNow = (from scheds in db.Schedules
where scheds.Source == 2 && scheds.EnrollmentId != null && scheds.GroupId == groups.Id && scheds.DateBegin <= DateTime.Now
select new { SchedSum = scheds.Value - scheds.Discount }).Sum(s => (double?)(s.SchedSum)) ?? 0,
PaysSumNow = (from pays in db.Payments
join enrolls in db.Enrollments on pays.EnrollmentId equals enrolls.Id
where enrolls.GroupId == groups.Id && enrolls.DateExclusion == null && pays.IsDeleted == false && pays.AdditionalPay == false
select new { PaySum = pays.ValuePayment }).Sum(s => (double?)(s.PaySum)) ?? 0,
//SaldoNow = String.Empty,
}).ToList();
var exportGroupFull = new Report();
exportGroupFull.ExportExcelGroupFull(total);
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void подробныйСписокToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dgvStudents.Rows.Count != 0)
{
try
{
var total = (from enroll in db.Enrollments
join groups in db.Groups on enroll.GroupId equals groups.Id
join activity in db.ActivityGroups on groups.ActivityId equals activity.Id
join students in db.Students on enroll.StudentId equals students.Id
join years in db.Years on groups.YearId equals years.Id into g
from years in g.DefaultIfEmpty()
where (activity.Name == "Текущие" || activity.Name == "В наборе") && enroll.DateExclusion == null
select new ListStudentFull
{
EnrollmentId = enroll.Id,
YearId = years.Id,
Lastname = students.Lastname,
Firstname = students.Firstname,
Middlename = students.Middlename,
DateOfBirth = students.DateOfBirth,
Age = DateTime.Now.Year - students.DateOfBirth.Year,
Sex = students.Sex,
City = students.City.Name,
Address = students.Street.Name + ((!String.IsNullOrEmpty(students.House)) ? ", д." + students.House : "") + ((students.Float != null) ? ", кв." + students.Float : ""),
StatusStudent = students.Status.Name,
School = students.School.Name,
Class = students.Class,
Shift = students.Shift,
PhoneNumber1 = students.StudentPhone,
PhoneNumber2 = students.StudentPhone2,
LastnameParent = students.LastnameParent,
FirstnameParent = students.FirstnameParent,
MiddlenameParent = students.MiddlenameParent,
PhoneNumberParent = students.ParentsPhone,
Group = groups.Name,
Year = years.Name,
StatusGroup = activity.Name,
SchedSumNow = (from scheds in db.Schedules
where scheds.Source == 2 && scheds.EnrollmentId == enroll.Id && scheds.DateBegin <= DateTime.Now
select new { SchedSum = scheds.Value - scheds.Discount }).Sum(s => (double?)(s.SchedSum)) ?? 0,
PaysSumNow = (from pays in db.Payments
where pays.EnrollmentId == enroll.Id && pays.IsDeleted == false && pays.AdditionalPay == false
select new { PaySum = pays.ValuePayment }).Sum(s => (double?)(s.PaySum)) ?? 0,
SaldoNow = String.Empty,
}).ToList();
var exportStudentFull = new Report();
exportStudentFull.ExportExcelStudentFull(total);
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btOK_Click(object sender, EventArgs e)
{
try
{
if (addLesson)
{
lesson = new Lesson();
lesson.Number = (db.Lessons.Where(a => a.GroupId == group.Id).Count() != 0) ? db.Lessons.Where(a => a.GroupId == group.Id).Max(a => a.Number) + 1 : 1;
}
lesson.Date = dtpDateLesson.Value;
lesson.ClassId = Convert.ToInt32(cbCurrentClass.SelectedValue);
lesson.DurationLesson = Convert.ToByte(nudDurationLesson.Value);
lesson.GroupId = group.Id;
lesson.TeacherId = Convert.ToInt32(cbCurrentTeacher.SelectedValue);
//сохранение темы
if (lbTopics.Items.Count == 0 && tbCurrentTopic.Text != String.Empty)
{
var currentTopic = new Topic {
Name = tbCurrentTopic.Text, CourseId = group.CourseId
};
db.Topics.Add(currentTopic);
db.SaveChanges();
lesson.TopicId = currentTopic.Id;
}
else if (tbCurrentTopic.Text == String.Empty)
{
lesson.TopicId = null;
}
else
{
lbTopics.SelectedIndex = 0;
lesson.TopicId = Convert.ToInt32(lbTopics.SelectedValue);
}
if (addLesson)
{
db.Lessons.Add(lesson);
}
else
{
db.Entry(lesson).State = EntityState.Modified;
}
db.SaveChanges();
this.idLesson = lesson.Number;
this.dateLesson = lesson.Date;
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public PayForm(int idEnroll, int idWorker, int?idPayment)
{
InitializeComponent();
try
{
var months = db.Months.ToList();
cbMonth.DataSource = months;
cbMonth.DisplayMember = "Name";
cbMonth.ValueMember = "Id";
var types = db.TypePayments.ToList();
cbTypePayment.DataSource = types;
cbTypePayment.DisplayMember = "Name";
cbTypePayment.ValueMember = "Id";
//основные платежи
if (idPayment == null)
{
add = true;
currentPay = new Payment();
currentPay.EnrollmentId = idEnroll;
currentPay.WorkerId = idWorker;
//определение текущего месяца и года
int currentMonth = DateTime.Now.Month;
cbMonth.SelectedValue = currentMonth;
nudYear.Value = DateTime.Now.Year;
dtpDatePay.Value = DateTime.Now;
}
else
{
currentPay = db.Payments.FirstOrDefault(a => a.Id == idPayment);
tbPay.Text = currentPay.ValuePayment.ToString();
dtpDatePay.Value = currentPay.DatePayment;
if (!currentPay.AdditionalPay)
{
cbMonth.SelectedValue = currentPay.MonthId;
nudYear.Value = currentPay.Year;
}
else
{
cbMonth.Enabled = false;
nudYear.Enabled = false;
}
cbTypePayment.SelectedValue = currentPay.TypePaymentId;
tbNotePay.Text = currentPay.Note;
chbAdditionalPay.Checked = currentPay.AdditionalPay;
}
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PrintGroupForm_Load(object sender, EventArgs e)
{
try
{
// Определение доступной информации для печати
// Запрещать отправлять журнал на печать, если учащихся в журнале не существует
if (!countStudents)
{
chkbJournal.Enabled = chkbJournal.Checked = false;
countDisableCheckBox++;
}
if (CurrentSession.CurrentRole.Name == "Преподаватель")
{
chkbContacts.Enabled = false;
}
var lessonsList = db.Lessons.Include("Topic").Where(Lesson => (id == Lesson.GroupId)).OrderBy(Lesson => (Lesson.Date)).ToList();
// Запрещать отправлять список тем на печать, если их не существует
if (!countStudents)
{
chkbListTopic.Enabled = chkbListTopic.Checked = false;
countDisableCheckBox++;
}
var contactsList = db.Enrollments.Include("Student").Where(Enrollment => (id == Enrollment.GroupId && Enrollment.DateExclusion == null))
.OrderBy(Enrollment => (Enrollment.Student.Lastname)).ToList();
// Запрещать отправлять контактные данные на печать, если их не существует
if (!countStudents)
{
chkbContacts.Enabled = chkbContacts.Checked = false;
countDisableCheckBox++;
}
var studentList = db.Enrollments.Include("Student").Include("School").Where(a => (a.GroupId == id && a.DateExclusion == null))
.Select(Enrollment => (Enrollment.Student)).OrderBy(Student => (Student.Lastname)).ToList();
// Запрещать отправлять информацию об учащихся на печать, если их не существует
if (!countStudents)
{
chkbStudents.Enabled = chkbStudents.Checked = false;
countDisableCheckBox++;
}
if (countDisableCheckBox == 4)
{
button1.Enabled = false;
}
}
catch (Exception ex)
{
var m = new StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ArchiveForm_Load(object sender, EventArgs e)
{
btStudentDelete.Visible = false;
//права доступа
if (CurrentSession.CurrentRole.Name == "Управляющий" || CurrentSession.CurrentRole.Name == "Администратор" || CurrentSession.CurrentRole.Name == "Старший секретарь")
{
btStudentDelete.Visible = true;
}
try
{
//загрузка списка слушателей
Filter(null, null, null, null, null, sortColumn, chbTransfer.Checked, sortOrder);
//оформление таблицы
dgvStudents.Columns["StudentId"].Visible = dgvStudents.Columns["GroupId"].Visible =
dgvStudents.Columns["SchoolId"].Visible = dgvStudents.Columns["EnrollId"].Visible =
dgvStudents.Columns["ActivityId"].Visible = dgvStudents.Columns["YearId"].Visible = false;
dgvStudents.Columns["Lastname"].HeaderText = "Фамилия";
dgvStudents.Columns["Firstname"].HeaderText = "Имя";
dgvStudents.Columns["Middlename"].HeaderText = "Отчество";
dgvStudents.Columns["Status"].HeaderText = "Статус";
dgvStudents.Columns["NameGroup"].HeaderText = "Группа";
dgvStudents.Columns["Teacher"].HeaderText = "Преподаватель";
dgvStudents.Columns["Phone1"].HeaderText = "Тел1";
dgvStudents.Columns["Phone2"].HeaderText = "Тел2";
dgvStudents.Columns["ParentPhone"].HeaderText = "Тел родителя";
dgvStudents.Columns["BirthDate"].HeaderText = "Дата рожд.";
dgvStudents.Columns["School"].HeaderText = "Школа";
dgvStudents.Columns["Class"].HeaderText = "Класс";
dgvStudents.Columns["Transfer"].HeaderText = "Переведен";
dgvStudents.Columns["Note"].HeaderText = "Примечание";
dgvStudents.Columns["DateEnrollment"].HeaderText = "Дата зачисления";
dgvStudents.Columns["DateExclusion"].HeaderText = "Дата отчисления";
dgvStudents.Columns["Cause"].HeaderText = "Причина";
dgvStudents.Columns["Sex"].HeaderText = "Пол";
dgvStudents.Columns["Year"].HeaderText = "Форма\\Год";
dgvStudents.Columns["NameGroup"].AutoSizeMode = dgvStudents.Columns["School"].AutoSizeMode =
dgvStudents.Columns["Class"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvStudents.Columns["BirthDate"].DefaultCellStyle.Format = "dd/MM/yyyy";
dgvStudents.Columns["DateEnrollment"].DefaultCellStyle.Format = "dd/MM/yyyy";
dgvStudents.Columns["DateExclusion"].DefaultCellStyle.Format = "dd/MM/yyyy";
dgvStudents.Columns["Phone1"].DefaultCellStyle.Format = "(###) ###-####";
}
catch (Exception ex)
{
string methodName = ex.TargetSite + ";\r\n" + ex.StackTrace;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ListPaymentsForm_Load(object sender, EventArgs e)
{
try
{
dtpBegin.Value = dtpEnd.Value = DateTime.Now;
payments = GetPaymentsList();
dgvPayments.DataSource = payments.ToList();
dgvPayments.Columns["DatePayment"].ReadOnly = dgvPayments.Columns["ValuePayment"].ReadOnly = dgvPayments.Columns["GroupName"].ReadOnly =
dgvPayments.Columns["StudentLastname"].ReadOnly = dgvPayments.Columns["StudentFirstname"].ReadOnly =
dgvPayments.Columns["StudentMiddlename"].ReadOnly = dgvPayments.Columns["WorkerLastnameFM"].ReadOnly = true;
dgvPayments.Columns["PaymentId"].Visible = dgvPayments.Columns["EnrollmentId"].Visible = dgvPayments.Columns["WorkerId"].Visible =
dgvPayments.Columns["GroupId"].Visible = dgvPayments.Columns["StudentId"].Visible = false;
dgvPayments.Columns["IsSelected"].HeaderText = "Выбрано";
dgvPayments.Columns["IsSelected"].Width = 60;
dgvPayments.Columns["DatePayment"].HeaderText = "Дата платежа";
dgvPayments.Columns["DatePayment"].DefaultCellStyle.Format = "dd/MM/yyyy";
dgvPayments.Columns["ValuePayment"].HeaderText = "Сумма возврата";
dgvPayments.Columns["GroupName"].HeaderText = "Группа";
dgvPayments.Columns["StudentLastname"].HeaderText = "Фамилия студента";
dgvPayments.Columns["StudentFirstname"].HeaderText = "Имя студента";
dgvPayments.Columns["StudentMiddlename"].HeaderText = "Отчество студента";
dgvPayments.Columns["WorkerLastnameFM"].HeaderText = "Работник";
dgvPayments.Columns["Housing"].HeaderText = "Корпус";
dgvPayments.Columns["Note"].HeaderText = "Примечание";
dgvPayments.Columns["Note"].Width = 360;
cbWorkers.DataSource = db.Workers.Where(Worker => (Worker.RoleId == 1)).ToList();
cbWorkers.DisplayMember = "LastnameFM";
cbWorkers.ValueMember = "Id";
cbWorkers.SelectedIndex = -1;
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Filter(string lastname, string group, DateTime dateBegin, DateTime dateEnd, int?workerId, string type, string housing)
{
try
{
payments = GetPaymentsList();
if (lastname != String.Empty && lastname != null)
{
payments = payments.Where(Payment => (Payment.StudentLastname.Contains(lastname)));
}
if (group != String.Empty && group != null)
{
payments = payments.Where(Payment => (Payment.GroupName.Contains(group)));
}
if (isPickedDateBegin && isPickedDateEnd)
{
dateBegin = dateBegin.Date;
dateEnd = dateEnd.AddDays(1).Date;
payments = payments.Where(Payment => Payment.DatePayment < dateEnd && Payment.DatePayment >= dateBegin);
}
if (workerId != null)
{
payments = payments.Where(Payment => (workerId == Payment.WorkerId));
}
if (housing != String.Empty && housing != null)
{
payments = payments.Where(Payment => (housing == Payment.Housing));
}
if (type != String.Empty && type != null)
{
payments = payments.Where(Payment => (type == Payment.Type));
}
dgvPayments.DataSource = payments.ToList();
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ListLessonForm()
{
try
{
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
InitializeComponent();
}
private void WhatNewsForm_Load(object sender, EventArgs e)
{
try
{
string path = Directory.GetCurrentDirectory() + "\\" + "version.rtf";
richTextBox1.LoadFile(path);
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dgvListGroups_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
try
{
int currentRow = e.RowIndex;
if (currentRow != -1)
{
var idGroup = Convert.ToInt32(dgvListGroups.Rows[currentRow].Cells["GroupId"].Value);
Group currentGroup;
using (var db = new IstraContext())
{
currentGroup = db.Groups.FirstOrDefault(a => a.Id == idGroup);
}
if (currentGroup != null)
{
var groupForm = new GroupForm(currentGroup);
groupForm.MdiParent = this.MdiParent;
groupForm.Show();
Filter((int?)cbDirectionOfTraining.SelectedValue, tbNameGroup.Text, (int?)cbTypeGroup.SelectedValue, (int?)cbTeachers.SelectedValue, cbActivity.Text, sortColumn, sortOrder);
if (currentRow != dgvListGroups.Rows.Count)
{
if (dgvListGroups.Rows.Count != 0)
{
dgvListGroups.Rows[currentRow].Selected = true;
dgvListGroups.CurrentCell = dgvListGroups.Rows[currentRow].Cells["Name"];
}
}
else
{
dgvListGroups.Rows[dgvListGroups.Rows.Count - 1].Selected = true;
dgvListGroups.CurrentCell = dgvListGroups.Rows[currentRow].Cells["Name"];
}
}
else
{
MessageBox.Show("Не удалось найти группу в базе данных", "Ошибка", MessageBoxButtons.OK);
}
}
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public WorkerForm(int?WorkerId)
{
InitializeComponent();
if (WorkerId == null)
{
worker = new Worker();
}
else
{
try
{
worker = db.Workers.Find(WorkerId);
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
try
{
var roles = db.Roles.Where(a => a.Priority > CurrentSession.CurrentRole.Priority).OrderBy(a => a.Name).ToList();
cbRoles.DataSource = roles;
cbRoles.ValueMember = "Id";
cbRoles.DisplayMember = "Name";
var departments = db.Departments.OrderBy(a => a.Name).ToList();
cbDepartment.DataSource = departments;
cbDepartment.ValueMember = "Id";
cbDepartment.DisplayMember = "Name";
var posts = db.Posts.OrderBy(a => a.Name).ToList();
cbPosts.DataSource = posts;
cbPosts.ValueMember = "Id";
cbPosts.DisplayMember = "Name";
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
foreach (var Control in Controls)
{
if (ReferenceEquals(new CheckBox().GetType(), Control.GetType()))
{
if ((Control as CheckBox).Checked)
{
if ((Control as CheckBox) == chkbJournal)
{
chkbPrintListAlbum.Add(Control as CheckBox);
}
else
{
chkbPrintListBook.Add(Control as CheckBox);
}
}
}
}
try
{
PrintDocument document = new PrintDocument();
//PrintPreviewDialog documentPreview = new PrintPreviewDialog();
document.DefaultPageSettings.PaperSize.RawKind = (int)PaperKind.A4;
document.DefaultPageSettings.Landscape = chkbPrintListAlbum.Count != 0;
document.DocumentName = "Документация";
//documentPreview.Document = document;
document.PrintPage += new PrintPageEventHandler(Print);
PrintDialog printDialog = new PrintDialog();
printDialog.Document = document;
if (printDialog.ShowDialog() == DialogResult.OK)
{
document.Print();
}
Close();
//documentPreview.ShowDialog();
}
catch (Exception ex)
{
var m = new StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DiscountForm(int idEnroll)
{
InitializeComponent();
try
{
enroll = db.Enrollments.Find(idEnroll);
//заполнение привилегий
var privileges = db.Privileges.ToList();
cbPrivilege.DataSource = privileges;
cbPrivilege.DisplayMember = "Name";
cbPrivilege.ValueMember = "Id";
//автопоиск льгот
AutoCompleteStringCollection privilegeList = new AutoCompleteStringCollection();
for (int i = 0; i < privileges.Count; i++)
{
privilegeList.Add(privileges[i].Name);
}
cbPrivilege.AutoCompleteSource = AutoCompleteSource.CustomSource;
cbPrivilege.AutoCompleteCustomSource = privilegeList;
cbPrivilege.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
DataGridViewCheckBoxColumn c = new DataGridViewCheckBoxColumn();
c.Name = "Check";
c.HeaderText = "Выбрать";
dgvSchedules.Columns.Add("Id", "Id");
dgvSchedules.Columns.Add(c);
dgvSchedules.Columns.Add("Date", "Дата");
dgvSchedules.Columns.Add("Val", "Платеж");
dgvSchedules.Columns.Add("Discount", "Скидка");
dgvSchedules.Columns.Add("Note", "Основание");
dgvSchedules.Columns["Id"].Visible = false;
dgvSchedules.Columns["Date"].DefaultCellStyle.Format = "dd/MM/yyyy";
dgvSchedules.Columns["Date"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvSchedules.Columns["Val"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvSchedules.Columns["Discount"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
private void AddingStudentToGroupForm_Load(object sender, EventArgs e)
{
try
{
//загрузка списка слушателей
Filter(null);
//оформление таблицы
dgvListStudents.Columns["StudentId"].Visible = dgvListStudents.Columns["SchoolId"].Visible =
dgvListStudents.Columns["StatusId"].Visible = false;
dgvListStudents.Columns["Lastname"].HeaderText = "Фамилия";
dgvListStudents.Columns["Firstname"].HeaderText = "Имя";
dgvListStudents.Columns["Middlename"].HeaderText = "Отчество";
dgvListStudents.Columns["Status"].HeaderText = "Статус";
dgvListStudents.Columns["Phone1"].HeaderText = "Тел1";
dgvListStudents.Columns["Phone2"].HeaderText = "Тел2";
dgvListStudents.Columns["BirthDate"].HeaderText = "Дата рожд.";
dgvListStudents.Columns["School"].HeaderText = "Школа";
dgvListStudents.Columns["Class"].HeaderText = "Класс";
dgvListStudents.Columns["Shift"].HeaderText = "Смена";
dgvListStudents.Columns["Note"].HeaderText = "Примечание";
dgvListStudents.Columns["Sex"].HeaderText = "Пол";
dgvListStudents.Columns["School"].AutoSizeMode = dgvListStudents.Columns["Class"].AutoSizeMode =
dgvListStudents.Columns["Shift"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvListStudents.Columns["BirthDate"].DefaultCellStyle.Format = "dd/MM/yyyy";
dgvListStudents.Columns["Phone1"].DefaultCellStyle.Format = "(###) ###-####";
DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
dgvListStudents.Columns.Add(btn);
btn.HeaderText = "Добавление";
btn.Text = "Добавить";
btn.Name = "btn";
btn.UseColumnTextForButtonValue = true;
}
catch (Exception ex)
{
string methodName = ex.TargetSite + ";\r\n" + ex.StackTrace;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btOK_Click(object sender, EventArgs e)
{
try
{
if (!int.TryParse(tbDuration.Text, out int duration))
{
MessageBox.Show(this, "Значение в поле продолжительности раздела указано неверно\nЗаполните его и повторите попытку", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var lesson = db.Lessons.Where(Lesson => (group.Id == Lesson.GroupId)).ToList().FirstOrDefault(Lesson => ((cbLesson.SelectedItem as Lesson).Date == Lesson.Date));
if (lesson == null)
{
MessageBox.Show(this, "Выбранного урока не существует в базе данных\nСоздайте урок и повторите попытку снова", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Section = new Section
{
IsCredit = cbCredit.Checked,
IsTypeGrade = cbTypeGrade.Checked,
Name = tbName.Text,
Duration = duration,
CourseId = group.CourseId,
GroupId = group.Id,
LessonId = lesson.Id
};
DialogResult = DialogResult.OK;
Close();
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LessonForm_Load(object sender, EventArgs e)
{
try
{
//заполнение данных о занятии по умолчанию, для нового занятия
if (group != null && lesson == null)
{
nudDurationLesson.Value = group.DurationLesson;
var currentHousing = db.Classes.FirstOrDefault(a => a.Id == group.ClassId);
cbCurrentHousing.SelectedValue = currentHousing.HousingId;
SelectHousing(currentHousing.HousingId);
cbCurrentClass.SelectedValue = group.ClassId;
cbCurrentTeacher.SelectedValue = group.TeacherId;
}
//заполнение данных о занятии для редактирования
if (group != null && lesson != null)
{
dtpDateLesson.Value = lesson.Date;
nudDurationLesson.Value = lesson.DurationLesson;
var currentHousing = db.Classes.FirstOrDefault(a => a.Id == lesson.ClassId);
cbCurrentHousing.SelectedValue = currentHousing.HousingId;
SelectHousing(currentHousing.HousingId);
cbCurrentClass.SelectedValue = lesson.ClassId;
cbCurrentTeacher.SelectedValue = lesson.TeacherId;
if (lesson.TopicId != null)
{
var currentTopic = db.Topics.FirstOrDefault(a => a.Id == lesson.TopicId);
tbCurrentTopic.Text = currentTopic.Name;
}
}
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Filter(string lastname)
{
try
{
var listExclude = db.Enrollments.Where(a => a.GroupId == groupId && a.DateExclusion == null).Select(a => a.StudentId).ToList();
listStudents = from students in db.Students
join statuses in db.Statuses on students.StatusId equals statuses.Id
join schools in db.Schools on students.SchoolId equals schools.Id into school
from years in school.DefaultIfEmpty()
select new AddingStudents
{
StudentId = students.Id,
SchoolId = students.SchoolId,
StatusId = students.StatusId,
Lastname = students.Lastname,
Firstname = students.Firstname,
Middlename = students.Middlename,
Status = statuses.Name,
Phone1 = students.StudentPhone,
Phone2 = students.StudentPhone2,
Sex = students.Sex,
BirthDate = students.DateOfBirth,
School = students.School.Name,
Class = students.Class,
Shift = students.Shift,
Note = students.Note
};
if (lastname != null && lastname != "")
{
listStudents = listStudents.Where(e => e.Lastname.StartsWith(lastname));
}
dgvListStudents.DataSource = listStudents.Where(a => !listExclude.Contains(a.StudentId)).OrderBy(f => f.Lastname).ToList();
}
catch (Exception ex)
{
string methodName = ex.TargetSite + ";\r\n" + ex.StackTrace;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btCleanFilter_Click(object sender, EventArgs e)
{
try
{
tbLastname.Clear();
tbGroup.Clear();
cbWorkers.SelectedIndex = -1;
cbHousings.SelectedIndex = -1;
cbTypePay.SelectedIndex = -1;
Filter(null, null, dtpBegin.Value, dtpEnd.Value, null, null, null);
}
catch (Exception ex)
{
var m = new System.Diagnostics.StackTrace(false).GetFrame(0).GetMethod();
string methodName = m.DeclaringType.ToString() + ";" + m.Name;
CurrentSession.ReportError(methodName, ex.Message);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
