public static int SaveSkills(LIVEX.UserControls.AddTeacher teacher_form_values, int teacherID)
{
livexEntities context = new livexEntities();
//List<teacher_skills> lts = new List<teacher_skills>();
List <int> skID = new List <int>();
if (teacher_form_values.chkTOEFL.IsChecked == true)
{
skID.Add(1);
}
if (teacher_form_values.chkExp.IsChecked == true)
{
skID.Add(2);
}
if (teacher_form_values.chkTraining.IsChecked == true)
{
skID.Add(3);
}
if (teacher_form_values.chkSimilar.IsChecked == true)
{
skID.Add(4);
}
foreach (int s in skID)
{
teacher_skills ts = new teacher_skills();
ts.teacherID = teacherID;
ts.skillID = s;
context.teacher_skills.Add(ts);
}
int result = context.SaveChanges();
return(result);
}
/// <summary>
/// this function creates a new teacher in teachers's table and also adds the list of skills into skill's table
/// </summary>
/// <param name="teacher_form_values"></param>
/// <param name="skills_Values"></param>
/// <returns>0-if the DB was updated successfully 1-if there was an exception</returns>
public static int SaveTeacher(LIVEX.UserControls.AddTeacher teacher_form_values, int[] skills_Values)
{
livexEntities context = new livexEntities();
teacher teacher_ = new teacher();
int t_sSaved = 0;
int result = 0;
//int maxTeacherID = context.teacher.Count();
//int maxTeacher_skillID = context.teacher_skills.Count();
//teacher_.idteacher = maxTeacherID + 1;
teacher_.teacher_names = teacher_form_values.txtNewTeacherName.Text;
teacher_.teacher_lastname = teacher_form_values.txtNewTeacherApellidos.Text;
teacher_.RFC = teacher_form_values.txtTeacherRFC.Text;
teacher_.CURP = teacher_form_values.txtTeacherCURP.Text;
teacher_.phone = teacher_form_values.txtAddressPhone.Text;
teacher_.celphone = teacher_form_values.txtCelPhone.Text;
teacher_.email = teacher_form_values.txtEmail.Text;
teacher_.birthday = teacher_form_values.dpBirthday.Text;
teacher_.street_address = teacher_form_values.txtAddress.Text;
teacher_.neighborhood = teacher_form_values.txtNeighbordhood.Text;
teacher_.zip_code = teacher_form_values.txtZipCode.Text;
teacher_.state = teacher_form_values.txtState.Text;
teacher_.sub_state = teacher_form_values.txtSubState.Text;
teacher_.emergency_contact_name = teacher_form_values.txtEmergencyName.Text;
teacher_.emergency_contact_number = teacher_form_values.txtEmergencyPhone.Text;
teacher_.start_date = teacher_form_values.dpStartDate.Text;
teacher_.uid = teacher_form_values.txtUID.Text;
if (teacher_form_values.imgTeacher.ImageSource != null)
{
teacher_.picture = teacher_form_values.imgTeacher.ImageSource.ToString();
}
else
{
teacher_.picture = "";
}
if (teacher_form_values.rbtnTeacherFemenio.IsChecked == true)//Femenino
{
teacher_.teacher_gender = "F";
}
else if (teacher_form_values.rbtnTeacherMasculino.IsChecked == true)//Masculino
{
teacher_.teacher_gender = "M";
}
teacher_.salary_base = Int32.Parse(teacher_form_values.txtSalarioBase.Text);
if (teacher_form_values.rbtnIngles.IsChecked == true)//Ingles
{
teacher_.language = "Ingles";
}
else if (teacher_form_values.rbtnFrances.IsChecked == true)//Frances
{
teacher_.language = "Frances";
}
for (int i = 0; i < skills_Values.Count(); i++)
{
if (skills_Values[i] == 1)
{
teacher_skills teacher_Skill = new teacher_skills();
teacher_Skill.skillID = i + 1;
teacher_Skill.teacherID = teacher_.idteacher;
teacher_Skill.teacher = teacher_;
teacher_.teacher_skills.Add(teacher_Skill);
//context.teacher_skills.Add(teacher_Skill);
//t_sSaved = context.SaveChanges();
}
}
context.teacher.Add(teacher_);
int teachersaved = context.SaveChanges();
//if (teachersaved > 0)
//{
// //teacher_Skill.idteacher_skills = maxTeacher_skillID + 1;
// teacher_Skill.teacherID = teacher_.idteacher;
// for(int i=0; i<skills_Values.Count();i++)
// {
// if (skills_Values[i] == 1)
// {
// teacher_Skill.skillID = i+1;
// context.teacher_skills.Add(teacher_Skill);
// t_sSaved = context.SaveChanges();
// }
// }
//}
//if (t_sSaved > 0 && teachersaved > 0)
// result = 0;
//else
// result = -1;
return(result);
}
public static int SaveEditTeacher(LIVEX.UserControls.AddTeacher teacher_form_values, int teacherID)
{
livexEntities context = new livexEntities();
teacher t = new teacher();
bool[] skills = new bool[4];
List <teacher_skills> sl = new List <teacher_skills>();
int result = 0;
int resultS = 0;
t = context.teacher.FirstOrDefault(x => x.idteacher == teacherID);
//sl = context.teacher_skills.Where(x => x.teacherID == teacherID).ToList();
//foreach (teacher_skills s in sl)
foreach (teacher_skills s in t.teacher_skills)
{
switch (s.skillID)
{
case 1:
skills[0] = true;
break;
case 2:
skills[1] = true;
break;
case 3:
skills[2] = true;
break;
case 4:
skills[3] = true;
break;
}
}
if (teacher_form_values.chkTOEFL.IsChecked == true)
{
if (!skills[0])
{
teacher_skills ts = new teacher_skills();
ts.skillID = 1;
ts.teacher = t;
t.teacher_skills.Add(ts);
}
}
if (teacher_form_values.chkExp.IsChecked == true)
{
if (!skills[1])
{
teacher_skills ts = new teacher_skills();
ts.skillID = 2;
ts.teacher = t;
t.teacher_skills.Add(ts);
}
}
if (teacher_form_values.chkTraining.IsChecked == true)
{
if (!skills[2])
{
teacher_skills ts = new teacher_skills();
ts.skillID = 3;
ts.teacher = t;
t.teacher_skills.Add(ts);
}
}
if (teacher_form_values.chkSimilar.IsChecked == true)
{
if (!skills[3])
{
teacher_skills ts = new teacher_skills();
ts.skillID = 4;
ts.teacher = t;
t.teacher_skills.Add(ts);
}
}
t.teacher_names = teacher_form_values.txtNewTeacherName.Text;
t.teacher_lastname = teacher_form_values.txtNewTeacherApellidos.Text;
t.RFC = teacher_form_values.txtTeacherRFC.Text;
t.CURP = teacher_form_values.txtTeacherCURP.Text;
t.phone = teacher_form_values.txtAddressPhone.Text;
t.celphone = teacher_form_values.txtCelPhone.Text;
t.email = teacher_form_values.txtEmail.Text;
t.birthday = teacher_form_values.dpBirthday.Text;
t.street_address = teacher_form_values.txtAddress.Text;
t.neighborhood = teacher_form_values.txtNeighbordhood.Text;
t.zip_code = teacher_form_values.txtZipCode.Text;
t.state = teacher_form_values.txtState.Text;
t.sub_state = teacher_form_values.txtSubState.Text;
t.emergency_contact_name = teacher_form_values.txtEmergencyName.Text;
t.emergency_contact_number = teacher_form_values.txtEmergencyPhone.Text;
t.start_date = teacher_form_values.dpStartDate.Text;
t.uid = teacher_form_values.txtUID.Text;
if (teacher_form_values.imgTeacher.ImageSource != null)
{
t.picture = teacher_form_values.imgTeacher.ImageSource.ToString();
}
else
{
t.picture = "";
}
if (teacher_form_values.rbtnTeacherFemenio.IsChecked == true)
{
t.teacher_gender = "F";
}
else
{
t.teacher_gender = "M";
}
if (teacher_form_values.rbtnIngles.IsChecked == true)
{
t.language = "Ingles";
}
else
{
t.language = "Frances";
}
t.salary_base = Int32.Parse(teacher_form_values.txtSalarioBase.Text);
int resultT = context.SaveChanges();
//if(resultT>=0)
//{
// resultS = SaveSkills(teacher_form_values,teacherID);
//}
if (resultS >= 0 && resultT >= 0)
{
result = 0;
}
else
{
result = -1;
}
return(result);
}
