protected void Save_Click(object sender, EventArgs e)
{
EEmpDocument c = new EEmpDocument();
Hashtable values = new Hashtable();
binding.toValues(values);
PageErrors errors = PageErrors.getErrors(db, Page.Master);
errors.clear();
db.validate(errors, values);
if (!errors.isEmpty())
{
return;
}
db.parse(values, c);
if (CurID < 0)
{
if (!UploadDocumentFile.HasFile)
{
errors.addError(HROne.Translation.PageErrorMessage.ERROR_INVALID_FILE);
return;
}
string errorMessage = string.Empty;
if (HROne.CommonLib.FileIOProcess.IsFolderAllowWritePermission(uploadFolder, out errorMessage))
{
// Utils.MarkCreate(Session, c);
string uploadFullName = UploadToDocumentFolder();
c.EmpDocumentOriginalFileName = UploadDocumentFile.FileName;
c.EmpDocumentStoredFileName = uploadFullName;
c.EmpDocumentIsCompressed = true;
WebUtils.StartFunction(Session, FUNCTION_CODE, c.EmpID);
db.insert(dbConn, c);
WebUtils.EndFunction(dbConn);
CurID = c.EmpDocumentID;
}
else
{
errors.addError(errorMessage);
return;
}
// url = Utils.BuildURL(-1, CurID);
}
else
{
// Utils.Mark(Session, c);
WebUtils.StartFunction(Session, FUNCTION_CODE, c.EmpID);
db.update(dbConn, c);
WebUtils.EndFunction(dbConn);
}
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/Emp_Document_View.aspx?EmpDocumentID=" + CurID + "&EmpID=" + c.EmpID);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!WebUtils.CheckAccess(Response, Session, FUNCTION_CODE, WebUtils.AccessLevel.Read))
{
return;
}
int EmpDocumentID = 0;
int EmpID = 0;
try
{
EmpDocumentID = int.Parse(DecryptedRequest["EmpDocumentID"]);
EmpID = int.Parse(DecryptedRequest["EmpID"]);
}
catch
{
return;
}
//string pathDelimiter = System.IO.Path.DirectorySeparatorChar.ToString();
EEmpDocument empDocument = new EEmpDocument();
empDocument.EmpDocumentID = EmpDocumentID;
if (EEmpDocument.db.select(dbConn, empDocument))
{
if (empDocument.EmpID.Equals(EmpID))
{
string documentFilePath = empDocument.GetDocumentPhysicalPath(dbConn);
string transferFilePath = documentFilePath;
string strTmpFolder = string.Empty;
if (empDocument.EmpDocumentIsCompressed)
{
transferFilePath = empDocument.GetExtractedFilePath(dbConn);
}
if (System.IO.File.Exists(transferFilePath))
{
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/download"; //Fixed download problem on https
Response.AddHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode(empDocument.EmpDocumentOriginalFileName));
Response.AppendHeader("Content-Length", new System.IO.FileInfo(transferFilePath).Length.ToString());
Response.Expires = -1;
Response.WriteFile(transferFilePath, true);
Response.Flush();
// WebUtils.TransmitFile(Response, strTmpFolder + pathDelimiter+ fileList[0], empDocument.EmpDocumentOriginalFileName, true);
}
empDocument.RemoveExtractedFile();
Response.End();
}
}
}
protected bool loadObject()
{
obj = new EEmpDocument();
bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest);
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", CurEmpID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
if (EEmpPersonalInfo.db.count(dbConn, filter) == 0)
{
if (CurEmpID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
if (!db.select(dbConn, obj))
{
if (CurID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
if (obj.EmpID != CurEmpID)
{
if (CurID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
return(true);
}
protected void SetAsProfilePhoto_Click(object sender, EventArgs e)
{
DBFilter filter = new DBFilter();
filter.add(new Match("EmpDocumentID", "<>", CurID));
filter.add(new Match("EmpID", CurEmpID));
filter.add(new Match("EmpDocumentIsProfilePhoto", "<>", false));
EEmpDocument t = new EEmpDocument();
t.EmpDocumentIsProfilePhoto = false;
db.updateByTemplate(dbConn, t, filter);
EEmpDocument empDocument = new EEmpDocument();
empDocument.EmpDocumentID = CurID;
empDocument.EmpDocumentIsProfilePhoto = true;
EEmpDocument.db.update(dbConn, empDocument);
toolBar.CustomButton1_Visible = false;
}
protected void Delete_Click(object sender, EventArgs e)
{
EEmpDocument c = new EEmpDocument();
c.EmpDocumentID = CurID;
db.select(dbConn, c);
WebUtils.StartFunction(Session, FUNCTION_CODE, c.EmpID);
db.delete(dbConn, c);
WebUtils.EndFunction(dbConn);
try
{
string UploadFile = System.IO.Path.Combine(uploadFolder, c.EmpDocumentStoredFileName);
if (System.IO.File.Exists(UploadFile))
{
System.IO.File.Delete(UploadFile);
}
}
catch
{
}
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "EmpTab_Document_View.aspx?EmpID=" + EmpID.Value);
}
protected void Delete_Click(object sender, EventArgs e)
{
ArrayList list = new ArrayList();
foreach (RepeaterItem i in Repeater.Items)
{
CheckBox cb = (CheckBox)i.FindControl("ItemSelect");
if (cb.Checked)
{
EEmpDocument o = new EEmpDocument();
WebFormUtils.GetKeys(sdb, o, cb);
list.Add(o);
}
}
foreach (EEmpDocument o in list)
{
if (sdb.select(dbConn, o))
{
WebUtils.StartFunction(Session, FUNCTION_CODE, o.EmpID);
sdb.delete(dbConn, o);
WebUtils.EndFunction(dbConn);
try
{
string UploadFile = System.IO.Path.Combine(uploadFolder, o.EmpDocumentStoredFileName);
if (System.IO.File.Exists(UploadFile))
{
System.IO.File.Delete(UploadFile);
}
}
catch
{
}
}
}
loadData(info, sdb, Repeater);
}
public override ReportDocument GenerateReport()
{
if (EmpList.Count > 0)
{
string HierarchyLevel1 = " ";
string HierarchyLevel2 = " ";
string HierarchyLevel3 = " ";
ArrayList HierarchyLevelList = EHierarchyLevel.db.select(dbConn, new DBFilter());
foreach (EHierarchyLevel hLevel in HierarchyLevelList)
{
if (hLevel.HLevelSeqNo.Equals(1))
{
HierarchyLevel1 = hLevel.HLevelDesc;
}
else if (hLevel.HLevelSeqNo.Equals(2))
{
HierarchyLevel2 = hLevel.HLevelDesc;
}
else if (hLevel.HLevelSeqNo.Equals(3))
{
HierarchyLevel3 = hLevel.HLevelDesc;
}
}
DataSet.EmployeeDetail ds = new DataSet.EmployeeDetail();
ArrayList empExtraFieldList = EEmpExtraField.db.select(dbConn, new DBFilter());
DataSet.EmployeeDetail.EmpExtraFieldDataTable empExtraFieldTable = ds.EmpExtraField;
foreach (EEmpExtraField empExtraField in empExtraFieldList)
{
DataSet.EmployeeDetail.EmpExtraFieldRow empExtraFieldRow = empExtraFieldTable.NewEmpExtraFieldRow();
empExtraFieldRow.EmpExtraFieldGroupName = empExtraField.EmpExtraFieldGroupName;
empExtraFieldRow.EmpExtraFieldID = empExtraField.EmpExtraFieldID;
empExtraFieldRow.EmpExtraFieldName = empExtraField.EmpExtraFieldName;
if (empExtraFieldRow.IsEmpExtraFieldGroupNameNull())
{
empExtraFieldRow.EmpExtraFieldGroupName = "Extra Information";
}
empExtraFieldTable.Rows.Add(empExtraFieldRow);
}
foreach (int EmpID in EmpList)
{
DataSet.EmployeeDetail.employeedetailRow empRow = ImportEmployeeDetailRow(dbConn, ds.employeedetail, EmpID, AppUtils.ServerDateTime().Date);
EEmpDocument empDocument = EEmpDocument.GetProfilePhotoEmpDocument(dbConn, EmpID);
if (empDocument != null)
{
string documentFilePath = empDocument.GetDocumentPhysicalPath(dbConn);
string transferFilePath = documentFilePath;
string strTmpFolder = string.Empty;
if (empDocument.EmpDocumentIsCompressed)
{
transferFilePath = empDocument.GetExtractedFilePath(dbConn);
}
empRow.PhotoByteArray = ThumbnailToByteArray(transferFilePath, 200, 200);
empDocument.RemoveExtractedFile();
}
DBFilter empFilter = new DBFilter();
empFilter.add(new Match("EmpID", EmpID));
DBFilter empPosFilter = new DBFilter();
empPosFilter.add(new Match("EmpID", EmpID));
empPosFilter.add("EmpPosEffFr", false);
ArrayList empPosList = EEmpPositionInfo.db.select(dbConn, empPosFilter);
DataSet.EmployeeDetail.EmpPositionInfoDataTable empPosTable = ds.EmpPositionInfo;
foreach (EEmpPositionInfo empPos in empPosList)
{
DataSet.EmployeeDetail.EmpPositionInfoRow row = empPosTable.NewEmpPositionInfoRow();
row.CompanyID = empPos.CompanyID;
row.EmpID = empPos.EmpID;
row.EmpPosEffFr = empPos.EmpPosEffFr;
if (!empPos.EmpPosEffTo.Ticks.Equals(0))
{
row.EmpPosEffTo = empPos.EmpPosEffTo;
}
row.EmpPosID = empPos.EmpPosID;
row.LeavePlanID = empPos.LeavePlanID;
row.PayGroupID = empPos.PayGroupID;
EPosition position = new EPosition();
position.PositionID = empPos.PositionID;
if (EPosition.db.select(dbConn, position))
{
row.PositionCode = position.PositionCode;
row.PositionDesc = position.PositionDesc;
row.PositionID = position.PositionID;
}
ERank rank = new ERank();
rank.RankID = empPos.RankID;
if (ERank.db.select(dbConn, rank))
{
row.RankCode = rank.RankCode;
row.RankDesc = rank.RankDesc;
row.RankID = rank.RankID;
}
row.StaffTypeID = empPos.StaffTypeID;
foreach (EHierarchyLevel hLevel in HierarchyLevelList)
{
if (hLevel.HLevelSeqNo < 4 && hLevel.HLevelSeqNo > 0)
{
DBFilter empHierarchyFilter = new DBFilter();
empHierarchyFilter.add(new Match("EmpPosID", empPos.EmpPosID));
empHierarchyFilter.add(new Match("HLevelID", hLevel.HLevelID));
ArrayList empHierarchyList = EEmpHierarchy.db.select(dbConn, empHierarchyFilter);
if (empHierarchyList.Count > 0)
{
EEmpHierarchy empHierarchy = (EEmpHierarchy)empHierarchyList[0];
EHierarchyElement hElement = new EHierarchyElement();
hElement.HElementID = empHierarchy.HElementID;
EHierarchyElement.db.select(dbConn, hElement);
row["HierarchyCode" + hLevel.HLevelSeqNo] = hElement.HElementCode;
row["HierarchyDesc" + hLevel.HLevelSeqNo] = hElement.HElementDesc;
}
}
}
empPosTable.AddEmpPositionInfoRow(row);
}
DBFilter empRPFilter = new DBFilter();
empRPFilter.add(new Match("EmpID", EmpID));
empRPFilter.add("empRPEffFr", false);
ArrayList empRPList = EEmpRecurringPayment.db.select(dbConn, empRPFilter);
DataSet.EmployeeDetail.EmpRecurringPaymentDataTable empRPTable = ds.EmpRecurringPayment;
foreach (EEmpRecurringPayment empRP in empRPList)
{
DataSet.EmployeeDetail.EmpRecurringPaymentRow row = empRPTable.NewEmpRecurringPaymentRow();
row.CurrencyID = empRP.CurrencyID;
row.EmpAccID = empRP.EmpAccID;
row.EmpID = empRP.EmpID;
row.EmpRPAmount = Convert.ToDecimal(empRP.EmpRPAmount);
row.EmpRPEffFr = empRP.EmpRPEffFr;
if (!empRP.EmpRPEffTo.Ticks.Equals(0))
{
row.EmpRPEffTo = empRP.EmpRPEffTo;
}
row.EmpRPID = empRP.EmpRPID;
if (empRP.EmpRPMethod.Equals("A"))
{
row.EmpRPMethod = HROne.Common.WebUtility.GetLocalizedString("Autopay");
}
else if (empRP.EmpRPMethod.Equals("Q"))
{
row.EmpRPMethod = HROne.Common.WebUtility.GetLocalizedString("Cheque");
}
else if (empRP.EmpRPMethod.Equals("C"))
{
row.EmpRPMethod = HROne.Common.WebUtility.GetLocalizedString("Cash");
}
else if (empRP.EmpRPMethod.Equals("O"))
{
row.EmpRPMethod = HROne.Common.WebUtility.GetLocalizedString("Others");
}
row.EmpRPRemark = empRP.EmpRPRemark;
row.EmpRPUnit = empRP.EmpRPUnit;
EPaymentCode paymentCode = new EPaymentCode();
paymentCode.PaymentCodeID = empRP.PayCodeID;
if (EPaymentCode.db.select(dbConn, paymentCode))
{
row.PayCodeID = paymentCode.PaymentCodeID;
row.PaymentCode = paymentCode.PaymentCode;
row.PaymentCodeDesc = paymentCode.PaymentCodeDesc;
row.PaymentCodeID = paymentCode.PaymentCodeID;
// row.p
}
empRPTable.AddEmpRecurringPaymentRow(row);
}
EmployeeBankAccountProcess.ImportEmpBankAccountRow(dbConn, ds.EmpBankAccount, EmpID);
ArrayList empSpouseList = EEmpSpouse.db.select(dbConn, empFilter);
DataSet.EmployeeDetail.EmpSpouseDataTable empSpouseTable = ds.EmpSpouse;
foreach (EEmpSpouse empSpouse in empSpouseList)
{
DataSet.EmployeeDetail.EmpSpouseRow row = empSpouseTable.NewEmpSpouseRow();
row.EmpID = empSpouse.EmpID;
row.EmpSpouseChineseName = empSpouse.EmpSpouseChineseName;
//empSpouse.EmpSpouseDateOfBirth;
row.EmpSpouseHKID = empSpouse.EmpSpouseHKID;
row.EmpSpouseID = empSpouse.EmpSpouseID;
row.EmpSpouseOtherName = empSpouse.EmpSpouseOtherName;
row.EmpSpousePassportIssuedCountry = empSpouse.EmpSpousePassportIssuedCountry;
row.EmpSpousePassportNo = empSpouse.EmpSpousePassportNo;
row.EmpSpouseSurname = empSpouse.EmpSpouseSurname;
// Start 0000142, KuangWei, 2014-12-21
row.EmpGender = empSpouse.EmpGender;
if (empSpouse.EmpIsMedicalSchemaInsured)
{
row.EmpIsMedicalSchemaInsured = "Yes";
}
else
{
row.EmpIsMedicalSchemaInsured = "No";
}
row.EmpMedicalEffectiveDate = empSpouse.EmpMedicalEffectiveDate;
row.EmpMedicalExpiryDate = empSpouse.EmpMedicalExpiryDate;
// End 0000142, KuangWei, 2014-12-21
empSpouseTable.AddEmpSpouseRow(row);
}
ArrayList empDependantList = EEmpDependant.db.select(dbConn, empFilter);
DataSet.EmployeeDetail.EmpDependantDataTable empDependantTable = ds.EmpDependant;
foreach (EEmpDependant empDependant in empDependantList)
{
DataSet.EmployeeDetail.EmpDependantRow row = empDependantTable.NewEmpDependantRow();
row.EmpID = empDependant.EmpID;
row.EmpDependantChineseName = empDependant.EmpDependantChineseName;
//empDependant.EmpDependantDateOfBirth;
row.EmpDependantGender = empDependant.EmpDependantGender;
row.EmpDependantHKID = empDependant.EmpDependantHKID;
row.EmpDependantID = empDependant.EmpDependantID;
row.EmpDependantOtherName = empDependant.EmpDependantOtherName;
row.EmpDependantPassportIssuedCountry = empDependant.EmpDependantPassportIssuedCountry;
row.EmpDependantPassportNo = empDependant.EmpDependantPassportNo;
row.EmpDependantRelationship = empDependant.EmpDependantRelationship;
row.EmpDependantSurname = empDependant.EmpDependantSurname;
empDependantTable.AddEmpDependantRow(row);
}
DBFilter empQualificationFilter = new DBFilter();
empQualificationFilter.add(new Match("EmpID", EmpID));
empQualificationFilter.add("EmpQualificationFrom", false);
ArrayList empQualificationList = EEmpQualification.db.select(dbConn, empQualificationFilter);
DataSet.EmployeeDetail.EmpQualificationDataTable empQualificationTable = ds.EmpQualification;
foreach (EEmpQualification empQualification in empQualificationList)
{
DataSet.EmployeeDetail.EmpQualificationRow row = empQualificationTable.NewEmpQualificationRow();
row.EmpID = empQualification.EmpID;
if (!empQualification.EmpQualificationFrom.Ticks.Equals(0))
{
row.EmpQualificationFrom = empQualification.EmpQualificationFrom;
}
if (!empQualification.EmpQualificationTo.Ticks.Equals(0))
{
row.EmpQualificationTo = empQualification.EmpQualificationTo;
}
row.EmpQualificationID = empQualification.EmpQualificationID;
row.EmpQualificationInstitution = empQualification.EmpQualificationInstitution;
row.EmpQualificationRemark = empQualification.EmpQualificationRemark;
EQualification qualification = new EQualification();
qualification.QualificationID = empQualification.QualificationID;
if (EQualification.db.select(dbConn, qualification))
{
row.QualificationID = qualification.QualificationID;
row.QualificationCode = qualification.QualificationCode;
row.QualificationDesc = qualification.QualificationDesc;
}
empQualificationTable.AddEmpQualificationRow(row);
}
ArrayList empSkillList = EEmpSkill.db.select(dbConn, empFilter);
DataSet.EmployeeDetail.EmpSkillDataTable empSkillTable = ds.EmpSkill;
foreach (EEmpSkill empSkill in empSkillList)
{
DataSet.EmployeeDetail.EmpSkillRow row = empSkillTable.NewEmpSkillRow();
row.EmpID = empSkill.EmpID;
row.EmpSkillID = empSkill.EmpSkillID;
ESkill skill = new ESkill();
skill.SkillID = empSkill.SkillID;
if (ESkill.db.select(dbConn, skill))
{
row.SkillID = skill.SkillID;
row.SkillCode = skill.SkillCode;
row.SkillDesc = skill.SkillDesc;
}
ESkillLevel skillLevel = new ESkillLevel();
skillLevel.SkillLevelID = empSkill.SkillLevelID;
if (ESkillLevel.db.select(dbConn, skillLevel))
{
row.SkillLevelID = skillLevel.SkillLevelID;
row.SkillLevelCode = skillLevel.SkillLevelCode;
row.SkillLevelDesc = skillLevel.SkillLevelDesc;
}
empSkillTable.AddEmpSkillRow(row);
}
ArrayList empWorkExpList = EEmpWorkExp.db.select(dbConn, empFilter);
DataSet.EmployeeDetail.EmpWorkExpDataTable empWorkExpTable = ds.EmpWorkExp;
foreach (EEmpWorkExp empWorkExp in empWorkExpList)
{
DataSet.EmployeeDetail.EmpWorkExpRow row = empWorkExpTable.NewEmpWorkExpRow();
row.EmpID = empWorkExp.EmpID;
row.EmpWorkExpID = empWorkExp.EmpWorkExpID;
row.EmpWorkExpFromMonth = empWorkExp.EmpWorkExpFromMonth;
row.EmpWorkExpFromYear = empWorkExp.EmpWorkExpFromYear;
row.EmpWorkExpToYear = empWorkExp.EmpWorkExpToYear;
row.EmpWorkExpToMonth = empWorkExp.EmpWorkExpToMonth;
row.EmpWorkExpPosition = empWorkExp.EmpWorkExpPosition;
row.EmpWorkExpCompanyName = empWorkExp.EmpWorkExpCompanyName;
row.EmpWorkExpRemark = empWorkExp.EmpWorkExpRemark;
empWorkExpTable.AddEmpWorkExpRow(row);
}
ArrayList empExtraFieldValueList = EEmpExtraFieldValue.db.select(dbConn, empFilter);
DataSet.EmployeeDetail.EmpExtraFieldValueDataTable empExtraFieldValueTable = ds.EmpExtraFieldValue;
foreach (EEmpExtraFieldValue empExtraFieldValue in empExtraFieldValueList)
{
DataSet.EmployeeDetail.EmpExtraFieldValueRow row = empExtraFieldValueTable.NewEmpExtraFieldValueRow();
row.EmpID = empExtraFieldValue.EmpID;
row.EmpExtraFieldValueID = empExtraFieldValue.EmpExtraFieldValueID;
row.EmpExtraFieldID = empExtraFieldValue.EmpExtraFieldID;
row.EmpExtraFieldValue = empExtraFieldValue.EmpExtraFieldValue;
empExtraFieldValueTable.AddEmpExtraFieldValueRow(row);
}
//DBFilter filter = new DBFilter();
//filter.add(new Match("P.EmpID", EmpID));
//select = "P.*,EmpPos.*,Pos.*";
//from = "from EmpPersonalInfo P LEFT JOIN EmpPositionInfo EmpPos ON P.EmpID=EmpPos.EmpID AND EmpPos.EmpPosEffTo IS NULL LEFT JOIN Position Pos ON EmpPos.PositionID=Pos.PositionID";
//filter.loadData(ds, "employeedetail", null, select, from, null);
//select = "P.*,Pos.PositionCode,Pos.PositionDesc,R.RankCode, R.RankDesc";
//from = "from EmpPositionInfo P LEFT JOIN Position Pos ON P.PositionID=Pos.PositionID LEFT JOIN Rank R ON P.RankID=R.RankID";
//filter.loadData(ds, "EmpPositionInfo", null, select, from, null);
//select = "P.*,C.*";
//from = "from EmpRecurringPayment P LEFT JOIN PaymentCode C ON P.PayCodeID=C.PaymentCodeID ";
//filter.loadData(ds, "EmpRecurringPayment", null, select, from, null);
//select = "P.*";
//from = "from EmpBankAccount P ";
//filter.loadData(ds, "EmpBankAccount", null, select, from, null);
//select = "P.*";
//from = "from EmpSpouse P ";
//filter.loadData(ds, "EmpSpouse", null, select, from, null);
//select = "P.*";
//from = "from EmpDependant P ";
//filter.loadData(ds, "EmpDependant", null, select, from, null);
//select = "P.*, Q.*";
//from = "from EmpQualification P LEFT JOIN Qualification Q on P.QualificationID=Q.QualificationID";
//filter.loadData(ds, "EmpQualification", null, select, from, null);
//select = "P.*, S.*,L.*";
//from = "from EmpSkill P LEFT JOIN Skill S ON P.SkillID=S.SkillID LEFT JOIN SkillLevel L on P.SkillLevelID=L.SkillLevelID";
//filter.loadData(ds, "EmpSkill", null, select, from, null);
}
//DBAESEncryptStringFieldAttribute.decode(ds.Tables["employeedetail"], "EmpHKID", true);
//DBAESEncryptStringFieldAttribute.decode(ds.Tables["employeedetail"], "EmpPassportNo", false);
//DBAESEncryptStringFieldAttribute.decode(ds.Tables["employeedetail"], "EmpResAddr", true);
//DBAESEncryptStringFieldAttribute.decode(ds.Tables["employeedetail"], "EmpCorAddr", true);
//DBAESEncryptStringFieldAttribute.decode(ds.Tables["EmpSpouse"], "EmpSpouseHKID", false);
//DBAESEncryptStringFieldAttribute.decode(ds.Tables["EmpSpouse"], "EmpSpousePassportNo", false);
//DBAESEncryptStringFieldAttribute.decode(ds.Tables["EmpDependant"], "EmpDependantHKID", false);
//DBAESEncryptStringFieldAttribute.decode(ds.Tables["EmpDependant"], "EmpDependantPassportNo", false);
if (reportDocument == null)
{
reportDocument = new ReportTemplate.Report_Employee_Detail();
}
else
{
}
reportDocument.SetDataSource(ds);
reportDocument.SetParameterValue("HierarchyLevel1", HierarchyLevel1);
reportDocument.SetParameterValue("HierarchyLevel2", HierarchyLevel2);
reportDocument.SetParameterValue("HierarchyLevel3", HierarchyLevel3);
reportDocument.SetParameterValue("HierarchyLevel1", HierarchyLevel1, "PositionInfo");
reportDocument.SetParameterValue("HierarchyLevel2", HierarchyLevel2, "PositionInfo");
reportDocument.SetParameterValue("HierarchyLevel3", HierarchyLevel3, "PositionInfo");
return(reportDocument);
}
else
{
return(null);
}
}
protected bool loadObject()
{
obj = new EEmpDocument();
bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest);
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", CurEmpID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
if (EEmpPersonalInfo.db.count(dbConn, filter) == 0)
{
if (CurEmpID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
if (!db.select(dbConn, obj))
{
if (CurID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
if (obj.EmpID != CurEmpID)
{
if (CurID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
if (obj.EmpDocumentIsProfilePhoto)
{
toolBar.CustomButton1_Visible = false;
}
else
{
EDocumentType documentType = new EDocumentType();
documentType.DocumentTypeID = obj.DocumentTypeID;
EDocumentType.db.select(dbConn, documentType);
if (documentType.DocumentTypeCode.Equals("PHOTO"))
{
toolBar.CustomButton1_Visible = true;
}
else
{
toolBar.CustomButton1_Visible = false;
}
}
return(true);
}
protected bool loadObject()
{
lblLastEmploymentDateValue.Visible = false;
obj = new EEmpPersonalInfo();
bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest);
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", obj.EmpID));
filter.add(WebUtils.AddRankFilter(Session, "EmpID", true));
ArrayList empInfoList = EEmpPersonalInfo.db.select(dbConn, filter);
if (empInfoList.Count == 0)
{
if (CurID <= 0)
{
return(false);
}
else
{
HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx");
}
}
obj = (EEmpPersonalInfo)empInfoList[0];
EEmpTermination empTerm = EEmpTermination.GetObjectByEmpID(dbConn, obj.EmpID);
NewEmpNoPanel.Visible = false;
lblLastEmploymentDateValue.Visible = false;
if (empTerm != null)
{
lblLastEmploymentDateValue.Visible = true;
lblLastEmploymentDateValue.Text = empTerm.EmpTermLastDate.ToString("yyyy-MM-dd");
EEmpPersonalInfo newEmpInfo = new EEmpPersonalInfo();
newEmpInfo.EmpID = empTerm.NewEmpID;
if (EEmpPersonalInfo.db.select(dbConn, newEmpInfo))
{
NewEmpNoPanel.Visible = true;
hlNewEmpNo.Text = newEmpInfo.EmpNo;
hlNewEmpNo.NavigateUrl = "~/Emp_View.aspx?EmpID=" + newEmpInfo.EmpID;
}
}
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
EEmpDocument empDocument = EEmpDocument.GetProfilePhotoEmpDocument(dbConn, obj.EmpID);
if (empDocument != null)
{
ProfilePhotoCell.Visible = true;
ProfilePhoto.ImageUrl = "~/Emp_Document_Download.aspx?EmpID=" + empDocument.EmpID + "&EmpDocumentID=" + empDocument.EmpDocumentID;
ProfilePhoto.Width = new Unit(100);
}
else
{
ProfilePhotoCell.Visible = false;
}
EEmpPersonalInfo prevEmpInfo = obj.GetPreviousEmpInfo(dbConn);
if (prevEmpInfo == null)
{
PrevEmpNoRow.Visible = false;
}
else
{
hlPreviousEmpNo.Text = prevEmpInfo.EmpNo;
hlPreviousEmpNo.NavigateUrl = "~/Emp_View.aspx?EmpID=" + prevEmpInfo.EmpID;
PrevEmpNoRow.Visible = true;
}
MasterEmpNoRow.Visible = false;
if (obj.MasterEmpID > 0)
{
EEmpPersonalInfo masterEmpInfo = new EEmpPersonalInfo();
masterEmpInfo.EmpID = obj.MasterEmpID;
if (EEmpPersonalInfo.db.select(dbConn, masterEmpInfo))
{
hlMasterEmpNo.Text = masterEmpInfo.EmpNo;
hlMasterEmpNo.NavigateUrl = "~/Emp_View.aspx?EmpID=" + masterEmpInfo.EmpID;
MasterEmpNoRow.Visible = true;
}
}
ArrayList childRoleList = obj.GetOtherRoleList(dbConn);
if (childRoleList.Count <= 0)
{
ChildRoleEmpNoRow.Visible = false;
}
else
{
ChildRoleEmpNoRow.Visible = true;
ChildRoleEmpNoRepeater.DataSource = childRoleList;
ChildRoleEmpNoRepeater.DataBind();
}
double age = AppUtils.GetAge(obj.EmpDateOfBirth);
if (!double.IsNaN(age))
{
lblAge.Text = HROne.CommonLib.GenericRoundingFunctions.RoundingDown(age, 0, 3).ToString("0");
}
else
{
lblAge.Text = string.Empty;
}
double yearOfService = obj.GetYearOfServer(dbConn, AppUtils.ServerDateTime());
if (!double.IsNaN(yearOfService))
{
lblYearOfService.Text = HROne.CommonLib.GenericRoundingFunctions.RoundingDown(yearOfService, 1, 3).ToString("0.0");
}
else
{
lblYearOfService.Text = string.Empty;
}
return(true);
}
