public ActionResult Create([Bind(Include = "Id,Email,Password")] Login login)
{
if (ModelState.IsValid)
{
db.Logins.Add(login);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(login));
}
public ActionResult Create([Bind(Include = "Id,Header,Text")] News news)
{
if (ModelState.IsValid)
{
db.News.Add(news);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(news));
}
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 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 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 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 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 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 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 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 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();
}
