protected void filldata()
{
Candidate_pros pros = new Candidate_pros();
List <string> idetails = pros.getInterviewById(int_Id);
Employee_pros epros = new Employee_pros();
Label14.Text = epros.getPositionName(Int32.Parse(idetails[1]));
poid = Int32.Parse(idetails[1]);
Label16.Text = idetails[2];
Label18.Text = idetails[3];
Label20.Text = idetails[5];
Label22.Text = idetails[6];
Label29.Text = idetails[7];
Label26.Text = idetails[8];
if (Label22.Text.Equals("0"))
{
Label22.Text = "Not Done";
Button1.Visible = true;
}
if (Label29.Text.TrimEnd().Equals("NOT_DONE"))
{
Button2.Visible = true;
}
Account ac = new Account();
Label3.Text = ac.get_name(idetails[0]);
List <string> company = ac.getCompanyDetails(idetails[0]);
Label27.Text = company[0];
Label28.Text = company[1];
TextBox1.Text = company[2];
Label7.Text = company[3];
}
protected void loadInterviews()
{
Employee_pros pros = new Employee_pros();
List <List <string> > det = pros.getInterviewDetails(Session["user"].ToString().TrimEnd());
int pid = 0;
for (int i = 0; i < det.Count; i++)
{
if (i > 4)
{
return;
}
for (int j = 0; j < 4; j++)
{
if (j == 1)
{
Table1.Rows[i + 1].Cells[j].Text = pros.getPositionName(Int32.Parse(det[i][j]));
if (i == 0)
{
pid = Int32.Parse(det[i][j]);
}
}
else
{
Table1.Rows[i + 1].Cells[j].Text = det[i][j];
}
}
}
Label5.Text = Table1.Rows[1].Cells[0].Text;
Label6.Text = Table1.Rows[1].Cells[1].Text;
intid = pros.getInterviewId(Session["user"].ToString().TrimEnd(), Label5.Text, pid);
Session["intid"] = intid;
}
protected void fillform()
{
List <string> answer = new List <string>();
List <string> question = new List <string>();
Employee_pros pros = new Employee_pros();
answer = pros.getFormAnswers(int_id);
if (answer.Count < 1)
{
return;
}
int formId = Int32.Parse(answer[0]);
question = pros.getFormQuestion(formId);
for (int i = 0; i < question.Count; i++)
{
System.Drawing.Color color;
if (i % 2 != 0)
{
color = System.Drawing.Color.LightBlue;
}
else
{
color = System.Drawing.Color.White;
}
TableRow qrow = new TableRow();
TableCell number = new TableCell();
number.Text = (i + 1).ToString() + "-";
TableCell qu = new TableCell();
qu.Text = question[i];
qrow.Cells.Add(number);
qrow.Cells.Add(qu);
TableRow arow = new TableRow();
TableCell dumb = new TableCell();
TableCell an = new TableCell();
an.Text = answer[i + 1];
arow.Cells.Add(dumb);
arow.Cells.Add(an);
qrow.BackColor = color;
arow.BackColor = color;
arow.Height = 25;
Table1.Rows.Add(qrow);
Table1.Rows.Add(arow);
}
Label2.Text = pros.getFormName(formId);
Label3.Text = pros.getPositionName(pros.getInterviewPositionId(int_id));
Account ac = new Account();
Label1.Text = ac.get_name(pros.getInterviewById(int_id)[0]);
}
protected void getInterviewdet()
{
Employee_pros pros = new Employee_pros();
List <string> details = pros.getInterviewById(int_id);
candidate = details[0];
Label14.Text = pros.getPositionName(Int32.Parse(details[1]));
Label16.Text = details[2];
Label18.Text = details[3];
Label20.Text = details[5];
Label22.Text = details[6];
Label26.Text = details[7];
Account ac = new Account();
List <string> cand_det = new List <string>();
cand_det = ac.getUserDetails(candidate);
Label3.Text = cand_det[0];
Label5.Text = cand_det[1].Substring(0, 9);
Label7.Text = cand_det[2];
Candidate_pros cpros = new Candidate_pros();
List <string> skills = new List <string>();
skills = cpros.getSkills(candidate);
if (skills.Count != 0)
{
TextBox1.Text = skills[0];
TextBox2.Text = skills[1];
Label12.Text = skills[2];
TextBox3.Text = skills[3];
}
List <string> fileName = new List <string>();
fileName = cpros.getFilesName(candidate);
Label36.Text = fileName[0];
Label38.Text = fileName[1];
Label40.Text = fileName[2];
Label42.Text = fileName[3];
Interview_pros ipros = new Interview_pros();
List <string> scors = ipros.getInterviewScore(int_id);
if (scors.Count == 5)
{
Label27.Text = scors[0];
Label29.Text = scors[1];
Label31.Text = scors[2];
Label33.Text = scors[3];
TextBox4.Text = scors[4];
}
if (Label26.Text.TrimEnd().Equals("PENDING"))
{
ImageButton2.Visible = true;
ImageButton3.Visible = true;
}
}
protected void getInfo()
{
Employee_pros epros = new Employee_pros();
Candidate_pros cpros = new Candidate_pros();
Label4.Text = epros.getPositionName(positionId);
testId = cpros.getTestId(positionId);
List <string> testDet = cpros.getTestDetails(testId);
Label5.Text = testDet[0];
dur = Int32.Parse(testDet[1]);
}
protected void Page_Load(object sender, EventArgs e)
{
inter_id = Int32.Parse(Session["inter"].ToString().TrimEnd());
Account ac = new Account();
string name = ac.get_name(Session["user"].ToString().TrimEnd());
Label1.Text = name.ToUpper();
positionId = Int32.Parse(Session["pos"].ToString().TrimEnd());
Employee_pros pros = new Employee_pros();
Label4.Text = pros.getPositionName(positionId);
getFormQuestion();
}
protected void fillInfo()
{
Employee_pros pros = new Employee_pros();
Label3.Text = pros.getPositionName(pos_id);
Label4.Text = pros.getRequierment(pos_id);
Candidate_pros cpros = new Candidate_pros();
List <string> det = cpros.getInterviewById(int_id);
dur = Int32.Parse(det[4]);
Account ac = new Account();
List <string> d = ac.getCompanyDetails(det[0]);
Label1.Text = d[0];
}
protected void get_info()
{
Account ac = new Account();
Label1.Text = ac.get_name(candidate);
Employee_pros epros = new Employee_pros();
int positionId = epros.getInterviewPositionId(int_id);
Label3.Text = epros.getPositionName(positionId);
Label4.Text = epros.getRequierment(positionId);
Label2.Text = ac.getBd(candidate).ToString().Substring(0, 9);
Candidate_pros cpros = new Candidate_pros();
List <string> skills = cpros.getSkills(candidate);
TextBox1.Text = skills[0];
TextBox2.Text = skills[2];
TextBox3.Text = skills[1];
Label11.Text = skills[3];
}
protected void getInterviewDetails()
{
Candidate_pros pros = new Candidate_pros();
List <string> details = pros.getFirstInterviewDetails(Session["user"].ToString().TrimEnd());
if (details.Count == 0)
{
return;
}
Label14.Text = details[2] + " Minuts";
Label15.Text = details[3];
Label16.Text = details[4];
int_id = details[5];
Label12.Text = int_time.Date.ToString().Substring(0, 10);
Label13.Text = int_time.TimeOfDay.ToString();
Employee_pros pros2 = new Employee_pros();
Label4.Text = pros2.getPositionName(Int32.Parse(details[1]));
Label3.Text = pros.getCompanyName(details[0]);
if (Label15.Text.TrimEnd().Equals("NOT_DONE"))
{
Button1.Visible = true;
Label15.Text = "Not Taken";
}
else
{
Label15.Text = "DONE Result: " + details[6] + "%";
}
if (Label16.Text.TrimEnd().Equals("NOT_DONE"))
{
Button2.Visible = true;
Label16.Text = "Not Filled";
}
pos_id = details[1];
Session["inter"] = int_id;
Session["pos"] = pos_id;
}
protected void filltabel()
{
int count = 0;
Candidate_pros pros = new Candidate_pros();
Employee_pros epros = new Employee_pros();
List <List <string> > details = pros.getInterviews(Session["user"].ToString().TrimEnd(), type);
foreach (List <string> temp in details)
{
count++;
TableRow row = new TableRow();
TableCell number = new TableCell();
number.Text = (count).ToString();
row.HorizontalAlign = HorizontalAlign.Center;
number.BackColor = System.Drawing.Color.Silver;
TableCell candidate = new TableCell();
candidate.Text = temp[0];
TableCell position = new TableCell();
position.Text = epros.getPositionName(Int32.Parse(temp[1]));
position.BackColor = System.Drawing.Color.Silver;
TableCell date = new TableCell();
date.Text = temp[2];
TableCell time = new TableCell();
time.Text = temp[3];
time.BackColor = System.Drawing.Color.Silver;
TableCell status = new TableCell();
status.Text = temp[5];
TableCell testres = new TableCell();
testres.Text = temp[6];
testres.BackColor = System.Drawing.Color.Silver;
TableCell res = new TableCell();
res.Text = temp[7];
TableCell check = new TableCell();
RadioButton ch = new RadioButton();
ch.GroupName = "ch";
check.BackColor = System.Drawing.Color.Silver;
check.Controls.Add(ch);
row.Cells.Add(number);
row.Cells.Add(candidate);
row.Cells.Add(position);
row.Cells.Add(date);
row.Cells.Add(time);
row.Cells.Add(status);
row.Cells.Add(testres);
row.Cells.Add(res);
row.Cells.Add(check);
Table1.Rows.Add(row);
}
}
protected void fill_table()
{
int count = 0;
int type = 0;
if (RadioButton1.Checked)
{
type = 1;
}
else if (RadioButton2.Checked)
{
type = -1;
}
int positionId;
Employee_pros pros = new Employee_pros();
if (DropDownList1.SelectedItem.ToString().Equals("ALL"))
{
positionId = 0;
}
else
{
positionId = pros.gerPositionId(Session["user"].ToString().TrimEnd(), DropDownList1.SelectedItem.ToString());
}
List <List <string> > details = pros.getInterviews(Session["user"].ToString().TrimEnd(), type, positionId);
foreach (List <string> temp in details)
{
count++;
TableRow row = new TableRow();
TableCell number = new TableCell();
number.Text = (count).ToString();
row.HorizontalAlign = HorizontalAlign.Center;
number.BackColor = System.Drawing.Color.Silver;
TableCell candidate = new TableCell();
candidate.Text = temp[0];
TableCell position = new TableCell();
position.Text = pros.getPositionName(Int32.Parse(temp[1]));
position.BackColor = System.Drawing.Color.Silver;
TableCell date = new TableCell();
date.Text = temp[2];
TableCell time = new TableCell();
time.Text = temp[3];
time.BackColor = System.Drawing.Color.Silver;
TableCell status = new TableCell();
status.Text = temp[5];
TableCell testres = new TableCell();
testres.Text = temp[6];
testres.BackColor = System.Drawing.Color.Silver;
TableCell res = new TableCell();
res.Text = temp[7];
TableCell check = new TableCell();
RadioButton ch = new RadioButton();
ch.GroupName = "ch";
check.BackColor = System.Drawing.Color.Silver;
check.Controls.Add(ch);
row.Cells.Add(number);
row.Cells.Add(candidate);
row.Cells.Add(position);
row.Cells.Add(date);
row.Cells.Add(time);
row.Cells.Add(status);
row.Cells.Add(testres);
row.Cells.Add(res);
row.Cells.Add(check);
Table1.Rows.Add(row);
}
}