/* 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(); }