private void BtnDelete_Click(object sender, EventArgs e)
{
studId = (int)gridStudent[0, gridStudent.CurrentRow.Index].Value;
using (DB.Context db = new DB.Context())
{
DB.Student stud =
db.Students.Where(i => i.IdStudent == studId).FirstOrDefault();
var result = MessageBox.Show($"Вы хотите удалить студента {stud.FIO}?", "Внимание!",
MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (DialogResult.Yes == result)
{
db.Students.Remove(stud);
db.SaveChanges();
MessageBox.Show($"Вы успешно удалили студента {stud.FIO}!", "Внимание!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Удаление отменено!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
UpdateGrid();
ClearAll();
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
int prisutidId = (int)dbgridPrisut[0, dbgridPrisut.CurrentRow.Index].Value;
DateTime DatePrisut = datePickerToday.Value;
string prisut = "Да";
if (rbtnNo.Checked)
{
prisut = "Нет";
}
else if (rbtnYes.Checked)
{
prisut = "Да";
}
else if (rbtnOfficial.Checked)
{
prisut = "Предупредил";
}
using (DB.Context db = new DB.Context())
{
DB.TablePrisut prisup = db.TablePrisuts.Where(i => i.IdPrisut == prisutidId).FirstOrDefault();
prisup.Prisut = prisut;
prisup.Date = DatePrisut;
db.SaveChanges();
UpdateGrid();
}
}
private void BtnDelete_Click(object sender, EventArgs e)
{
int id = (int)dbgridTeacher[0, dbgridTeacher.CurrentRow.Index].Value;
string FIOtemp = txtFIO.Text.ToString();
string MobileTemp = txtMobile.Text.ToString();
string EmailTemp = txtEmail.Text.ToString();
using (DB.Context db = new DB.Context())
{
DB.Teacher teach = db.Teachers.Where(t => t.IdTeacher == id).FirstOrDefault();
var result = MessageBox.Show($"Вы хотите удалить {teach.FIO}?", "Внимание!",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (DialogResult.Yes == result)
{
db.Teachers.Remove(teach);
MessageBox.Show($"Вы успешно удалили {teach.FIO}?", "Внимание!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
db.SaveChanges();
UpdateGrid();
ClearAll();
}
}
}
private void CmbGroup_SelectedIndexChanged(object sender, EventArgs e)
{
using (DB.Context db = new DB.Context())
{
cmbFIO.DataSource = db.Students.Where(i => i.IdGroup == (int)cmbGroup.SelectedValue).ToList();
}
}
private void GridStudent_SelectionChanged(object sender, EventArgs e)
{
int id = (int)gridStudent[0, gridStudent.CurrentRow.Index].Value;
if (gridStudent.SelectedRows.Count > 0)
{
Program.row = gridStudent.SelectedRows[0].Index;
txtFIOStudent.Text = gridStudent[1, Program.row].Value.ToString();
txtAgeStudent.Text = gridStudent[2, Program.row].Value.ToString();
txtFIOMom.Text = gridStudent[3, Program.row].Value.ToString();
txtMobileMom.Text = gridStudent[4, Program.row].Value.ToString();
txtFIOFather.Text = gridStudent[6, Program.row].Value.ToString();
txtMobileFather.Text = gridStudent[7, Program.row].Value.ToString();
cmbGroups.SelectedValue = gridStudent[5, Program.row].Value;
using (DB.Context db = new DB.Context())
{
gridFather.DataSource =
gridMother.DataSource =
db.Students.Where(s => s.IdStudent == id).ToList();
}
}
else
{
Program.row = -1;
}
}
private void BtnInsert_Click(object sender, EventArgs e)
{
string FIOtemp = txtFIO.Text.ToString();
string MobileTemp = txtMobile.Text.ToString();
string EmailTemp = txtEmail.Text.ToString();
if (txtFIO.Text == "" || txtMobile.Text == "" || txtEmail.Text == "")
{
MessageBox.Show("Вы не заполнили все поля!", "Ошибка!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
using (DB.Context db = new DB.Context())
{
db.Teachers.Add(new DB.Teacher
{
FIO = FIOtemp,
MobilePhone = MobileTemp,
MailBox = EmailTemp
});
db.SaveChanges();
MessageBox.Show($"Вы успешно добавили {FIOtemp}!", "Внимание!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
UpdateGrid();
ClearAll();
}
}
}
void UpdateGrid()
{
using (DB.Context db = new DB.Context())
{
dbgridTeacher.DataSource = db.Teachers.ToList();
}
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
int id = (int)dbgridTeacher[0, dbgridTeacher.CurrentRow.Index].Value;
string FIOtemp = txtFIO.Text.ToString();
string MobileTemp = txtMobile.Text.ToString();
string EmailTemp = txtEmail.Text.ToString();
if (txtFIO.Text == "" || txtMobile.Text == "" || txtEmail.Text == "")
{
MessageBox.Show("Вы не заполнили все поля!", "Ошибка!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
using (DB.Context db = new DB.Context())
{
DB.Teacher teach = db.Teachers.Where(t => t.IdTeacher == id).FirstOrDefault();
teach.FIO = FIOtemp;
teach.MobilePhone = MobileTemp;
teach.MailBox = EmailTemp;
MessageBox.Show($"Вы успешно изменили данные учителя на {FIOtemp} {MobileTemp} {EmailTemp}",
"Внимание!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
db.SaveChanges();
UpdateGrid();
ClearAll();
}
}
}
void UpdateGrid()
{
using (DB.Context db = new DB.Context())
{
cmbFIOSearch.DataSource = db.Students.Where(s => s.IdGroup == (int)cmbGroup.SelectedValue).ToList();
cmbFIO.DataSource = db.Students.Where(s => s.IdGroup == (int)cmbGroup.SelectedValue).ToList();
dbgridPrisut.DataSource = db.TablePrisuts.Where(g => g.IdGroup == (int)cmbGroup.SelectedValue).ToList();
}
}
/* private void DbgridPrisut_SelectionChanged(object sender, EventArgs e)
* {
* int prisutidId = (int)dbgridPrisut[0, dbgridPrisut.CurrentRow.Index].Value;
* if (dbgridPrisut.SelectedRows.Count > 0)
* {
* Program.row = dbgridPrisut.SelectedRows[0].Index;
* datePickerToday.Value = (DateTime)dbgridPrisut[5, Program.row].Value;
* cmbFIO.SelectedValue = (int)dbgridPrisut[1, Program.row].Value;
* cmbGroup.SelectedValue = (int)dbgridPrisut[2, Program.row].Value;
*
* if (dbgridPrisut[6, Program.row].Value.ToString() == "Да")
* {
* rbtnYes.Checked = true;
* }
* else if (dbgridPrisut[6, Program.row].Value.ToString() == "Нет")
* {
* rbtnNo.Checked = true;
* }
* else
* {
* rbtnOfficial.Checked = true;
* }
* }
*/
private void BtnFIOSearch_Click(object sender, EventArgs e)
{
int IdStudent = (int)cmbFIOSearch.SelectedValue;
using (DB.Context db = new DB.Context())
{
dbgridPrisut.DataSource = db.TablePrisuts.Where(i => i.IdStudent == IdStudent).ToList();
}
}
private void GridStudent_SelectionChanged(object sender, EventArgs e)
{
using (DB.Context db = new DB.Context())
{
int id = (int)gridStudent[0, gridStudent.CurrentRow.Index].Value;
gridFather.DataSource =
gridMother.DataSource =
db.Students.Where(s => s.IdStudent == id).ToList();
}
}
void UpdateGrid()
{
using (DB.Context db = new DB.Context())
{
gridStudent.DataSource =
db.Students.ToList();
cmbGroups.DataSource =
db.Groups.ToList();
}
}
private void BtnDateSearch_Click(object sender, EventArgs e)
{
int idgroup = (int)cmbGroup.SelectedValue;
using (DB.Context db = new DB.Context())
{
dbgridPrisut.DataSource = db.TablePrisuts.Where
(i => (i.Date == TimePickerDateSearch.Value.Date) && (i.IdGroup == idgroup)).ToList();
}
}
public PayForm()
{
InitializeComponent();
using (DB.Context db = new DB.Context())
{
cmbGroup.DataSource = db.Groups.ToList();
cmbGroup.SelectedIndex = 0;
dbGridPay.DataSource = db.TablePays.ToList();
}
}
private void GridTeachers_SelectionChanged(object sender, EventArgs e)
{
int idteacher =
(int)gridTeachers[0, gridTeachers.CurrentRow.Index].Value;
using (DB.Context db = new DB.Context())
{
gridGroups.DataSource =
db.Groups.Where(i => i.IdTeacher == idteacher).ToList();
}
}
public StudentsFrom()
{
InitializeComponent();
LStatusDate.Text = GetDate.DateNow();
LStatusDayWeek.Text = GetDate.DayWeekNow();
DateTimer.Start();
using (DB.Context db = new DB.Context())
{
gridStudent.DataSource =
db.Students.ToList();
}
}
private void CmbGroup_SelectedIndexChanged(object sender, EventArgs e)
{
using (DB.Context db = new DB.Context())
{
cmbFIOSearch.DataSource = db.Students.Where(s => s.IdGroup ==
(int)cmbGroup.SelectedValue).ToList();
cmbFIO.DataSource = db.Students.Where(s => s.IdGroup ==
(int)cmbGroup.SelectedValue).ToList();
dbgridPrisut.DataSource = db.TablePrisuts.Where(g => g.IdGroup == (
int)cmbGroup.SelectedValue).ToList();
}
}
void UpdateGrid()
{
LStatusDate.Text = GetDate.DateNow();
LStatusDayWeek.Text = GetDate.DayWeekNow();
DateTimer.Start();
using (DB.Context db = new DB.Context())
{
gridGroup.DataSource =
db.Groups.ToList();
cmbTeacher.DataSource =
db.Teachers.ToList();
}
}
public TeacherForm()
{
InitializeComponent();
LStatusDate.Text = GetDate.DateNow();
LStatusDayWeek.Text = GetDate.DayWeekNow();
DateTimer.Start();
using (DB.Context db = new DB.Context())
{
gridTeachers.DataSource =
db.Teachers.ToList();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
int prisutidId = (int)dbgridPrisut[0, dbgridPrisut.CurrentRow.Index].Value;
using (DB.Context db = new DB.Context())
{
DB.TablePrisut prisdel = db.TablePrisuts.Where(i => i.IdPrisut == prisutidId).FirstOrDefault();
db.TablePrisuts.Remove(prisdel);
db.SaveChanges();
UpdateGrid();
}
}
private void BtnPayAdd_Click(object sender, EventArgs e)
{
DateTime DatePay = datePickerDatePay.Value;
DateTime DateStart = datePickerDateStart.Value;
int IdStudent = (int)cmbFIO.SelectedValue;
string TypePay = "Наличные";
string CountPay = "3000";
if (rbtnWithoutSale.Checked)
{
CountPay = "3000";
}
else if (rbtnWithSale.Checked)
{
CountPay = "2700";
}
if (rbtnCard.Checked)
{
TypePay = "Картой";
}
else if (rbtnToCard.Checked)
{
TypePay = "Перевод на карту";
}
else if (rbtnMoney.Checked)
{
TypePay = "Наличные";
}
using (DB.Context db = new DB.Context())
{
string FIO = db.Students.Where(f => f.IdStudent == IdStudent).FirstOrDefault().FIO;
db.TablePays.Add(new DB.TablePay
{
TypePay = TypePay,
CountPay = CountPay,
DatePay = DatePay,
DateStart = DateStart,
FIO = FIO,
IdStudent = IdStudent
});
db.SaveChanges();
MessageBox.Show($"Вы успешно добавили оплату для: {FIO}!", "Успешно!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
dbGridPay.DataSource = db.TablePays.ToList();
}
}
private void GridGroups_SelectionChanged(object sender, EventArgs e)
{
int idgroup =
(int)gridGroups[0, gridGroups.CurrentRow.Index].Value;
string message = "Всего студентов в группе: ";
using (DB.Context db = new DB.Context())
{
gridStudents.DataSource =
db.Students.Where(i => i.IdGroup == idgroup).ToList();
LStudentsCount.Text = message += db.Students.Where(i => i.IdGroup == idgroup).ToList().Count().ToString();
}
}
public PrisutForm()
{
InitializeComponent();
int idgroup = cmbGroup.SelectedIndex;
LStatusDate.Text = GetDate.DateNow();
LStatusDayWeek.Text = GetDate.DayWeekNow();
DateTimer.Start();
using (DB.Context db = new DB.Context())
{
cmbGroup.DataSource = db.Groups.ToList();
}
UpdateGrid();
}
private void BtnSearch_Click(object sender, EventArgs e)
{
string FIOsearch = txtFIOSearch.Text.ToString();
using (DB.Context db = new DB.Context())
{
int id = (int)gridStudent[0, gridStudent.CurrentRow.Index].Value;
gridStudent.DataSource =
db.Students.Where(f => f.FIO == FIOsearch).ToList();
gridFather.DataSource =
gridMother.DataSource =
db.Students.Where(s => s.IdStudent == id).ToList();
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
FIOstudentTemp = txtFIOStudent.Text.ToString();
AgeTemp = Int32.Parse(txtAgeStudent.Text);
FIOMotherTemp = txtFIOMom.Text.ToString();
MobileMomTemp = txtMobileMom.Text.ToString();
FIOFatherTemp = txtFIOFather.Text.ToString();
MobileFatherTemp = txtMobileFather.Text.ToString();
idgrouptemp = (int)cmbGroups.SelectedValue;
countMobileFather = txtMobileFather.Text.Count();
countMobileMom = txtMobileMom.Text.Count();
if (txtMobileFather.Text != "" || txtMobileFather.Text != "")
{
if (txtMobileFather.Text.Length != 10 || txtMobileMom.Text.Length != 10)
{
MessageBox.Show("Номер должен состояить из 10 цифр. Без разделителей и кода страны", "Ошибка"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
using (DB.Context db = new DB.Context())
{
db.Students.Add(new DB.Student
{
FIO = FIOstudentTemp,
Age = AgeTemp,
FIOMother = FIOMotherTemp,
NumberMother = MobileMomTemp,
FIOFather = FIOFatherTemp,
NumberFather = MobileFatherTemp,
IdGroup = idgrouptemp
});
db.SaveChanges();
MessageBox.Show($"Вы успешно добавили {FIOstudentTemp}!", "Внимание!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
UpdateGrid();
ClearAll();
}
}
}
}
private void BtnSearchFIO_Click(object sender, EventArgs e)
{
string FIOSearch = txtFIOSearch.Text.ToString();
int idteacher =
(int)gridTeachers[0, gridTeachers.CurrentRow.Index].Value;
using (DB.Context db = new DB.Context())
{
gridTeachers.DataSource =
db.Teachers.
Where(f => f.FIO == FIOSearch).ToList();
gridGroups.DataSource =
db.Groups.Where(i => i.IdTeacher == idteacher).ToList();
}
}
public AdUrlRedirects(IEnumerable <string> originalAdUrls)
{
using (var db = new DB.Context())
{
foreach (var url in originalAdUrls)
{
db.AdRedirectUrls_AddRedirectUrl(url);
}
var urls = db.AdRedirectUrls_GetRedirectUrls().ToList();
this.OriginalUrlsByGuid = urls
.ToDictionary(r => r.Ad_Guid.ToString("N"), r => r.Redirect_Url, StringComparer.OrdinalIgnoreCase);
this.GuidsByOriginalUrl = urls
.ToDictionary(r => r.Redirect_Url, r => r.Ad_Guid.ToString("N"), StringComparer.OrdinalIgnoreCase);
}
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
id = (int)gridGroup[0, gridGroup.CurrentRow.Index].Value;
GroupNameTemp = txtGroupName.Text.ToString();
daystart = PickerDay.Value;
teacherid = (int)cmbTeacher.SelectedValue;
if (rbtnEV3.Checked)
{
setNameTemp = "EV3";
}
else
{
setNameTemp = "WeDo";
}
if (GroupNameTemp == "" || teacherid < 0)
{
MessageBox.Show("Вы не заполнили все поля!", "Ошибка!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
using (DB.Context db = new DB.Context())
{
DB.Group group =
db.Groups.Where(i => i.IdGroup == id).FirstOrDefault();
group.GroupName = GroupNameTemp;
group.Day = daystart;
group.IdTeacher = teacherid;
group.SetName = setNameTemp;
db.SaveChanges();
MessageBox.Show($"Группа {GroupNameTemp} успешно обновлена!", "Внимание!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
UpdateGrid();
}
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
DateTime DatePrisut = datePickerToday.Value;
int IdStudent = (int)cmbFIO.SelectedValue;
string prisut = "Да";
int idgroup = (int)cmbGroup.SelectedValue;
if (rbtnNo.Checked)
{
prisut = "Нет";
}
else if (rbtnYes.Checked)
{
prisut = "Да";
}
else if (rbtnOfficial.Checked)
{
prisut = "Предупредил";
}
using (DB.Context db = new DB.Context())
{
string FIO = db.Students.Where(f => f.IdStudent == IdStudent).FirstOrDefault().FIO;
string groupname = db.Groups.Where(g => g.IdGroup == idgroup).FirstOrDefault().GroupName;
db.TablePrisuts.Add(new DB.TablePrisut
{
FIO = FIO,
GroupName = groupname,
Date = DatePrisut,
IdGroup = idgroup,
IdStudent = IdStudent,
Prisut = prisut
});
db.SaveChanges();
UpdateGrid();
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
GroupNameTemp = txtGroupName.Text.ToString();
daystart = PickerDay.Value;
teacherid = (int)cmbTeacher.SelectedValue;
if (rbtnEV3.Checked)
{
setNameTemp = "EV3";
}
else
{
setNameTemp = "WeDo";
}
if (GroupNameTemp == "" || teacherid < 0)
{
MessageBox.Show("Вы не заполнили все поля!", "Ошибка!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
using (DB.Context db = new DB.Context())
{
db.Groups.Add(new DB.Group
{
GroupName = GroupNameTemp,
Day = daystart,
IdTeacher = teacherid,
SetName = setNameTemp
});
db.SaveChanges();
MessageBox.Show($"Группа {GroupNameTemp} успешно добавлена!", "Внимание!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
UpdateGrid();
}
}
}
