private void UpdateBtn_Click(object sender, EventArgs e)
{
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
if (ValidateChildren())
{
if (itemid != 0)
{
var Curritem = db.Education_Programs.Where(p => itemid == p.Id).First();
Curritem.Name = EPNameTxt.Text;
Curritem.Price = Convert.ToInt32(EPPriceTxt.Text);
MessageBox.Show("Program Updated");
SaveBtn.Enabled = true;
DeleteBtn.Enabled = true;
ResetInputs();
db.SaveChanges();
}
else
{
MessageBox.Show("Program could not be updated");
return;
}
}
else
{
return;
}
if (SaveBtn.Enabled == true)
{
UpdateBtn.Enabled = false;
}
}
dgvPrograms.Rows.Clear();
ShowPrograms();
}
private void DeleteProgram()
{
if (dgvPrograms.CurrentRow.Index > -1)
{
int affectedRows = 0;
int itemid = (int)dgvPrograms.SelectedRows[0].Cells[0].Value;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var program = db.Education_Programs.Where(ep => ep.Id == itemid).FirstOrDefault();
program.Status = false;
affectedRows = db.SaveChanges();
}
if (!(affectedRows > 0))
{
MessageBox.Show("program deleted");
dgvPrograms.Rows.Clear();
}
return;
}
else
{
MessageBox.Show("Choose program firstly");
}
return;
}
private void UpdateBtn_Click(object sender, EventArgs e)
{
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
if (ValidateChildren())
{
if (itemId != 0)
{
var classroom = db.Classrooms.Where(t => itemId == t.Id).First();
classroom.Name = ClassroomTxt.Text;
classroom.Capacity = Convert.ToInt32(ClassCapTxt.Text);
MessageBox.Show("Classroom Updated");
SaveBtn.Enabled = true;
DeleteBtn.Enabled = true;
ClearInputs();
db.SaveChanges();
}
else
{
MessageBox.Show("Classroom could not be updated");
return;
}
}
else
{
MessageBox.Show("Please fill the form");
return;
}
if (SaveBtn.Enabled == true)
{
UpdateBtn.Enabled = false;
}
}
ShowClassrooms();
}
private void CreatePosition()
{
int affectedrows = 0;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
Position NewPos = new Position
{
Name = PositionTxt.Text,
Status = true
};
db.Positions.Add(NewPos);
affectedrows = db.SaveChanges();
}
if (affectedrows > 0)
{
MessageBox.Show("Position created");
ResetInputs();
dgvPosition.Rows.Clear();
}
else
{
MessageBox.Show("Position could not be created");
return;
}
}
private void DeleteBtn_Click(object sender, EventArgs e)
{
if (dgvClassroom.CurrentRow.Index > -1)
{
int affectedRows = 0;
int classId = (int)dgvClassroom.SelectedRows[0].Cells[0].Value;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var user = db.Classrooms.Where(c => c.Id == classId).FirstOrDefault();
user.Status = false;
affectedRows = db.SaveChanges();
}
if (!(affectedRows > 0))
{
MessageBox.Show("Classroom could not be deleted");
}
else
{
MessageBox.Show("Classroom deleted");
ShowClassrooms();
}
}
else
{
MessageBox.Show("Choose classroom firstly");
}
}
private void UpdateBtn_Click(object sender, EventArgs e)
{
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
if (ValidateChildren())
{
if (PosId != 0)
{
var CurrPosition = db.Positions.Where(p => PosId == p.Id).First();
CurrPosition.Name = PositionTxt.Text;
MessageBox.Show("Position Updated");
SaveBtn.Enabled = true;
DeleteBtn.Enabled = true;
ResetInputs();
db.SaveChanges();
}
else
{
MessageBox.Show("Position could not be updated");
return;
}
}
else
{
return;
}
if (SaveBtn.Enabled == true)
{
UpdateBtn.Enabled = false;
}
}
dgvPosition.Rows.Clear();
FillPositions();
}
private void CreateEducationProgram()
{
int affectedrows = 0;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
Education_Program EP = new Education_Program
{
Name = EPNameTxt.Text,
Price = Convert.ToInt32(EPPriceTxt.Text),
Status = true
};
db.Education_Programs.Add(EP);
affectedrows = db.SaveChanges();
}
if (affectedrows > 0)
{
MessageBox.Show("Program created");
ResetInputs();
dgvPrograms.Rows.Clear();
}
else
{
MessageBox.Show("Program could not be created");
return;
}
}
private void DeletePosition()
{
if (dgvPosition.CurrentRow.Index > -1)
{
int affectedRows = 0;
int userid = (int)dgvPosition.SelectedRows[0].Cells[0].Value;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var user = db.Positions.Where(t => t.Id == userid).FirstOrDefault();
user.Status = false;
affectedRows = db.SaveChanges();
}
if (!(affectedRows > 0))
{
MessageBox.Show("Position deleted");
dgvPosition.Rows.Clear();
}
return;
}
else
{
MessageBox.Show("Choose position firstly");
return;
}
}
private bool CreateTeacher()
{
int affectedRows = 0;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
Teacher newTea = new Teacher
{
Name = TNameTxt.Text,
Surname = TSurnameTxt.Text,
Speciality = (int)TSpecialityCmb.SelectedValue,
Email = TEmailTxt.Text,
Phone = TPhoneTxt.Text,
Status = true
};
db.Teachers.Add(newTea);
affectedRows = db.SaveChanges();
}
if (affectedRows > 0)
{
MessageBox.Show("Teacher created");
ResetInputs();
return(true);
}
else
{
MessageBox.Show("Teacher could not be created");
return(false);
}
}
private void SignInBtn_Click(object sender, EventArgs e)
{
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
//Session sess = new Session();
if (ValidateChildren())
{
List <User> allUsers = db.Users.ToList();
if (allUsers.Any(u => u.Email == emailTxt.Text.Trim().ToLower() && u.Password == passwordTxt.Text.Trim()))
{
var user = allUsers.Find(u => u.Email == emailTxt.Text.Trim().ToLower() && u.Password == passwordTxt.Text.Trim());
Session.UserRole = user.RoleId;
MainForm mf = new MainForm();
mf.Show();
Hide();
}
else
{
MessageBox.Show("This user does not exist.Please register");
}
}
else
{
MessageBox.Show("Fill the form");
}
}
}
private void ShowGroups()
{
dgvGroups.Rows.Clear();
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var allgroups = db.Groups.Where(g => g.Status == true).ToList();
var Classrooms = db.Classrooms.Where(c => c.Status == true).ToList();;
var Teachers = db.Teachers.Where(c => c.Status == true).ToList();
var Employees = db.Employees.Where(c => c.Status == true).ToList();
var Programs = db.Education_Programs.Where(c => c.Status == true).ToList();
foreach (var item in allgroups)
{
var list = Classrooms.Where(a => a.Id == item.ClasroomId);
string classroomname = "";
foreach (var classroom in list)
{
classroom.Name = classroomname;
}
dgvGroups.Rows.Add(
item.Id,
item.Name,
classroomname,
item.TeacherId,
item.MentorId,
item.Capacity,
item.EducationId
);
}
}
}
private void FillPrograms()
{
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var data = db.Education_Programs.Select(x => new { x.Name, x.Id }).ToList();
GrEducCmb.DisplayMember = "Name";
GrEducCmb.ValueMember = "Id";
GrEducCmb.DataSource = data.ToList();
}
}
private void FillClassrooms()
{
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var data = db.Classrooms.Select(x => new { x.Name, x.Id }).ToList();
GrClassCmb.DisplayMember = "Name";
GrClassCmb.ValueMember = "Id";
GrClassCmb.DataSource = data.ToList();
}
}
private void FillMentors()
{
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var data = db.Employees.Where(e => e.PositionId == 7).Select(x => new { x.Name, x.Id }).ToList();
GrMentorCmb.DisplayMember = "Name";
GrMentorCmb.ValueMember = "Id";
GrMentorCmb.DataSource = data.ToList();
}
}
private void RegBtn_Click(object sender, EventArgs e)
{
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
List <User> allusers = db.Users.ToList();
if (Pass2Reg.Text == PassReg.Text)
{
if (ValidateChildren())
{
foreach (var item in allusers)
{
if (item.Email == EmailTxtReg.Text.ToLower())
{
MessageBox.Show("This user is already created");
return;
}
}
if (ChooseRole() != 0)
{
User newuser = new User
{
Email = EmailTxtReg.Text,
Password = PassReg.Text,
RoleId = ChooseRole()
};
db.Users.Add(newuser);
db.SaveChanges();
MessageBox.Show("User created");
MainForm mf = new MainForm();
mf.Show();
Hide();
}
else
{
MessageBox.Show("Choose one them below");
return;
}
}
else
{
MessageBox.Show("Could not create user");
}
}
else
{
MessageBox.Show("Passwords are not matching");
return;
}
}
}
private void ShowTeachers()
{
dgvTeachers.Rows.Clear();
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
List <Teacher> teachers = db.Teachers.Where(t => t.Status == true).ToList();
List <Models.Group> groups = db.Groups.Where(g => g.Status == true).ToList();
List <Education_Program> specs = db.Education_Programs.Where(s => s.Status == true).ToList();
foreach (var teacher in teachers)
{
var TeacherGroups = teacher.Groups.Where(g =>
g.TeacherId == teacher.Id).ToList();
var TeacherSpecs = specs.Where(
e => e.Id == teacher.Speciality
);
string speciality = "";
string GroupsNames = "";
foreach (var group in TeacherGroups)
{
//Comma seperator
if (group != TeacherGroups[TeacherGroups.Count - 1])
{
GroupsNames += group.Name + ", ";
}
else
{
GroupsNames += group.Name;
}
}
foreach (var spec in TeacherSpecs)
{
speciality += spec.Name;
}
dgvTeachers.Rows.Add(teacher.Id,
teacher.Name,
teacher.Surname,
speciality,
teacher.Email,
teacher.Phone,
GroupsNames
);
}
}
}
private void FillPositions()
{
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var positionslist = db.Positions.Where(p => p.Status == true).ToList();
foreach (var item in positionslist)
{
dgvPosition.Rows.Add(
item.Id,
item.Name
);
}
}
}
private void dgvPosition_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
UpdateBtn.Enabled = true;
SaveBtn.Enabled = false;
DeleteBtn.Enabled = false;
if (dgvPosition.CurrentRow.Index > 0)
{
PosId = (int)dgvPosition.SelectedRows[0].Cells[0].Value;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var Currposition = db.Positions.Where(p => p.Id == PosId).FirstOrDefault();
PositionTxt.Text = Currposition.Name;
}
}
}
private void ShowClassrooms()
{
dgvClassroom.Rows.Clear();
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
List <Classroom> classrooms = db.Classrooms.Where(c => c.Status == true).ToList();
foreach (var item in classrooms)
{
dgvClassroom.Rows.Add(
item.Id,
item.Name,
item.Capacity);
}
}
}
private void dgvClassroom_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
UpdateBtn.Enabled = true;
SaveBtn.Enabled = false;
DeleteBtn.Enabled = false;
if (dgvClassroom.CurrentRow.Index > 0)
{
itemId = (int)dgvClassroom.SelectedRows[0].Cells[0].Value;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var Curritem = db.Classrooms.Where(p => p.Id == itemId).FirstOrDefault();
ClassroomTxt.Text = Curritem.Name;
ClassCapTxt.Text = Curritem.Capacity.ToString();
}
}
}
private void dgvPrograms_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
UpdateBtn.Enabled = true;
SaveBtn.Enabled = false;
DeleteBtn.Enabled = false;
if (dgvPrograms.CurrentRow.Index > 0)
{
itemid = (int)dgvPrograms.SelectedRows[0].Cells[0].Value;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var Curritem = db.Education_Programs.Where(p => p.Id == itemid).FirstOrDefault();
EPNameTxt.Text = Curritem.Name;
EPPriceTxt.Text = Curritem.Price.ToString();
}
}
}
private void ShowPrograms()
{
dgvPrograms.Rows.Clear();
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var positionslist = db.Education_Programs.Where(p => p.Status == true).ToList();
foreach (var item in positionslist)
{
dgvPrograms.Rows.Add(
item.Id,
item.Name,
item.Price
);
}
}
}
private void dgvTeachers_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DeleteBtn.Enabled = false;
UpdateBtn.Enabled = true;
SaveBtn.Enabled = false;
if (dgvTeachers.CurrentRow.Index > 0)
{
teacherid = (int)dgvTeachers.SelectedRows[0].Cells[0].Value;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var teacher = db.Teachers.Where(t => t.Id == teacherid).FirstOrDefault();
TNameTxt.Text = teacher.Name;
TSurnameTxt.Text = teacher.Surname;
TSpecialityCmb.Text = dgvTeachers.CurrentRow.Cells[3].Value.ToString();
TEmailTxt.Text = teacher.Email;
TPhoneTxt.Text = teacher.Phone;
}
}
}
private void MainForm_Load(object sender, EventArgs e)
{
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
List <Info> infolist = db.Infoes.ToList();
foreach (var item in infolist)
{
AcaName.Text = item.Name;
AcaAdress.Text = item.Adress;
AcaEmail.Text = item.Contemail;
}
}
if (Session.UserRole == 1)
{
teachersToolStripMenuItem.Enabled = false;
employeeToolStripMenuItem.Enabled = false;
positionToolStripMenuItem.Enabled = false;
}
}
private void NewClassroom()
{
int affectedrows = 0;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
Classroom classroom = new Classroom
{
Name = ClassroomTxt.Text,
Capacity = Convert.ToInt32(ClassCapTxt.Text),
Status = true
};
db.Classrooms.Add(classroom);
affectedrows = db.SaveChanges();
if (!(affectedrows > 0))
{
return;
}
}
}
private bool DeleteTeacher()
{
if (dgvTeachers.CurrentRow.Index > -1)
{
int affectedRows = 0;
int userid = (int)dgvTeachers.SelectedRows[0].Cells[0].Value;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
var user = db.Teachers.Where(t => t.Id == userid).FirstOrDefault();
user.Status = false;
affectedRows = db.SaveChanges();
}
if (!(affectedRows > 0))
{
MessageBox.Show("User deleted");
return(false);
}
return(true);
}
MessageBox.Show("Choose user firstly");
return(false);
}
private void UpdateBtn_Click(object sender, EventArgs e)
{
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
if (ValidateChildren())
{
if (teacherid != 0)
{
var teacher = db.Teachers.Where(t => teacherid == t.Id).First();
teacher.Name = TNameTxt.Text;
teacher.Surname = TSurnameTxt.Text;
teacher.Speciality = (int)TSpecialityCmb.SelectedValue;
teacher.Email = TEmailTxt.Text;
teacher.Phone = TPhoneTxt.Text;
MessageBox.Show("Teacher Updated");
SaveBtn.Enabled = true;
DeleteBtn.Enabled = true;
ResetInputs();
db.SaveChanges();
}
else
{
MessageBox.Show("Teacher could not be updated");
return;
}
}
else
{
MessageBox.Show("Please fill the form");
return;
}
if (SaveBtn.Enabled == true)
{
UpdateBtn.Enabled = false;
}
}
ShowTeachers();
}
