private List <DOADM_AccessGroupMaster> GetAccessGroupSearchResult(string AccessGroupName = "", string AccessGroupDescription = "", bool IsActive = true)
{
long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
BLAccessGroup objBLAccessGroup = new BLAccessGroup();
DOADM_AccessGroupMaster objDOADM_AccessGroupMaster = new DOADM_AccessGroupMaster();
objDOADM_AccessGroupMaster.AccessGroupName = AccessGroupName;
objDOADM_AccessGroupMaster.AccessGroupDescription = AccessGroupDescription;
objDOADM_AccessGroupMaster.IsActive = IsActive;
List <DOADM_AccessGroupMaster> lstDOADM_AccessGroupMaster = new List <DOADM_AccessGroupMaster>();
try
{
ExceptionTypes result = objBLAccessGroup.GetAccessGroupBasedOnSearch(TimeZone, objDOADM_AccessGroupMaster, out lstDOADM_AccessGroupMaster);
if (result != (long)ExceptionTypes.Success)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, string.Empty, "error while retriving search results");
}
return(lstDOADM_AccessGroupMaster);
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
return(null);
}
}
public ExceptionTypes GetAccessGroupForEdit(DOADM_AccessGroupMaster objDOADM_AccessGroupMaster, out UIDOAccessGroup objUIDOAccessGroup)
{
objUIDOAccessGroup = new UIDOAccessGroup();
try
{
DAHelper dah = new DAHelper();
long lErrocode = 0;
long lErrorNumber = 0;
DataSet dsTable = new DataSet();
string errorMessage;
List <SqlParameter> parameters = new List <SqlParameter>();
SqlParameter sqlParam;
if (objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId > 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@AccessGroupMasterId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId;
parameters.Add(sqlParam);
}
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ErrorMessage";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = string.Empty;
sqlParam.Direction = ParameterDirection.Output;
sqlParam.Size = 2000;
parameters.Add(sqlParam);
long executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_USP_APP_SEL_AccesssGroup, parameters.ToArray(), out dsTable, out lErrocode, out lErrorNumber, out errorMessage);
if (executionResult == 0)
{
if (dsTable.Tables.Count > 0 && dsTable.Tables[0].Rows.Count > 0)
{
MapUIDOAccessGroupObjectProperties(dsTable, out objUIDOAccessGroup);
if (objUIDOAccessGroup != null)
{
return(ExceptionTypes.Success);
}
}
return(ExceptionTypes.ZeroRecords);
}
else if (executionResult == 2)
{
return(ExceptionTypes.ZeroRecords);
}
else
{
return(ExceptionTypes.UnknownError);
}
}
catch (Exception ex)
{
return(ExceptionTypes.UnknownError);
}
}
public ActionResult Search(DOADM_AccessGroupMaster objDOADM_AccessGroupMaster)
{
try
{
return(PartialView("_SearchResults", GetAccessGroupSearchResult(objDOADM_AccessGroupMaster.AccessGroupName, objDOADM_AccessGroupMaster.AccessGroupDescription, objDOADM_AccessGroupMaster.IsActive)));
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
return(RedirectToAction("Maintenance", "Error", new { Error = MethodBase.GetCurrentMethod().Name + " Action terminated and redirected to Maintenance. Error:" + ex.ToString() }));
}
}
public ActionResult Add(long ADM_AccessGroupMasterId = 0, bool isActive = true)
{
try
{
long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
Session[ConstantTexts.AccessGroupSkillSessionKey] = null;
Session[ConstantTexts.AccessGroupReportSessionKey] = null;
ViewBag.RoleList = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Role);
ViewBag.WorkBasketList = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.WorkBasket);
ViewBag.Reports = ViewBag.Reports = CacheUtility.GetAllReportsFromCache(null, "");
UIDOAccessGroup objUIDOAccessGroup = new UIDOAccessGroup();
objUIDOAccessGroup.IsActive = true;
objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation = new List <DOADM_AccessGroupSkillsCorrelation>();
objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation = new List <DOADM_AccessGroupReportCorrelation>();
if (ADM_AccessGroupMasterId != 0)
{
DOADM_AccessGroupMaster objDOADM_AccessGroupMaster = new DOADM_AccessGroupMaster();
BLAccessGroup objBLAccessGroup = new BLAccessGroup();
objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId = ADM_AccessGroupMasterId;
objDOADM_AccessGroupMaster.IsActive = isActive;
ExceptionTypes result = objBLAccessGroup.GetAccessGroupForEdit(objDOADM_AccessGroupMaster, out objUIDOAccessGroup);
Session[ConstantTexts.AccessGroupSkillSessionKey] = objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation;
Session[ConstantTexts.AccessGroupReportSessionKey] = objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation;
DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster();
List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>();
BLSkills objBLSkills = new BLSkills();
objDOADM_SkillsMaster.IsActive = true;
objDOADM_SkillsMaster.WorkBasketLkup = objUIDOAccessGroup.WorkBasketLkup;
objDOADM_SkillsMaster.RoleLkup = objUIDOAccessGroup.RoleLkup;
ExceptionTypes result1 = objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out string errorMesssage);
ViewBag.Skills = lstDOADM_SkillsMaster.Where(x => x.IsActive == true).ToList();
}
return(View(objUIDOAccessGroup));
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
return(RedirectToAction("Maintenance", "Error", new { Error = MethodBase.GetCurrentMethod().Name + " Action terminated and redirected to Maintenance. Error:" + ex.ToString() }));
}
}
public ActionResult CheckExistsAccessGroup(string accessGroupsName)
{
string strErrorMessage = string.Empty;
string strMessage = string.Empty;
bool accessGroupExists = false;
try
{
long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
BLAccessGroup _objBLAccessGroups = new BLAccessGroup();
DOADM_AccessGroupMaster objDOADM_AccessGroupMaster = new DOADM_AccessGroupMaster();
objDOADM_AccessGroupMaster.AccessGroupName = accessGroupsName;
objDOADM_AccessGroupMaster.IsActive = true;
List <DOADM_AccessGroupMaster> lstDOADM_AccessGroupsMaster;
ExceptionTypes result = _objBLAccessGroups.GetAccessGroupBasedOnSearch(TimeZone, objDOADM_AccessGroupMaster, out lstDOADM_AccessGroupsMaster);
if (lstDOADM_AccessGroupsMaster.Count > 0)
{
accessGroupExists = true;
}
else
{
objDOADM_AccessGroupMaster.IsActive = false;//search again to check for not active records
result = _objBLAccessGroups.GetAccessGroupBasedOnSearch(TimeZone, objDOADM_AccessGroupMaster, out lstDOADM_AccessGroupsMaster);
if (lstDOADM_AccessGroupsMaster.Count > 0)
{
accessGroupExists = true;
}
else
{
accessGroupExists = false;
}
}
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
return(RedirectToAction("Maintenance", "Error", new { Error = MethodBase.GetCurrentMethod().Name + " Action terminated and redirected to Maintenance. Error:" + ex.ToString() }));
}
return(Json(new { accessGroupExists = accessGroupExists, strMessage = strMessage }, JsonRequestBehavior.AllowGet));
}
public void MapObjectProperties(long?TimeZone, DataSet dsTable, out List <DOADM_AccessGroupMaster> lstDOADM_AccessGroupMaster)
{
lstDOADM_AccessGroupMaster = new List <DOADM_AccessGroupMaster>();
try
{
if (dsTable.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsTable.Tables[0].Rows)
{
DOADM_AccessGroupMaster objDOADM_AccessGroupMaster = new DOADM_AccessGroupMaster();
if (dr.Table.Columns.Contains("AccessGroupMasterId"))
{
if (!DBNull.Value.Equals(dr["AccessGroupMasterId"]))
{
objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId = (long)dr["AccessGroupMasterId"];
}
}
if (dr.Table.Columns.Contains("AccessGroupName"))
{
if (!DBNull.Value.Equals(dr["AccessGroupName"]))
{
objDOADM_AccessGroupMaster.AccessGroupName = dr["AccessGroupName"].ToString();
}
}
if (dr.Table.Columns.Contains("CreatedByRef"))
{
if (!DBNull.Value.Equals(dr["CreatedByRef"]))
{
objDOADM_AccessGroupMaster.CreatedByRef = (long)dr["CreatedByRef"];
}
}
if (dr.Table.Columns.Contains("CreatedOn"))
{
if (!DBNull.Value.Equals(dr["CreatedOn"]))
{
objDOADM_AccessGroupMaster.UTCCreatedOn = ZoneLookupUI.ConvertToTimeZone(dr["CreatedOn"].ToDateTime(), TimeZone);
}
}
if (dr.Table.Columns.Contains("LastUpdatedByRef"))
{
if (!DBNull.Value.Equals(dr["LastUpdatedByRef"]))
{
objDOADM_AccessGroupMaster.LastUpdatedByRef = (long)dr["LastUpdatedByRef"];
}
}
if (dr.Table.Columns.Contains("LastUpdatedOn"))
{
if (!DBNull.Value.Equals(dr["LastUpdatedOn"]))
{
objDOADM_AccessGroupMaster.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(dr["LastUpdatedOn"].ToDateTime(), TimeZone);
}
}
if (dr.Table.Columns.Contains("CreatedByName"))
{
if (!DBNull.Value.Equals(dr["CreatedByName"]))
{
objDOADM_AccessGroupMaster.CreatedByName = dr["CreatedByName"].ToString();;
}
}
if (dr.Table.Columns.Contains("LastUpdatedByName"))
{
if (!DBNull.Value.Equals(dr["LastUpdatedByName"]))
{
objDOADM_AccessGroupMaster.LastUpdateByName = dr["LastUpdatedByName"].ToString();
}
}
if (dr.Table.Columns.Contains("LockedByRef"))
{
if (!DBNull.Value.Equals(dr["LockedByRef"]))
{
objDOADM_AccessGroupMaster.LockedByRef = Convert.ToInt64(dr["LockedByRef"]);
}
}
if (dr.Table.Columns.Contains("UTCLockedOn"))
{
if (!DBNull.Value.Equals(dr["UTCLockedOn"]))
{
objDOADM_AccessGroupMaster.UTCLockedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCLockedOn"].ToDateTime(), TimeZone);
}
}
if (dr.Table.Columns.Contains("LockedBy"))
{
if (!DBNull.Value.Equals(dr["LockedBy"]))
{
objDOADM_AccessGroupMaster.LockedByName = dr["LockedBy"].ToString();
}
}
if (dr.Table.Columns.Contains("IsActive"))
{
if (!DBNull.Value.Equals(dr["IsActive"]))
{
if (dr["IsActive"].ToString() == "True")
{
objDOADM_AccessGroupMaster.IsActive = true;
}
else
{
objDOADM_AccessGroupMaster.IsActive = false;
}
}
}
lstDOADM_AccessGroupMaster.Add(objDOADM_AccessGroupMaster);
}
}
}
catch (Exception ex)
{
}
}
public ExceptionTypes GetAccessGroupBasedOnSearch(long?TimeZone, DOADM_AccessGroupMaster objDOADM_AccessGroupMaster, out List <DOADM_AccessGroupMaster> lstDOADM_AccessGroupMaster)
{
lstDOADM_AccessGroupMaster = new List <DOADM_AccessGroupMaster>();
try
{
DAHelper dah = new DAHelper();
long lErrocode = 0;
long lErrorNumber = 0;
DataSet dsTable = new DataSet();
string errorMessage;
List <SqlParameter> parameters = new List <SqlParameter>();
SqlParameter sqlParam;
if (objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId > 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@AccessGroupMasterId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId;
parameters.Add(sqlParam);
}
if (!string.IsNullOrEmpty(objDOADM_AccessGroupMaster.AccessGroupName))
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@AccessGroupName";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_AccessGroupMaster.AccessGroupName;
parameters.Add(sqlParam);
}
if (!string.IsNullOrEmpty(objDOADM_AccessGroupMaster.AccessGroupDescription))
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@AccessGroupDescription";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_AccessGroupMaster.AccessGroupDescription;
parameters.Add(sqlParam);
}
if (objDOADM_AccessGroupMaster.IsActive != null)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@IsActive";
sqlParam.SqlDbType = SqlDbType.Bit;
sqlParam.Value = objDOADM_AccessGroupMaster.IsActive;
parameters.Add(sqlParam);
}
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ErrorMessage";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = string.Empty;
sqlParam.Direction = ParameterDirection.Output;
sqlParam.Size = 2000;
parameters.Add(sqlParam);
long executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_USP_APP_SEL_AccesssGroup, parameters.ToArray(), out dsTable, out lErrocode, out lErrorNumber, out errorMessage);
if (executionResult == 0)
{
if (dsTable.Tables.Count > 0 && dsTable.Tables[0].Rows.Count > 0)
{
MapObjectProperties(TimeZone, dsTable, out lstDOADM_AccessGroupMaster);
if (lstDOADM_AccessGroupMaster.Count > 0)
{
return(ExceptionTypes.Success);
}
}
return(ExceptionTypes.ZeroRecords);
}
else if (executionResult == 2)
{
return(ExceptionTypes.ZeroRecords);
}
else
{
return(ExceptionTypes.UnknownError);
}
}
catch (Exception ex)
{
return(ExceptionTypes.UnknownError);
}
}
public ExceptionTypes GetAccessGroupForEdit(DOADM_AccessGroupMaster objDOADM_AccessGroupMaster, out UIDOAccessGroup objUIDOAccessGroup)
{
DALAccessGroup objDALAccessGroup = new DALAccessGroup();
return(retVal = objDALAccessGroup.GetAccessGroupForEdit(objDOADM_AccessGroupMaster, out objUIDOAccessGroup));
}
public ExceptionTypes GetAccessGroupBasedOnSearch(long?TimeZone, DOADM_AccessGroupMaster objDOADM_AccessGroupMaster, out List <DOADM_AccessGroupMaster> lstDOADM_AccessGroupMaster)
{
DALAccessGroup objDALAccessGroup = new DALAccessGroup();
return(retVal = objDALAccessGroup.GetAccessGroupBasedOnSearch(TimeZone, objDOADM_AccessGroupMaster, out lstDOADM_AccessGroupMaster));
}
