/* protected void Button2_Click1(object sender, EventArgs e)
* {
*
* }*/
protected void Button2_Click(object sender, EventArgs e)
{
string reqid = Request.QueryString["reqid"];
bal bl = new bal();
hrmanager cls = bl.rec(reqid);
TextBox1.Text = cls.appl_id.ToString();
//TextBox1.Text = "Hello";
TextBox2.Text = cls.job_desc;
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox17.Text = cls.req_id.ToString();
TextBox7.Text = cls.appstatus;
TextBox8.Text = cls.manager_name;
TextBox9.Text = cls.project_name;
TextBox10.Text = cls.period_month.ToString();
TextBox11.Text = cls.noof_vacancies.ToString();
TextBox12.Text = cls.skill;
TextBox13.Text = cls.pgm_languages.ToString();
TextBox14.Text = cls.exp_years.ToString();
TextBox15.Text = cls.desg;
TextBox16.Text = cls.dateapp.ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
hrmanager cls2 = new hrmanager();
cls2.appl_id = Convert.ToInt32(TextBox1.Text);
cls2.job_desc = TextBox2.Text;
cls2.min_qualification = TextBox3.Text;
cls2.pref_qualification = TextBox4.Text;
cls2.resp = TextBox5.Text;
cls2.req_id = Convert.ToInt32(TextBox17.Text);
cls2.appstatus = "inprogress";
cls2.manager_name = TextBox8.Text;
cls2.project_name = TextBox9.Text;
cls2.period_month = Convert.ToInt32(TextBox10.Text);
cls2.noof_vacancies = Convert.ToInt32(TextBox11.Text);
cls2.skill = TextBox12.Text;
cls2.pgm_languages = TextBox13.Text;
cls2.exp_years = Convert.ToInt32(TextBox14.Text);
cls2.desg = TextBox15.Text;
cls2.dateapp = TextBox16.Text;
dl.storeapp(cls2);
Label1.Text = TextBox4.Text;
/*hrmanager cls1 = new hrmanager();
* cls1.req_id = Convert.ToInt32(TextBox17.Text);
* cls1.appstatus = "inprogress";
*/
//dl.post(cls1);
}
protected void Button1_Click(object sender, EventArgs e)
{
hrmanager cls = new hrmanager();
cls.appl_id = Convert.ToInt32(TextBox1.Text);
cls.job_desc = TextBox2.Text;
cls.min_qualification = TextBox3.Text;
cls.pref_qualification = TextBox4.Text;
cls.resp = TextBox5.Text;
cls.req_id = Convert.ToInt32(TextBox17.Text);
cls.appstatus = TextBox7.Text;
cls.manager_name = TextBox8.Text;
cls.project_name = TextBox9.Text;
cls.period_month = Convert.ToInt32(TextBox10.Text);
cls.noof_vacancies = Convert.ToInt32(TextBox11.Text);
cls.skill = TextBox12.Text;
cls.pgm_languages = TextBox13.Text;
cls.exp_years = Convert.ToInt32(TextBox14.Text);
cls.desg = TextBox15.Text;
cls.dateapp = TextBox16.Text;
dal dl = new dal();
dl.storeapp(cls);
hrmanager cls1 = new hrmanager();
cls1.req_id = Convert.ToInt32(TextBox17.Text);
cls1.appstatus = TextBox7.Text;
Label1.Text = " Form pushed to database...";
}
public hrmanager rec(string req_id)
{
dal dl = new dal();
DataTable dt = dl.status();
hrmanager cls = new hrmanager();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i].ItemArray[8].ToString() == req_id)
{
//cls.appl_id = Convert.ToInt32(dt.Rows[i].ItemArray[0].ToString());
cls.appl_id = Convert.ToInt32(dt.Rows[i].ItemArray[8].ToString());;
cls.job_desc = dt.Rows[i].ItemArray[7].ToString();
//cls.min_qualification = dt.Rows[i].ItemArray[2].ToString();
//cls.pref_qualification = dt.Rows[i].ItemArray[3].ToString();
//cls.resp = dt.Rows[i].ItemArray[4].ToString();
cls.req_id = Convert.ToInt32(dt.Rows[i].ItemArray[8].ToString());
cls.appstatus = dt.Rows[i].ItemArray[9].ToString();
cls.manager_name = dt.Rows[i].ItemArray[0].ToString();
cls.project_name = dt.Rows[i].ItemArray[1].ToString();
cls.period_month = Convert.ToInt32(dt.Rows[i].ItemArray[2].ToString());
cls.noof_vacancies = Convert.ToInt32(dt.Rows[i].ItemArray[3].ToString());
cls.skill = dt.Rows[i].ItemArray[4].ToString();
cls.pgm_languages = dt.Rows[i].ItemArray[5].ToString();
cls.exp_years = Convert.ToInt32(dt.Rows[i].ItemArray[6].ToString());
cls.desg = dt.Rows[i].ItemArray[10].ToString();
cls.dateapp = dt.Rows[i].ItemArray[11].ToString();
}
}
return(cls);
}
public void storeapp(hrmanager cls)
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into application_table values(@job_desc,@min_qualification, @pref_qualification,@resp,@req_id,@appstatus,@manager_name,@project_name,@period_month,@noof_vacancies,@skill,@pgm_languages,@exp_years,@desg,@dateapp)", con);
//cmd.Parameters.AddWithValue("@appl_id", cls.appl_id);
cmd.Parameters.AddWithValue("@job_desc", cls.job_desc);
cmd.Parameters.AddWithValue("@min_qualification", cls.min_qualification);
cmd.Parameters.AddWithValue("@pref_qualification", cls.pref_qualification);
cmd.Parameters.AddWithValue("@resp", cls.resp);
cmd.Parameters.AddWithValue("@req_id", cls.req_id);
cmd.Parameters.AddWithValue("@appstatus", cls.appstatus);
cmd.Parameters.AddWithValue("@manager_name", cls.manager_name);
cmd.Parameters.AddWithValue("@project_name", cls.project_name);
cmd.Parameters.AddWithValue("@period_month", cls.period_month);
cmd.Parameters.AddWithValue("@noof_vacancies", cls.noof_vacancies);
cmd.Parameters.AddWithValue("@skill", cls.skill);
cmd.Parameters.AddWithValue("@pgm_languages", cls.pgm_languages);
cmd.Parameters.AddWithValue("@exp_years", cls.exp_years);
cmd.Parameters.AddWithValue("@desg", cls.desg);
cmd.Parameters.AddWithValue("@dateapp", cls.dateapp);
cmd.ExecuteNonQuery();
con.Close();
}
public void post(hrmanager status)
{
con.Open();
hrmanager cls1 = new hrmanager();
SqlCommand cmd = new SqlCommand("update request_table set application_status=@appstatus where request_id=@req_id", con);
cmd.Parameters.AddWithValue("@req_id", cls1.req_id);
cmd.Parameters.AddWithValue("@appstatus", cls1.appstatus);
cmd.ExecuteNonQuery();
con.Close();
}
