protected void btn_insert_sc_Click(object sender, ImageClickEventArgs e)
{
ImageButton btn = (ImageButton)sender;
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
TextBox txt_insert_sc_symbol = (TextBox)gvr.FindControl("txt_insert_sc_symbol");
TextBox txt_insert_sc_name = (TextBox)gvr.FindControl("txt_insert_sc_name");
DropDownList txt_insert_ddlCities = (DropDownList)gvr.FindControl("txt_insert_ddlCities");
TextBox txt_insert_sc_address = (TextBox)gvr.FindControl("txt_insert_sc_address");
TextBox txt_insert_sc_telephone = (TextBox)gvr.FindControl("txt_insert_sc_telephone");
//all vars to one object
//add cty to db
ch_cities cty = new ch_cities();
cty.cty_Name = txt_insert_ddlCities.SelectedItem.Text;
//בדיקה אם קיים בWS
Cities.Cities ctyWs = new Cities.Cities();
if (!ctyWs.IsExist(cty.cty_Name))
{
lblErrGV.Text = "העיר כבר לא קיימת במאגר הנתונים הארצי";
return;
}
ch_citiesSvc.AddCity(cty);
//all vars to one object
ch_schools sc1 = new ch_schools();
sc1.sc_Symbol = txt_insert_sc_symbol.Text.Trim();
sc1.sc_Name = txt_insert_sc_name.Text.Trim();
sc1.cty_Id = ch_citiesSvc.GetIdByCtyName(cty.cty_Name);
sc1.sc_Address = txt_insert_sc_address.Text.Trim();
sc1.sc_Telephone = txt_insert_sc_telephone.Text.Trim();
if ((lblErrGV.Text = Validation(sc1)) != "")
{
return;
}
string err = ch_schoolsSvc.AddSchool(sc1);
if (err == "")//אם ההכנסה התבצע
{
lblErrGV.Text = "";
gvSchools.ShowFooter = false;
btnInsert.Enabled = true;
//Bind data to GridView
gvBind();
}
else
{
lblErrGV.Text = err;
txt_insert_sc_name.Text = "";
//Bind data to GridView
gvBind();
}
}
protected void btn_update_sc_Click(object sender, ImageClickEventArgs e)
{
ImageButton btn = (ImageButton)sender;
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
int sc_id = Convert.ToInt32(gvSchools.DataKeys[gvr.RowIndex].Value.ToString());
TextBox txt_edit_sc_symbol = (TextBox)gvr.FindControl("txt_edit_sc_symbol");
TextBox txt_edit_sc_name = (TextBox)gvr.FindControl("txt_edit_sc_name");
DropDownList txt_edit_ddlCities = (DropDownList)gvr.FindControl("txt_edit_ddlCities");
TextBox txt_edit_sc_address = (TextBox)gvr.FindControl("txt_edit_sc_address");
TextBox txt_edit_sc_telephone = (TextBox)gvr.FindControl("txt_edit_sc_telephone");
//all vars to one object
//add cty to db
ch_cities cty = new ch_cities();
cty.cty_Name = txt_edit_ddlCities.SelectedItem.Text;
//בדיקה אם קיים בWS
Cities.Cities ctyWs = new Cities.Cities();
if (!ctyWs.IsExist(cty.cty_Name))
{
lblErrGV.Text = "העיר כבר לא קיימת במאגר הנתונים הארצי";
return;
}
ch_citiesSvc.AddCity(cty);
//all vars to one object
ch_schools sc1 = new ch_schools();
sc1.sc_Symbol = txt_edit_sc_symbol.Text.Trim();
sc1.sc_Name = txt_edit_sc_name.Text.Trim();
sc1.cty_Id = ch_citiesSvc.GetIdByCtyName(cty.cty_Name);
sc1.sc_Address = txt_edit_sc_address.Text.Trim();
sc1.sc_Telephone = txt_edit_sc_telephone.Text.Trim();
if ((lblErrGV.Text = Validation(sc1)) == "")
{
string err = ch_schoolsSvc.UpdateSchoolById(sc_id, sc1);
if (err == "")//אם העדכון התבצע
{
lblErrGV.Text = string.Empty;
gvSchools.EditIndex = -1;
//Bind data to GridView
gvBind();
}
else
{
lblErrGV.Text = err;
//Bind data to GridView
gvBind();
}
}
}
/// <summary>
/// Add a new ch_schools record to the database
/// </summary>
/// <param name="sc1">a new school you want to add</param>
/// <returns>string of an error or a string.Empty if the action is completed</returns>
public static string AddSchool(ch_schools sc1)
{
string strSql1 = "SELECT COUNT(sc_id) FROM ch_schools WHERE sc_symbol = '" + sc1.sc_Symbol + "'";
int num = Convert.ToInt32(Connect.MathAction(strSql1, "ch_schools"));
if (num > 0)
{
return("בית ספר כבר קיים");
}
string strSql = "INSERT INTO ch_schools(sc_name, sc_symbol, cty_id, sc_address, sc_telephone) VALUES('" + sc1.sc_Name + "', '" + sc1.sc_Symbol + "', " + sc1.cty_Id + ", '" + sc1.sc_Address + "', '" + sc1.sc_Telephone + "')";
Connect.DoAction(strSql, "ch_schools");
return("");
}
/// <summary>
/// Update a record of ch_schools using its id
/// </summary>
/// <param name="id">sc_id statement</param>
/// <param name="newSchool1">ch_schools object</param>
public static string UpdateSchoolById(int id, ch_schools newSchool1)
{
string strSql1 = "SELECT COUNT(sc_id) FROM ch_schools WHERE sc_symbol = '" + newSchool1.sc_Symbol + "' AND sc_id <> " + id;
int num = Convert.ToInt32(Connect.MathAction(strSql1, "ch_schools"));
if (num > 0)
{
return("בית ספר כבר קיים");
}
string strSql = "UPDATE ch_schools SET sc_name='" + newSchool1.sc_Name + "', sc_symbol='" + newSchool1.sc_Symbol + "', cty_id=" + newSchool1.cty_Id + ", sc_address='" + newSchool1.sc_Address + "', sc_telephone='" + newSchool1.sc_Telephone + "' WHERE sc_id=" + id;
Connect.DoAction(strSql, "ch_schools");
return("");
}
public string Validation(ch_schools sc1)
{
if (sc1.sc_Symbol == "")
{
return("הכנס סמל מוסד");
}
if (!Regex.IsMatch(sc1.sc_Symbol, "^[0-9]{6}$"))
{
return("סמל מוסד לא תקין");
}
if (sc1.sc_Name == "")
{
return("הכנס שם בית ספר");
}
if (!Regex.IsMatch(sc1.sc_Name, @"^[א-תa-zA-z\s-]{2,35}$"))
{
return("שם בית ספר לא תקין");
}
if (sc1.cty_Id == -1)
{
return("הכנס עיר");
}
if (sc1.sc_Address == "")
{
return("הכנס כתובת");
}
if (!Regex.IsMatch(sc1.sc_Address, @"^[א-תa-zA-z0-9\s-,]{2,35}$"))
{
return("כתובת לא תקינה");
}
if (sc1.sc_Telephone == "")
{
return("הכנס טלפון");
}
if (!Regex.IsMatch(sc1.sc_Telephone, @"^0\d([\d]{0,1})([-]{0,1})\d{7}$"))
{
return("טלפון לא תקין");
}
return("");
}
