//Bind Data On Check List Box
private void BindOptions()
{
DataView dv = new TRNTraineeBO().SelectOptionsForTrainingRegular();
chkOptions.Items.Add(dv.Table.Columns[0].ColumnName);
chkOptions.Items.Add(dv.Table.Columns[1].ColumnName);
chkOptions.Items.Add(dv.Table.Columns[2].ColumnName);
chkOptions.Items.Add(dv.Table.Columns[3].ColumnName);
chkOptions.Items.Add(dv.Table.Columns[4].ColumnName);
chkOptions.Items.Add(dv.Table.Columns[5].ColumnName);
chkOptions.Items.Add(dv.Table.Columns[6].ColumnName);
chkOptions.Items.Add(dv.Table.Columns[7].ColumnName);
chkOptions.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
TRNDepartureCheckList objDepartureCheckList = new TRNDepartureCheckList();
int CurrentEmploymentId = 0;
int employmentId = 0;
int updateEmp = 0;
int updateCurrentEmployment = 0;
#region Current Abroad Information
TRNCurrentEmployment objCurrentEmployment = new TRNCurrentEmployment();
objCurrentEmployment.TraineeID = TraineeID;
DataView dvCurrentEmployment = TRNCurrentEmploymentBO.GetCurrentEmploymentIdByTraineeID(TraineeID);
if (rbCurrentCountryYes.Checked)
{
objCurrentEmployment.CountryID = Convert.ToInt32(ddlWhichCountry.SelectedValue);
objCurrentEmployment.WorkingYear = txtWorkingYears.Text;
objCurrentEmployment.WorkingMonth = txtWorkingMonths.Text;
objCurrentEmployment.Occupation = txtOccupation.Text;
objCurrentEmployment.MonthlySalary = txtPreviousMonthlySalary.Text;
objCurrentEmployment.ReturnDate = txtPreviousReturnDate.Text;
}
else
{
objCurrentEmployment.CountryID = 0;
objCurrentEmployment.WorkingYear = "";
objCurrentEmployment.WorkingMonth = "";
objCurrentEmployment.Occupation = "";
objCurrentEmployment.MonthlySalary = "";
objCurrentEmployment.ReturnDate = "";
}
objCurrentEmployment.Status = 1;
if (rbCurrentCountryYes.Checked)
{
if (dvCurrentEmployment.Count == 0)
{
objCurrentEmployment.CreatedBy = UserAuthentication.GetUserId(this.Page);
CurrentEmploymentId = new TRNTraineeBO().InsertCurrentEmployment(objCurrentEmployment);
}
else
{
objCurrentEmployment.ModifiedBy = UserAuthentication.GetUserId(this.Page);
CurrentEmploymentId = Convert.ToInt32(dvCurrentEmployment.Table.Rows[0]["ID"]);
objCurrentEmployment.EmploymentID = CurrentEmploymentId;
objCurrentEmployment.ModifiedBy = UserAuthentication.GetUserId(this.Page);
new TRNTraineeBO().UpdateCurrentEmployment(objCurrentEmployment);
}
}
else
{
if (dvCurrentEmployment.Count > 0)
{
CurrentEmploymentId = Convert.ToInt32(dvCurrentEmployment.Table.Rows[0]["ID"]);
objCurrentEmployment.EmploymentID = CurrentEmploymentId;
//objEmployment.Status = 0;
updateCurrentEmployment = TRNCurrentEmploymentBO.Delete(CurrentEmploymentId);
DisableCurrentAbroadInfo();
}
else
{
}
}
#endregion
#region Past Abroad Information
TRNEmployment objEmployment = new TRNEmployment();
objEmployment.TraineeID = TraineeID;
DataView dvEmployment = TRNEmploymentBO.GetEmploymentIdByTraineeID(TraineeID);
if (rdoAbroadYes.Checked)
{
if (!String.IsNullOrEmpty(ddlCountry.SelectedValue.ToString()))
objEmployment.CountryID = Convert.ToInt32(ddlCountry.SelectedValue);
objEmployment.Organization = txtCompany.Text;
objEmployment.RecruitmentAgency = txtPastRecruitmentAgency.Text;
//if (!String.IsNullOrEmpty(ddlOrganization.SelectedValue.ToString()))
// objEmployment.OrganizationID = Convert.ToInt32(ddlOrganization.SelectedValue);
if (!String.IsNullOrEmpty(ddlEmploymentType.SelectedValue.ToString()))
objEmployment.EmploymentTypeID = Convert.ToInt32(ddlEmploymentType.SelectedValue);
if (!String.IsNullOrEmpty(ddlEmploymentStatus.SelectedValue.ToString()))
objEmployment.EmploymentStatusID = Convert.ToInt32(ddlEmploymentStatus.SelectedValue);
//if (!String.IsNullOrEmpty(ddlRecruitmentAgency.SelectedValue.ToString()))
// objEmployment.RecruitmentAgencyID = Convert.ToInt32(ddlRecruitmentAgency.SelectedValue);
//objEmployment.WorkDoneMonth = txtJobDoneMonth.Text;
//objEmployment.WorkDoneYear = txtJobDoneYear.Text;
objEmployment.EmploymentPeriod = txtEmploymentPeriod.Text;
if (!String.IsNullOrEmpty(txtMonthlySalary.Text))
objEmployment.Salary = txtMonthlySalary.Text.ToString();
if (!String.IsNullOrEmpty(txtForeignCurrency.Text))
objEmployment.Currency = txtForeignCurrency.Text;
if (!String.IsNullOrEmpty(txtDepartureDate.Text))
objEmployment.DepartureDate = Convert.ToDateTime(txtDepartureDate.Text);
if (!String.IsNullOrEmpty(txtReturnDate.Text))
objEmployment.ReturnDate = Convert.ToDateTime(txtReturnDate.Text);
}
else
{
objEmployment.CountryID = 0;
objEmployment.Organization = "";
objEmployment.EmploymentTypeID = 0;
objEmployment.EmploymentStatusID = 0;
objEmployment.RecruitmentAgency = "";
objEmployment.WorkDoneMonth = "";
objEmployment.WorkDoneYear = "";
objEmployment.Salary = "";
objEmployment.Currency = "";
objEmployment.DepartureDate = null;
objEmployment.ReturnDate = null;
}
objEmployment.Status = 1;
if (rdoAbroadYes.Checked)
{
if (dvEmployment.Count == 0)
{
objEmployment.CreatedBy = UserAuthentication.GetUserId(this.Page);
employmentId = new TRNTraineeBO().InsertEmployment(objEmployment);
}
else
{
objEmployment.ModifiedBy = UserAuthentication.GetUserId(this.Page);
employmentId = Convert.ToInt32(dvEmployment.Table.Rows[0]["ID"]);
objEmployment.EmploymentID = employmentId;
new TRNTraineeBO().UpdateEmployment(objEmployment);
}
}
else
{
if (dvEmployment.Count > 0)
{
employmentId = Convert.ToInt32(dvEmployment.Table.Rows[0]["ID"]);
List<int> count = TRNDepartureChecklistBO.GetDepartureCheckListByEmploymentID(employmentId);
for (int b = 0; b < count.Count; b++)
{
DataView dvDepartureCheckList = TRNEmploymentBO.GetDepartureIDByEmploymentID(employmentId);
objDepartureCheckList.DepartureChecklistID = Convert.ToInt32(dvDepartureCheckList.Table.Rows[0]["ID"]);
TRNDepartureChecklistBO.Delete(Convert.ToInt32(dvDepartureCheckList.Table.Rows[0]["ID"]));
}
objEmployment.EmploymentID = employmentId;
//objEmployment.Status = 0;
updateEmp = TRNEmploymentBO.Delete(employmentId);
DisableAbroadInfo();
}
else
{
}
}
#endregion
#region DepartureCheckList
List<TRNDepartureCheckList> lstDeparture = new List<TRNDepartureCheckList>();
List<int> checkList = new List<int>();
string departureList = hfTraineeCheckList.Value;
string[] list = departureList.Split(',');
foreach (string item in list)
{
if (item != string.Empty)
{
checkList.Add(Convert.ToInt32(item));
}
}
//int EmploymentID = 0;
//DataView dv = TRNEmploymentBO.GetEmploymentIdByTraineeID(TraineeID);
//int EmploymentID = Convert.ToInt32(dv.Table.Rows[0]["ID"]);
if (employmentId > 0)
{
String a = hfTraineeCheckList.Value;
List<int> lstCheckList = TRNDepartureChecklistBO.GetDepartureCheckListByEmploymentID(employmentId);
//if (lstCheckList.Count > 0)
//{
for (int j = 0; j < ddlTraineeCheckList.Items.Count; j++)
{
if (lstCheckList.Exists(delegate(int region) { return region == Convert.ToInt32(ddlTraineeCheckList.Items[j].Value); }))
{
if (checkList.Exists(delegate(int region) { return region == Convert.ToInt32(ddlTraineeCheckList.Items[j].Value); }))
{
}
else
{
new TRNDepartureChecklistBO().DeleteDepartureList(employmentId, Convert.ToInt32(ddlTraineeCheckList.Items[j].Value));
}
}
else
{
if (checkList.Exists(delegate(int region) { return region == Convert.ToInt32(ddlTraineeCheckList.Items[j].Value); }))
{
objDepartureCheckList.EmploymentID = employmentId;
objDepartureCheckList.CheckListID = Convert.ToInt32(ddlTraineeCheckList.Items[j].Value);
objDepartureCheckList.Availability = 1;
objDepartureCheckList.DepartureChecklistID = new TRNTraineeBO().InsertDepartureList(objDepartureCheckList);
}
else
{
}
}
//list.Add(j);
}
//}
}
//if (updateEmp > 0)
//{
// employmentId = Convert.ToInt32(dvEmployment.Table.Rows[0]["ID"]);
// DataView dvDepartureCheckList = TRNEmploymentBO.GetDepartureIDByEmploymentID(employmentId);
// objDepartureCheckList.DepartureChecklistID = Convert.ToInt32(dvDepartureCheckList.Table.Rows[0]["ID"]);
// int a = TRNDepartureChecklistBO.Delete(Convert.ToInt32(dvDepartureCheckList.Table.Rows[0]["ID"]));
// //new TRNDepartureChecklistBO().DeleteDepartureList(employmentId, Convert.ToInt32(ddlTraineeCheckList.Items[j].Value));
//}
#endregion
#region PreviousTraining
int previousTrainingId = 0;
TRNPreviousTraining objPreviousTraining = new TRNPreviousTraining();
DataView dvPreviousTraining = TRNPreviousTrainingBO.GetPreviousTrainingIDByTraineeID(TraineeID);
objPreviousTraining.TraineeID = Convert.ToInt32(Request.QueryString.Get("ID"));
if (rbHavePreviousTrainingYes.Checked)
{
objPreviousTraining.Name = txtTrainingName.Text;
objPreviousTraining.Year = txtTrainingYear.Text;
objPreviousTraining.Institute = txtTrainingInstituteName.Text;
objPreviousTraining.Duration = txtTrainingDuration.Text;
}
else
{
objPreviousTraining.Name = "";
objPreviousTraining.Year = "";
objPreviousTraining.Institute = "";
objPreviousTraining.Duration = "";
}
if (rbHavePreviousTrainingYes.Checked)
{
if (dvPreviousTraining.Count == 0)
{
previousTrainingId = new TRNTraineeBO().InsertPreviousTraining(objPreviousTraining);
}
else
{
objPreviousTraining.PreviousTrainingID = Convert.ToInt32(dvPreviousTraining.Table.Rows[0]["ID"]);
previousTrainingId = new TRNTraineeBO().UpdatePreviousTraining(objPreviousTraining);
}
}
else
{
if (dvPreviousTraining.Count > 0)
{
objPreviousTraining.PreviousTrainingID = Convert.ToInt32(dvPreviousTraining.Table.Rows[0]["ID"]);
previousTrainingId = new TRNTraineeBO().UpdatePreviousTraining(objPreviousTraining);
}
else
{
}
}
#endregion
int result = new TRNTraineeBO().UpdateTrainee(MapTrainee());
if (employmentId > 0 || objDepartureCheckList.DepartureChecklistID > 0 || previousTrainingId > 0)
{
Response.Redirect("Default.aspx");
}
else
{
Response.Redirect("Default.aspx");
}
//Update TRNTrainee, TRNEmployment, TRNPreviousTraining, TRNDepartureCheckList
//if (dvPreviousTraining.Count > 0 && dvEmployment.Count > 0)
//{
// int result = new TRNTraineeBO().UpdateTrainee(MapTrainee(), objEmployment, objPreviousTraining);
//}
//if (result > 0)
//{
// Response.Redirect("Default.aspx");
//}
//else
//{
//}
}
// Bind Data On Grid View
protected void BindData()
{
if (chkOptions.Items[0].Selected == true)
CitizenshipNumber = chkOptions.Items[0].Text;
if (chkOptions.Items[1].Selected == true)
PassportNumber = chkOptions.Items[1].Text;
if (chkOptions.Items[2].Selected == true)
DOBBS = chkOptions.Items[2].Text;
if (chkOptions.Items[3].Selected == true)
VDCID = chkOptions.Items[3].Text;
if (chkOptions.Items[4].Selected == true)
WardNumber = chkOptions.Items[4].Text;
if (chkOptions.Items[5].Selected == true)
MobileNumber = chkOptions.Items[5].Text;
if (chkOptions.Items[6].Selected == true)
EducationLevelID = chkOptions.Items[6].Text;
if (chkOptions.Items[7].Selected == true)
ReferredBy = chkOptions.Items[7].Text;
if (!String.IsNullOrEmpty(ddlEthnicity.SelectedValue))
EthnicityID = Convert.ToInt32(ddlEthnicity.SelectedValue);
if (!String.IsNullOrEmpty(ddlDistrict.SelectedValue))
DistrictID = Convert.ToInt32(ddlDistrict.SelectedValue);
if (!String.IsNullOrEmpty(ddlTrainingEvent.SelectedValue))
EventID = Convert.ToInt32(ddlTrainingEvent.SelectedValue);
if (!string.IsNullOrEmpty(txtSearchText.Text))
{
strOption = txtSearchText.Text.Trim();
}
DataView dvTrainingReport = new TRNTraineeBO().GetCustomTrainingRegular(CitizenshipNumber, PassportNumber, DOBBS, VDCID, WardNumber, MobileNumber, EducationLevelID, ReferredBy, EthnicityID, DistrictID, EventID, strOption);
if (dvTrainingReport != null)
{
for (int i = 0; i < dvTrainingReport.Table.Columns.Count; i++)
{
BoundField boundfield = new BoundField();
boundfield.DataField = dvTrainingReport.Table.Columns[i].ColumnName.ToString();
boundfield.HeaderText = dvTrainingReport.Table.Columns[i].ColumnName.ToString();
gdvTrainingRegularReport.Columns.Add(boundfield);
}
gdvTrainingRegularReport.Width = 1200;
gdvTrainingRegularReport.HeaderStyle.CssClass = "header";
gdvTrainingRegularReport.RowStyle.CssClass = "rowstyle";
}
gdvTrainingRegularReport.Columns[1].HeaderText = "Event ID";
gdvTrainingRegularReport.Columns[2].HeaderText = "Trade Name";
gdvTrainingRegularReport.Columns[3].HeaderText = "Start Date";
gdvTrainingRegularReport.Columns[4].HeaderText = "End Date";
gdvTrainingRegularReport.Columns[5].HeaderText = "Name of Trainee";
gdvTrainingRegularReport.Columns[6].HeaderText = "Last Name";
((BoundField)gdvTrainingRegularReport.Columns[3]).DataFormatString = "{0:dd-MMM-yyyy}";
((BoundField)gdvTrainingRegularReport.Columns[4]).DataFormatString = "{0:dd-MMM-yyyy}";
gdvTrainingRegularReport.DataSource = dvTrainingReport;
gdvTrainingRegularReport.DataBind();
Panel1.Controls.Add(gdvTrainingRegularReport);
//Get Record Count
dv = TRNTraineeBO.GetTrainingRegularCount(strOption, EthnicityID, DistrictID, EventID);
int count = Convert.ToInt32(dv.Table.Rows[0]["Count"]);
lblNoOfRecords.Text = count.ToString();
}
protected void btnSave_Click(object sender, EventArgs e)
{
TRNDepartureCheckList objDepartureCheckList = new TRNDepartureCheckList();
List<TRNDepartureCheckList> lstDeparture = new List<TRNDepartureCheckList>();
List<int> checkList = new List<int>();
string departureList = hfTraineeCheckList.Value;
string[] list = departureList.Split(',');
foreach (string item in list)
{
if (item != string.Empty)
{
checkList.Add(Convert.ToInt32(item));
}
}
//Insert TRNTrainee, TRNEmployment, TRNPreviousTraining, TRNDepartureCheckList
int result = new TRNTraineeBO().InsertTrainee(MapTrainee(), MapCurrentEmployment(), MapEmployment(), MapPreviousTraining(), checkList);
if (result > 0)
{
Clear();
}
else
{
Response.Write("Profile not saved successfully.");
}
}
