public static EEmpPersonalInfo GetObject(DatabaseConnection dbConn, int EmpID)
{
EEmpPersonalInfo m_obj = new EEmpPersonalInfo();
m_obj.EmpID = EmpID;
if (EEmpPersonalInfo.db.select(dbConn, m_obj))
{
return(m_obj);
}
else
{
return(null);
}
}
public double GetAge(DatabaseConnection dbConn, DateTime AsOfDate)
{
if (string.IsNullOrEmpty(m_EmpNo))
{
EEmpPersonalInfo dummyEmpInfo = new EEmpPersonalInfo();
if (dummyEmpInfo.LoadDBObject(dbConn, EmpID))
{
return(dummyEmpInfo.GetAge(dbConn, AsOfDate));
}
else
{
return(0);
}
}
if (this.EmpDateOfBirth.Ticks.Equals(0))
{
return(0);
}
DateTime tmpDateOfBirth = this.EmpDateOfBirth;
return(HROne.CommonLib.Utility.YearDifference(tmpDateOfBirth, AsOfDate.AddDays(-1)));
}
public static EEmpBankAccount GetDefaultBankAccount(DatabaseConnection dbConn, int EmpID)
{
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", EmpID));
filter.add(new Match("EmpAccDefault", "<>", 0));
ArrayList bankAccountList = EEmpBankAccount.db.select(dbConn, filter);
if (bankAccountList.Count > 0)
{
return((EEmpBankAccount)bankAccountList[0]);
}
else
{
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = EmpID;
if (EEmpPersonalInfo.db.select(dbConn, empInfo) && empInfo.MasterEmpID > 0)
{
return(GetDefaultBankAccount(dbConn, empInfo.MasterEmpID));
}
}
return(null);
}
public double GetYearOfServer(DatabaseConnection dbConn, DateTime AsOfDate)
{
if (string.IsNullOrEmpty(m_EmpNo))
{
EEmpPersonalInfo dummyEmpInfo = new EEmpPersonalInfo();
if (dummyEmpInfo.LoadDBObject(dbConn, EmpID))
{
return(dummyEmpInfo.GetYearOfServer(dbConn, AsOfDate));
}
else
{
return(0);
}
}
if (this.EmpServiceDate.Ticks.Equals(0))
{
return(0);
}
DateTime tmpYearOfService = this.EmpServiceDate;
if (tmpYearOfService > AsOfDate)
{
return(0);
}
EEmpTermination empTerm = EEmpTermination.GetObjectByEmpID(dbConn, m_EmpID);
if (empTerm != null)
{
if (empTerm.EmpTermLastDate < AsOfDate)
{
AsOfDate = empTerm.EmpTermLastDate;
}
}
return(HROne.CommonLib.Utility.YearDifference(tmpYearOfService, AsOfDate));
}
public string GetLogText(DatabaseConnection dbConn, string EmpNoFilter, bool ShowHeaderOnly, bool ShowKeyIDOnly, bool DoNotConvertID)
{
StringBuilder logTextBuilder = new StringBuilder();
bool skipGenerateLog = false;
DBFilter auditTrailDetailFilter = new DBFilter();
auditTrailDetailFilter.add(new Match("AuditTrailID", this.AuditTrailID));
ArrayList auditTrailDetailList = EAuditTrailDetail.db.select(dbConn, auditTrailDetailFilter);
int empID = this.EmpID;
if (!string.IsNullOrEmpty(EmpNoFilter.Trim()))
{
if (empID.Equals(0))
{
foreach (EAuditTrailDetail auditTrailDetail in auditTrailDetailList)
{
string tmpRemark = auditTrailDetail.Remark.Replace(" ", "");
int pos = tmpRemark.IndexOf("\nEmpID=", StringComparison.CurrentCultureIgnoreCase);
if (pos >= 0)
{
string empIDString = tmpRemark.Substring(pos + 1, tmpRemark.IndexOf("\n", pos + 1) - pos);
empID = int.Parse(empIDString.Substring(empIDString.IndexOf("=") + 1));
}
}
}
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = empID;
if (EEmpPersonalInfo.db.select(dbConn, empInfo))
{
if (empInfo.EmpNo.IndexOf(EmpNoFilter.Trim(), StringComparison.CurrentCultureIgnoreCase) < 0)
{
skipGenerateLog = true;
}
}
else
{
skipGenerateLog = true;
}
}
if (!skipGenerateLog)
{
ESystemFunction function = new ESystemFunction();
function.FunctionID = this.FunctionID;
if (ESystemFunction.db.select(dbConn, function))
{
logTextBuilder.AppendLine(string.Empty.PadLeft(78, '-'));
EUser user = new EUser();
user.UserID = this.UserID;
if (EUser.db.select(dbConn, user))
{
logTextBuilder.AppendLine("User : \t" + user.LoginID + " - " + user.UserName);
}
else if (this.UserID.Equals(0))
{
logTextBuilder.AppendLine("User : \t" + "System");
}
else
{
logTextBuilder.AppendLine("User : \t" + this.UserID + " (Unknown)");
}
logTextBuilder.AppendLine("Function : \t" + function.FunctionCode + " - " + function.Description);
logTextBuilder.AppendLine("Date/Time: \t" + this.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"));
if (!this.EmpID.Equals(0))
{
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = this.EmpID;
if (EEmpPersonalInfo.db.select(dbConn, empInfo))
{
logTextBuilder.AppendLine("Employee : \t" + empInfo.EmpNo + " - " + empInfo.EmpEngFullName);
}
}
logTextBuilder.AppendLine(string.Empty.PadLeft(78, '-'));
if (!ShowHeaderOnly)
{
foreach (EAuditTrailDetail auditTrailDetail in auditTrailDetailList)
{
if ((auditTrailDetail.Remark.Replace(" ", "").IndexOf("EmpID=" + empID, StringComparison.CurrentCultureIgnoreCase) >= 0 || this.EmpID.Equals(empID)) && !string.IsNullOrEmpty(EmpNoFilter.Trim()) || string.IsNullOrEmpty(EmpNoFilter.Trim()))
{
logTextBuilder.Append(auditTrailDetail.GetLogText(dbConn, ShowKeyIDOnly, DoNotConvertID));
}
}
}
}
//logTextBuilder.AppendLine(string.Empty);
}
return(logTextBuilder.ToString());
}