public List <ss_emp_mas> GetEmployeeList()
{
List <ss_emp_mas> data = new List <ss_emp_mas>();
using (var db = new ORIX_ESS_DB_DevEntities())
{
data = db.ss_emp_mas.Where(w => w.em_sta_ind == "O" && (w.em_rsg_dat == null || w.em_rsg_dat >= DateTime.Now)).ToList();
}
return(data);
}
public ss_emp_mas GetEmployeeDetails(string strEmployeeCode)
{
glog.Debug("GetEmployeeDetails: Entry");
using (var db = new ORIX_ESS_DB_DevEntities())
{
try
{
var dateToday = DateTime.Now;
var list = db.Set <ss_emp_mas>().Where(x => x.em_emp_cod == strEmployeeCode && x.em_sta_ind == "O" && (x.em_rsg_dat == null || x.em_rsg_dat > dateToday)).OrderBy(x => x.em_sht_nam).FirstOrDefault();
glog.Debug("GetEmployeeDetails: Exit");
return(list);
}
catch (Exception ex)
{
glog.Error("GetEmployeeDetails Exception: " + ex.Message);
throw;
}
}
}
private string GetEmailByEmpCode(string code)
{
glog.Debug("GetEmailByEmpCode: Entry");
using (var db = new ORIX_ESS_DB_DevEntities())
{
try
{
var clientname = db.ss_emp_mas.Where(x => x.em_emp_cod == code).Select(x => x.em_smtp_id).FirstOrDefault();
glog.Debug("GetEmailByEmpCode: Exit");
return(clientname);
}
catch (Exception ex)
{
glog.Error("GetEmailByEmpCode Exception: " + ex.Message);
return("");
}
}
}
public string GetFaxNumberByEmployeeDepartmentCode(string strEmployeeDepartmentCode)
{
glog.Debug("GetFaxNumberByEmployeeDepartmentCode: Entry");
using (var db = new ORIX_ESS_DB_DevEntities())
{
try
{
var result = db.ss_dept_det.Where(x => x.dd_dept_cod == strEmployeeDepartmentCode).Select(x =>
x.dd_fax_num).FirstOrDefault();
glog.Debug("GetFaxNumberByEmployeeDepartmentCode: Exit");
return(result);
}
catch (Exception ex)
{
glog.Error("GetFaxNumberByEmployeeDepartmentCode Exception: " + ex.Message);
throw;
}
}
}
public string GetDesignationByEmployeeDesignCode(string strEmployeeDesignCode)
{
glog.Debug("GetDesignationByEmployeeDesignCode: Entry");
using (var db = new ORIX_ESS_DB_DevEntities())
{
try
{
var result = db.ss_para_meter.Where(x => x.pm_par_cod == strEmployeeDesignCode).Select(x =>
x.pm_par_desc).FirstOrDefault();
glog.Debug("GetDesignationByEmployeeDesignCode: Exit");
return(result);
}
catch (Exception ex)
{
glog.Error("GetDesignationByEmployeeDesignCode Exception: " + ex.Message);
throw;
}
}
}
//Get list of value for drop down
public List <SelectListItem> GetListOfValue(string groupType, string parentId, string status, string selectedText, string selectedValue)
{
List <SelectListItem> listOfValue = new List <SelectListItem>();
try
{
using (var db = new MainDbContext())
{
//GroupType
if (String.IsNullOrEmpty(parentId) && String.IsNullOrEmpty(status))
{
listOfValue = db.Sys_ListOfValue.Where(u => u.GroupType.ToString().Trim() == groupType)
.OrderBy(o => o.GroupMemberDesc)
.Select(x =>
new SelectListItem()
{
Text = x.GroupMemberDesc.ToString(),
Value = x.GroupCode.ToString()
}).ToList();
}
//GroupType + Status
else if (String.IsNullOrEmpty(parentId))
{
listOfValue = db.Sys_ListOfValue.Where(u => u.GroupType.ToString().Trim() == groupType && u.Status.ToString().Trim() == status)
.OrderBy(o => o.GroupMemberDesc)
.Select(x =>
new SelectListItem()
{
Text = x.GroupMemberDesc.ToString(),
Value = x.GroupCode.ToString()
}).ToList();
}
//GroupType + ParentId
else if (String.IsNullOrEmpty(status))
{
listOfValue = db.Sys_ListOfValue.Where(u => u.GroupType.ToString().Trim() == groupType && u.ParentID.ToString().Trim() == parentId)
.OrderBy(o => o.GroupMemberDesc)
.Select(x =>
new SelectListItem()
{
Text = x.GroupMemberDesc.ToString(),
Value = x.GroupCode.ToString()
}).ToList();
}
//GroupType + ParentId + Status
else
{
listOfValue = db.Sys_ListOfValue.Where(u => u.GroupType.ToString().Trim() == groupType && u.Status.ToString().Trim() == status && u.ParentID.ToString().Trim() == parentId)
.OrderBy(o => o.GroupMemberDesc)
.Select(x =>
new SelectListItem()
{
Text = x.GroupMemberDesc.ToString(),
Value = x.GroupCode.ToString()
}).ToList();
}
if (groupType == "FINANCIAL_SERVICES_SALES_DEPARTMENT")
{
var orixDb = new ORIX_ESS_DB_DevEntities();
var groupCode = listOfValue.Select(x => x.Value).ToList();
var dateToday = DateTime.Now;
var list = orixDb.Set <ss_emp_mas>().Where(x => groupCode.Contains(x.em_dept_cod) && x.em_sta_ind == "O" && (x.em_rsg_dat == null || x.em_rsg_dat > dateToday))
.OrderBy(x => x.em_sht_nam).ToList();
listOfValue = list.Select(x => new SelectListItem()
{
Text = x.em_sht_nam,
Value = x.em_emp_cod
}).ToList();
}
//Looping to set selected item
for (int i = 0; i < listOfValue.Count; i++)
{
if (listOfValue[i].Text.ToString().Trim() == selectedText)
{
listOfValue[i].Selected = true;
}
if (listOfValue[i].Value.ToString().Trim() == selectedValue)
{
listOfValue[i].Selected = true;
}
}
}
}
catch (Exception ex)
{
glog.Error(ex.Message);
}
return(listOfValue);
}
