public JsonResult GetAdminRoles()
{
string LoginUser = (string)Session["LoginSAPID"];
try
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchAllRoles();
dt.TableName = "FetchRoles";
var roles = (from DataRow dr in dt.Rows
where dr["isexternal"].ToString().Trim() != "Y"
select new Models.UserRoles()
{
ID = dr["ID"].ToString(),
Name = dr["Name"].ToString(),
Code = dr["Code"].ToString()
}).ToList();
return(Json(new { data = roles }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Admin/GetRoles", "Admin", "GetRoles", "FetchAllRoles Error", ex.Message.ToString(), 0);
return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetRequestCategory()
{
string LoginUser = (string)Session["LoginSAPID"];
try
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string ROLE_ID = (string)Session["ROLE_ID"];
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchRequestCategories(ROLE_ID, userkey, uid);
dt.TableName = "Fetchrequestcategory";
dt.Columns.ToString();
var requestCategory = (from DataRow dr in dt.Rows
select new
{
ID = dr["ID"].ToString(),
Descr = dr["Descr"].ToString(),
Mail = dr["Mail"].ToString(),
Dynamictext = dr["dynamictext"].ToString(),
Dynamicurl = dr["dynamicurls"].ToString(),
IsAES = dr["IsAES"].ToString()
}).ToList();
return(Json(new { data = requestCategory }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Requests/GetRequestCategory", "Requests", "GetRequestCategory", "FetchRequestCategories Error", ex.Message.ToString(), 0);
return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeactivateUser(string StaffID)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
Employer.Employer employer = new Employer.Employer();
var updateStatus = employer.AdministerInternalUser(StaffID, LoginUser, "1", "3", userkey, uid);
var updateDetails = updateStatus.Split('~');
if (updateDetails[0] != "01")
{
TempData["smessage"] = updateDetails[1];
return(RedirectToAction("Index"));
}
else
{
TempData["message"] = updateDetails[1];
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Admin/UpdateUsers", "Admin", "ActivateUser", "AdministerInternalUser Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
ViewBag.Error = TempData["error"];
return(RedirectToAction("Index"));
}
}
public ActionResult Create(AdminViews views)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
Employer.Employer employer = new Employer.Employer();
var defineRole = employer.DefineView(views.MenuName, views.ControllerName, views.ActionName, "INP211", userkey, uid);
var roleDetails = defineRole.Split('~');
if (roleDetails[0] != "01")
{
TempData["msg"] = roleDetails[1];
return(RedirectToAction("Index"));
}
else
{
TempData["error"] = roleDetails[1];
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "AdminViews/Create", "AdminViews", "Create", "DefineView Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
ViewBag.Error = TempData["error"];
return(View());
}
}
public ActionResult ChangePassword(string WebUserID, string oldpassword, string newpassword)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
string ipaddress = Request.UserHostAddress;
string Agent = Request.UserAgent;
string BrowserUsed = Request.Browser.Browser;
try
{
Employer.Employer employer = new Employer.Employer();
var changeStatus = employer.ChangePassword(WebUserID, BrowserUsed, WebUserID, newpassword, uid, userkey, uid);
var changeDetails = changeStatus.Split('~');
if (changeDetails[0] != "4")
{
TempData["error"] = changeDetails[1];
return(RedirectToAction("Index"));
}
else
{
TempData["error"] = changeDetails[1];
return(RedirectToAction("Index"));
}
}catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog(WebUserID, "", "", "Login/ChangePassword", "Login", "ChangePassword", "ChangePassword Error", ex.Message.ToString(), 0);
return(View());
}
}
public JsonResult GetMaritalStatusRatio()
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchCompanYEmployees("1002", userkey, uid);
dt.TableName = "ExternalUsers";
dt.Columns.ToString();
var requestCategory = (from DataRow dr in dt.Rows
//where dr["eid"].ToString() == "113"
group dr by dr["Marital Status"] into g
select new
{
Mid = g.Key,
Count = g.Count()
}).ToList();
return(Json(new { data = requestCategory }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Requests/GetRequestCategory", "Requests", "GetRequestCategory", "FetchRequestCategories Error", ex.Message.ToString(), 0);
return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult RoleDetails(string roleId)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchRoleView(roleId, userkey, uid);
dt.TableName = "FetchRolesView";
dt.Columns.ToString();
List <AdminViews> adminViews = (from DataRow dr in dt.Rows
select new AdminViews()
{
ID = dr["ID"].ToString(),
MenuID = dr["MenuID"].ToString(),
ParentMenuID = dr["ParentMenuID"].ToString(),
ParentMenuName = dr["parentmenyname"].ToString(),
MenuName = dr["MenuName"].ToString(),
}).ToList();
ViewData.Model = adminViews;
return(View());
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "AdminViews/RoleDetails", "AdminViews", "RoleDetails", "FetchRoleView Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
ViewBag.Error = TempData["error"];
return(View());
}
}
public ActionResult UnMapView(string viewId)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
Employer.Employer employer = new Employer.Employer();
var unMap = employer.UnMapRoleView(viewId, LoginUser, userkey, uid);
var unmapStatus = unMap.Split('~');
if (unmapStatus[0] != "01")
{
TempData["error"] = unmapStatus[1];
ViewBag.Error = TempData["error"];
return(RedirectToAction("MapViewsToRole"));
}
else
{
TempData["error"] = unmapStatus[1];
ViewBag.Error = TempData["error"];
return(RedirectToAction("MapViewsToRole"));
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "AdminViews/UnMapView", "AdminViews", "UnMapView", "UnMapRoleView Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
ViewBag.Error = TempData["error"];
return(View());;
}
}
public ActionResult EditEmployerContact(EmployerContacts contact, String EmployerId)
{
string LoginUser = (string)Session["LoginSAPID"];
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
try
{
Employer.Employer employer = new Employer.Employer();
var createEmContact = employer.ModifyExternalUser(contact.EmployerID, "", contact.Email, contact.Fullname, contact.PhoneNo, LoginUser, contact.Role, contact.ID, userkey, uid);
var createStatus = createEmContact.Split('~');
if (createStatus[0] != "01")
{
TempData["Msg"] = createStatus[1];
ViewBag.sMessage = TempData["Msg"];
return(RedirectToAction("Index"));
//return View();
}
else
{
TempData["error"] = createStatus[1];
ViewBag.Error = TempData["error"];
return(View());
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Admin/CreateRole", "Admin", "CreateRole", "CreateRole Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
ViewBag.Error = TempData["error"];
return(View());
}
}
public JsonResult GetInternalUsers()
{
string LoginUser = (string)Session["LoginSAPID"];
try
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchInternalUsers(userkey, uid);
dt.TableName = "InternalUsers";
dt.Columns.ToString();
var users = (from DataRow dr in dt.Rows
select new Models.InternalUsers()
{
ID = dr["ID"].ToString(),
FULLNAME = dr["FULLNAME"].ToString(),
ROLE_ID = dr["ROLE_ID"].ToString()
}).ToList();
return(Json(new { data = users }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Requests/GetInternalUsers", "Requests", "GetInternalUsers", "FetchInternalUsers Error", ex.Message.ToString(), 0);
return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult MapRole(string menuId, string parentId, string roleId)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
Employer.Employer employer = new Employer.Employer();
var mapResult = employer.MapRoleView(menuId, parentId, roleId, "INP211", userkey, uid);
var mapDetails = mapResult.Split('~');
if (mapDetails[0] != "01")
{
TempData["msg"] = mapDetails[1];
return(RedirectToAction("EditRole"));
}
else
{
TempData["error"] = mapDetails[1];
return(RedirectToAction("EditRole"));
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "AdminViews/UnMapView", "AdminViews", "UnMapView", "UnMapRoleView Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
ViewBag.Error = TempData["error"];
return(RedirectToAction("EditRole"));
}
}
public JsonResult GetBatchLists()
{
string LoginUser = (string)Session["LoginSAPID"];
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string EmployerId = (string)Session["EMPLOYER_ID"];
string CompanyName = (string)Session["CompanyName"];
string _access_key = ConfigurationManager.AppSettings["Salt"];
try
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchStatementEmployerBatch(CompanyName, EmployerId, userkey, uid);
dt.TableName = "EmployerBatch";
dt.Columns.ToString();
var batches = (from DataRow dr in dt.Rows
select new
{
ID = CryptoEngine.EncryptString(dr["Category ID"].ToString(), _access_key),
BatchName = dr["StmtBatchName"].ToString(),
AddressId = CryptoEngine.EncryptString(dr["Address ID"].ToString(), _access_key),
}).ToList();
return(Json(new { data = batches }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "StatementOptions/GetBatchLists", "StatementOptions", "GetBatchLists", "FetchInternalUsers Error", ex.Message.ToString(), 0);
return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Batch(Batch batch)
{
string LoginUser = (string)Session["LoginSAPID"];
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string EmployerId = (string)Session["EMPLOYER_ID"];
string CompanyName = (string)Session["CompanyName"];
try
{
Employer.Employer employer = new Employer.Employer();
var batchStatus = employer.CreateStatementEmployerBatch(batch.BatchName, CompanyName, EmployerId, batch.ContactAddress, batch.ContactAddress1, batch.ContactLGA, batch.ContactState, batch.ContactName, batch.ContactPhone, batch.ContactName2, batch.ContactPhone2, userkey, uid);
var statusDetails = batchStatus.Split('~');
if (statusDetails[0] != "01")
{
TempData["bMsg"] = statusDetails[1];
return(RedirectToAction("Index"));
}
else
{
TempData["bError"] = statusDetails[1];
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "StatementOptions/Batch", "StatementOptions", "Batch", "FetchInternalUsers Error", ex.Message.ToString(), 0);
TempData["bError"] = ex.Message.ToString();
return(RedirectToAction("Index"));
}
}
public JsonResult GetAllRoles([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchAllRoles();
dt.TableName = "Roles";
List <UserRoles> roles = new List <UserRoles>();
int startRec = requestModel.Start;
int pageSize = requestModel.Length;
List <UserRoles> roleCount = (from DataRow dr in dt.Rows
select new UserRoles()
{
ID = dr["ID"].ToString()
}).ToList();
roles = (from DataRow dr in dt.Rows
select new UserRoles()
{
ID = dr["ID"].ToString(),
Name = dr["NAME"].ToString(),
Code = dr["CODE"].ToString(),
}).Skip(startRec).Take(pageSize).ToList();
var totalCount = roleCount.Count();
var filteredCount = roleCount.Count();
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
var data = roles.Select(emList => new
{
ID = emList.ID,
Name = emList.Name,
Code = emList.Code
}).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "AdminViewsController/GetAllRoles", "AdminViewsController", "GetAllRoles", "FetchAllRoles Error", ex.Message.ToString(), 0);
throw new Exception(ex.Message.ToString());
}
}
public ActionResult Details()
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
string _access_key = ConfigurationManager.AppSettings["Salt"];
string Pin = this.Request.QueryString[0];
try
{
Util.Util utility = new Util.Util();
Crypto.Service1 _crypt = new Crypto.Service1();
string dPin = _crypt.Decryptfx(Pin, _access_key);
DataTable dt = utility.Fetchdata(dPin, "", userkey, uid);
dt.TableName = "CompanyEmployees";
var EmployeeDetails = (from DataRow dr in dt.Rows
select new CompanyEmployee()
{
Title = dr["Title"].ToString(),
FirstName = dr["First Name"].ToString(),
LastName = dr["Last Name"].ToString(),
MiddleName = dr["Middle Names"].ToString(),
PhoneNo = dr["Mobile 1"].ToString(),
DateOfBirth = dr["Date Of Birth"].ToString(),
DateOfEmployment = dr["Date Of Employment"].ToString(),
Email = dr["E-mail"].ToString(),
StateOfOrigin = dr["State of Origin"].ToString(),
LGA = dr["Local Government Authority"].ToString(),
Address = dr["Address"].ToString(),
Address2 = dr["Address 2"].ToString(),
City = dr["City"].ToString(),
Religion = dr["Religion"].ToString(),
Nationality = dr["Nationality"].ToString(),
Qualification = dr["Qualification"].ToString(),
State = dr["State of Posting"].ToString(),
}).ToList();
ViewBag.Details = EmployeeDetails;
return(View());
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Employee/Details", "Employee", "Details", "Fetchdata Error", ex.Message.ToString(), 0);
return(RedirectToAction("Index"));
}
}
public ActionResult EditRole(string Id, string Name)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchViews(userkey, uid);
dt.TableName = "AdminViews";
dt.Columns.ToString();
var adminViews = (from DataRow dr in dt.Rows
select new AdminViews()
{
ID = dr["MenuID"].ToString(),
MenuName = dr["MenuName"].ToString(),
ControllerName = dr["Controller"].ToString(),
ActionName = dr["Action"].ToString(),
}).ToList();
ViewData.Model = adminViews;
ViewBag.ParentId = adminViews;
return(View());
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "AdminViews/EditRole", "AdminViews", "EditRole", "FetchViews Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
ViewBag.Error = TempData["error"];
return(View());
}
}
public JsonResult GetValidSapId(string SAPID)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
string ipaddress = Request.UserHostAddress;
string BrowserUsed = Request.UserAgent;
Employer.Employer employer = new Employer.Employer();
var validDetails = employer.ADAuth(SAPID, BrowserUsed, ipaddress, "", userkey, uid);
var sapDetails = validDetails.Split('~');
return(Json(new { data = sapDetails }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Admin/GetValidSapId", "Admin", "GetValidSapId", "ADAuth Error", ex.Message.ToString(), 0);
throw new Exception(ex.Message.ToString());
}
}
public ActionResult CreateRole(UserRoles role)
{
string LoginUser = (string)Session["LoginSAPID"];
try
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
Employer.Employer employer = new Employer.Employer();
var createRole = employer.CreateRole(role.Name, LoginUser, userkey, uid);
var createStatus = createRole.Split('~');
if (createStatus[0] != "01")
{
TempData["error"] = createStatus[1];
ViewBag.Error = TempData["error"];
//return RedirectToAction("Roles");
return(View());
}
else
{
TempData["error"] = createStatus[1];
ViewBag.Error = TempData["error"];
return(View());
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Admin/CreateRole", "Admin", "CreateRole", "CreateRole Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
ViewBag.Error = TempData["error"];
return(View());
}
}
public ActionResult Create(AdminUsers admin)
{
string LoginUser = (string)Session["LoginSAPID"];
try
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
Employer.Employer employer = new Employer.Employer();
var createAdmin = employer.AdministerInternalUser(admin.SAPID, LoginUser, admin.Role, "1", userkey, uid);
var createStatus = createAdmin.Split('~');
if (createStatus[0] != "01")
{
TempData["error"] = createStatus[1];
ViewBag.Error = TempData["error"];
return(RedirectToAction("Index"));
}
else
{
TempData["error"] = createStatus[1];
ViewBag.Error = TempData["error"];
return(View());
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Admin/Create", "Admin", "Create", "AdministerInternalUser Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
ViewBag.Error = TempData["error"];
return(View());
}
}
public JsonResult GetRequests([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, String EmployerId)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
string _access_key = ConfigurationManager.AppSettings["Salt"];
string WebUserID = (string)Session["WebUserID"];
string EMPLOYER_ID = (string)Session["EMPLOYER_ID"];
try
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchIncidents("6", EMPLOYER_ID, "N/A", userkey, uid);
dt.TableName = "Requests";
dt.Columns.ToString();
List <Requests> requests = new List <Requests>();
int startRec = requestModel.Start;
int pageSize = requestModel.Length;
//DateTime dateTime10 = Convert.ToDateTime(loginStatus[0].LastLogin);
//Session["LastLogin"] = dateTime10.ToString("dd-MMM-yyyy hh:mm");
List <Requests> requestCount = (from DataRow dr in dt.Rows
select new Requests()
{
RequestID = dr["RequestID"].ToString()
}).ToList();
requests = (from DataRow dr in dt.Rows
orderby dr["Datecreated"] descending
select new Requests()
{
ID = dr["RequestID"].ToString(),
RequestID = dr["RequestID"].ToString(),
Category = dr["Cat"].ToString(),
Comment = dr["Comment"].ToString(),
Datecreated = Convert.ToDateTime(dr["Datecreated"]).ToString("dd-MMM-yyyy hh:mm"),
CurrentStatus = dr["CurrentStatus"].ToString(),
CurrentAssignedToID = dr["CurrentAssignedToID"].ToString(),
CurrentAssignedRoleID = dr["CurrentAssignedRoleID"].ToString()
}).Skip(startRec).Take(pageSize).ToList();
var totalCount = requestCount.Count();
var filteredCount = requests.Count();
if (requestModel.Search.Value != string.Empty)
{
var value = requestModel.Search.Value.ToLower().Trim();
requestCount = (from DataRow dr in dt.Rows
where dr["RequestID"].ToString().ToLower().Contains(value) || dr["Cat"].ToString().ToLower().Contains(value) ||
dr["Datecreated"].ToString().ToLower().Contains(value) || dr["CurrentStatus"].ToString().ToLower().Contains(value)
select new Requests()
{
RequestID = dr["RequestID"].ToString()
}).ToList();
requests = (from DataRow dr in dt.Rows
orderby dr["Datecreated"] descending
where dr["RequestID"].ToString().ToLower().Contains(value) || dr["Cat"].ToString().ToLower().Contains(value) ||
Convert.ToDateTime(dr["Datecreated"]).ToString("dd-MMM-yyyy hh:mm").ToLower().Contains(value) ||
dr["CurrentStatus"].ToString().ToLower().Contains(value)
select new Requests()
{
RequestID = dr["RequestID"].ToString(),
Category = dr["Cat"].ToString(),
Comment = dr["Comment"].ToString(),
Datecreated = Convert.ToDateTime(dr["Datecreated"]).ToString("dd-MMM-yyyy hh:mm"),
CurrentStatus = dr["CurrentStatus"].ToString(),
CurrentAssignedToID = dr["CurrentAssignedToID"].ToString(),
CurrentAssignedRoleID = dr["CurrentAssignedRoleID"].ToString()
}).Skip(startRec).Take(pageSize).ToList();
totalCount = requestCount.Count();
filteredCount = requests.Count();
}
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
var data = requests.Select(emList => new
{
RequestID = emList.RequestID,
Category = emList.Category,
Comment = emList.Comment,
CurrentStatus = emList.CurrentStatus,
Datecreated = emList.Datecreated,
CurrentAssignedToID = emList.CurrentAssignedToID,
CurrentAssignedRoleID = emList.CurrentAssignedRoleID
}).OrderBy(orderByString == string.Empty ? "ID asc" : orderByString).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0);
return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetAdminViews([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchViews(userkey, uid);
dt.TableName = "AdminViews";
dt.Columns.ToString();
List <AdminViews> adminViews = new List <AdminViews>();
int startRec = requestModel.Start;
int pageSize = requestModel.Length;
List <AdminViews> viewsCount = (from DataRow dr in dt.Rows
select new AdminViews()
{
MenuName = dr["MenuName"].ToString()
}).ToList();
adminViews = (from DataRow dr in dt.Rows
select new AdminViews()
{
MenuName = dr["MenuName"].ToString(),
ControllerName = dr["Controller"].ToString(),
ActionName = dr["Action"].ToString(),
}).Skip(startRec).Take(pageSize).ToList();
var totalCount = viewsCount.Count();
var filteredCount = adminViews.Count();
/*if (requestModel.Search.Value != string.Empty)
* {
* var value = requestModel.Search.Value.Trim();
*
* employeeCount = (from DataRow dr in dt.Rows
* where dr["P_I_N"].ToString().ToString().Contains(value) || dr["First Name"].ToString().Contains(value)
|| dr["Last Name"].ToString().Contains(value) || dr["Phone No"].ToString().Contains(value)
|| dr["E-mail"].ToString().Contains(value)
|| select new CompanyEmployee()
|| {
|| PIN = dr["P_I_N"].ToString()
|| }).ToList();
||
|| companyEmployee = (from DataRow dr in dt.Rows
|| where dr["P_I_N"].ToString().ToString().Contains(value) || dr["First Name"].ToString().Contains(value)
|| dr["Last Name"].ToString().Contains(value) || dr["Phone No"].ToString().Contains(value)
|| dr["E-mail"].ToString().Contains(value)
|| select new CompanyEmployee()
|| {
|| PIN = dr["P_I_N"].ToString(),
|| FirstName = dr["First Name"].ToString(),
|| LastName = dr["Last Name"].ToString(),
|| MiddleName = dr["Middle Names"].ToString(),
|| PhoneNo = dr["Mobile 1"].ToString(),
|| DateOfBirth = dr["Date Of Birth"].ToString(),
|| DateOfEmployment = dr["Date Of Employment"].ToString(),
|| Email = dr["E-mail"].ToString(),
|| }).Skip(startRec).Take(pageSize).ToList();
||
|| totalCount = employeeCount.Count();
|| filteredCount = companyEmployee.Count();
||}*/
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
var data = adminViews.Select(emList => new
{
MenuName = emList.MenuName,
ControllerName = emList.ControllerName,
ActionName = emList.ActionName
}).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "AdminViewsController/GetAdminViews", "AdminViewsController", "GetAdminViews", "FetchViews Error", ex.Message.ToString(), 0);
throw new Exception(ex.Message.ToString());
}
}
public ActionResult Index(string ReportType, string ReportFormat, string startdate, string enddate)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
string EMPLOYER_ID = (string)Session["EMPLOYER_ID"];
string CompanyName = (string)Session["CompanyName"];
try
{
if (ReportType == "1")
{
if (ReportFormat == "PDF")
{
Employer.Employer employer = new Employer.Employer();
var report = employer.Report_CFI_Status_Report_By_Employer(EMPLOYER_ID, "PDF", userkey, uid, uid);
//var report = employer.Report_RSA_Details_by_employer(CompanyName, "PDF", userkey, uid, uid);
if (report != null)
{
string stmt_name = EMPLOYER_ID.ToString().Trim() + "_" + DateTime.Today.Day.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Year.ToString() + DateTime.Today.Second.ToString() + DateTime.Today.Millisecond.ToString() + DateTime.UtcNow.Ticks + EMPLOYER_ID;
string pth = stmt_name + ".pdf";
Response.AppendCookie(new HttpCookie("fileDownloadToken", "Report"));
//FileStream stream = System.IO.File.Create(pth, report.Length);
//stream.Write(report, 0, report.Length);
//stream.Close();
return(File(report, "application/pdf", pth));
}
else
{
TempData["error"] = "Report not found";
return(View());
}
}
else if (ReportFormat == "CSV")
{
Employer.Employer employer = new Employer.Employer();
var report = employer.Report_CFI_Status_Report_By_Employer(EMPLOYER_ID, "csv", userkey, uid, uid);
if (report != null)
{
string stmt_name = EMPLOYER_ID.ToString().Trim() + "_" + DateTime.Today.Day.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Year.ToString() + DateTime.Today.Second.ToString() + DateTime.Today.Millisecond.ToString() + DateTime.UtcNow.Ticks + EMPLOYER_ID;
string pth = stmt_name + ".csv";
Response.AppendCookie(new HttpCookie("fileDownloadToken", "Report"));
//FileStream stream = System.IO.File.Create(pth, report.Length);
//stream.Write(report, 0, report.Length);
//stream.Close();
return(File(report, "text/csv", pth));
}
else
{
TempData["error"] = "Report not found";
return(View());
}
}
else
{
TempData["error"] = "File type not allowed";
return(View());
}
}
else if (ReportType == "2")
{
Employer.Employer employer = new Employer.Employer();
var report = employer.Report_Pencom_Employer_Code(EMPLOYER_ID, "PDF", userkey, uid, uid);
if (report != null)
{
string stmt_name = EMPLOYER_ID.ToString().Trim() + "_" + DateTime.Today.Day.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Year.ToString() + DateTime.Today.Second.ToString() + DateTime.Today.Millisecond.ToString() + DateTime.UtcNow.Ticks + EMPLOYER_ID;
string pth = stmt_name + ".pdf";
//FileStream stream = System.IO.File.Create(pth, report.Length);
//stream.Write(report, 0, report.Length);
//stream.Close();
return(File(report, "application/pdf", pth));
}
else
{
TempData["error"] = "Report cannot be generated at the moment. Kindly contact System Admininistrator.";
return(View());
}
}
else if (ReportType == "3")
{
if (ReportFormat == "PDF")
{
Employer.Employer employer = new Employer.Employer();
var report = employer.Report_RSA_Details_by_employer(CompanyName, "PDF", userkey, uid, uid);
if (report != null)
{
string stmt_name = EMPLOYER_ID.ToString().Trim() + "_" + DateTime.Today.Day.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Year.ToString() + DateTime.Today.Second.ToString() + DateTime.Today.Millisecond.ToString() + DateTime.UtcNow.Ticks + EMPLOYER_ID;
string pth = stmt_name + ".pdf";
//FileStream stream = System.IO.File.Create(pth, report.Length);
//stream.Write(report, 0, report.Length);
//stream.Close();
return(File(report, "application/pdf", pth));
}
else
{
TempData["error"] = "Report not found";
return(View());
}
}
else if (ReportFormat == "CSV")
{
Employer.Employer employer = new Employer.Employer();
var report = employer.Report_RSA_Details_by_employer(CompanyName, "csv", userkey, uid, uid);
if (report != null)
{
string stmt_name = EMPLOYER_ID.ToString().Trim() + "_" + DateTime.Today.Day.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Year.ToString() + DateTime.Today.Second.ToString() + DateTime.Today.Millisecond.ToString() + DateTime.UtcNow.Ticks + EMPLOYER_ID;
string pth = stmt_name + ".csv";
//FileStream stream = System.IO.File.Create(pth, report.Length);
//stream.Write(report, 0, report.Length);
//stream.Close();
return(File(report, "text/csv", pth));
}
else
{
TempData["error"] = "Report not found";
return(View());
}
}
else
{
TempData["error"] = "File type not allowed";
return(View());
}
}
else if (ReportType == "4")
{
if (ReportFormat == "PDF")
{
Employer.Employer employer = new Employer.Employer();
var report = employer.Report_RSA_Unfunded(CompanyName, startdate, enddate, "PDF", userkey, uid, uid);
if (report != null)
{
string stmt_name = EMPLOYER_ID.ToString().Trim() + "_" + DateTime.Today.Day.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Year.ToString() + DateTime.Today.Second.ToString() + DateTime.Today.Millisecond.ToString() + DateTime.UtcNow.Ticks + EMPLOYER_ID;
string pth = stmt_name + ".pdf";
//FileStream stream = System.IO.File.Create(pth, report.Length);
//stream.Write(report, 0, report.Length);
//stream.Close();
return(File(report, "application/pdf", pth));
}
else
{
TempData["error"] = "Report not found";
return(View());
}
}
else if (ReportFormat == "CSV")
{
Employer.Employer employer = new Employer.Employer();
var report = employer.Report_RSA_Unfunded(CompanyName, startdate, enddate, "csv", userkey, uid, uid);
if (report != null)
{
string stmt_name = EMPLOYER_ID.ToString().Trim() + "_" + DateTime.Today.Day.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Year.ToString() + DateTime.Today.Second.ToString() + DateTime.Today.Millisecond.ToString() + DateTime.UtcNow.Ticks + EMPLOYER_ID;
string pth = stmt_name + ".csv";
//FileStream stream = System.IO.File.Create(pth, report.Length);
//stream.Write(report, 0, report.Length);
//stream.Close();
return(File(report, "text/csv", pth));
}
else
{
TempData["error"] = "Report not found";
return(View());
}
}
else
{
TempData["error"] = "File type not allowed";
return(View());
}
}
else if (ReportType == "5")
{
if (ReportFormat == "PDF")
{
Employer.Employer employer = new Employer.Employer();
var report = employer.Report_RSA_Unfunded(CompanyName, startdate, enddate, "PDF", userkey, uid, uid);
if (report != null)
{
string stmt_name = EMPLOYER_ID.ToString().Trim() + "_" + DateTime.Today.Day.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Year.ToString() + DateTime.Today.Second.ToString() + DateTime.Today.Millisecond.ToString() + DateTime.UtcNow.Ticks + EMPLOYER_ID;
string pth = stmt_name + ".pdf";
//FileStream stream = System.IO.File.Create(pth, report.Length);
//stream.Write(report, 0, report.Length);
//stream.Close();
return(File(report, "application/pdf", pth));
}
else
{
TempData["error"] = "Report not found";
return(View());
}
}
else if (ReportFormat == "CSV")
{
Employer.Employer employer = new Employer.Employer();
var report = employer.Report_RSA_Unfunded(CompanyName, startdate, enddate, "csv", userkey, uid, uid);
if (report != null)
{
string stmt_name = EMPLOYER_ID.ToString().Trim() + "_" + DateTime.Today.Day.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Year.ToString() + DateTime.Today.Second.ToString() + DateTime.Today.Millisecond.ToString() + DateTime.UtcNow.Ticks + EMPLOYER_ID;
string pth = stmt_name + ".csv";
//FileStream stream = System.IO.File.Create(pth, report.Length);
//stream.Write(report, 0, report.Length);
//stream.Close();
return(File(report, "text/csv", pth));
}
else
{
TempData["error"] = "Report not found";
return(View());
}
}
else
{
TempData["error"] = "File type not allowed";
return(View());
}
}
else
{
TempData["error"] = "ReportType not selected";
return(View());
}
} catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Reports/Index", "Reports", "Index", "Reports Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
return(View());
}
}
public ActionResult UpdateRequest(string requestId, string statusUpdate, string internalUser, string externalUser, string custodianUser, string Comment, string convertedFile, string convertedFile1, string convertedFile2)
{
string UploadStatus = "";
string UploadStatus1 = "";
string UploadStatus2 = "";
string assignedToId = "";
string roleId = "";
//convertedFile = "";
//convertedFile1 = "";
//convertedFile2 = "";
string ipaddress = Request.UserHostAddress;
string Agent = Request.UserAgent;
string BrowserUsed = Request.Browser.Browser;
string SessionID = HttpContext.Session.SessionID;
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
string EmployerId = (string)Session["EMPLOYER_ID"];
string WebUserID = (string)Session["WebUserID"];
string RoleID = (string)Session["ROLE_ID"];
try
{
Employer.Employer employer = new Employer.Employer();
if (internalUser != "")
{
assignedToId = internalUser;
roleId = "2";
}
else if (externalUser != "")
{
assignedToId = externalUser;
roleId = "3";
}
else if (custodianUser != "")
{
assignedToId = externalUser;
roleId = "4";
}
string requestStatus;
if (statusUpdate == "Assigned")
{
requestStatus = employer.AssignRequest(requestId, Comment, WebUserID, "2", roleId, assignedToId, statusUpdate, userkey, uid);
}
else
{
requestStatus = employer.AssignRequest(requestId, Comment, WebUserID, "2", roleId, WebUserID, statusUpdate, userkey, uid);
}
//var requestStatus = employer.CreateRequest(WebUserID, "3", requestCategory, "Initiated", Comment, userkey, uid);
var requestDetails = requestStatus.Split('~');
if (requestDetails[0] != "01")
{
var file = Request.Files;
if (file[0].ContentLength > 0)
{
string _FileName = file[0].FileName;
string Docext = Path.GetExtension(file[0].FileName);
string Doc = convertedFile;
UploadStatus = employer.LogRequestDoc(requestId, requestDetails[1], Doc, Docext, _FileName, "Y", userkey, uid);
var uploadDetails = UploadStatus.Split('~');
}
if (file[1].ContentLength > 0)
{
string _FileName1 = file[1].FileName;
string Docext1 = Path.GetExtension(file[1].FileName);
string Doc1 = convertedFile1;
UploadStatus1 = employer.LogRequestDoc(requestId, requestDetails[1], Doc1, Docext1, _FileName1, "Y", userkey, uid);
//var uploadDetails1 = UploadStatus1.Split('~');
}
if (file[2].ContentLength > 0)
{
string _FileName2 = file[2].FileName;
string Docext2 = Path.GetExtension(file[2].FileName);
string Doc2 = convertedFile2;
UploadStatus2 = employer.LogRequestDoc(requestId, requestDetails[1], Doc2, Docext2, _FileName2, "Y", userkey, uid);
//uploadDetails2 = UploadStatus2.Split('~');
}
if (UploadStatus == "00~Your documents have been logged successfully" || UploadStatus1 == "00~Your documents have been logged successfully" || UploadStatus2 == "00~Your documents have been logged successfully")
{
employer.NotifyIncident(requestDetails[1], userkey, uid);
string status = "00~Your documents have been logged successfully";
var statusDetails = status.Split('~');
TempData["error"] = "Your request and " + statusDetails[1];
//employer
return(RedirectToAction("Index"));
}
else
{
}
TempData["msg"] = requestDetails[2];
return(RedirectToAction("Index"));
}
else
{
TempData["error"] = requestDetails[2];
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Requests/UpdateRequest", "Requests", "UpdateRequest", "AssignRequest Error", ex.InnerException.Message.ToString(), 0);
TempData["error"] = "An error processing complaints";
return(View());
}
}
public ActionResult Index(Users users, string ReturnUrl)
{
string LoginType;
string ipaddress = Request.UserHostAddress;
string Agent = Request.UserAgent;
string BrowserUsed = Request.Browser.Browser;
string SessionID = HttpContext.Session.SessionID;
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
try
{
List <LoginStatus> loginStatus;
Employer.Employer employer = new Employer.Employer();
if ((users.Username.Trim().Length >= 5) && (users.Username.Trim().Contains("@") == true) && (users.Username.Trim().Contains(".") == true))
{
LoginType = "2";
DataTable dt = employer.ExternalLogin(users.Username, LoginType, users.Password, BrowserUsed, SessionID, Agent, ipaddress, userkey, uid);
dt.TableName = "ReturnedVal";
var response = dt.Columns.Count.ToString();
if (response == "2")
{
var loginError = (from DataRow dr in dt.Rows
select new LoginStatus()
{
ErrorMessage = dr["ErrorMessage"].ToString(),
LoginStat = dr["LoginStat"].ToString(),
}).ToList();
TempData["error"] = loginError[0].ErrorMessage;
return(View());
}
loginStatus = (from DataRow dr in dt.Rows
select new LoginStatus()
{
ErrorMessage = dr["ErrorMessage"].ToString(),
LoginStat = dr["LoginStat"].ToString(),
WebUserID = dr["WebUserID"].ToString(),
EMPLOYER_ID = dr["EMPLOYER_ID"].ToString(),
EnforceChange = dr["EnforceChange"].ToString(),
CUSTODIAN_ID = dr["CUSTODIAN_ID"].ToString(),
LastLogin = dr["LastLogin"].ToString(),
email = dr["email"].ToString(),
BrowserUsed = dr["BrowserUsed"].ToString(),
ROLE_ID = dr["ROLE_ID"].ToString(),
FULLNAME = dr["FULLNAME"].ToString(),
}).ToList();
if (loginStatus[0].EnforceChange == "Y")
{
ViewBag.Email = loginStatus[0].email;
Session["WebUserID"] = loginStatus[0].WebUserID;
Session["ROLE_ID"] = loginStatus[0].ROLE_ID;
return(RedirectToAction("ChangePassword"));
}
else if (loginStatus[0].LoginStat == "False")
{
TempData["error"] = loginStatus[0].ErrorMessage;
return(View());
}
else if (loginStatus[0].ROLE_ID == "3")
{
FormsAuthentication.SetAuthCookie(loginStatus[0].FULLNAME, false);
Session["LoginSAPID"] = users.Username;
DateTime dateTime10 = Convert.ToDateTime(loginStatus[0].LastLogin);
Session["LastLogin"] = dateTime10.ToString("dd-MMM-yyyy hh:mm");
Session["EMPLOYER_ID"] = loginStatus[0].EMPLOYER_ID;
Session["WebUserID"] = loginStatus[0].WebUserID;
Session["ROLE_ID"] = loginStatus[0].ROLE_ID;
DataTable dts = employer.FetchCompanYEmployees(loginStatus[0].EMPLOYER_ID, userkey, uid);
dts.TableName = "CompanyEmployees";
var companyEmployee = (from DataRow dr in dts.Rows
select new
{
Coyname = dr["Coyname"].ToString()
}).ToList();
Session["CompanyName"] = companyEmployee[0].Coyname;
DataTable dtz = employer.FetchEmployerContact(loginStatus[0].EMPLOYER_ID);
dtz.TableName = "EmpoyerContact";
dtz.Columns.ToString();
var EmpoyerContact = (from DataRow dr in dtz.Rows
select new
{
Email = dr["Email"].ToString(),
Address = dr["Address"].ToString(),
MobilePhone = dr["Mobile Phone"].ToString(),
Name = dr["Name"].ToString()
}).ToList();
Session["EmpoyerContactName"] = EmpoyerContact[0].Name;
Session["EmpoyerContactEmail"] = EmpoyerContact[0].Email;
Session["EmpoyerContactAddress"] = EmpoyerContact[0].Address;
Session["EmpoyerContactMobilePhone"] = EmpoyerContact[0].MobilePhone;
if (Url.IsLocalUrl(ReturnUrl) && ReturnUrl.Length > 1 && ReturnUrl.StartsWith("/") && !ReturnUrl.StartsWith("//") && !ReturnUrl.StartsWith("/\\"))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else if (loginStatus[0].ROLE_ID == "4")
{
FormsAuthentication.SetAuthCookie(loginStatus[0].FULLNAME, false);
Session["LoginSAPID"] = users.Username;
DateTime dateTime10 = Convert.ToDateTime(loginStatus[0].LastLogin);
Session["LastLogin"] = dateTime10.ToString("dd-MMM-yyyy hh:mm");
Session["CUSTODIAN_ID"] = loginStatus[0].CUSTODIAN_ID;
Session["WebUserID"] = loginStatus[0].WebUserID;
Session["ROLE_ID"] = loginStatus[0].ROLE_ID;
DataTable dts = employer.FetchCompanYEmployees(loginStatus[0].EMPLOYER_ID, userkey, uid);
dts.TableName = "CompanyEmployees";
var companyEmployee = (from DataRow dr in dts.Rows
select new
{
Coyname = dr["Coyname"].ToString()
}).ToList();
Session["CompanyName"] = companyEmployee[0].Coyname;
if (Url.IsLocalUrl(ReturnUrl) && ReturnUrl.Length > 1 && ReturnUrl.StartsWith("/") && !ReturnUrl.StartsWith("//") && !ReturnUrl.StartsWith("/\\"))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index", "Employee"));
}
}
else if (loginStatus[0].ROLE_ID == "7")
{
FormsAuthentication.SetAuthCookie(loginStatus[0].FULLNAME, false);
Session["LoginSAPID"] = users.Username;
DateTime dateTime10 = Convert.ToDateTime(loginStatus[0].LastLogin);
Session["LastLogin"] = dateTime10.ToString("dd-MMM-yyyy hh:mm");
Session["EMPLOYER_ID"] = loginStatus[0].EMPLOYER_ID;
Session["WebUserID"] = loginStatus[0].WebUserID;
Session["ROLE_ID"] = loginStatus[0].ROLE_ID;
DataTable dts = employer.FetchCompanYEmployees(loginStatus[0].EMPLOYER_ID, userkey, uid);
dts.TableName = "CompanyEmployees";
var companyEmployee = (from DataRow dr in dts.Rows
select new
{
Coyname = dr["Coyname"].ToString()
}).ToList();
Session["CompanyName"] = companyEmployee[0].Coyname;
DataTable dtz = employer.FetchEmployerContact(loginStatus[0].EMPLOYER_ID);
dtz.TableName = "EmpoyerContact";
dtz.Columns.ToString();
var EmpoyerContact = (from DataRow dr in dtz.Rows
select new
{
Email = dr["Email"].ToString(),
Address = dr["Address"].ToString(),
MobilePhone = dr["Mobile Phone"].ToString(),
Name = dr["Name"].ToString()
}).ToList();
Session["EmpoyerContactName"] = EmpoyerContact[0].Name;
Session["EmpoyerContactEmail"] = EmpoyerContact[0].Email;
Session["EmpoyerContactAddress"] = EmpoyerContact[0].Address;
Session["EmpoyerContactMobilePhone"] = EmpoyerContact[0].MobilePhone;
if (Url.IsLocalUrl(ReturnUrl) && ReturnUrl.Length > 1 && ReturnUrl.StartsWith("/") && !ReturnUrl.StartsWith("//") && !ReturnUrl.StartsWith("/\\"))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
}
else if ((users.Username.Trim().Length >= 10) && ((users.Username.Trim().All(char.IsDigit)) == true))
{
LoginType = "1";
DataTable dt = employer.ExternalLogin(users.Username, LoginType, users.Password, BrowserUsed, SessionID, Agent, ipaddress, userkey, uid);
dt.TableName = "ReturnedVal";
var response = dt.Columns.Count.ToString();
if (response == "2")
{
var loginError = (from DataRow dr in dt.Rows
select new LoginStatus()
{
ErrorMessage = dr["ErrorMessage"].ToString(),
LoginStat = dr["LoginStat"].ToString(),
}).ToList();
TempData["error"] = loginError[0].ErrorMessage;
return(View());
}
loginStatus = (from DataRow dr in dt.Rows
select new LoginStatus()
{
ErrorMessage = dr["ErrorMessage"].ToString(),
LoginStat = dr["LoginStat"].ToString(),
WebUserID = dr["WebUserID"].ToString(),
EMPLOYER_ID = dr["EMPLOYER_ID"].ToString(),
EnforceChange = dr["EnforceChange"].ToString(),
CUSTODIAN_ID = dr["CUSTODIAN_ID"].ToString(),
LastLogin = dr["LastLogin"].ToString(),
email = dr["email"].ToString(),
BrowserUsed = dr["BrowserUsed"].ToString(),
ROLE_ID = dr["ROLE_ID"].ToString(),
FULLNAME = dr["FULLNAME"].ToString()
}).ToList();
if (loginStatus[0].EnforceChange == "Y")
{
ViewBag.Email = loginStatus[0].email;
Session["WebUserID"] = loginStatus[0].WebUserID;
return(RedirectToAction("ChangePassword"));
}
else if (loginStatus[0].LoginStat == "False")
{
ViewBag.Email = loginStatus[0].email;
return(View());
}
else if (loginStatus[0].LoginStat == "False")
{
TempData["error"] = loginStatus[0].ErrorMessage;
return(View());
}
else if (loginStatus[0].ROLE_ID == "3")
{
FormsAuthentication.SetAuthCookie(loginStatus[0].FULLNAME, false);
Session["LoginSAPID"] = users.Username;
DateTime dateTime10 = Convert.ToDateTime(loginStatus[0].LastLogin);
Session["LastLogin"] = dateTime10.ToString("dd-MMM-yyyy hh:mm");
Session["EMPLOYER_ID"] = loginStatus[0].EMPLOYER_ID;
Session["WebUserID"] = loginStatus[0].WebUserID;
Session["ROLE_ID"] = loginStatus[0].ROLE_ID;
DataTable dts = employer.FetchCompanYEmployees(loginStatus[0].EMPLOYER_ID, userkey, uid);
dts.TableName = "CompanyEmployees";
var companyEmployee = (from DataRow dr in dts.Rows
select new
{
Coyname = dr["Coyname"].ToString()
}).ToList();
Session["CompanyName"] = companyEmployee[0].Coyname;
DataTable dtz = employer.FetchEmployerContact(loginStatus[0].EMPLOYER_ID);
dtz.TableName = "EmpoyerContact";
dtz.Columns.ToString();
var EmpoyerContact = (from DataRow dr in dtz.Rows
select new
{
Email = dr["Email"].ToString(),
Address = dr["Address"].ToString(),
MobilePhone = dr["Mobile Phone"].ToString(),
Name = dr["Name"].ToString()
}).ToList();
Session["EmpoyerContactName"] = EmpoyerContact[0].Name;
Session["EmpoyerContactEmail"] = EmpoyerContact[0].Email;
Session["EmpoyerContactAddress"] = EmpoyerContact[0].Address;
Session["EmpoyerContactMobilePhone"] = EmpoyerContact[0].MobilePhone;
if (Url.IsLocalUrl(ReturnUrl) && ReturnUrl.Length > 1 && ReturnUrl.StartsWith("/") && !ReturnUrl.StartsWith("//") && !ReturnUrl.StartsWith("/\\"))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else if (loginStatus[0].ROLE_ID == "4")
{
FormsAuthentication.SetAuthCookie(loginStatus[0].FULLNAME, false);
Session["LoginSAPID"] = users.Username;
DateTime dateTime10 = Convert.ToDateTime(loginStatus[0].LastLogin);
Session["LastLogin"] = dateTime10.ToString("dd-MMM-yyyy hh:mm");
Session["CUSTODIAN_ID"] = loginStatus[0].CUSTODIAN_ID;
Session["WebUserID"] = loginStatus[0].WebUserID;
Session["ROLE_ID"] = loginStatus[0].ROLE_ID;
DataTable dts = employer.FetchCompanYEmployees(loginStatus[0].EMPLOYER_ID, userkey, uid);
dts.TableName = "CompanyEmployees";
var companyEmployee = (from DataRow dr in dts.Rows
select new
{
Coyname = dr["Coyname"].ToString()
}).ToList();
Session["CompanyName"] = companyEmployee[0].Coyname;
if (Url.IsLocalUrl(ReturnUrl) && ReturnUrl.Length > 1 && ReturnUrl.StartsWith("/") && !ReturnUrl.StartsWith("//") && !ReturnUrl.StartsWith("/\\"))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index", "Employee"));
}
}
else if (loginStatus[0].ROLE_ID == "7")
{
FormsAuthentication.SetAuthCookie(loginStatus[0].FULLNAME, false);
Session["LoginSAPID"] = users.Username;
DateTime dateTime10 = Convert.ToDateTime(loginStatus[0].LastLogin);
Session["LastLogin"] = dateTime10.ToString("dd-MMM-yyyy hh:mm");
Session["EMPLOYER_ID"] = loginStatus[0].EMPLOYER_ID;
Session["WebUserID"] = loginStatus[0].WebUserID;
Session["ROLE_ID"] = loginStatus[0].ROLE_ID;
DataTable dts = employer.FetchCompanYEmployees(loginStatus[0].EMPLOYER_ID, userkey, uid);
dts.TableName = "CompanyEmployees";
var companyEmployee = (from DataRow dr in dts.Rows
select new
{
Coyname = dr["Coyname"].ToString()
}).ToList();
Session["CompanyName"] = companyEmployee[0].Coyname;
DataTable dtz = employer.FetchEmployerContact(loginStatus[0].EMPLOYER_ID);
dtz.TableName = "EmpoyerContact";
dtz.Columns.ToString();
var EmpoyerContact = (from DataRow dr in dtz.Rows
select new
{
Email = dr["Email"].ToString(),
Address = dr["Address"].ToString(),
MobilePhone = dr["Mobile Phone"].ToString(),
Name = dr["Name"].ToString()
}).ToList();
Session["EmpoyerContactName"] = EmpoyerContact[0].Name;
Session["EmpoyerContactEmail"] = EmpoyerContact[0].Email;
Session["EmpoyerContactAddress"] = EmpoyerContact[0].Address;
Session["EmpoyerContactMobilePhone"] = EmpoyerContact[0].MobilePhone;
if (Url.IsLocalUrl(ReturnUrl) && ReturnUrl.Length > 1 && ReturnUrl.StartsWith("/") && !ReturnUrl.StartsWith("//") && !ReturnUrl.StartsWith("/\\"))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
}
return(View());
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog(users.Username, "", "", "Login/Index", "Login", "Index", "ExternalLogin Error", ex.Message.ToString(), 0);
return(View());
}
}
public JsonResult GetSexRatio()
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchCompanYEmployees("1002", userkey, uid);
dt.TableName = "ExternalUsers";
dt.Columns.ToString();
var employeeCount = (from DataRow dr in dt.Rows
select new
{
PIN = dr["P_I_N"].ToString()
}).ToList();
var totalCount = employeeCount.Count();
var sexCount = (from DataRow dr in dt.Rows
group dr by dr["SEX"] into g
select new
{
Mid = g.Key,
Count = g.Count()
}).ToList();
var stateCount = (from DataRow dr in dt.Rows
group dr by dr["State of Origin"] into g
select new
{
Mid = g.Key,
Count = g.Count()
}).ToList();
var religionCount = (from DataRow dr in dt.Rows
group dr by dr["Religion"] into g
select new
{
Mid = g.Key,
Count = g.Count()
}).ToList();
var maritalStatus = (from DataRow dr in dt.Rows
group dr by dr["Marital Status"] into g
select new
{
Mid = g.Key,
Count = g.Count()
}).ToList();
var statementOption = (from DataRow dr in dt.Rows
group dr by dr["Statement Option"] into g
select new
{
Mid = g.Key,
Count = g.Count()
}).ToList();
return(Json(new { sex = sexCount, state = stateCount, religion = religionCount, statement = statementOption, marital = maritalStatus }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Requests/GetRequestCategory", "Requests", "GetRequestCategory", "FetchRequestCategories Error", ex.Message.ToString(), 0);
return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ForgotPassword(string Username)
{
string LoginType;
try
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string ipaddress = Request.UserHostAddress;
string Agent = Request.UserAgent;
string BrowserUsed = Request.Browser.Browser;
Employer.Employer employer = new Employer.Employer();
if ((Username.Trim().Length >= 5) && (Username.Trim().Contains("@") == true) && (Username.Trim().Contains(".") == true))
{
LoginType = "2";
var LoginVal = Username;
DataTable dt = employer.ResetPassword(Username, LoginType, BrowserUsed, uid, userkey, uid);
dt.TableName = "ReturnedVal";
var response = dt.Columns.Count.ToString();
if (response == "2")
{
var erroStatus = (from DataRow dr in dt.Rows
select new ForgotPassword()
{
Message = dr["Message"].ToString(),
LoginStat = dr["LoginStat"].ToString(),
}).ToList();
TempData["error"] = erroStatus[0].Message;
return(View());
}
var forgotStatus = (from DataRow dr in dt.Rows
select new ForgotPassword()
{
Message = dr["Message"].ToString(),
LoginStat = dr["LoginStat"].ToString(),
RSAPIN = dr["RSAPIN"].ToString()
}).ToList();
TempData["sMsg"] = forgotStatus[0].Message;
return(RedirectToAction("Index"));
}
else if ((Username.Trim().Length >= 10) && ((Username.Trim().All(char.IsDigit)) == true))
{
LoginType = "1";
var LoginVal = Username;
DataTable dt = employer.ResetPassword(Username, LoginType, BrowserUsed, uid, userkey, uid);
dt.TableName = "ReturnedVal";
var response = dt.Columns.Count.ToString();
if (response == "2")
{
var erroStatus = (from DataRow dr in dt.Rows
select new ForgotPassword()
{
Message = dr["Message"].ToString(),
LoginStat = dr["LoginStat"].ToString(),
}).ToList();
TempData["error"] = erroStatus[0].Message;
return(View());
}
var forgotStatus = (from DataRow dr in dt.Rows
select new ForgotPassword()
{
Message = dr["Message"].ToString(),
LoginStat = dr["LoginStat"].ToString(),
RSAPIN = dr["RSAPIN"].ToString()
}).ToList();
TempData["sMsg"] = forgotStatus[0].Message;
return(RedirectToAction("Index"));
}
else
{
TempData["error"] = "Email/Password not found";
return(View());
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog(Username, "", "", "Login/ForgotPassword", "Login", "ForgotPassword", "ResetPassword Error", ex.Message.ToString(), 0);
return(View());
}
}
public JsonResult GetCompanyEmployee([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, String EmployerId)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
string _access_key = ConfigurationManager.AppSettings["Salt"];
try
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchCompanYEmployees(EmployerId, userkey, uid);
dt.TableName = "CompanyEmployees";
Crypto.Service1 _crypt = new Crypto.Service1();
List <CompanyEmployee> companyEmployee = new List <CompanyEmployee>();
int startRec = requestModel.Start;
int pageSize = requestModel.Length;
List <CompanyEmployee> employeeCount = (from DataRow dr in dt.Rows
select new CompanyEmployee()
{
PIN = dr["P_I_N"].ToString()
}).ToList();
companyEmployee = (from DataRow dr in dt.Rows
select new CompanyEmployee()
{
dPIN = _crypt.Encryptfx(dr["P_I_N"].ToString(), _access_key),
PIN = dr["P_I_N"].ToString(),
FirstName = dr["First Name"].ToString(),
LastName = dr["Last Name"].ToString(),
MiddleName = dr["Middle Names"].ToString(),
PhoneNo = dr["Mobile 1"].ToString(),
DateOfBirth = dr["Date Of Birth"].ToString(),
DateOfEmployment = dr["Date Of Employment"].ToString(),
Email = dr["E-mail"].ToString(),
}).Skip(startRec).Take(pageSize).ToList();
var totalCount = employeeCount.Count();
var filteredCount = companyEmployee.Count();
if (requestModel.Search.Value != string.Empty)
{
var value = requestModel.Search.Value.ToLower().Trim();
employeeCount = (from DataRow dr in dt.Rows
where dr["P_I_N"].ToString().ToLower().Contains(value) || dr["First Name"].ToString().ToLower().Contains(value) ||
dr["Last Name"].ToString().ToLower().Contains(value) || dr["Mobile 1"].ToString().ToLower().Contains(value) ||
dr["E-mail"].ToString().ToLower().Contains(value)
select new CompanyEmployee()
{
PIN = dr["P_I_N"].ToString()
}).ToList();
companyEmployee = (from DataRow dr in dt.Rows
where dr["P_I_N"].ToString().ToLower().Contains(value) || dr["First Name"].ToString().ToLower().Contains(value) ||
dr["Last Name"].ToString().ToLower().Contains(value) || dr["Mobile 1"].ToString().ToLower().Contains(value) ||
dr["E-mail"].ToString().ToLower().Contains(value)
select new CompanyEmployee()
{
dPIN = _crypt.Encryptfx(dr["P_I_N"].ToString(), _access_key),
PIN = dr["P_I_N"].ToString(),
FirstName = dr["First Name"].ToString(),
LastName = dr["Last Name"].ToString(),
MiddleName = dr["Middle Names"].ToString(),
PhoneNo = dr["Mobile 1"].ToString(),
DateOfBirth = dr["Date Of Birth"].ToString(),
DateOfEmployment = dr["Date Of Employment"].ToString(),
Email = dr["E-mail"].ToString(),
}).Skip(startRec).Take(pageSize).ToList();
totalCount = employeeCount.Count();
filteredCount = companyEmployee.Count();
}
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
var data = companyEmployee.Select(emList => new
{
//dPIN = emList.dPIN,
PIN = emList.PIN,
FirstName = emList.FirstName,
LastName = emList.LastName,
MiddleName = emList.MiddleName,
PhoneNo = emList.PhoneNo,
DateOfBirth = emList.DateOfBirth,
DateOfEmployment = emList.DateOfEmployment,
Email = emList.Email
}).OrderBy(orderByString == string.Empty ? "PIN asc" : orderByString).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Employee/GetCompanyEmployee", "Employee", "GetCompanyEmployee", "GetCompanyEmployee Error", ex.Message.ToString(), 0);
throw new Exception(ex.Message.ToString());
}
}
public ActionResult Index(Users users, string returnUrl)
{
try
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string ipaddress = Request.UserHostAddress;
string BrowserUsed = Request.UserAgent;
Employer.Employer employer = new Employer.Employer();
var LoginStatus = employer.LOGIN(users.Username, users.Password, BrowserUsed, ipaddress, "", userkey, uid);
var LoginDetails = LoginStatus.Split('~');
if (LoginDetails[0] != "01")
{
DataTable dt = employer.FetchRoleView(LoginDetails[3], userkey, uid);
dt.TableName = "FetchRolesView";
dt.Columns.ToString();
List <AdminViews> AdminViews = (from DataRow dr in dt.Rows
select new AdminViews()
{
ID = dr["ID"].ToString(),
MenuID = dr["MenuID"].ToString(),
ParentMenuID = dr["ParentMenuID"].ToString(),
ParentMenuName = dr["parentmenyname"].ToString(),
MenuName = dr["MenuName"].ToString(),
ControllerName = dr["Controller"].ToString(),
ActionName = dr["Action"].ToString()
}).ToList();
var menuView = AdminViews.Cast <AdminViews>().GroupBy(tm => tm.ParentMenuID).Select(group => new { ID = group.Key, Items = group.ToArray() }).ToArray();
Session["menuView"] = AdminViews;
FormsAuthentication.SetAuthCookie(LoginDetails[1], false);
Session["LoginSAPID"] = users.Username;
Session["RoleID"] = LoginDetails[3];
Session["WebUserID"] = LoginDetails[4];
if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") && !returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\"))
{
if (LoginDetails[3] == "1" || LoginDetails[3] == "2")
{
return(Redirect(returnUrl));
}
else
{
return(RedirectToAction("MyRequest", "Requests"));
}
}
else
{
if (LoginDetails[3] == "1" || LoginDetails[3] == "2")
{
return(RedirectToAction("Index", "Employers"));
}
else
{
return(RedirectToAction("MyRequest", "Requests"));
}
}
}
else
{
TempData["error"] = LoginDetails[1];
ViewBag.Error = TempData["error"];
return(View());
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog(users.Username, "2", "3", "4", "Login", "Index", "Login Error", ex.Message.ToString(), 0);
TempData["error"] = ex.Message.ToString();
ViewBag.Error = TempData["error"];
return(View());
}
}
public JsonResult GetEmployers([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
string RoleID = (string)Session["RoleID"];
string WebUserID = (string)Session["WebUserID"];
try
{
if (RoleID == "1")
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchCompanies("YES", LoginUser);
dt.TableName = "Employer";
List <Employers> employerList = new List <Employers>();
int startRec = requestModel.Start;
int pageSize = requestModel.Length;
List <Employers> employerCount = (from DataRow dr in dt.Rows
select new Employers()
{
EmployerID = dr["EmployerID"].ToString(),
CompanyName = dr["Company Name"].ToString(),
}).ToList();
employerList = (from DataRow dr in dt.Rows
select new Employers()
{
EmployerID = dr["EmployerID"].ToString(),
CompanyName = dr["Company Name"].ToString(),
Address1 = dr["Address1"].ToString(),
Address2 = dr["Address2"].ToString(),
State = dr["State"].ToString(),
Email = dr["Email"].ToString(),
RelationshipManager = dr["Relationship Manager"].ToString(),
RMName = dr["RM Name"].ToString()
}).Skip(startRec).Take(pageSize).ToList();
var totalCount = employerCount.Count();
var filteredCount = employerList.Count();
if (requestModel.Search.Value != string.Empty)
{
var value = requestModel.Search.Value.ToLower().Trim();
employerCount = (from DataRow dr in dt.Rows
where dr["EmployerID"].ToString().ToLower().Contains(value) || dr["Company Name"].ToString().ToLower().Contains(value) ||
dr["Email"].ToString().ToLower().Contains(value) || dr["Relationship Manager"].ToString().ToLower().Contains(value) ||
dr["RM Name"].ToString().ToLower().Contains(value)
select new Employers()
{
EmployerID = dr["EmployerID"].ToString(),
CompanyName = dr["Company Name"].ToString(),
}).ToList();
employerList = (from DataRow dr in dt.Rows
where dr["EmployerID"].ToString().ToLower().Contains(value) || dr["Company Name"].ToString().ToLower().Contains(value) ||
dr["Email"].ToString().ToLower().Contains(value) || dr["Relationship Manager"].ToString().ToLower().Contains(value) ||
dr["RM Name"].ToString().ToLower().Contains(value)
select new Employers()
{
EmployerID = dr["EmployerID"].ToString(),
CompanyName = dr["Company Name"].ToString(),
Address1 = dr["Address1"].ToString(),
Address2 = dr["Address2"].ToString(),
State = dr["State"].ToString(),
Email = dr["Email"].ToString(),
RelationshipManager = dr["Relationship Manager"].ToString(),
RMName = dr["RM Name"].ToString()
}).Skip(startRec).Take(pageSize).ToList();
totalCount = employerCount.Count();
filteredCount = employerList.Count();
}
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
var data = employerList.Select(emList => new
{
EmployerID = emList.EmployerID,
CompanyName = emList.CompanyName,
Address1 = emList.Address1,
Address2 = emList.Address2,
State = emList.State,
Email = emList.Email,
RelationshipManager = emList.RelationshipManager,
RMName = emList.RMName
}).OrderBy(orderByString == string.Empty ? "EmployerID asc" : orderByString).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet));
}
else
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchCompanies("All", "");
dt.TableName = "Employer";
List <Employers> employerList = new List <Employers>();
int startRec = requestModel.Start;
int pageSize = requestModel.Length;
List <Employers> employerCount = (from DataRow dr in dt.Rows
select new Employers()
{
EmployerID = dr["EmployerID"].ToString(),
CompanyName = dr["Company Name"].ToString(),
}).ToList();
employerList = (from DataRow dr in dt.Rows
select new Employers()
{
EmployerID = dr["EmployerID"].ToString(),
CompanyName = dr["Company Name"].ToString(),
Address1 = dr["Address1"].ToString(),
Address2 = dr["Address2"].ToString(),
State = dr["State"].ToString(),
Email = dr["Email"].ToString(),
RelationshipManager = dr["Relationship Manager"].ToString(),
RMName = dr["RM Name"].ToString()
}).Skip(startRec).Take(pageSize).ToList();
var totalCount = employerCount.Count();
var filteredCount = employerList.Count();
if (requestModel.Search.Value != string.Empty)
{
var value = requestModel.Search.Value.ToLower().Trim();
employerCount = (from DataRow dr in dt.Rows
where dr["EmployerID"].ToString().ToLower().Contains(value) || dr["Company Name"].ToString().ToLower().Contains(value) ||
dr["Email"].ToString().ToLower().Contains(value) || dr["Relationship Manager"].ToString().ToLower().Contains(value) ||
dr["RM Name"].ToString().ToLower().Contains(value)
select new Employers()
{
EmployerID = dr["EmployerID"].ToString(),
CompanyName = dr["Company Name"].ToString(),
}).ToList();
employerList = (from DataRow dr in dt.Rows
where dr["EmployerID"].ToString().ToLower().Contains(value) || dr["Company Name"].ToString().ToLower().Contains(value) ||
dr["Email"].ToString().ToLower().Contains(value) || dr["Relationship Manager"].ToString().ToLower().Contains(value) ||
dr["RM Name"].ToString().ToLower().Contains(value)
select new Employers()
{
EmployerID = dr["EmployerID"].ToString(),
CompanyName = dr["Company Name"].ToString(),
Address1 = dr["Address1"].ToString(),
Address2 = dr["Address2"].ToString(),
State = dr["State"].ToString(),
Email = dr["Email"].ToString(),
RelationshipManager = dr["Relationship Manager"].ToString(),
RMName = dr["RM Name"].ToString()
}).Skip(startRec).Take(pageSize).ToList();
totalCount = employerCount.Count();
filteredCount = employerList.Count();
}
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
var data = employerList.Select(emList => new
{
EmployerID = emList.EmployerID,
CompanyName = emList.CompanyName,
Address1 = emList.Address1,
Address2 = emList.Address2,
State = emList.State,
Email = emList.Email,
RelationshipManager = emList.RelationshipManager,
RMName = emList.RMName
}).OrderBy(orderByString == string.Empty ? "EmployerID asc" : orderByString).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Employer/GetEmployers", "Employer", "GetEmployers", "GetEmployers Error", ex.Message.ToString(), 0);
throw new Exception(ex.Message.ToString());
}
}
public JsonResult GetEmployerContacts([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, string EmployerId)
{
string userkey = ConfigurationManager.AppSettings["userkey"];
string uid = ConfigurationManager.AppSettings["uid"];
string LoginUser = (string)Session["LoginSAPID"];
try
{
Employer.Employer employer = new Employer.Employer();
DataTable dt = employer.FetchExternalUsers(true, EmployerId, userkey, uid);
dt.TableName = "ExternalUsers";
dt.Columns.ToString();
List <ExternalUsers> userList = new List <ExternalUsers>();
int startRec = requestModel.Start;
int pageSize = requestModel.Length;
List <ExternalUsers> usersCount = (from DataRow dr in dt.Rows
select new ExternalUsers()
{
ID = dr["ID"].ToString()
}).ToList();
userList = (from DataRow dr in dt.Rows
select new ExternalUsers()
{
ID = dr["ID"].ToString(),
EMAIL = dr["EMAIL"].ToString(),
PHONE = dr["PHONE"].ToString(),
FULLNAME = dr["FULLNAME"].ToString(),
LOCKED = dr["LOCKED"].ToString(),
STATUS = dr["STATUS"].ToString(),
PCODE = dr["PCODE"].ToString(),
ROLE_ID = dr["ROLE_ID"].ToString(),
/*STATUS = dr["EMPLOYER_ID"].ToString(),
* STATUS = dr["APPROVAL_STATUS"].ToString(),
* STATUS = dr["CREATED_BY"].ToString(),
* STATUS = dr["DATE_CREATED"].ToString(),
* STATUS = dr["APPROVED_BY"].ToString(),
* STATUS = dr["STATUS"].ToString(),
* DATE_LAST_MODIFIED = dr["DATE_APPROVED"].ToString()*/
}).Skip(startRec).Take(pageSize).ToList();
var totalCount = usersCount.Count();
var filteredCount = userList.Count();
if (requestModel.Search.Value != string.Empty)
{
var value = requestModel.Search.Value.ToLower().Trim();
usersCount = (from DataRow dr in dt.Rows
where dr["ID"].ToString().ToLower().Contains(value) || dr["EMAIL"].ToString().ToLower().Contains(value) ||
dr["FULLNAME"].ToString().ToLower().Contains(value) || dr["PHONE"].ToString().ToLower().Contains(value)
select new ExternalUsers()
{
ID = dr["ID"].ToString()
}).ToList();
userList = (from DataRow dr in dt.Rows
where dr["ID"].ToString().ToLower().Contains(value) || dr["EMAIL"].ToString().ToLower().Contains(value) ||
dr["FULLNAME"].ToString().ToLower().Contains(value) || dr["PHONE"].ToString().ToLower().Contains(value)
select new ExternalUsers()
{
ID = dr["ID"].ToString(),
EMAIL = dr["EMAIL"].ToString(),
PHONE = dr["PHONE"].ToString(),
FULLNAME = dr["FULLNAME"].ToString(),
LOCKED = dr["LOCKED"].ToString(),
STATUS = dr["STATUS"].ToString(),
PCODE = dr["PCODE"].ToString(),
ROLE_ID = dr["ROLE_ID"].ToString(),
/*STATUS = dr["EMPLOYER_ID"].ToString(),
* STATUS = dr["APPROVAL_STATUS"].ToString(),
* STATUS = dr["CREATED_BY"].ToString(),
* STATUS = dr["DATE_CREATED"].ToString(),
* STATUS = dr["APPROVED_BY"].ToString(),
* STATUS = dr["STATUS"].ToString(),*/
DATE_LAST_MODIFIED = dr["DATE_APPROVED"].ToString()
}).Skip(startRec).Take(pageSize).ToList();
totalCount = usersCount.Count();
filteredCount = userList.Count();
}
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
var data = userList.Select(emList => new
{
ID = emList.ID,
PHONE = emList.PHONE,
FULLNAME = emList.FULLNAME,
EMAIL = emList.EMAIL,
LOCKED = emList.LOCKED,
STATUS = emList.STATUS,
ROLE_ID = emList.ROLE_ID,
DATE_LAST_MODIFIED = emList.DATE_LAST_MODIFIED
}).OrderBy(orderByString == string.Empty ? "ID asc" : orderByString).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogError logerror = new LogError();
logerror.ErrorLog("", LoginUser, "", "Admin/GetInternalUsers", "Admin", "GetExternalUsers", "FetchExternalUsers Error", ex.Message.ToString(), 0);
throw new Exception(ex.Message.ToString());
}
}