private void FillDataGrid()
{
dataGrid.Rows.Clear();
using (MyAcademyEntities db = new MyAcademyEntities())
{
List <Employee> classrooms = db.Employees.ToList();
foreach (var item in classrooms)
{
if (item.Status_emp == true)
{
dataGrid.Rows.Add(
item.ID_emp,
item.Name_emp,
item.Surname_emp,
item.Phone_emp,
item.Email_emp,
db.Positions.Where(x => x.ID_pos == item.PositionID).FirstOrDefault().Name_pos,
item.Speciality_emp,
item.Salary,
item.StartTime.ToShortDateString(),
item.Status_emp
);
}
}
}
}
private bool Create()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Classroom Newdata = new Classroom();
if (GoCheck.IsEmpityOrMaxChar(textBoxName.Text) && GoCheck.IsStringValue(textBoxName.Text))
{
Newdata.Name_room = GoCheck.ClearValue;
}
else
{
return(false);
}
if (GoCheck.isInt(textBoxCapacity.Text))
{
Newdata.Capacity = Convert.ToInt32(GoCheck.ClearValue);
Newdata.Status_room = true;
}
else
{
return(false);
}
db.Classrooms.Add(Newdata);
return(GoCheck.isSave(db.SaveChanges()));
}
}
private bool Create()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Education_Program Newdata = new Education_Program();
if (GoCheck.IsEmpityOrMaxChar(textBoxName.Text) && GoCheck.IsStringValue(textBoxName.Text))
{
Newdata.Name_edu = GoCheck.ClearValue;
}
else
{
return(false);
}
if (GoCheck.isPrice(textBoxPrice.Text))
{
Newdata.Price = Convert.ToDecimal(GoCheck.ClearValue);
Newdata.Status_edu = true;
}
else
{
return(false);
}
db.Education_Program.Add(Newdata);
return(GoCheck.isSave(db.SaveChanges()));
}
}
private bool UpdateData()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Education_Program UpdatedData = db.Education_Program.Where(x => x.ID_edu == SelectedID).FirstOrDefault();
if (GoCheck.IsEmpityOrMaxChar(textBoxName.Text) && GoCheck.IsStringValue(textBoxName.Text))
{
UpdatedData.Name_edu = GoCheck.ClearValue;
}
else
{
return(false);
}
if (GoCheck.isPrice(textBoxPrice.Text))
{
UpdatedData.Price = Convert.ToDecimal(GoCheck.ClearValue);
}
else
{
return(false);
}
return(GoCheck.isSave(db.SaveChanges()));
}
}
private void FillComboPosition()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
comboBoxPosition.DataSource = db.Positions.Where(x => x.Status_pos == true).Select(x => x.Name_pos).ToList();
}
}
private bool UpdateData()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Models.Task UpdatedData = db.Tasks.Where(x => x.ID_task == SelectedID).FirstOrDefault();
if (GoCheck.IsEmpityOrMaxChar(textBoxName.Text) && GoCheck.IsStringValue(textBoxName.Text))
{
UpdatedData.Name_task = GoCheck.ClearValue;
}
else
{
return(false);
}
if (GoCheck.isDate(dateTimeDeadline.Value))
{
UpdatedData.DeadLine = dateTimeDeadline.Value;
}
else
{
return(false);
}
return(GoCheck.isSave(db.SaveChanges()));
}
}
private bool Create()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Models.Task Newdata = new Models.Task();
if (GoCheck.IsEmpityOrMaxChar(textBoxName.Text) && GoCheck.IsStringValue(textBoxName.Text))
{
Newdata.Name_task = GoCheck.ClearValue;
}
else
{
return(false);
}
if (GoCheck.isDate(dateTimeDeadline.Value))
{
Newdata.DeadLine = dateTimeDeadline.Value;
Newdata.Status_task = true;
}
else
{
return(false);
}
db.Tasks.Add(Newdata);
return(GoCheck.isSave(db.SaveChanges()));
}
}
private bool UpdateData()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Classroom UpdatedData = db.Classrooms.Where(x => x.ID_room == SelectedID).FirstOrDefault();
if (GoCheck.IsEmpityOrMaxChar(textBoxName.Text) && GoCheck.IsStringValue(textBoxName.Text))
{
UpdatedData.Name_room = GoCheck.ClearValue;
}
else
{
return(false);
}
if (GoCheck.isInt(textBoxCapacity.Text))
{
UpdatedData.Capacity = Convert.ToInt32(GoCheck.ClearValue);
}
else
{
return(false);
}
return(GoCheck.isSave(db.SaveChanges()));
}
}
private void MyAcademyApp_Activated(object sender, EventArgs e)
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
app_name.Text = db.Academy_info.FirstOrDefault().Name_academy;
}
}
private bool UpdateData()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Group UpdatedData = db.Groups.Where(x => x.ID_group == SelectedID).FirstOrDefault();
if (GoCheck.IsEmpityOrMaxChar(textBoxName.Text) && GoCheck.IsStringValue(textBoxName.Text))
{
UpdatedData.Name_group = GoCheck.ClearValue;
}
else
{
return(false);
}
if (!(comboBoxClass.SelectedItem == null))
{
UpdatedData.ClassroomID = db.Classrooms.Where(x => x.Status_room == true).ToList()[comboBoxClass.SelectedIndex].ID_room;
}
else
{
MessageBox.Show("Otaq seçin", "Diqqət!");
return(false);
}
if (!(comboBoxEdu.SelectedItem == null))
{
UpdatedData.EducationID = db.Education_Program.Where(x => x.Status_edu == true).ToList()[comboBoxEdu.SelectedIndex].ID_edu;
UpdatedData.Status_group = true;
}
else
{
MessageBox.Show("Təhsil seçin", "Diqqət!");
return(false);
}
return(GoCheck.isSave(db.SaveChanges()));
}
}
private void FillCombo()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
comboBoxClass.DataSource = db.Classrooms.Where(x => x.Status_room == true).Select(x => x.Name_room).ToList();
comboBoxEdu.DataSource = db.Education_Program.Where(x => x.Status_edu == true).Select(x => x.Name_edu).ToList();
}
}
public void FillTextBoxs()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Academy_info Ai = db.Academy_info.FirstOrDefault();
textBoxAcademyİnfo.Text = Ai.Name_academy;
textBoxAcademyPhone.Text = Ai.phone_academy;
textBoxAcademyEmail.Text = Ai.email_academy;
textBoxAcademyAdress.Text = Ai.Adress_academy;
}
}
private void DataGrid_RowHeaderMouseDoubleClick_1(object sender, DataGridViewCellMouseEventArgs e)
{
int SelectedRowID = Convert.ToInt32(dataGrid.Rows[e.RowIndex].Cells[0].Value);
using (MyAcademyEntities db = new MyAcademyEntities())
{
SelectedID = db.Positions.Where(x => x.ID_pos == SelectedRowID).FirstOrDefault().ID_pos;
textBoxPositionName.Text = db.Positions.Where(x => x.ID_pos == SelectedID).FirstOrDefault().Name_pos;
}
ChangeBtnToTrue();
}
private void DataGrid_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
int SelectedRowID = Convert.ToInt32(dataGrid.Rows[e.RowIndex].Cells[0].Value);
using (MyAcademyEntities db = new MyAcademyEntities())
{
SelectedID = db.Tasks.Where(x => x.ID_task == SelectedRowID).FirstOrDefault().ID_task;
textBoxName.Text = db.Tasks.Where(x => x.ID_task == SelectedID).FirstOrDefault().Name_task;
dateTimeDeadline.Value = db.Tasks.Where(x => x.ID_task == SelectedID).FirstOrDefault().DeadLine;
}
ChangeBtnToTrue();
}
private void AboutAcademy_Load(object sender, EventArgs e)
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Academy_info academy_Info = db.Academy_info.FirstOrDefault();
academyNameLabel.Text = academy_Info.Name_academy;
textPhone.Text = academy_Info.phone_academy;
textEmail.Text = academy_Info.email_academy;
textAdress.Text = academy_Info.Adress_academy;
this.academyNameLabel.Left = (this.Width - this.academyNameLabel.Width) / 2;
}
}
private void DataGrid_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
int SelectedRowID = Convert.ToInt32(dataGrid.Rows[e.RowIndex].Cells[0].Value);
using (MyAcademyEntities db = new MyAcademyEntities())
{
SelectedID = db.Classrooms.Where(x => x.ID_room == SelectedRowID).FirstOrDefault().ID_room;
textBoxName.Text = db.Classrooms.Where(x => x.ID_room == SelectedID).FirstOrDefault().Name_room;
textBoxCapacity.Text = db.Classrooms.Where(x => x.ID_room == SelectedID).FirstOrDefault().Capacity.ToString();
}
ChangeBtnToTrue();
}
private void DataGrid_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
int SelectedRowID = Convert.ToInt32(dataGrid.Rows[e.RowIndex].Cells[0].Value);
using (MyAcademyEntities db = new MyAcademyEntities())
{
SelectedID = db.Education_Program.Where(x => x.ID_edu == SelectedRowID).FirstOrDefault().ID_edu;
textBoxName.Text = db.Education_Program.Where(x => x.ID_edu == SelectedID).FirstOrDefault().Name_edu;
textBoxPrice.Text = db.Education_Program.Where(x => x.ID_edu == SelectedID).FirstOrDefault().Price.ToString();
}
ChangeBtnToTrue();
}
private void DataGrid_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
int SelectedRowID = Convert.ToInt32(dataGrid.Rows[e.RowIndex].Cells[0].Value);
using (MyAcademyEntities db = new MyAcademyEntities())
{
SelectedID = db.Groups.Where(x => x.ID_group == SelectedRowID).FirstOrDefault().ID_group;
textBoxName.Text = db.Groups.Where(x => x.ID_group == SelectedID).FirstOrDefault().Name_group;
comboBoxClass.SelectedIndex = db.Classrooms.Where(x => x.Status_room == true).ToList().FindIndex(x => x.ID_room == db.Groups.Where(y => y.ID_group == SelectedID).FirstOrDefault().ClassroomID);
comboBoxEdu.SelectedIndex = db.Education_Program.Where(x => x.Status_edu == true).ToList().FindIndex(x => x.ID_edu == db.Groups.Where(y => y.ID_group == SelectedID).FirstOrDefault().EducationID);
}
ChangeBtnToTrue();
}
private bool UpdateData()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Position UpdatedData = db.Positions.Where(x => x.ID_pos == SelectedID).FirstOrDefault();
if (GoCheck.IsEmpityOrMaxChar(textBoxPositionName.Text) && GoCheck.IsStringValue(textBoxPositionName.Text))
{
UpdatedData.Name_pos = GoCheck.ClearValue;
}
else
{
return(false);
}
return(GoCheck.isSave(db.SaveChanges()));
}
}
private void DataGrid_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
int SelectedRowID = Convert.ToInt32(dataGrid.Rows[e.RowIndex].Cells[0].Value);
using (MyAcademyEntities db = new MyAcademyEntities())
{
SelectedID = db.Employees.Where(x => x.ID_emp == SelectedRowID).FirstOrDefault().ID_emp;
textBoxName.Text = db.Employees.Where(x => x.ID_emp == SelectedID).FirstOrDefault().Name_emp;
textBoxSurname.Text = db.Employees.Where(x => x.ID_emp == SelectedID).FirstOrDefault().Surname_emp;
textBoxPhone.Text = db.Employees.Where(x => x.ID_emp == SelectedID).FirstOrDefault().Phone_emp;
textBoxEmail.Text = db.Employees.Where(x => x.ID_emp == SelectedID).FirstOrDefault().Email_emp;
comboBoxPosition.SelectedIndex = db.Positions.Where(x => x.Status_pos == true).ToList().FindIndex(x => x.ID_pos == db.Employees.Where(y => y.ID_emp == SelectedID).FirstOrDefault().PositionID);
textBoxSpeciality.Text = db.Employees.Where(x => x.ID_emp == SelectedID).FirstOrDefault().Speciality_emp;
textBoxSalary.Text = db.Employees.Where(x => x.ID_emp == SelectedID).FirstOrDefault().Salary.ToString();
dateTimeStartTime.Value = db.Employees.Where(x => x.ID_emp == SelectedID).FirstOrDefault().StartTime;
}
ChangeBtnToTrue();
}
public bool CreateAcademyInfo()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Academy_info Ai = new Academy_info();
if (GoCheck.IsEmpityOrMaxChar(textBoxAcademyName.Text) && GoCheck.IsStringValue(textBoxAcademyName.Text))
{
Ai.Name_academy = textBoxAcademyName.Text;
}
else
{
return(false);
}
if (GoCheck.IsEmpityOrMaxChar(textBoxAcademyPhone.Text) && GoCheck.IsPhoneValue(textBoxAcademyPhone.Text))
{
Ai.phone_academy = textBoxAcademyPhone.Text;
}
else
{
return(false);
}
if (GoCheck.IsEmpityOrMaxChar(textBoxAcademyEmail.Text) && GoCheck.IsEmailValue(textBoxAcademyEmail.Text))
{
Ai.email_academy = textBoxAcademyEmail.Text;
}
else
{
return(false);
}
if (GoCheck.IsEmpityOrMaxChar(textBoxAcademyAdress.Text, 150))
{
Ai.Adress_academy = textBoxAcademyAdress.Text;
Ai.Status_academy = true;
}
else
{
return(false);
}
db.Academy_info.Add(Ai);
return(GoCheck.isSave(db.SaveChanges()));
}
}
private bool Delete()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Classroom DeletedData = db.Classrooms.Where(x => x.ID_room == SelectedID).FirstOrDefault();
string Dialog = "Seçilmiş " + DeletedData.Name_room + " otağını silmək istəyirsiniz?";
DialogResult result = MessageBox.Show(Dialog, "Silmək Sorğusu!", MessageBoxButtons.YesNo);
if (DialogResult.Yes != result)
{
MessageBox.Show("Seçilmiş " + DeletedData.Name_room + " otağı Silinmədi.", "Silmək Sorğusuna cavab");
return(false);
}
else
{
DeletedData.Status_room = false;
return(GoCheck.isDeleted(db.SaveChanges()));
}
}
}
private void FillDataGrid()
{
dataGrid.Rows.Clear();
using (MyAcademyEntities db = new MyAcademyEntities())
{
List <Position> position = db.Positions.ToList();
foreach (var item in position)
{
if (item.Status_pos == true)
{
dataGrid.Rows.Add(
item.ID_pos,
item.Name_pos,
item.Status_pos
);
}
}
}
}
private void FillDataGrid()
{
dataGrid.Rows.Clear();
using (MyAcademyEntities db = new MyAcademyEntities())
{
List <Classroom> classrooms = db.Classrooms.ToList();
foreach (var item in classrooms)
{
if (item.Status_room == true)
{
dataGrid.Rows.Add(
item.ID_room,
item.Name_room,
item.Capacity,
item.Status_room
);
}
}
}
}
private bool Create()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Position Newdata = new Position();
if (GoCheck.IsEmpityOrMaxChar(textBoxPositionName.Text) && GoCheck.IsStringValue(textBoxPositionName.Text))
{
Newdata.Name_pos = GoCheck.ClearValue;
Newdata.Status_pos = true;
}
else
{
return(false);
}
db.Positions.Add(Newdata);
return(GoCheck.isSave(db.SaveChanges()));
}
}
private void FillDataGrid()
{
dataGrid.Rows.Clear();
using (MyAcademyEntities db = new MyAcademyEntities())
{
List <Models.Task> classrooms = db.Tasks.ToList();
foreach (var item in classrooms)
{
if (item.Status_task == true)
{
dataGrid.Rows.Add(
item.ID_task,
item.Name_task,
item.DeadLine.ToShortDateString(),
item.Status_task
);
}
}
}
}
private void FillDataGrid()
{
dataGrid.Rows.Clear();
using (MyAcademyEntities db = new MyAcademyEntities())
{
List <Education_Program> classrooms = db.Education_Program.ToList();
foreach (var item in classrooms)
{
if (item.Status_edu == true)
{
dataGrid.Rows.Add(
item.ID_edu,
item.Name_edu,
item.Price,
item.Status_edu
);
}
}
}
}
private void FillDataGrid()
{
dataGrid.Rows.Clear();
using (MyAcademyEntities db = new MyAcademyEntities())
{
List <Group> classrooms = db.Groups.ToList();
foreach (var item in classrooms)
{
if (item.Status_group == true)
{
dataGrid.Rows.Add(
item.ID_group,
item.Name_group,
db.Classrooms.Where(x => x.ID_room == item.ClassroomID).FirstOrDefault().Name_room,
db.Education_Program.Where(x => x.ID_edu == item.EducationID).FirstOrDefault().Name_edu,
db.Classrooms.Where(x => x.ID_room == item.ClassroomID).FirstOrDefault().Capacity,
item.Status_group
);
}
}
}
}
private bool UpdateData()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Employee UpdatedData = db.Employees.Where(x => x.ID_emp == SelectedID).FirstOrDefault();
if (GoCheck.IsEmpityOrMaxChar(textBoxName.Text) && GoCheck.IsStringValue(textBoxName.Text))
{
UpdatedData.Name_emp = GoCheck.ClearValue;
}
else
{
return(false);
}
if (GoCheck.IsEmpityOrMaxChar(textBoxSurname.Text) && GoCheck.IsStringValue(textBoxSurname.Text))
{
UpdatedData.Surname_emp = GoCheck.ClearValue;
}
else
{
return(false);
}
if (GoCheck.IsPhoneValue(textBoxPhone.Text))
{
UpdatedData.Phone_emp = GoCheck.ClearValue;
}
else
{
return(false);
}
if (GoCheck.IsEmailValue(textBoxEmail.Text))
{
UpdatedData.Email_emp = GoCheck.ClearValue;
}
else
{
return(false);
}
if (!(comboBoxPosition.SelectedItem == null))
{
UpdatedData.PositionID = db.Positions.Where(x => x.Status_pos == true).ToList()[comboBoxPosition.SelectedIndex].ID_pos;
}
else
{
MessageBox.Show("Vəzifə seçin", "Diqqət!");
return(false);
}
if (GoCheck.isPrice(textBoxSalary.Text))
{
UpdatedData.Salary = Convert.ToDecimal(GoCheck.ClearValue);
UpdatedData.StartTime = dateTimeStartTime.Value;
UpdatedData.Status_emp = true;
}
else
{
return(false);
}
if (GoCheck.IsEmpityOrMaxChar(textBoxSpeciality.Text) && GoCheck.IsStringValue(textBoxSpeciality.Text))
{
UpdatedData.Speciality_emp = GoCheck.ClearValue;
}
else
{
return(false);
}
return(GoCheck.isSave(db.SaveChanges()));
}
}
