public long SaveRole(ClsRole objSave)
{
try
{
long roleId = 0;
using (TransactionScope scope = new TransactionScope())
{
using (this.objDataContext = new RoleDataContext(Functions.StrConnection))
{
var result = this.objDataContext.InsertOrUpdateRole(objSave.lgId, objSave.strRoleName, objSave.strDescription, objSave.blAllowKilometerLimit, objSave.lgCompanyID, mySession.Current.UserId, PageMaster.Role, objSave.blAllowDispatchBackDateEntry).FirstOrDefault();
if (result != null)
{
roleId = result.InsertedId;
foreach (var item in objSave.strRights.Split(','))
{
string[] strRight = item.Split('|');
this.objDataContext.InsertOrUpdateRolePermissions(strRight[0].longSafe(), roleId, strRight[1].longSafe(), strRight[2].boolSafe(), strRight[3].boolSafe(), strRight[4].boolSafe(), strRight[5].boolSafe(), strRight[6].boolSafe(), mySession.Current.UserId, PageMaster.Role);
}
}
}
scope.Complete();
}
return(roleId);
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId);
return(0);
}
}
public bool IsRoleExists(long lgRoleId, string strRoleName, long lgCompnayId)
{
try
{
using (this.objDataContext = new RoleDataContext(Functions.StrConnection))
{
if (lgCompnayId > 0)
{
if (this.objDataContext.Roles.Where(x => x.Id != lgRoleId && x.IsDeleted == false && x.RoleName == strRoleName && x.CompanyId == lgCompnayId).Count() > 0)
{
return(true);
}
}
else
{
if (this.objDataContext.Roles.Where(x => x.Id != lgRoleId && x.IsDeleted == false && x.RoleName == strRoleName).Count() > 0)
{
return(true);
}
}
}
return(false);
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId);
return(false);
}
}
public ClsRole GetRoleByRoleId(long lgRoleId)
{
ClsRole objClsRole = new ClsRole();
try
{
using (this.objDataContext = new RoleDataContext(Functions.StrConnection))
{
GetRoleByIdResult item = this.objDataContext.GetRoleById(lgRoleId).FirstOrDefault();
if (item != null)
{
objClsRole.lgId = item.Id;
objClsRole.strRoleName = item.RoleName;
objClsRole.strDescription = item.DESCRIPTION;
objClsRole.blAllowKilometerLimit = Convert.ToBoolean(item.AllowKilometerLimit);
objClsRole.blAllowDispatchBackDateEntry = Convert.ToBoolean(item.AllowDispatchBackDateEntry);
objClsRole.lgCompanyID = Convert.ToInt32(item.CompanyID);
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId);
}
return(objClsRole);
}
public List <SelectListItem> GetAllRoleForDropDown(long?CompanyId)
{
List <SelectListItem> lstRole = new List <SelectListItem>();
try
{
using (this.objDataContext = new RoleDataContext(Functions.StrConnection))
{
int AdminRoleID = Common.Enum.USER_ADMIN_ROLES.ADMIN.GetHashCode();
int SysAdminRoleID = Common.Enum.USER_ADMIN_ROLES.SYSADMIN.GetHashCode();
lstRole.Add(new SelectListItem {
Text = "--Select--", Value = string.Empty
});
List <GetRoleAllResult> lstRoleResult = this.objDataContext.GetRoleAll(mySession.Current.UserId, SysAdminRoleID, AdminRoleID).ToList();
if (lstRoleResult.Count > 0)
{
if (CompanyId == null || CompanyId == 0)
{
foreach (var item in lstRoleResult)
{
lstRole.Add(new SelectListItem {
Text = item.RoleName, Value = item.Id.ToString()
});
}
}
else
{
var lstCompanyFilterRoleResult = lstRoleResult.Where(x => x.CompanyID == CompanyId).ToList();
foreach (var item in lstCompanyFilterRoleResult)
{
lstRole.Add(new SelectListItem {
Text = item.RoleName, Value = item.Id.ToString()
});
}
}
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId);
}
return(lstRole);
}
public List <SearchRoleResult> SearchRole(int inRow, int inPage, string strSearch, string strSort)
{
try
{
using (this.objDataContext = new RoleDataContext(Functions.StrConnection))
{
int SysAdminRoleID = Common.Enum.USER_ADMIN_ROLES.SYSADMIN.GetHashCode();
int AdminRoleID = Common.Enum.USER_ADMIN_ROLES.ADMIN.GetHashCode();
return(this.objDataContext.SearchRole(inRow, inPage, strSearch, strSort, mySession.Current.UserId, SysAdminRoleID, AdminRoleID).ToList());
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId);
return(null);
}
}
public bool IsRoleDeleted(long lgRoleId)
{
try
{
using (this.objDataContext = new RoleDataContext(Functions.StrConnection))
{
if (this.objDataContext.Roles.Where(x => x.Id == lgRoleId && x.IsDeleted == true).Count() > 0)
{
return(true);
}
return(false);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId);
return(false);
}
}
public DeleteRoleResult DeleteRole(string strRoleIdList, long lgDeletedBy)
{
try
{
using (this.objDataContext = new RoleDataContext(Functions.StrConnection))
{
DeleteRoleResult result = this.objDataContext.DeleteRole(strRoleIdList, lgDeletedBy, PageMaster.Role, PageMaster.User).FirstOrDefault();
if (result == null)
{
result = new DeleteRoleResult();
}
return(result);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Role, mySession.Current.UserId);
return(null);
}
}