public IList <HREmployee_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression)
{
IList <HREmployee_DetailedEntity> hREmployee_DetailedEntityList = new List <HREmployee_DetailedEntity>();
try
{
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = "HREmployee.SalaryLevel desc";
}
Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1;
//startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1;
if (pageSize == -1)
{
pageSize = 1000000000;
}
hREmployee_DetailedEntityList = FCCHREmployee_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression);
if (hREmployee_DetailedEntityList != null && hREmployee_DetailedEntityList.Count > 0)
{
totalRowCount = hREmployee_DetailedEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(hREmployee_DetailedEntityList ?? new List <HREmployee_DetailedEntity>());
}
private HREmployee_DetailedEntity GetHREmployeeInfo(Int64 employeeID)
{
IList <HREmployee_DetailedEntity> list = FCCHREmployee_Detailed.GetFacadeCreate().GetIL(1000, 1, String.Empty, String.Empty);
HREmployee_DetailedEntity ent = list.Single(x => x.EmployeeID == employeeID);
return(ent);
}
private HREmployee_DetailedEntity GetHREmployeeInfo(Int64 employeeID)
{
HREmployee_DetailedEntity ent = null;
String fe = "HREmployee.EmployeeID =" + employeeID + "";
IList <HREmployee_DetailedEntity> list = FCCHREmployee_Detailed.GetFacadeCreate().GetIL(1000, 1, String.Empty, fe);
if (list != null && list.Count > 0)
{
ent = list.Single(x => x.EmployeeID == employeeID);
}
return(ent);
}
private void SendMail(HREmployeeLeaveApplicationEntity hREmployeeLeaveApplicationEntity)
{
HREmployeeLeaveApplicationEntity entity = hREmployeeLeaveApplicationEntity;
String fe = "EmployeeID = " + entity.BackupEmployeeID + "";
IList <HREmployee_DetailedEntity> listEmployee = FCCHREmployee_Detailed.GetFacadeCreate().GetIL(1000, 1, String.Empty, fe);
String EmployeeName = listEmployee[0].EmployeeFullName;
String EmployeeCode = listEmployee[0].EmployeeCode;
Int64 BackupEmployeeID = (Int64)entity.BackupEmployeeID;
#region Notice Mail
String MailBody = String.Empty;
String Subject = String.Empty;
//int count = 0;
StringBuilder sb = new StringBuilder();
sb.Append("Dear Sir,");
sb.Append("<br/>");
sb.Append("This is a auto generated mail from the ERP.");
sb.Append("<br/>");
sb.Append("Employee Name: " + EmployeeName + " Code :" + EmployeeCode + " is going to take " + entity.TotalLeaveDays + " days leave. And you are the back employee or assigned to his/her work. .");
sb.Append("<br/>");
sb.Append("Please contact with him/her if you have any problem.");
sb.Append("<br/>");
sb.Append("-");
sb.Append("<br/>");
sb.Append("Thanks");
sb.Append("<br/>");
sb.Append("ERP System");
MailBody = sb.ToString();
Subject = "ERP, Leave";
String[] sendToMail = new String[1];
HREmployeeEntity _hREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetByID(BackupEmployeeID);
if (_hREmployeeEntity != null)
{
sendToMail[0] = _hREmployeeEntity.PrimaryEmail;
}
MiscUtil.SendMail(sendToMail, Subject, MailBody);
#endregion
}
