public EmployeeForInsertModel Employee_SelectById(int empId)
{
using (var con = GetDbConnection())
{
try
{
EmployeeForInsertModel em = new EmployeeForInsertModel
{
EmployeeId = empId,
EmployeeBasicInfo = con.QueryFirstOrDefault <EmployeeBasicInfoForInsertModel>("dbo.Usp_EmployeeBasicInfo_GetById",
new { @iIntEmployeeId = empId },
commandType: CommandType.StoredProcedure),
EmployeeContactInfo = con.QueryFirstOrDefault <EmployeeContactInfoForInsertModel>("dbo.Usp_EmployeeContactInfo_GetByEmployeeId",
new { @iIntEmployeeId = empId },
commandType: CommandType.StoredProcedure),
EmployeeEducation = con.QueryFirstOrDefault <EmployeeEducationForInsertModel>("dbo.Usp_EmployeeEducation_GetByEmpId",
new { @iIntEmployeeId = empId },
commandType: CommandType.StoredProcedure),
EmployeeEmpInfo = con.QueryFirstOrDefault <EmployeeEmpInfoForInsertModel>("dbo.Usp_EmployeeEmpInfo_GetByEmpId",
new { @iIntEmployeeId = empId },
commandType: CommandType.StoredProcedure)
};
return(em);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
private void linkLabel5_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (listView1.SelectedItems.Count < 1)
{
MessageBox.Show("Pls. Select an Item.", "Select Item", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
EmployeeForInsertModel emp = svc.Employee_SelectById(int.Parse(listView1.SelectedItems[0].Text));
frmRptViewer frm = new frmRptViewer();
string exeFolder = Path.GetDirectoryName(Application.StartupPath);
string reportPath = Path.Combine(exeFolder, "..\\Reports\\RptEmpProfile.rdlc");
frm.reportViewer1.LocalReport.ReportPath = reportPath;
ReportParameter generatedBy = new ReportParameter("UserFullName", GlobalSession.UserFullName);
ReportParameter imagePath = new ReportParameter("ImagePath", AppDomain.CurrentDomain.BaseDirectory + "EmpPics\\ProfilePic\\" + listView1.SelectedItems[0].Text + "\\" + emp.EmployeeBasicInfo.PicName);
List <EmployeeBasicInfoForInsertModel> empBasicinfo = new List <EmployeeBasicInfoForInsertModel>();
List <EmployeeContactInfoForInsertModel> empContactInfo = new List <EmployeeContactInfoForInsertModel>();
List <EmployeeEducationForInsertModel> empEducation = new List <EmployeeEducationForInsertModel>();
List <EmployeeEmpInfoForInsertModel> empEmployment = new List <EmployeeEmpInfoForInsertModel>();
empBasicinfo.Add(emp.EmployeeBasicInfo);
empContactInfo.Add(emp.EmployeeContactInfo);
empEducation.Add(emp.EmployeeEducation);
empEmployment.Add(emp.EmployeeEmpInfo);
frm.reportViewer1.LocalReport.DataSources.Clear();
ReportDataSource rs = new ReportDataSource {
Name = "ds_employee_basicinfo", Value = empBasicinfo
};
ReportDataSource rs1 = new ReportDataSource {
Name = "ds_employee_contactinfo", Value = empContactInfo
};
ReportDataSource rs2 = new ReportDataSource {
Name = "ds_employee_education", Value = empContactInfo
};
ReportDataSource rs3 = new ReportDataSource {
Name = "ds_employee_employment", Value = empEmployment
};
frm.reportViewer1.LocalReport.DataSources.Add(rs);
frm.reportViewer1.LocalReport.DataSources.Add(rs1);
frm.reportViewer1.LocalReport.DataSources.Add(rs2);
frm.reportViewer1.LocalReport.DataSources.Add(rs3);
frm.reportViewer1.LocalReport.EnableExternalImages = true;
frm.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { generatedBy, imagePath });
frm.ShowDialog();
}
}
public void Employee_Update(EmployeeForInsertModel em)
{
_repo.Employee_Update(em);
}
public int Employee_Insert(EmployeeForInsertModel em)
{
return(_repo.Employee_Insert(em));
}
void GetEmpDetails(int employeeId)
{
if (employeeId > 0)
{
emp = empSvc.Employee_SelectById(employeeId);
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + employeeId + "\\" + emp.EmployeeBasicInfo.PicName) == true)
{
picEmployee.Image = Image.FromFile(AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + employeeId + "\\" + emp.EmployeeBasicInfo.PicName, true);
}
try
{
lblDesignation.Text = emp.EmployeeEmpInfo.Designation;
lblDepartment.Text = emp.EmployeeEmpInfo.DepartmentName;
lblRate.Text = emp.EmployeeEmpInfo.BasicPay.ToString("#,####.00");
lblPayOption.Text = emp.EmployeeEmpInfo.BasicRateOption;
var dtr = dsvc.DTR_GetDetailsForPayroll(emp.EmployeeId, (int)cmbPayrollPeriod.SelectedValue);
if (dtr != null)
{
lblTotalLate.Text = dtr.TotalLate.ToString(".00");
lblTotalUndertime.Text = dtr.TotalUndertime.ToString(".00");
lblTotDaysWork.Text = dtr.TotalDaysWork.ToString(".00");
label2.Visible = false;
HAS_DTR = true;
if (employeeId > 0 && (int)cmbPayrollPeriod.SelectedValue > 0)
{
var model = _payrollService.GetPayrollDetails(employeeId, (int)cmbPayrollPeriod.SelectedValue);
if (model != null)
{
//lblTotDaysWork.Text = model.TotalDaysWork.ToString("0.00");
//lblTotalLate.Text = model.MinsLate.ToString("0.00");
//lblTotalUndertime.Text = model.UnderTime.ToString("0.00");
txtCottageRental.Text = model.Cottage_Rental.ToString("#,####.00");
lblGrossEarning.Text = model.GrossAmount.ToString("#,####.00");
//HDMF_Tax.Text = model.Tax.ToString("#,####.00");
txtHDMF.Text = model.HDMF_Premiums.ToString("#,####.00");
txtHDMF_Calamity.Text = model.HDMF_Calamity.ToString("#,####.00");
lblNetAmount.Text = model.NetAmount.ToString("#,####.00");
lblLateAmount.Text = model.LateAmtDeduction.ToString("#,####.00");
lblUnderTime.Text = model.UnderTimeAmtDeduction.ToString("#,####.00");
}
}
}
else
{
label2.Visible = true;
lblTotalLate.Text = "";
lblTotalUndertime.Text = "";
lblTotDaysWork.Text = "";
HAS_DTR = false;
}
}
catch (Exception ex)
{
lblTotalLate.Text = "";
lblTotalUndertime.Text = "";
lblTotDaysWork.Text = "";
HAS_DTR = false;
}
}
else
{
ClearAll();
}
}
public void Employee_Update(EmployeeForInsertModel em)
{
using (var con = GetDbConnection())
{
con.Open();
using (var tran = con.BeginTransaction())
{
try
{
con.Execute("dbo.Usp_EmployeeBasicInfo_Update",
new
{
@iIntEmployeeId = em.EmployeeId,
@iStrLastName = em.EmployeeBasicInfo.LastName,
@iStrFirstName = em.EmployeeBasicInfo.FirstName,
@iStrMiddleName = em.EmployeeBasicInfo.MiddleName,
@iStrSuffix = em.EmployeeBasicInfo.Suffix,
@iStrBirthDate = em.EmployeeBasicInfo.BirthDate,
@iStrPlaceOfBirth = em.EmployeeBasicInfo.PlaceOfBirth,
@iStrCitizenship = em.EmployeeBasicInfo.Citizenship,
@iStrHeight = em.EmployeeBasicInfo.Height,
@iStrWeight = em.EmployeeBasicInfo.Weight,
@iStrReligion = em.EmployeeBasicInfo.Religion,
@iStrResidentialAddress1 = em.EmployeeBasicInfo.ResidentialAddress1,
@iStrResidentialAddress2 = em.EmployeeBasicInfo.ResidentialAddress2,
@iStrCurrentAddress1 = em.EmployeeBasicInfo.CurrentAddress1,
@iStrCurrentAddress2 = em.EmployeeBasicInfo.CurrentAddress2,
@iStrGender = em.EmployeeBasicInfo.Gender,
@iStrCivilStatus = em.EmployeeBasicInfo.CivilStatus,
@iStrPicName = em.EmployeeBasicInfo.PicName
},
transaction: tran, commandType: CommandType.StoredProcedure);
con.Execute("dbo.Usp_EmployeeContactInfo_Update",
new
{
@iIntEmployeeId = em.EmployeeId,
@iStrSpouseName = em.EmployeeContactInfo.SpouseName,
@iStrSpouseOccupation = em.EmployeeContactInfo.SpouseOccupation,
@iDtSpouseBirthDate = em.EmployeeContactInfo.SpouseBirthDate,
@iStrFatherName = em.EmployeeContactInfo.FatherName,
@iStrFatherOccupation = em.EmployeeContactInfo.FatherOccupation,
@iDtFatherBirthDate = em.EmployeeContactInfo.FatherBirthDate,
@iStrMotherName = em.EmployeeContactInfo.MotherName,
@iStrMotherOccupation = em.EmployeeContactInfo.MotherOccupation,
@iDtMotherBirthDate = em.EmployeeContactInfo.MotherBirthDate,
@iStrParentAddress1 = em.EmployeeContactInfo.ParentAddress1,
@iStrParentAddress2 = em.EmployeeContactInfo.ParentAddress2,
@iStrContactNum1 = em.EmployeeContactInfo.ContactNum1,
@iStrContactNum2 = em.EmployeeContactInfo.ContactNum2,
@iStrEmailAddress = em.EmployeeContactInfo.EmailAddress,
@iStrContactPersonName = em.EmployeeContactInfo.ContactPersonName,
@iStrContactPersonNumber = em.EmployeeContactInfo.ContactPersonNumber,
@iStrContactPersonAddress1 = em.EmployeeContactInfo.ContactPersonAddress1,
@iStrContactPersonAddress2 = em.EmployeeContactInfo.ContactPersonAddress2
},
transaction: tran, commandType: CommandType.StoredProcedure);
con.Execute("dbo.Usp_EmployeeEducation_Update",
new
{
@iIntEmployeeId = em.EmployeeId,
@iStrElementary = em.EmployeeEducation.Elementary,
@iDtElemDateGraduated = em.EmployeeEducation.ElemDateGraduated,
@iStrHighSchool = em.EmployeeEducation.HighSchool,
@iDtHighSchoolDateGraduated = em.EmployeeEducation.HighSchoolDateGraduated,
@iStrVocational = em.EmployeeEducation.Vocational,
@iStrVocationalCourse = em.EmployeeEducation.VocationalCourse,
@iDtVocationalDateGraduated = em.EmployeeEducation.VocationalDateGraduated,
@iStrCollege = em.EmployeeEducation.College,
@iStrCollegeCourse = em.EmployeeEducation.CollegeCourse,
@iDtCollegeDateGraduated = em.EmployeeEducation.CollegeDateGraduated,
@iStrHighestEducAttainment = em.EmployeeEducation.HighestEducAttainment,
@iStrEducationalBackgroundRemarks = em.EmployeeEducation.EducationalBackgroundRemarks
},
transaction: tran, commandType: CommandType.StoredProcedure);
con.Execute("dbo.Usp_EmployeeEmpInfo_Update",
new
{
@iIntEmployeeId = em.EmployeeId,
@iStrDesignation = em.EmployeeEmpInfo.Designation,
@iIntDepartment = em.EmployeeEmpInfo.DepartmentId,
@iStrEmploymentType = em.EmployeeEmpInfo.EmploymentType,
@iDecBasicPay = em.EmployeeEmpInfo.BasicPay,
@iDtDateHired = em.EmployeeEmpInfo.DateHired,
@iStrTINNo = em.EmployeeEmpInfo.TINNo,
@iStrSSSNo = em.EmployeeEmpInfo.SSSNo,
@iStrPhilHealth = em.EmployeeEmpInfo.PhilHealth,
@iStrPagIbigNo = em.EmployeeEmpInfo.PagIbigNo,
@iStrCharRefFullName1 = em.EmployeeEmpInfo.CharRefFullName1,
@iStrCharRefOccupation1 = em.EmployeeEmpInfo.CharRefOccupation1,
@iStrCharRefContactNum1 = em.EmployeeEmpInfo.CharRefContactNum1,
@iStrCharRefFullName2 = em.EmployeeEmpInfo.CharRefFullName2,
@iStrCharRefOccupation2 = em.EmployeeEmpInfo.CharRefOccupation2,
@iStrCharRefContactNum2 = em.EmployeeEmpInfo.CharRefContactNum2,
@iStrCharRefFullName3 = em.EmployeeEmpInfo.CharRefFullName3,
@iStrCharRefOccupation3 = em.EmployeeEmpInfo.CharRefOccupation3,
@iStrCharRefContactNum3 = em.EmployeeEmpInfo.CharRefContactNum3,
@istrEmpStatus = em.EmployeeEmpInfo.EmpStatus,
@iStrBasicPayOption = em.EmployeeEmpInfo.BasicRateOption
},
transaction: tran, commandType: CommandType.StoredProcedure);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw new Exception(ex.Message);
}
finally
{
con.Close();
}
}
}
}
private void bttnSave_Click(object sender, EventArgs e)
{
int result;
picName = (txtFirstName.Text + " " + txtLastName.Text + ".jpeg");
if (Validation.IsTextEmpty(txtLastName))
{
tabControl1.SelectedIndex = 0;
Validation.FocusTextBox(txtLastName, "Last Name");
return;
}
else if (Validation.IsTextEmpty(txtFirstName))
{
tabControl1.SelectedIndex = 0;
Validation.FocusTextBox(txtFirstName, "First Name");
return;
}
else if (Validation.IsTextEmpty(txtMiddleName))
{
tabControl1.SelectedIndex = 0;
Validation.FocusTextBox(txtMiddleName, "Middle Name");
return;
}
else if (Validation.IsComboEmpty(cmbGender))
{
tabControl1.SelectedIndex = 0;
Validation.FocusComboBox(cmbGender, "Gender");
return;
}
else if (Validation.IsComboEmpty(cmbCivilStatus))
{
tabControl1.SelectedIndex = 0;
Validation.FocusComboBox(cmbCivilStatus, "Marital Status");
return;
}
else if (Validation.IsComboEmpty(cmbCitizen))
{
tabControl1.SelectedIndex = 0;
Validation.FocusComboBox(cmbCitizen, "Citizenship");
return;
}
else if (Validation.IsTextEmpty(txtResidentialAddress1))
{
tabControl1.SelectedIndex = 0;
Validation.FocusTextBox(txtResidentialAddress1, "Residential street address");
return;
}
else if (txtResidentialAddress2.Text == string.Empty)
{
tabControl1.SelectedIndex = 0;
ShowMessage.CustomErrorMessage("Residential Address2 is empty. Please check the field.");
button2.PerformClick();
}
else if (cmbCivilStatus.Text == "Married" && Validation.IsTextEmpty(txtSpouseName))
{
tabControl1.SelectedIndex = 2;
Validation.FocusTextBox(txtSpouseName, "Spouse Name");
return;
}
else if (Validation.IsTextEmpty(txtDesignation))
{
tabControl1.SelectedIndex = 3;
Validation.FocusTextBox(txtDesignation, "Designation");
return;
}
else if (Validation.IsComboEmpty(cmbDepartment))
{
tabControl1.SelectedIndex = 3;
Validation.FocusComboBox(cmbDepartment, "Department");
return;
}
else if (Validation.IsComboEmpty(cmbEmpType))
{
tabControl1.SelectedIndex = 3;
Validation.FocusComboBox(cmbEmpType, "Employee Type");
return;
}
else if (double.Parse(txtBasicPay.Text) <= 0)
{
tabControl1.SelectedIndex = 3;
MessageBox.Show("Invalid basic pay value.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtBasicPay.Focus();
return;
}
else if (Validation.IsComboEmpty(cmbRateOption))
{
tabControl1.SelectedIndex = 3;
Validation.FocusComboBox(cmbRateOption, "Basic Rate Option");
return;
}
else if (Validation.IsComboEmpty(cmbEmpStatus))
{
tabControl1.SelectedIndex = 3;
Validation.FocusComboBox(cmbEmpStatus, "Employee Status");
return;
}
else
{
string bdate = "";
if (dtBdate.Text == "")
{
bdate = "";
}
else
{
bdate = dtBdate.Value.ToString("yyyy-MM-dd");
}
dtBdate.Format = DateTimePickerFormat.Custom;
EmployeeForInsertModel em = new EmployeeForInsertModel
{
EmployeeBasicInfo = new EmployeeBasicInfoForInsertModel
{
LastName = txtLastName.Text,
FirstName = txtFirstName.Text,
MiddleName = txtMiddleName.Text,
Suffix = cmbSuffix.Text,
BirthDate = bdate,
PlaceOfBirth = txtPlaceOfBirth.Text,
Gender = cmbGender.Text,
Citizenship = cmbCitizen.Text,
Height = txtHeight.Text,
Weight = txtWeight.Text,
Religion = cmbReligion.Text,
ResidentialAddress1 = txtResidentialAddress1.Text,
ResidentialAddress2 = txtResidentialAddress2.Text,
CurrentAddress1 = txtCurrentAddress1.Text,
CurrentAddress2 = txtCurrentAddress2.Text,
CivilStatus = cmbCivilStatus.Text
},
EmployeeEducation = new EmployeeEducationForInsertModel
{
Elementary = txtElementary.Text,
ElemDateGraduated = dtElemGraduated.Value,
HighSchool = txtHighSchool.Text,
HighSchoolDateGraduated = dtHSGraduated.Value,
Vocational = txtVocational.Text,
VocationalCourse = txtVocationalCourse.Text,
VocationalDateGraduated = dtVocGraduated.Value,
College = txtCollege.Text,
CollegeCourse = txtCollegeCourse.Text,
CollegeDateGraduated = dtCollegeGraudated.Value,
HighestEducAttainment = txtEdcuAttainment.Text,
EducationalBackgroundRemarks = txtRemarks.Text
},
EmployeeContactInfo = new EmployeeContactInfoForInsertModel
{
SpouseName = txtSpouseName.Text,
SpouseBirthDate = dtSpouseBdate.Value,
SpouseOccupation = txtSpouseOccupation.Text,
FatherBirthDate = dtFatherBdate.Value,
FatherName = txtFatherName.Text,
FatherOccupation = txtFatherOccupation.Text,
MotherName = txtMotherName.Text,
MotherOccupation = txtMotherOccupation.Text,
MotherBirthDate = dtMotherBdate.Value,
ParentAddress1 = txtParentAddress1.Text,
ParentAddress2 = txtParentAddress2.Text,
ContactNum1 = txtContactNum1.Text,
ContactNum2 = txtContactNum2.Text,
EmailAddress = txtEmailAddress.Text,
ContactPersonName = txtContactPersonName.Text,
ContactPersonNumber = txtContactPersonMobile.Text,
ContactPersonAddress1 = txtContactPersonAddress1.Text,
ContactPersonAddress2 = txtContactPersonAddress2.Text
},
EmployeeEmpInfo = new EmployeeEmpInfoForInsertModel
{
Designation = txtDesignation.Text,
DepartmentId = (int)cmbDepartment.SelectedValue,
EmploymentType = cmbEmpType.Text,
BasicPay = decimal.Parse(txtBasicPay.Text),
DateHired = dtDateHired.Value,
TINNo = txtTIN.Text,
SSSNo = txtSSS.Text,
PhilHealth = txtPhilHealth.Text,
PagIbigNo = txtPagIbig.Text,
CharRefFullName1 = txtCharRefFullName1.Text,
CharRefFullName2 = txtCharRefFullName2.Text,
CharRefFullName3 = txtCharRefFullName3.Text,
CharRefOccupation1 = txtCharRefOccupation1.Text,
CharRefOccupation2 = txtCharRefOccupation2.Text,
CharRefOccupation3 = txtCharRefOccupation3.Text,
CharRefContactNum1 = txtCharRefContactNum1.Text,
CharRefContactNum2 = txtCharRefContactNum2.Text,
CharRefContactNum3 = txtCharRefContactNum3.Text,
EmpStatus = cmbEmpStatus.Text,
BasicRateOption = cmbRateOption.Text
}
};
if (ADD_STATE == true)
{
em.EmployeeBasicInfo.PicName = picName;
result = empSvc.Employee_Insert(em);
if (picPath.Equals(""))
{
picName = "NoPic";
}
else
{
Directory.CreateDirectory(AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + result + "\\");
File.Copy(picPath, AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + result + "\\" + picName, true);
}
if (result > 0)
{
ShowMessage.ShowMessageBox(1);
this.Close();
}
else if (result == -1)
{
ShowMessage.ShowMessageBox(4);
}
else
{
ShowMessage.ShowMessageBox(3);
}
this.Close();
}
else
{
if (picPath != "")
{
em.EmployeeBasicInfo.PicName = picName;
if (!Directory.Exists(AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + employeeId + "\\"))
{
Directory.CreateDirectory(AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + employeeId + "\\");
}
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + employeeId + "\\" + picName) == true)
{
File.Delete(AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + employeeId + "\\" + picName);
File.Copy(picPath, AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + employeeId + "\\" + picName, true);
}
else
{
File.Copy(picPath, AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + employeeId + "\\" + picName, true);
}
}
else
{
em.EmployeeBasicInfo.PicName = emp.EmployeeBasicInfo.PicName;
}
em.EmployeeId = this.employeeId;
empSvc.Employee_Update(em);
ShowMessage.ShowMessageBox(2);
}
}
}
private void frmEmployee_AE_Load(object sender, EventArgs e)
{
loadDepartment();
if (employeeId > 0 && !ADD_STATE)
{
emp = empSvc.Employee_SelectById(employeeId);
label76.Text = "Employee ID No. : " + emp.EmployeeId.ToString("0000");
txtLastName.Text = emp.EmployeeBasicInfo.LastName;
txtFirstName.Text = emp.EmployeeBasicInfo.FirstName;
txtMiddleName.Text = emp.EmployeeBasicInfo.MiddleName;
cmbSuffix.Text = emp.EmployeeBasicInfo.Suffix;
if (emp.EmployeeBasicInfo.BirthDate == "1/1/1900 12:00:00 AM")
{
dtBdate.CustomFormat = " ";
dtBdate.Format = DateTimePickerFormat.Custom;
}
else
{
dtBdate.Value = DateTime.Parse(emp.EmployeeBasicInfo.BirthDate);
}
txtPlaceOfBirth.Text = emp.EmployeeBasicInfo.PlaceOfBirth;
cmbGender.Text = emp.EmployeeBasicInfo.Gender;
cmbCitizen.Text = emp.EmployeeBasicInfo.Citizenship;
txtHeight.Text = emp.EmployeeBasicInfo.Height;
txtWeight.Text = emp.EmployeeBasicInfo.Weight;
cmbReligion.Text = emp.EmployeeBasicInfo.Religion;
txtResidentialAddress1.Text = emp.EmployeeBasicInfo.ResidentialAddress1;
txtResidentialAddress2.Text = emp.EmployeeBasicInfo.ResidentialAddress2;
txtCurrentAddress1.Text = emp.EmployeeBasicInfo.CurrentAddress1;
txtCurrentAddress2.Text = emp.EmployeeBasicInfo.CurrentAddress2;
cmbCivilStatus.Text = emp.EmployeeBasicInfo.CivilStatus;
txtElementary.Text = emp.EmployeeEducation.Elementary;
dtElemGraduated.Value = emp.EmployeeEducation.ElemDateGraduated;
txtHighSchool.Text = emp.EmployeeEducation.HighSchool;
dtHSGraduated.Value = emp.EmployeeEducation.HighSchoolDateGraduated;
txtVocational.Text = emp.EmployeeEducation.Vocational;
txtVocationalCourse.Text = emp.EmployeeEducation.VocationalCourse;
dtVocGraduated.Value = emp.EmployeeEducation.VocationalDateGraduated;
txtCollege.Text = emp.EmployeeEducation.College;
txtCollegeCourse.Text = emp.EmployeeEducation.CollegeCourse;
dtCollegeGraudated.Value = emp.EmployeeEducation.CollegeDateGraduated;
txtEdcuAttainment.Text = emp.EmployeeEducation.HighestEducAttainment;
txtRemarks.Text = emp.EmployeeEducation.EducationalBackgroundRemarks;
txtSpouseName.Text = emp.EmployeeContactInfo.SpouseName;
dtSpouseBdate.Value = emp.EmployeeContactInfo.SpouseBirthDate;
txtSpouseOccupation.Text = emp.EmployeeContactInfo.SpouseOccupation;
dtFatherBdate.Value = emp.EmployeeContactInfo.FatherBirthDate;
txtFatherName.Text = emp.EmployeeContactInfo.FatherName;
txtFatherOccupation.Text = emp.EmployeeContactInfo.FatherOccupation;
txtMotherName.Text = emp.EmployeeContactInfo.MotherName;
txtMotherOccupation.Text = emp.EmployeeContactInfo.MotherOccupation;
dtMotherBdate.Value = emp.EmployeeContactInfo.MotherBirthDate;
txtParentAddress1.Text = emp.EmployeeContactInfo.ParentAddress1;
txtParentAddress2.Text = emp.EmployeeContactInfo.ParentAddress2;
txtContactNum1.Text = emp.EmployeeContactInfo.ContactNum1;
txtContactNum2.Text = emp.EmployeeContactInfo.ContactNum2;
txtEmailAddress.Text = emp.EmployeeContactInfo.EmailAddress;
txtContactPersonName.Text = emp.EmployeeContactInfo.ContactPersonName;
txtContactPersonMobile.Text = emp.EmployeeContactInfo.ContactPersonNumber;
txtContactPersonAddress1.Text = emp.EmployeeContactInfo.ContactPersonAddress1;
txtContactPersonAddress2.Text = emp.EmployeeContactInfo.ContactPersonAddress2;
if (emp.EmployeeBasicInfo.CivilStatus != "Single")
{
txtSpouseName.Enabled = true;
txtSpouseOccupation.Enabled = true;
dtSpouseBdate.Enabled = true;
}
if ((emp.EmployeeBasicInfo.ResidentialAddress1 == emp.EmployeeBasicInfo.CurrentAddress1) && (emp.EmployeeBasicInfo.ResidentialAddress2 == emp.EmployeeBasicInfo.CurrentAddress2))
{
checkBox1.Checked = true;
}
else
{
checkBox1.Checked = false;
}
if ((emp.EmployeeBasicInfo.ResidentialAddress1 == emp.EmployeeContactInfo.ParentAddress1) && (emp.EmployeeBasicInfo.ResidentialAddress2 == emp.EmployeeContactInfo.ParentAddress2))
{
checkBox2.Checked = true;
}
else
{
checkBox2.Checked = false;
}
if (emp.EmployeeEducation.HighestEducAttainment != "")
{
checkBox3.Checked = true;
}
else
{
checkBox3.Checked = false;
}
txtDesignation.Text = emp.EmployeeEmpInfo.Designation;
cmbDepartment.SelectedValue = emp.EmployeeEmpInfo.DepartmentId;
cmbEmpType.Text = emp.EmployeeEmpInfo.EmploymentType;
txtBasicPay.Text = emp.EmployeeEmpInfo.BasicPay.ToString("#,####.00");
dtDateHired.Value = emp.EmployeeEmpInfo.DateHired;
txtTIN.Text = emp.EmployeeEmpInfo.TINNo;
txtSSS.Text = emp.EmployeeEmpInfo.SSSNo;
txtPhilHealth.Text = emp.EmployeeEmpInfo.PhilHealth;
txtPagIbig.Text = emp.EmployeeEmpInfo.PagIbigNo;
txtCharRefFullName1.Text = emp.EmployeeEmpInfo.CharRefFullName1;
txtCharRefFullName2.Text = emp.EmployeeEmpInfo.CharRefFullName2;
txtCharRefFullName3.Text = emp.EmployeeEmpInfo.CharRefFullName3;
txtCharRefOccupation1.Text = emp.EmployeeEmpInfo.CharRefOccupation1;
txtCharRefOccupation2.Text = emp.EmployeeEmpInfo.CharRefOccupation2;
txtCharRefOccupation3.Text = emp.EmployeeEmpInfo.CharRefOccupation3;
txtCharRefContactNum1.Text = emp.EmployeeEmpInfo.CharRefContactNum1;
txtCharRefContactNum2.Text = emp.EmployeeEmpInfo.CharRefContactNum2;
txtCharRefContactNum3.Text = emp.EmployeeEmpInfo.CharRefContactNum3;
cmbEmpStatus.Text = emp.EmployeeEmpInfo.EmpStatus;
cmbRateOption.Text = emp.EmployeeEmpInfo.BasicRateOption;
bttnSave.Text = "&Edit Item";
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + employeeId + "\\" + emp.EmployeeBasicInfo.PicName) == true)
{
picEmployee.Image = Image.FromFile(AppDomain.CurrentDomain.BaseDirectory + "\\EmpPics\\ProfilePic\\" + employeeId + "\\" + emp.EmployeeBasicInfo.PicName, true);
}
button6.Enabled = true;
}
else
{
bttnRefresh.PerformClick();
}
}