/// <summary>
/// Adds a new record of job to the database.
/// </summary>
/// <param name="job1">The job to add</param>
/// <returns>string of an error or a string.Empty if the action is completed</returns>
public static string AddJob(ch_jobs job1)
{
string strSql1 = "SELECT COUNT(job_id) FROM ch_jobs WHERE job_name = '" + job1.job_Name + "'";
int num = Convert.ToInt32(Connect.MathAction(strSql1, "ch_jobs"));
if (num > 0)
{
return("התפקיד כבר קיים");
}
string strSql = "INSERT INTO ch_jobs(job_name) VALUES('" + job1.job_Name + "')";
Connect.DoAction(strSql, "ch_jobs");
return("");
}
/// <summary>
/// Update job using its id
/// </summary>
/// <param name="id">job_id statement</param>
/// <param name="newJob1">ch_jobs object</param>
public static string UpdateJobById(int id, ch_jobs newJob1)
{
string strSql1 = "SELECT COUNT(job_id) FROM ch_jobs WHERE job_name = '" + newJob1.job_Name + "' AND job_id <>" + id;
int num = Convert.ToInt32(Connect.MathAction(strSql1, "ch_jobs"));
if (num > 0)
{
return("התפקיד כבר קיים");
}
string strSql = "UPDATE ch_jobs SET job_name='" + newJob1.job_Name + "' WHERE job_id=" + id;
Connect.DoAction(strSql, "ch_jobs");
return("");
}
protected void btn_insert_job_Click(object sender, ImageClickEventArgs e)
{
ImageButton btn = (ImageButton)sender;
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
TextBox txt_insert_job_name = (TextBox)gvr.FindControl("txt_insert_job_name");
if (txt_insert_job_name.Text.Trim() != "")
{
if (Regex.IsMatch(txt_insert_job_name.Text.Trim(), @"^[א-תa-zA-Z''-'\s]{2,35}$"))
{
//all vars to one object
ch_jobs job1 = new ch_jobs();
job1.job_Name = txt_insert_job_name.Text.Trim();
string err = ch_jobsSvc.AddJob(job1);
if (err == "") //אם ההכנסה התבצע
{
lblErrGV.Text = "";
gvJobs.ShowFooter = false;
btnInsert.Enabled = true;
//Bind data to GridView
DataSet dsJobs = ch_jobsSvc.GetJobs();
GridViewSvc.GVBind(dsJobs, gvJobs);
}
else
{
lblErrGV.Text = err;
txt_insert_job_name.Text = "";
//Bind data to GridView
DataSet dsJobs = ch_jobsSvc.GetJobs();
GridViewSvc.GVBind(dsJobs, gvJobs);
}
}
else
{
lblErrGV.Text = "הכנס אותיות בין 2 ל 35 תווים";
}
}
else
{
lblErrGV.Text = "הכנס תפקיד";
}
}
protected void btn_update_job_Click(object sender, ImageClickEventArgs e)
{
ImageButton btn = (ImageButton)sender;
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
int job_id = Convert.ToInt32(gvJobs.DataKeys[gvr.RowIndex].Value.ToString());
TextBox txt_edit_job_name = (TextBox)gvr.FindControl("txt_edit_job_name");
if (txt_edit_job_name.Text.Trim() != "")
{
if (Regex.IsMatch(txt_edit_job_name.Text.Trim(), @"^[א-תa-zA-Z''-'\s]{2,35}$"))
{
//all vars to one object
ch_jobs job1 = new ch_jobs();
job1.job_Name = txt_edit_job_name.Text.Trim();
string err = ch_jobsSvc.UpdateJobById(job_id, job1);
if (err == "")//אם העדכון התבצע
{
lblErrGV.Text = string.Empty;
gvJobs.EditIndex = -1;
//Bind data to GridView
DataSet dsJobs = ch_jobsSvc.GetJobs();
GridViewSvc.GVBind(dsJobs, gvJobs);
}
else
{
lblErrGV.Text = err;
//Bind data to GridView
DataSet dsJobs = ch_jobsSvc.GetJobs();
GridViewSvc.GVBind(dsJobs, gvJobs);
}
}
else
{
lblErrGV.Text = "הכנס אותיות בין 2 ל 35 תווים";
}
}
else
{
lblErrGV.Text = "הכנס תפקיד";
}
}
