protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
EducationalDetailsBAL educationalDetailsBAL = new EducationalDetailsBAL();
EducationalDetailsEntity educationalDetails = new EducationalDetailsEntity();
educationalDetails.CandidateId = candidateId;
educationalDetails.DegreeId = Convert.ToInt32(degreeId); ;
educationalDetails.MediumOfEducation = ddlMedium.SelectedValue.Trim();
educationalDetails.OldSpecializationId = Convert.ToInt32(Request.QueryString["sId"]);
educationalDetails.SpecializationId = Convert.ToInt32(ddlSpecialization.SelectedValue.Trim());
educationalDetails.Status = rblStat.SelectedValue.Trim();
educationalDetails.FromYear = ddlMonthFrom.Text + '/' + ddlYearFrom.Text;
educationalDetails.ToYear = ddlMonthTo.Text + '/' + ddlYearTo.Text;
educationalDetails.College = txtCollege.Text.Trim();
educationalDetails.University = txtUniversity.Text.Trim();
educationalDetails.Percantage = txtPercentage.Text.Trim();
// Add object to the update education details
educationalDetailsBAL.UpdateEducationalDetailsBAL(educationalDetails);
//Response.Redirect("JSViewProfile.aspx");
}
catch (Exception)
{
// throw;
}
}
/// <summary>
///Adding new Bachelor Degree in database
/// </summary>
/// <param name="sender">The source of event</param>
/// <param name="e">the<see cref="EventArgs"/>containing event data</param>
protected void btnBDAdd_Click(object sender, EventArgs e)
{
try
{
EducationalDetailsEntity educationalDetailsEntity = new EducationalDetailsEntity();
EducationalDetailsBAL educationalDetailsBAL = new EducationalDetailsBAL();
// Assign values to entity
educationalDetailsEntity.AddBachelorDegreeName = txtBDAdd.Text;
// Add data to the database
educationalDetailsBAL.AddBachelorDegreeBAL(educationalDetailsEntity);
BindDropDownBachelorDegree();
txtBDAdd.Visible = false;
btnBDAdd.Visible = false;
}
catch (Exception)
{
// throw;
}
}
/// <summary>
/// Method for adding Master Degree Details in database
/// </summary>
/// <param name="educationalDetailsEntity">Object of EducationalDetailsEntity</param>
public void AddMasterDegreeDAL(EducationalDetailsEntity educationalDetailsEntity)
{
try
{
educationalDetailsEntity.DegreeId = 6;
connection.Open();
//Add parameter for stored procedure
SqlParameter[] sqlparams = {
new SqlParameter("@DegreeId",educationalDetailsEntity.DegreeId),
new SqlParameter("@DegreeName",educationalDetailsEntity.AddMasterDegreeName),
};
SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, Constants.sp_InsertDegreeDetails, sqlparams);
educationalDetailsEntity.DegreeId = 0;
}
catch (System.Exception)
{
// throw ;
}
finally
{
connection.Close();
}
}
/// <summary>
/// Handles the Click event of the btnSubmit control.
/// </summary>
/// <param name="sender">The source of the event</param>
/// <param name="e"></param>
protected void BtnSubmit_Click(object sender, EventArgs e)
{
try
{
List<EducationalDetailsEntity> educationDetailsList = new List<EducationalDetailsEntity>();
educationalDetails = new EducationalDetailsBAL();
// Get only selected checkboxes list
var selectedDegreeTypes = chkList.Items.Cast<ListItem>().Where(li => li.Selected).ToList();
foreach (var item in selectedDegreeTypes)
{
switch (item.Text)
{
case "SSC / 10th":
EducationalDetailsEntity sscDetails = new EducationalDetailsEntity();
sscDetails.CandidateId = candidateId;
sscDetails.HighestQualificationId = ddlHQ.SelectedValue.Trim();
sscDetails.DegreeId = Convert.ToInt32(item.Value);
sscDetails.MediumOfEducation = ddlSSCMedium.SelectedValue.Trim();
sscDetails.SpecializationId = 0;
sscDetails.Status = rblSSCStat.SelectedValue.Trim();
sscDetails.FromYear = ddlSSCMonthFrom.Text + '/' + ddlSSCYearFrom.Text;
sscDetails.ToYear = ddlSSCMonthTo.Text + '/' + ddlSSCYearTo.Text;
sscDetails.College = txtSSCSchool.Text.Trim();
sscDetails.University = txtSSCBoard.Text.Trim();
sscDetails.Percantage = txtSSCPercentage.Text.Trim();
// Add object to the education details collection
educationDetailsList.Add(sscDetails);
break;
case "HSC / 12th":
EducationalDetailsEntity hscDetails = new EducationalDetailsEntity();
hscDetails.CandidateId = candidateId;
hscDetails.HighestQualificationId = ddlHQ.SelectedValue.Trim();
hscDetails.DegreeId = Convert.ToInt32(item.Value);
hscDetails.MediumOfEducation = ddlHSCMedium.SelectedValue.Trim();
hscDetails.SpecializationId = Convert.ToInt32(ddlHSC.SelectedValue.Trim());
hscDetails.Status = rblHSCStat.SelectedValue.Trim();
hscDetails.FromYear = ddlHSCMonthFrom.Text + '/' + ddlHSCYearFrom.Text;
hscDetails.ToYear = ddlHSCMonthTo.Text + '/' + ddlHSCYearTo.Text;
hscDetails.College = txtHSCCollege.Text.Trim();
hscDetails.University = txtHSCBoard.Text.Trim();
hscDetails.Percantage = txtHSCPercentage.Text.Trim();
// Add object to the education details collection
educationDetailsList.Add(hscDetails);
break;
case "UG Diploma":
EducationalDetailsEntity ugDiplomaDetails = new EducationalDetailsEntity();
ugDiplomaDetails.CandidateId = candidateId;
ugDiplomaDetails.HighestQualificationId = ddlHQ.SelectedValue.Trim();
ugDiplomaDetails.DegreeId = Convert.ToInt32(item.Value);
ugDiplomaDetails.MediumOfEducation = ddlDipMedium.SelectedValue.Trim();
ugDiplomaDetails.SpecializationId = Convert.ToInt32(ddlDip.SelectedValue.Trim());
ugDiplomaDetails.Status = rblDipStat.SelectedValue.Trim();
ugDiplomaDetails.FromYear = ddlDipMonthFrom.Text + '/' + ddlDipYearFrom.Text;
ugDiplomaDetails.ToYear = ddlDipMonthTo.Text + '/' + ddlDipYearTo.Text;
ugDiplomaDetails.College = txtDipCollege.Text.Trim();
ugDiplomaDetails.University = txtDipUniversity.Text.Trim();
ugDiplomaDetails.Percantage = txtDipPercentage.Text.Trim();
// Add object to the education details collection
educationDetailsList.Add(ugDiplomaDetails);
break;
case "Bachelors Degree":
EducationalDetailsEntity bachelorDegreeDetails = new EducationalDetailsEntity();
bachelorDegreeDetails.CandidateId = candidateId;
bachelorDegreeDetails.HighestQualificationId = ddlHQ.SelectedValue.Trim();
bachelorDegreeDetails.DegreeId = Convert.ToInt32(item.Value);
bachelorDegreeDetails.MediumOfEducation = ddlBDMedium.SelectedValue.Trim();
bachelorDegreeDetails.Status = rblBDStat.SelectedValue.Trim();
bachelorDegreeDetails.SpecializationId = Convert.ToInt32(ddlBD.SelectedValue.Trim());
bachelorDegreeDetails.FromYear = ddlBDMonthFrom.Text + '/' + ddlBDYearFrom.Text;
bachelorDegreeDetails.ToYear = ddlBDMonthTo.Text + '/' + ddlBDYearTo.Text;
bachelorDegreeDetails.College = txtBDCollege.Text.Trim();
bachelorDegreeDetails.University = txtBDUniversity.Text.Trim();
bachelorDegreeDetails.Percantage = txtBDPercentage.Text.Trim();
// Add object to the education details collection
educationDetailsList.Add(bachelorDegreeDetails);
// functionality for adding records for Dual Bachelore Degree
if (pnlCollapsableDualBD.Visible == true)
{
EducationalDetailsEntity dualBachelorDegreeDetails = new EducationalDetailsEntity();
dualBachelorDegreeDetails.CandidateId = candidateId;
dualBachelorDegreeDetails.HighestQualificationId = ddlHQ.SelectedValue.Trim();
dualBachelorDegreeDetails.DegreeId = Convert.ToInt32(item.Value);
dualBachelorDegreeDetails.MediumOfEducation = ddlDualBDMedium.SelectedValue.Trim();
dualBachelorDegreeDetails.Status = rblDualBDStat.SelectedValue.Trim();
dualBachelorDegreeDetails.SpecializationId = Convert.ToInt32(ddlDualBD.SelectedValue.Trim());
dualBachelorDegreeDetails.FromYear = ddlDualBDMonthFrom.Text + '/' + ddlDualBDYearFrom.Text;
dualBachelorDegreeDetails.ToYear = ddlDualBDMonthTo.Text + '/' + ddlDualBDYearTo.Text;
dualBachelorDegreeDetails.College = txtDualBDCollege.Text.Trim();
dualBachelorDegreeDetails.University = txtDualBDUniversity.Text.Trim();
dualBachelorDegreeDetails.Percantage = txtDualBDPercentage.Text.Trim();
// Add object to the education details collection
educationDetailsList.Add(dualBachelorDegreeDetails);
}
break;
case "PG Diploma":
EducationalDetailsEntity pgDiplomaDetails = new EducationalDetailsEntity();
pgDiplomaDetails.CandidateId = candidateId;
pgDiplomaDetails.HighestQualificationId = ddlHQ.SelectedValue.Trim();
pgDiplomaDetails.DegreeId = Convert.ToInt32(item.Value);
pgDiplomaDetails.MediumOfEducation = ddlPgdMedium.SelectedValue.Trim();
pgDiplomaDetails.Status = rblPgdStat.SelectedValue.Trim();
pgDiplomaDetails.SpecializationId = Convert.ToInt32(ddlPgd.SelectedValue.Trim());
pgDiplomaDetails.FromYear = ddlPgdMonthFrom.Text + '/' + ddlPgdYearFrom.Text;
pgDiplomaDetails.ToYear = ddlPgdMonthTo.Text + '/' + ddlPgdYearTo.Text;
pgDiplomaDetails.College = txtPgdCollege.Text.Trim();
pgDiplomaDetails.University = txtPgdUniversity.Text.Trim();
pgDiplomaDetails.Percantage = txtPgdPercentage.Text.Trim();
// Add object to the education details collection
educationDetailsList.Add(pgDiplomaDetails);
break;
case "Masters Degree":
EducationalDetailsEntity masterDegreeDetails = new EducationalDetailsEntity();
masterDegreeDetails.CandidateId = candidateId;
masterDegreeDetails.HighestQualificationId = ddlHQ.SelectedValue.Trim();
masterDegreeDetails.DegreeId = Convert.ToInt32(item.Value);
masterDegreeDetails.MediumOfEducation = ddlMDMedium.SelectedValue.Trim();
masterDegreeDetails.SpecializationId = Convert.ToInt32(ddlMD.SelectedValue.Trim());
masterDegreeDetails.Status = rblMDStat.SelectedValue.Trim();
masterDegreeDetails.FromYear = ddlMDMonthFrom.Text + '/' + ddlMDYearFrom.Text;
masterDegreeDetails.ToYear = ddlMDMonthTo.Text + '/' + ddlMDYearTo.Text;
masterDegreeDetails.College = txtMDCollege.Text.Trim();
masterDegreeDetails.University = txtMDUniversity.Text.Trim();
masterDegreeDetails.Percantage = txtMDPercentage.Text.Trim();
// Add object to the education details collection
educationDetailsList.Add(masterDegreeDetails);
// functionality for adding records for Dual Master Degree
if (pnlCollapsableDualMD.Visible == true)
{
EducationalDetailsEntity dualMasterDegreeDetails = new EducationalDetailsEntity();
dualMasterDegreeDetails.CandidateId = candidateId;
dualMasterDegreeDetails.HighestQualificationId = ddlHQ.SelectedValue.Trim();
dualMasterDegreeDetails.DegreeId = Convert.ToInt32(item.Value);
dualMasterDegreeDetails.MediumOfEducation = ddlDualMDMedium.SelectedValue.Trim();
dualMasterDegreeDetails.SpecializationId = Convert.ToInt32(ddlDualMD.SelectedValue.Trim());
dualMasterDegreeDetails.Status = rblDualMDStat.SelectedValue.Trim();
dualMasterDegreeDetails.FromYear = ddlDualMDMonthFrom.Text + '/' + ddlDualMDYearFrom.Text;
dualMasterDegreeDetails.ToYear = ddlDualMDMonthTo.Text + '/' + ddlDualMDYearTo.Text;
dualMasterDegreeDetails.College = txtDualMDCollege.Text.Trim();
dualMasterDegreeDetails.University = txtDualMDUniversity.Text.Trim();
dualMasterDegreeDetails.Percantage = txtDualMDPercentage.Text.Trim();
// Add object to the education details collection
educationDetailsList.Add(dualMasterDegreeDetails);
}
break;
case "Doctorate/ PHD Degree":
EducationalDetailsEntity phdDetails = new EducationalDetailsEntity();
phdDetails.CandidateId = candidateId;
phdDetails.HighestQualificationId = ddlHQ.SelectedValue.Trim();
phdDetails.DegreeId = Convert.ToInt32(item.Value);
phdDetails.MediumOfEducation = ddlPHDMedium.SelectedValue.Trim();
phdDetails.SpecializationId = Convert.ToInt32(ddlPHD.SelectedValue.Trim());
phdDetails.Status = rblPHDStat.SelectedValue.Trim();
phdDetails.FromYear = ddlPHDMonthFrom.Text + '/' + ddlPHDYearFrom.Text;
phdDetails.ToYear = ddlPHDMonthTo.Text + '/' + ddlPHDYearTo.Text;
phdDetails.College = txtPHDCollege.Text.Trim();
phdDetails.University = txtPHDUniversity.Text.Trim();
phdDetails.Percantage = txtPHDPercentage.Text.Trim();
// Add object to the education details collection
educationDetailsList.Add(phdDetails);
break;
default:
break;
}
}
// Save educational deails.
if (educationalDetails.SaveEducationalDetailsBAL(educationDetailsList))
{
pnlCollapsableSSC.Visible = false;
pnlCollapsableHSC.Visible = false;
pnlCollapsableDip.Visible = false;
pnlCollapsableBD.Visible = false;
pnlCollapsableDualBD.Visible = false;
pnlCollapsablePgd.Visible = false;
pnlCollapsableMD.Visible = false;
pnlCollapsableDualMD.Visible = false;
pnlCollapsablePHD.Visible = false;
lblSuccess.Text = "Data saved Successfully...!!";
lblSuccess.Visible = true;
}
else
{
lblError.Text = "Data was not saved successfuly";
lblError.Visible = true;
}
}
catch (Exception)
{
// throw;
}
}
/// <summary>
///Adding new Doctor Of Philosophy in database
/// </summary>
/// <param name="sender">The source of event</param>
/// <param name="e">the<see cref="EventArgs"/>containing event data</param>
protected void btnPHDAdd_Click(object sender, EventArgs e)
{
try
{
EducationalDetailsEntity educationalDetailsEntity = new EducationalDetailsEntity();
EducationalDetailsBAL educationalDetailsBAL = new EducationalDetailsBAL();
// Assign values to entity
educationalDetailsEntity.AddPHDName = txtPHDAdd.Text;
// Add data to the database
educationalDetailsBAL.AddPHDBAL(educationalDetailsEntity);
BindDropDownDoctorOfPhilosophy();
txtPHDAdd.Visible = false;
btnPHDAdd.Visible = false;
}
catch (Exception)
{
// throw;
}
}
/// <summary>
///Adding new Post Graduate Diploma in database
/// </summary>
/// <param name="sender">The source of event</param>
/// <param name="e">the<see cref="EventArgs"/>containing event data</param>
protected void btnPgdAdd_Click(object sender, EventArgs e)
{
try
{
EducationalDetailsEntity educationalDetailsEntity = new EducationalDetailsEntity();
EducationalDetailsBAL educationalDetailsBAL = new EducationalDetailsBAL();
// Assign values to entity
educationalDetailsEntity.AddPostGraduateDiplomaName = txtPgdAdd.Text;
// Add data to the database
educationalDetailsBAL.AddPostGraduateDiplomaBAL(educationalDetailsEntity);
BindDropDownPostGraduateDiploma();
txtPgdAdd.Visible = false;
btnPgdAdd.Visible = false;
}
catch (Exception)
{
// throw;
}
}
/// <summary>
/// Update Educational Deatils JobSeeker.
/// </summary>
/// <param name="edEntity">Object for Updating data into database</param>
/// <returns>True/false</returns>
public int UpdateEducationalDetailsDAL(EducationalDetailsEntity educationalDetailsEntity)
{
int result = 0;
try
{
connection.Open();
SqlCommand cmd = new SqlCommand();
SqlParameter[] sqlparams = {
new SqlParameter("@CandidateId",educationalDetailsEntity.CandidateId),
//new SqlParameter("@HighestQualificationId",educationalDetailsEntity.HighestQualificationId),
new SqlParameter("@DegreeId",educationalDetailsEntity.DegreeId),
new SqlParameter("@MediumOfEducation",educationalDetailsEntity.MediumOfEducation),
new SqlParameter("@Status",educationalDetailsEntity.Status),
new SqlParameter("@OldSpecializationId",educationalDetailsEntity.OldSpecializationId),
new SqlParameter("@SpecializationId",educationalDetailsEntity.SpecializationId),
new SqlParameter("@FromYear",educationalDetailsEntity.FromYear),
new SqlParameter("@ToYear",educationalDetailsEntity.ToYear),
new SqlParameter("@College",educationalDetailsEntity.College),
new SqlParameter("@University",educationalDetailsEntity.University),
new SqlParameter("@Percantage",educationalDetailsEntity.Percantage),
};
result = SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, Constants.sp_JS_UpdateEducationalDetails, sqlparams);
}
catch (Exception)
{
//throw ;
}
finally
{
connection.Close();
}
return result;
}
private void BindEducationalDetails()
{
try
{
//List<EducationalDetailsEntity> educationDetailsList = new List<EducationalDetailsEntity>();
EducationalDetailsBAL educationalDetails = new EducationalDetailsBAL();
// Get only selected checkboxes list
//var selectedDegreeTypes = chkList.Items.Cast<ListItem>().Where(li => li.Selected).ToList();
// Get only selected checkboxes list
//var selectedDegreeTypes = chkList.Items.Cast<ListItem>().Where(li => li.Selected).ToList();
DataSet dsEducationalDetails = new DataSet();
dsEducationalDetails = educationalDetails.SelectEducationalDetailsBAL(candidateId, degreeId, specializationId);
if (dsEducationalDetails != null)
{
// var listofDegrees = Convert.ToString(degreeIdS);
// foreach (var list in listofDegrees)
// for (; ; degreeIdS++)
{
EducationalDetailsEntity EditDetails = new EducationalDetailsEntity();
EditDetails.CandidateId = candidateId;
//ddlHQ.SelectedItem.Text = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["HighestQualificationId"]);
//dsEducationalDetails = educationalDetails.UpdateEducationalDetailsBAL(CandidateId);
lblHead.Text = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["DegreeName"]);
EditDetails.DegreeId = Convert.ToInt32(degreeId); ;
//txtMedium.Text = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["MediumOfEducation"]);
ddlMedium.SelectedValue = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["LanguageId"]);
string Status = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["Status"]);
rblStat.Items.FindByValue(Status).Selected = true;
ddlSpecialization.SelectedValue = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["SpecializationId"]);
string FromYear = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["FromYear"]); ;
string[] FromYearSplit = FromYear.Split(new char[] { '/' });
int CountFrom = 0;
foreach (string Word in FromYearSplit)
{
CountFrom += 1;
if (CountFrom == 1)
{ ddlMonthFrom.SelectedValue = Word; }
if (CountFrom == 2)
{ ddlYearFrom.SelectedValue = Word; }
}
string ToYear = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["ToYear"]); ;
string[] ToYearSplit = ToYear.Split(new char[] { '/' });
int countTo = 0;
foreach (string Word in ToYearSplit)
{
countTo += 1;
if (countTo == 1)
{ ddlMonthTo.SelectedValue = Word; }
if (countTo == 2)
{ ddlYearTo.SelectedValue = Word; }
}
//ddlSSCMonthFrom.SelectedItem.Text + ddlSSCYearFrom.SelectedItem.Text = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["FromYear"]);
//ddlSSCMonthTo.Text + ddlSSCYearTo.Text = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["ToYear"]);
txtCollege.Text = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["College"]);
txtUniversity.Text = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["University"]);
txtPercentage.Text = Convert.ToString(dsEducationalDetails.Tables[0].Rows[0]["Percantage"]);
// Add object to the education details collection
//educationDetailsList.Add(sscDetails);
btnUpdate.Visible = true;
}
}
}
catch (Exception)
{
// throw;
}
}
