public RESPONSE_MODEL GetApplicationMenuTreeview(int application_id)
{
try
{
var listdata = ctx.APPLICATION_MENUS
.Where(o => o.APP_ID == application_id).OrderBy(o => o.MENU_LEVEL)
.ThenBy(o => o.MENU_SEQ).ToList();
treeviewModelOption state = new treeviewModelOption();
var listMenu = (from item in listdata
select new treeviewModel
{
id = item.MENU_ID.ToString(),
parent = item.PARENT_ID.ToString() == "" ? "#" : item.PARENT_ID.ToString(),
text = item.MENU_NAME,
state = state,
}).ToList();
resp.OUTPUT_DATA = listMenu;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetApplicationMenu(int menu_id)
{
try
{
var data = ctx.APPLICATION_MENUS
.Where(o => o.MENU_ID == menu_id).FirstOrDefault();
var menu = new APPLICATION_MENU_MODEL();
menu.MENU_ID = data.MENU_ID;
menu.PARENT_ID = data.PARENT_ID;
menu.PARENT_NAME = ctx.APPLICATION_MENUS
.Where(o => o.MENU_ID == data.PARENT_ID)
.FirstOrDefault()
.MENU_NAME;
menu.APP_ID = data.APP_ID;
menu.MENU_NAME = data.MENU_NAME;
menu.MENU_LEVEL = data.MENU_LEVEL;
menu.MENU_SEQ = data.MENU_SEQ;
menu.MENU_STATUS = data.MENU_STATUS;
resp.OUTPUT_DATA = menu;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL AddApplication(APPLICATIONS source)
{
try
{
APPLICATIONS application = new APPLICATIONS();
application.APP_NAME = source.APP_NAME;
application.APP_CODE = source.APP_CODE;
application.APP_DESCRIPTION = source.APP_DESCRIPTION;
application.APP_STATUS = source.APP_STATUS;
application.APP_URL = source.APP_URL;
ctx.APPLICATIONS.Add(application);
APPLICATION_MENUS menu = new APPLICATION_MENUS();
menu.APP_ID = application.APP_ID;
menu.MENU_LEVEL = 0;
menu.MENU_SEQ = 0;
menu.MENU_STATUS = 1;
menu.MENU_NAME = "Home";
ctx.APPLICATION_MENUS.Add(menu);
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL ErrorCollection(Exception ex)
{
RESPONSE_MODEL resp = new RESPONSE_MODEL();
resp.STATUS = false;
resp.ERROR_STACK = ex.StackTrace.ToString();
resp.MESSAGE = ex.Message.ToString();
return(resp);
}
public RESPONSE_MODEL UpdateUserProfile(EMPLOYEES source)
{
try
{
ctx.EMPLOYEES.Add(source);
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL DeleteApplicationMenu(int menu_id)
{
try
{
var menu = ctx.APPLICATION_MENUS.Where(o => o.MENU_ID == menu_id).FirstOrDefault();
ctx.APPLICATION_MENUS.Remove(menu);
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetUserApplicationPermission(int employee_id, string application_code)
{
try
{
var application = ctx.APPLICATIONS.Where(o => o.APP_CODE == application_code).FirstOrDefault();
var permission = ctx.APPLICATION_PERMISISONS.Where(o => o.APP_ID == application.APP_ID).FirstOrDefault();
resp.OUTPUT_DATA = permission.APP_PERMISISON_ALLOWED;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL DeleteApplicationRole(int role_id)
{
try
{
var role = ctx.ROLE.Where(o => o.ROLE_ID == role_id).FirstOrDefault();
ctx.ROLE.Remove(role);
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL UpdateApplicationMenu(APPLICATION_MENU_MODEL source)
{
try
{
var menu = ctx.APPLICATION_MENUS.Where(o => o.MENU_ID == source.MENU_ID).FirstOrDefault();
menu.MENU_NAME = source.MENU_NAME;
menu.MENU_STATUS = source.MENU_STATUS;
menu.MENU_SEQ = source.MENU_SEQ;
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL UpdateApplication(APPLICATIONS source)
{
try
{
var application = ctx.APPLICATIONS.Where(o => o.APP_ID == source.APP_ID).FirstOrDefault();
application.APP_NAME = source.APP_NAME;
application.APP_CODE = source.APP_CODE;
application.APP_DESCRIPTION = source.APP_DESCRIPTION;
application.APP_STATUS = source.APP_STATUS;
application.APP_URL = source.APP_URL;
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL UpdateApplicationRole(ROLE source)
{
try
{
var role = ctx.ROLE.Where(o => o.ROLE_ID == source.ROLE_ID).FirstOrDefault();
role.ROLE_NAME = source.ROLE_NAME;
role.ROLE_DESCRIPTION = source.ROLE_DESCRIPTION;
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetApplicationRole(int role_id)
{
try
{
var role = ctx.ROLE.Where(o => o.ROLE_ID == role_id).FirstOrDefault();
var data = new ROLE_MODEL();
data.ROLE_ID = role.ROLE_ID;
data.ROLE_NAME = role.ROLE_NAME;
data.ROLE_DESCRIPTION = role.ROLE_DESCRIPTION;
resp.OUTPUT_DATA = data;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL AddApplicationRole(ROLE source)
{
try
{
var role = new ROLE();
role.ROLE_NAME = source.ROLE_NAME;
role.ROLE_DESCRIPTION = source.ROLE_DESCRIPTION;
role.APP_ID = source.APP_ID;
ctx.ROLE.Add(role);
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetRolePermission(int menu_id, int role_id)
{
try
{
var IsHeaderMenu = ctx.APPLICATION_MENUS.Where(o => o.MENU_ID == menu_id).Select(o => o.PARENT_ID);
var IsPermissionExist = ctx.ROLE_PERMISSION_ALLOWED.Any(o => o.ROLE_ID == role_id && o.MENU_ID == menu_id);
if (IsPermissionExist)
{
var permission = ctx.ROLE_PERMISSION_ALLOWED.Where(o => o.ROLE_ID == role_id && o.MENU_ID == menu_id).FirstOrDefault();
ROLE_PERMISSION_ALLOWED_MODEL data = new ROLE_PERMISSION_ALLOWED_MODEL();
data.ROLE_PERMISSION_ID = permission.ROLE_PERMISSION_ID;
data.MENU_NAME = ctx.APPLICATION_MENUS.Where(o => o.MENU_ID == menu_id).Select(x => x.MENU_NAME).FirstOrDefault();
data.MENU_LEVEL = ctx.APPLICATION_MENUS.Where(o => o.MENU_ID == menu_id).Select(o => o.MENU_LEVEL).FirstOrDefault();
data.ROLE_ID = permission.ROLE_ID;
data.MENU_ID = permission.MENU_ID;
data.GRANT_PERMISSION = permission.GRANT_PERMISSION;
data.VIEW_PERMISSION = permission.VIEW_PERMISSION;
data.INSERT_PERMISSION = permission.INSERT_PERMISSION;
data.UPDATE_PERMISSION = permission.UPDATE_PERMISSION;
data.DELETE_PERMISSION = permission.DELETE_PERMISSION;
resp.OUTPUT_DATA = data;
}
else
{
ROLE_PERMISSION_ALLOWED_MODEL data = new ROLE_PERMISSION_ALLOWED_MODEL();
data.MENU_NAME = ctx.APPLICATION_MENUS.Where(o => o.MENU_ID == menu_id).Select(x => x.MENU_NAME).FirstOrDefault();
data.MENU_LEVEL = ctx.APPLICATION_MENUS.Where(o => o.MENU_ID == menu_id).Select(o => o.MENU_LEVEL).FirstOrDefault();
data.ROLE_ID = role_id;
data.MENU_ID = menu_id;
data.GRANT_PERMISSION = "N";
data.VIEW_PERMISSION = "N";
data.INSERT_PERMISSION = "N";
data.UPDATE_PERMISSION = "N";
data.DELETE_PERMISSION = "N";
resp.OUTPUT_DATA = data;
}
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL UpdateUserApplication(int employee_id, List <int> application_id)
{
try
{
var allApp = ctx.APPLICATIONS.ToList();
if (application_id != null)
{
var deleteOld = ctx.APPLICATION_PERMISISONS.Where(o => application_id.Contains(o.APP_ID) && o.EMPLOYEE_ID == employee_id).ToList();
ctx.APPLICATION_PERMISISONS.RemoveRange(deleteOld);
var allowedApp = allApp.Where(o => application_id.Contains(o.APP_ID)).ToList();
foreach (var item in allowedApp)
{
APPLICATION_PERMISISONS app = new APPLICATION_PERMISISONS();
app.APP_ID = item.APP_ID;
app.EMPLOYEE_ID = employee_id;
app.APP_PERMISISON_ALLOWED = "Y";
ctx.APPLICATION_PERMISISONS.Add(app);
}
var notAllowedApp = allApp.Where(o => !application_id.Contains(o.APP_ID)).ToList();
foreach (var item in notAllowedApp)
{
APPLICATION_PERMISISONS app = new APPLICATION_PERMISISONS();
app.APP_ID = item.APP_ID;
app.EMPLOYEE_ID = employee_id;
app.APP_PERMISISON_ALLOWED = "N";
ctx.APPLICATION_PERMISISONS.Add(app);
}
}
else
{
var deleteOld = ctx.APPLICATION_PERMISISONS.Where(o => o.EMPLOYEE_ID == employee_id).ToList();
ctx.APPLICATION_PERMISISONS.RemoveRange(deleteOld);
}
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL UpdateUserRole(int employee_id, int application_id, List <int> role_id)
{
try
{
var allRole = ctx.ROLE.Where(o => o.APP_ID == application_id).Select(o => o.ROLE_ID).ToList();
if (role_id != null)
{
var deleteOld = ctx.USER_ROLES.Where(o => allRole.Contains(o.ROLE_ID) && o.EMPLOYEE_ID == employee_id).ToList();
ctx.USER_ROLES.RemoveRange(deleteOld);
var allowedRole = allRole.Where(o => role_id.Contains(o)).ToList();
foreach (var item in allowedRole)
{
USER_ROLES role = new USER_ROLES();
role.ROLE_ID = item;
role.EMPLOYEE_ID = employee_id;
role.USER_ROLE_ALLOWED = "Y";
ctx.USER_ROLES.Add(role);
}
var notAllowedRole = allRole.Where(o => !role_id.Contains(o)).ToList();
foreach (var item in notAllowedRole)
{
USER_ROLES role = new USER_ROLES();
role.ROLE_ID = item;
role.EMPLOYEE_ID = employee_id;
role.USER_ROLE_ALLOWED = "N";
ctx.USER_ROLES.Add(role);
}
}
else
{
var deleteOld = ctx.USER_ROLES.Where(o => allRole.Contains(o.ROLE_ID) && o.EMPLOYEE_ID == employee_id).ToList();
ctx.USER_ROLES.RemoveRange(deleteOld);
}
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetUserProfile(int employee_id)
{
try
{
var data = ctx.EMPLOYEES.Where(o => o.EMPLOYEE_ID == employee_id).FirstOrDefault();
USER_PROFILE_MODEL employee = new USER_PROFILE_MODEL();
employee.EMPLOYEE_DEPARTMENT = data.EMPLOYEE_DEPARTMENT;
employee.EMPLOYEE_DISPLAY_NAME = data.EMPLOYEE_DISPLAY_NAME;
employee.EMPLOYEE_FIRST_NAME = data.EMPLOYEE_FIRST_NAME;
employee.EMPLOYEE_LAST_NAME = data.EMPLOYEE_LAST_NAME;
employee.EMPLOYEE_STATUS = data.EMPLOYEE_STATUS;
employee.EMPLOYEE_ID = data.EMPLOYEE_ID;
resp.OUTPUT_DATA = employee;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetComboApplication()
{
try
{
var listData = ctx.APPLICATIONS.ToList();
var listApplication = (from item in listData
select new APPLICATION_MODEL
{
APP_ID = item.APP_ID,
APP_NAME = item.APP_NAME
}).ToList();
resp.OUTPUT_DATA = listApplication;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL AddApplicationMenu(APPLICATION_MENU_MODEL source)
{
try
{
var menu = new APPLICATION_MENUS();
menu.MENU_NAME = source.MENU_NAME;
menu.MENU_STATUS = source.MENU_STATUS;
menu.MENU_SEQ = source.MENU_SEQ;
menu.MENU_LEVEL = source.MENU_LEVEL;
menu.PARENT_ID = source.PARENT_ID;
menu.APP_ID = source.APP_ID;
ctx.APPLICATION_MENUS.Add(menu);
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetListApplicationMenu(int application_id)
{
try
{
var listdata = ctx.APPLICATION_MENUS
.Where(o => o.APP_ID == application_id &&
o.PARENT_ID == null).ToList();
var listMenu = (from item in listdata
select new APPLICATION_MENU_MODEL
{
APP_ID = item.APP_ID,
MENU_NAME = item.MENU_NAME,
MENU_ID = item.MENU_ID,
MENU_LEVEL = item.MENU_LEVEL,
MENU_SEQ = item.MENU_SEQ,
PARENT_ID = item.PARENT_ID,
MENU_STATUS = item.MENU_STATUS,
COMPONENT = (from component in ctx.APPLICATION_MENUS.Where(o => o.PARENT_ID == item.MENU_ID)
select new APPLICATION_MENU_MODEL
{
APP_ID = component.APP_ID,
MENU_NAME = component.MENU_NAME,
MENU_ID = component.MENU_ID,
MENU_LEVEL = component.MENU_LEVEL,
MENU_SEQ = component.MENU_SEQ,
PARENT_ID = component.PARENT_ID,
MENU_STATUS = component.MENU_STATUS,
}).OrderBy(o => o.MENU_SEQ).ToList()
}).OrderBy(o => o.MENU_SEQ).ToList();
container.LIST_MENU_MODEL = listMenu;
resp.OUTPUT_DATA = container;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetApplication(int application_id)
{
try
{
var data = ctx.APPLICATIONS.Where(o => o.APP_ID == application_id).FirstOrDefault();
var application = new APPLICATION_MODEL();
application.APP_ID = data.APP_ID;
application.APP_NAME = data.APP_NAME;
application.APP_CODE = data.APP_CODE;
application.APP_DESCRIPTION = data.APP_DESCRIPTION;
application.APP_URL = data.APP_URL;
application.APP_STATUS = data.APP_STATUS.ToString();
resp.OUTPUT_DATA = application;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetListApplication(FILTER_APPLICATION_MODEL filter)
{
try
{
var listData = new List <APPLICATIONS>();
if (filter != null)
{
listData = ctx.APPLICATIONS.
Where(o => filter.APP_NAME.ToString() != "" ?
o.APP_NAME.ToUpper() == filter.APP_NAME.ToUpper() :
o.APP_NAME.Contains("")).ToList();
}
else
{
listData = ctx.APPLICATIONS.ToList();
}
var listApplication = new List <APPLICATION_MODEL>();
listApplication = (from item in listData
select new APPLICATION_MODEL
{
APP_ID = item.APP_ID,
APP_NAME = item.APP_NAME,
APP_DESCRIPTION = item.APP_DESCRIPTION,
APP_STATUS = item.APP_STATUS == 1 ? "Active" : "Inactive",
APP_URL = item.APP_URL,
APP_CODE = item.APP_CODE
}).OrderBy(o => o.APP_NAME).ToList();
container.LIST_APPLICATION_MODEL = listApplication;
resp.OUTPUT_DATA = container;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GeListApplicationRole(int application_id)
{
try
{
var listdata = ctx.ROLE.Where(o => o.APP_ID == application_id).ToList();
var listRole = (from item in listdata
select new ROLE_MODEL
{
APP_ID = item.APP_ID,
ROLE_NAME = item.ROLE_NAME,
ROLE_ID = item.ROLE_ID,
ROLE_DESCRIPTION = item.ROLE_DESCRIPTION
}).ToList();
container.LIST_ROLE_MODEL = listRole;
resp.OUTPUT_DATA = container;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetUserRole(int employee_id, int application_id)
{
try
{
var appRole = ctx.ROLE.Where(o => o.APP_ID == application_id).ToList();
List <USER_PROFILE_ROLE_MODEL> listData = new List <USER_PROFILE_ROLE_MODEL>();
foreach (var item in appRole)
{
USER_PROFILE_ROLE_MODEL userRole = new USER_PROFILE_ROLE_MODEL();
userRole.ROLE_ID = item.ROLE_ID;
userRole.ROLE_NAME = item.ROLE_NAME;
userRole.ALLOWED = ctx.USER_ROLES.Any(o => o.EMPLOYEE_ID == employee_id && o.ROLE_ID == item.ROLE_ID) == true
? (ctx.USER_ROLES.Where(o => o.EMPLOYEE_ID == employee_id &&
o.ROLE_ID == item.ROLE_ID).FirstOrDefault().USER_ROLE_ALLOWED == "Y" ? true : false) : false;
listData.Add(userRole);
}
resp.OUTPUT_DATA = listData;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetUserApplication(int employee_id)
{
try
{
var listApp = ctx.APPLICATIONS.ToList();
List <USER_PROFILE_APP_MODEL> listData = new List <USER_PROFILE_APP_MODEL>();
foreach (var item in listApp)
{
USER_PROFILE_APP_MODEL userApp = new USER_PROFILE_APP_MODEL();
userApp.APP_ID = item.APP_ID;
userApp.APP_NAME = item.APP_NAME;
userApp.ALLOWED = ctx.APPLICATION_PERMISISONS.Any(o => o.EMPLOYEE_ID == employee_id && o.APP_ID == item.APP_ID) == true
? (ctx.APPLICATION_PERMISISONS.Where(o => o.EMPLOYEE_ID == employee_id &&
o.APP_ID == item.APP_ID).FirstOrDefault().APP_PERMISISON_ALLOWED == "Y" ? true : false) : false;
listData.Add(userApp);
}
resp.OUTPUT_DATA = listData;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public RESPONSE_MODEL GetListUserProfile()
{
try
{
var employee = ctx.EMPLOYEES.ToList();
resp.OUTPUT_DATA = employee;
List <USER_PROFILE_MODEL> listUser = (from item in employee
select new USER_PROFILE_MODEL
{
EMPLOYEE_DEPARTMENT = item.EMPLOYEE_DEPARTMENT,
EMPLOYEE_DISPLAY_NAME = item.EMPLOYEE_DISPLAY_NAME,
EMPLOYEE_FIRST_NAME = item.EMPLOYEE_FIRST_NAME,
EMPLOYEE_LAST_NAME = item.EMPLOYEE_LAST_NAME,
EMPLOYEE_ID = item.EMPLOYEE_ID,
EMPLOYEE_STATUS = item.EMPLOYEE_STATUS
}).ToList();
resp.OUTPUT_DATA = listUser;
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public JsonResult UpdateUserRole(int employee_id, int application_id, List <int> role_id)
{
resp = service.UpdateUserRole(employee_id, application_id, role_id);
return(Json(resp, JsonRequestBehavior.AllowGet));
}
public JsonResult GetListUserProfile()
{
resp = service.GetListUserProfile();
return(Json(resp, JsonRequestBehavior.AllowGet));
}
public JsonResult GetUserRole(int employee_id, int application_id)
{
resp = service.GetUserRole(employee_id, application_id);
return(Json(resp, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateUserProfile(EMPLOYEES source)
{
resp = service.UpdateUserProfile(source);
return(Json(resp, JsonRequestBehavior.AllowGet));
}
