private bool UpdateTeacher()
{
int affectedRows = 0;
using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2())
{
int spId = (db.Educations.Where(a => a.Name == cbSpc.SelectedItem.ToString())).FirstOrDefault().Id;
T.Id = Convert.ToInt32(dvgTeacherss.CurrentRow.Cells[0].Value);
Modelss.Teacher Teachers = db.Teachers.Where(g => g.Id == T.Id).FirstOrDefault();
Teachers.Name = txtName.Text;
Teachers.Surname = txtSurname.Text;
Teachers.Email = txtEmail.Text;
Teachers.Phone = txtPhone.Text;
Teachers.SpecialityID = spId;
affectedRows = db.SaveChanges();
}
if (affectedRows > 0)
{
return(true);
}
else
{
return(false);
}
}
private bool DeleteTeacher()
{
int affectedRows = 0;
using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2())
{
T.Id = Convert.ToInt32(dvgTeacherss.CurrentRow.Cells[0].Value);
Modelss.Teacher Teachers = db.Teachers.Where(g => g.Id == T.Id).FirstOrDefault();
db.Teachers.Remove(Teachers);
affectedRows = db.SaveChanges();
}
if (affectedRows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void BtnTsave_Click(object sender, EventArgs e)
{
if (btnTdelete.Enabled)
{
if (!UpdateTeacher())
{
MessageBox.Show("Not Submited");
return;
}
MessageBox.Show("Submited");
Refresh();
return;
}
int affectedRow = 0;
using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2())
{
List <Modelss.Education> spcs = db.Educations.Where(a => a.Status == true).ToList();
List <Modelss.Teacher> teachers = db.Teachers.Where(t => t.Status == true).ToList();
Modelss.Teacher tt = new Modelss.Teacher();
//validation Name
string onlyLetters = @"^[a-zA-Z]+$";
Regex tname = new Regex(onlyLetters);
Match tnameMatch = tname.Match(txtName.Text);
if (!tnameMatch.Success)
{
MessageBox.Show("Adi duzgun Daxil edin");
txtName.Text = "";
return;
}
//validation Surname
Regex tsurname = new Regex(onlyLetters);
Match tsurnameMatch = tsurname.Match(txtSurname.Text);
if (!tsurnameMatch.Success)
{
MessageBox.Show("Soyadi duzgun Daxil edin");
txtSurname.Text = "";
return;
}
string emailPattern = @"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$";
//email validation
Regex mail = new Regex(emailPattern);
Match mailMatch = mail.Match(txtEmail.Text);
if (!mailMatch.Success)
{
MessageBox.Show("Emaili duzgin daxil edin...");
txtEmail.Text = "";
return;
}
//validation only numbers
String patternnum = "^[0-9]+(,[0-9]+)*$";
Regex salry = new Regex(patternnum);
Match numMatch = salry.Match(slry.Text);
if (!numMatch.Success)
{
MessageBox.Show("Yalniz ededler daxil edin");
slry.Text = "";
return;
}
dvgTeacherss.Rows.Add(ID, txtName.Text, txtSurname.Text, cbSpc.Text, txtEmail.Text, txtPhone.Text);
tt.Name = txtName.Text;
tt.Surname = txtSurname.Text;
int selected = cbSpc.SelectedIndex;
List <Modelss.Education> educations = db.Educations.ToList();
int catID = educations[selected].Id;
tt.SpecialityID = catID;
tt.Email = txtEmail.Text;
tt.Phone = txtPhone.Text;
tt.Salary = Convert.ToDouble(slry.Text);
tt.Status = true;
db.Teachers.Add(tt);
txtName.Text = txtSurname.Text = cbSpc.Text = txtEmail.Text = txtPhone.Text = slry.Text = "";
affectedRow = db.SaveChanges();
if (affectedRow > 0)
{
MessageBox.Show("Melumat qeyde alindi");
}
else
{
MessageBox.Show("xeta!!");
}
}
}
