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 List <candpool> getrec1(string k)
{
dal dl = new dal();
DataTable dt = dl.dispdet();
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < 18; j++)
{
if (dt.Rows[i].ItemArray[j].ToString().Contains(k) == true)
{
candpool cls1 = new candpool();
cls1.cand_id = Convert.ToInt32(dt.Rows[i].ItemArray[0].ToString());
cls1.cand_name = dt.Rows[i].ItemArray[1].ToString();
cls1.skills = dt.Rows[i].ItemArray[2].ToString();
cls1.pgm_language = dt.Rows[i].ItemArray[3].ToString();
cls1.high_qualification = dt.Rows[i].ItemArray[4].ToString();
cls1.college = dt.Rows[i].ItemArray[5].ToString();
cls1.university = dt.Rows[i].ItemArray[6].ToString();
cls1.address = dt.Rows[i].ItemArray[7].ToString();
cls1.exp_years = Convert.ToInt32(dt.Rows[i].ItemArray[8].ToString());
cls1.notice_months = Convert.ToInt32(dt.Rows[i].ItemArray[9].ToString());
cls1.latest_company = dt.Rows[i].ItemArray[10].ToString();
cls1.latest_desg = dt.Rows[i].ItemArray[11].ToString();
cls1.curr_sal = Convert.ToInt32(dt.Rows[i].ItemArray[12].ToString());
cls1.reg_date = Convert.ToDateTime(dt.Rows[i].ItemArray[13].ToString());
cls1.age = Convert.ToInt32(dt.Rows[i].ItemArray[14].ToString());
cls1.dob = dt.Rows[i].ItemArray[15].ToString();
cls1.interview_date = dt.Rows[i].ItemArray[16].ToString();
//cls1.req_id = Convert.ToInt32(dt.Rows[i].ItemArray[17].ToString());
ls1.Add(cls1);
}
}
}
return(ls1);
}
public void candShortlister(int cand_id)
{
dal d = new dal();
d.candShortlisterDal(cand_id);
}