public ActionResult Save(UIDOAccessGroup objUIDOAccessGroup)
{
string errorMessage = string.Empty;
string returnMessage = string.Empty;
ExceptionTypes result = new ExceptionTypes();
try
{
//check if this call is to update record or save new record
if (objUIDOAccessGroup.ADM_AccessGroupMasterId > 0)
{
//if old record is to be updated
BLCommon objCommon = new BLCommon();
//check if record is locked by current user
if (!objCommon.ValidateLockBeforeSave(currentUser.ADM_UserMasterId, (long)ScreenType.AccessGroup, objUIDOAccessGroup.ADM_AccessGroupMasterId))
{
//if record is not locked by current user dont save record and return error.
errorMessage = "Record not locked, please reload the page.";
result = ExceptionTypes.UnknownError;
return(Json(new { ID = result, Message = errorMessage }));
}
returnMessage = "Record updated successfully.";
}
else
{
//If new record to be saved
returnMessage = "Record saved successfully.";
}
objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation = new List <DOADM_AccessGroupSkillsCorrelation>();
objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation = new List <DOADM_AccessGroupReportCorrelation>();
if (Session[ConstantTexts.AccessGroupSkillSessionKey] != null)
{
objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation = Session[ConstantTexts.AccessGroupSkillSessionKey] as List <DOADM_AccessGroupSkillsCorrelation>;
}
if (Session[ConstantTexts.AccessGroupReportSessionKey] != null)
{
objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation = Session[ConstantTexts.AccessGroupReportSessionKey] as List <DOADM_AccessGroupReportCorrelation>;
}
BLAccessGroup objBLAccessGroup = new BLAccessGroup();
result = objBLAccessGroup.AddEditAccessGroup(currentUser.ADM_UserMasterId, objUIDOAccessGroup, out errorMessage);
if (result != (long)ExceptionTypes.Success)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage);
return(Json(new { ID = result, Message = "An error occured while updating DB." }));
}
Session[ConstantTexts.AccessGroupSkillSessionKey] = null;
Session[ConstantTexts.AccessGroupReportSessionKey] = null;
return(Json(new { ID = result, Message = returnMessage }));
}
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 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 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() }));
}
}
private void MapUIDOAccessGroupObjectProperties(DataSet dstTable, out UIDOAccessGroup objUIDOAccessGroup)
{
objUIDOAccessGroup = new UIDOAccessGroup();
try
{
if (dstTable.Tables.Count > 0)
{
foreach (DataRow drAG in dstTable.Tables[0].Rows)
{
if (drAG.Table.Columns.Contains("AccessGroupMasterId"))
{
if (!DBNull.Value.Equals(drAG["AccessGroupMasterId"]))
{
objUIDOAccessGroup.ADM_AccessGroupMasterId = (long)drAG["AccessGroupMasterId"];
}
}
if (drAG.Table.Columns.Contains("WorkBasketLkup"))
{
if (!DBNull.Value.Equals(drAG["WorkBasketLkup"]))
{
objUIDOAccessGroup.WorkBasketLkup = (long)drAG["WorkBasketLkup"];
}
}
if (drAG.Table.Columns.Contains("DescripancyCatLkup"))
{
if (!DBNull.Value.Equals(drAG["DescripancyCatLkup"]))
{
objUIDOAccessGroup.DescripancyCatLkup = (long)drAG["DescripancyCatLkup"];
}
}
if (drAG.Table.Columns.Contains("RoleLkup"))
{
if (!DBNull.Value.Equals(drAG["RoleLkup"]))
{
objUIDOAccessGroup.RoleLkup = (long)drAG["RoleLkup"];
}
}
if (drAG.Table.Columns.Contains("AccessGroupName"))
{
if (!DBNull.Value.Equals(drAG["AccessGroupName"]))
{
objUIDOAccessGroup.AccessGroupName = drAG["AccessGroupName"].ToString();
}
}
if (drAG.Table.Columns.Contains("AccessGroupDescription"))
{
if (!DBNull.Value.Equals(drAG["AccessGroupDescription"]))
{
objUIDOAccessGroup.AccessGroupDescription = drAG["AccessGroupDescription"].ToString();
}
}
if (drAG.Table.Columns.Contains("IsActive"))
{
if (!DBNull.Value.Equals(drAG["IsActive"]))
{
if (drAG["IsActive"].ToString() == "True")
{
objUIDOAccessGroup.IsActive = true;
}
else
{
objUIDOAccessGroup.IsActive = false;
}
}
}
}
objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation = new List <DOADM_AccessGroupSkillsCorrelation>();
foreach (DataRow drSkl in dstTable.Tables[1].Rows)
{
DOADM_AccessGroupSkillsCorrelation objDOADM_AccessGroupSkillsCorrelation = new DOADM_AccessGroupSkillsCorrelation();
if (drSkl.Table.Columns.Contains("ADM_AccessGroupSkillsCorrelationId"))
{
if (!DBNull.Value.Equals(drSkl["ADM_AccessGroupSkillsCorrelationId"]))
{
objDOADM_AccessGroupSkillsCorrelation.ADM_AccessGroupSkillsCorrelationId = (long)drSkl["ADM_AccessGroupSkillsCorrelationId"];
}
}
if (drSkl.Table.Columns.Contains("ADM_AccessGroupMasterRef"))
{
if (!DBNull.Value.Equals(drSkl["ADM_AccessGroupMasterRef"]))
{
objDOADM_AccessGroupSkillsCorrelation.ADM_AccessGroupMasterRef = (long)drSkl["ADM_AccessGroupMasterRef"];
}
}
if (drSkl.Table.Columns.Contains("ADM_SkillsMasterRef"))
{
if (!DBNull.Value.Equals(drSkl["ADM_SkillsMasterRef"]))
{
objDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef = (long)drSkl["ADM_SkillsMasterRef"];
}
}
if (drSkl.Table.Columns.Contains("CanCreate"))
{
if (!DBNull.Value.Equals(drSkl["CanCreate"]))
{
if (drSkl["CanCreate"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.CanCreate = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.CanCreate = false;
}
}
}
if (drSkl.Table.Columns.Contains("CanSearch"))
{
if (!DBNull.Value.Equals(drSkl["CanSearch"]))
{
if (drSkl["CanSearch"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.CanSearch = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.CanSearch = false;
}
}
}
if (drSkl.Table.Columns.Contains("CanReassign"))
{
if (!DBNull.Value.Equals(drSkl["CanReassign"]))
{
if (drSkl["CanReassign"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.CanReassign = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.CanReassign = false;
}
}
}
if (drSkl.Table.Columns.Contains("CanUnlock"))
{
if (!DBNull.Value.Equals(drSkl["CanUnlock"]))
{
if (drSkl["CanUnlock"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.CanUnlock = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.CanUnlock = false;
}
}
}
if (drSkl.Table.Columns.Contains("CanHistory"))
{
if (!DBNull.Value.Equals(drSkl["CanHistory"]))
{
if (drSkl["CanHistory"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.CanHistory = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.CanHistory = false;
}
}
}
if (drSkl.Table.Columns.Contains("CanModify"))
{
if (!DBNull.Value.Equals(drSkl["CanModify"]))
{
if (drSkl["CanModify"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.CanModify = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.CanModify = false;
}
}
}
if (drSkl.Table.Columns.Contains("CanView"))
{
if (!DBNull.Value.Equals(drSkl["CanView"]))
{
if (drSkl["CanView"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.CanView = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.CanView = false;
}
}
}
if (drSkl.Table.Columns.Contains("CanMassUpdate"))
{
if (!DBNull.Value.Equals(drSkl["CanMassUpdate"]))
{
if (drSkl["CanMassUpdate"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.CanMassUpdate = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.CanMassUpdate = false;
}
}
}
if (drSkl.Table.Columns.Contains("CanUpload"))
{
if (!DBNull.Value.Equals(drSkl["CanUpload"]))
{
if (drSkl["CanUpload"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.CanUpload = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.CanUpload = false;
}
}
}
if (drSkl.Table.Columns.Contains("CanClone"))
{
if (!DBNull.Value.Equals(drSkl["CanClone"]))
{
if (drSkl["CanClone"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.CanClone = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.CanClone = false;
}
}
}
if (drSkl.Table.Columns.Contains("CanReopen"))
{
if (!DBNull.Value.Equals(drSkl["CanReopen"]))
{
if (drSkl["CanReopen"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.CanReopen = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.CanReopen = false;
}
}
}
if (drSkl.Table.Columns.Contains("UTCLastUpdatedOn"))
{
if (!DBNull.Value.Equals(drSkl["UTCLastUpdatedOn"]))
{
objDOADM_AccessGroupSkillsCorrelation.UTCLastUpdatedOn = Convert.ToDateTime(drSkl["UTCLastUpdatedOn"]);
}
}
if (drSkl.Table.Columns.Contains("LastUpdatedByName"))
{
if (!DBNull.Value.Equals(drSkl["LastUpdatedByName"]))
{
objDOADM_AccessGroupSkillsCorrelation.LastUpdatedByName = drSkl["LastUpdatedByName"].ToString();
}
}
if (drSkl.Table.Columns.Contains("IsActive"))
{
if (!DBNull.Value.Equals(drSkl["IsActive"]))
{
if (drSkl["IsActive"].ToString() == "True")
{
objDOADM_AccessGroupSkillsCorrelation.IsActive = true;
}
else
{
objDOADM_AccessGroupSkillsCorrelation.IsActive = false;
}
}
}
objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation.Add(objDOADM_AccessGroupSkillsCorrelation);
}
objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation = new List <DOADM_AccessGroupReportCorrelation>();
foreach (DataRow drRpt in dstTable.Tables[2].Rows)
{
DOADM_AccessGroupReportCorrelation objDOADM_AccessGroupReportCorrelation = new DOADM_AccessGroupReportCorrelation();
if (drRpt.Table.Columns.Contains("ADM_AccessGroupReportCorrelationId"))
{
if (!DBNull.Value.Equals(drRpt["ADM_AccessGroupReportCorrelationId"]))
{
objDOADM_AccessGroupReportCorrelation.ADM_AccessGroupReportCorrelationId = (long)drRpt["ADM_AccessGroupReportCorrelationId"];
}
}
if (drRpt.Table.Columns.Contains("ADM_AccessGroupMasterRef"))
{
if (!DBNull.Value.Equals(drRpt["ADM_AccessGroupMasterRef"]))
{
objDOADM_AccessGroupReportCorrelation.ADM_AccessGroupMasterRef = (long)drRpt["ADM_AccessGroupMasterRef"];
}
}
if (drRpt.Table.Columns.Contains("RPT_ReportsMasterRef"))
{
if (!DBNull.Value.Equals(drRpt["RPT_ReportsMasterRef"]))
{
objDOADM_AccessGroupReportCorrelation.RPT_ReportsMasterRef = (long)drRpt["RPT_ReportsMasterRef"];
}
}
if (drRpt.Table.Columns.Contains("CreatedByRef"))
{
if (!DBNull.Value.Equals(drRpt["CreatedByRef"]))
{
objDOADM_AccessGroupReportCorrelation.CreatedByRef = (long)drRpt["CreatedByRef"];
}
}
if (drRpt.Table.Columns.Contains("UTCCreatedOn"))
{
if (!DBNull.Value.Equals(drRpt["UTCCreatedOn"]))
{
objDOADM_AccessGroupReportCorrelation.UTCCreatedOn = Convert.ToDateTime(drRpt["UTCCreatedOn"]);
}
}
if (drRpt.Table.Columns.Contains("UTCLastUpdatedOn"))
{
if (!DBNull.Value.Equals(drRpt["UTCLastUpdatedOn"]))
{
objDOADM_AccessGroupReportCorrelation.UTCLastUpdatedOn = Convert.ToDateTime(drRpt["UTCLastUpdatedOn"]);
}
}
if (drRpt.Table.Columns.Contains("LastUpdatedByRef"))
{
if (!DBNull.Value.Equals(drRpt["LastUpdatedByRef"]))
{
objDOADM_AccessGroupReportCorrelation.LastUpdatedByRef = (long)drRpt["LastUpdatedByRef"];
}
}
if (drRpt.Table.Columns.Contains("CreatedByName"))
{
if (!DBNull.Value.Equals(drRpt["CreatedByName"]))
{
objDOADM_AccessGroupReportCorrelation.CreatedByName = drRpt["CreatedByName"].ToString();
}
}
if (drRpt.Table.Columns.Contains("LastUpdatedByName"))
{
if (!DBNull.Value.Equals(drRpt["LastUpdatedByName"]))
{
objDOADM_AccessGroupReportCorrelation.LastUpdatedByName = drRpt["LastUpdatedByName"].ToString();
}
}
if (drRpt.Table.Columns.Contains("IsActive"))
{
if (!DBNull.Value.Equals(drRpt["IsActive"]))
{
if (drRpt["IsActive"].ToString() == "True")
{
objDOADM_AccessGroupReportCorrelation.IsActive = true;
}
else
{
objDOADM_AccessGroupReportCorrelation.IsActive = false;
}
}
}
objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation.Add(objDOADM_AccessGroupReportCorrelation);
}
}
}
catch (Exception ex)
{
//log
}
}
public ExceptionTypes AddEditAccessGroup(long lLoggedInUserId, UIDOAccessGroup objUIDOAccessGroup, out string errorMessage)
{
errorMessage = string.Empty;
try
{
DAHelper dah = new DAHelper();
long lErrocode = 0;
long lErrorNumber = 0;
long lNumberOfRowsEffected = 0;
DataSet dsTable = new DataSet();
List <SqlParameter> parameters = new List <SqlParameter>();
SqlParameter sqlParam;
if (objUIDOAccessGroup.ADM_AccessGroupMasterId > 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ADM_AccessGroupMasterId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objUIDOAccessGroup.ADM_AccessGroupMasterId;
parameters.Add(sqlParam);
}
if (objUIDOAccessGroup.AccessGroupName != string.Empty)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@AccessGroupName";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objUIDOAccessGroup.AccessGroupName;
parameters.Add(sqlParam);
}
if (objUIDOAccessGroup.AccessGroupDescription != string.Empty)
{
if (objUIDOAccessGroup.AccessGroupDescription == null)
{
objUIDOAccessGroup.AccessGroupDescription = "";
}
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@AccessGroupDescription";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objUIDOAccessGroup.AccessGroupDescription;
parameters.Add(sqlParam);
}
if (objUIDOAccessGroup.RoleLkup > 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@RoleLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objUIDOAccessGroup.RoleLkup;
parameters.Add(sqlParam);
}
if (objUIDOAccessGroup.WorkBasketLkup > 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@WorkBasketLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objUIDOAccessGroup.WorkBasketLkup;
parameters.Add(sqlParam);
}
if (objUIDOAccessGroup.DescripancyCatLkup > 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@DiscrepancyCategoryLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objUIDOAccessGroup.DescripancyCatLkup;
parameters.Add(sqlParam);
}
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@IsActive";
sqlParam.SqlDbType = SqlDbType.Bit;
sqlParam.Value = objUIDOAccessGroup.IsActive;
parameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@LoginUserId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = lLoggedInUserId;
parameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ScreenLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = ScreenType.AccessGroup;
parameters.Add(sqlParam);
if (objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation.Count() > 0)
{
DataTable accessGroupSkills;
SetAccessGroupSkills(objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation, out accessGroupSkills);
DataTableReader dtrAccessGroupSkills = new DataTableReader(accessGroupSkills);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@TV_Skills";
sqlParam.SqlDbType = SqlDbType.Structured;
sqlParam.Value = dtrAccessGroupSkills;
parameters.Add(sqlParam);
}
if (objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation.Count() > 0)
{
DataTable accessGroupReports;
SetAccessGroupReports(objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation, out accessGroupReports);
DataTableReader dtrAccessGroupReport = new DataTableReader(accessGroupReports);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@TV_Reports";
sqlParam.SqlDbType = SqlDbType.Structured;
sqlParam.Value = dtrAccessGroupReport;
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.ExecuteDMLSP(ConstantTexts.SP_USP_APP_INS_UPD_AccessGroup, parameters.ToArray(), out lErrocode, out lErrorNumber, out lNumberOfRowsEffected, out errorMessage);
sqlParam = parameters.FirstOrDefault(x => x.ParameterName == "@ErrorMessage");
if (sqlParam != null && sqlParam.Value != null)
{
errorMessage += sqlParam.Value.ToString();
}
if (executionResult == (long)ExceptionTypes.Success && string.IsNullOrEmpty(errorMessage))
{
return(ExceptionTypes.Success);
}
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 AddEditAccessGroup(long lLoggedInUserId, UIDOAccessGroup objUIDOAccessGroup, out string errorMessage)
{
DALAccessGroup objDALAccessGroup = new DALAccessGroup();
return(retVal = objDALAccessGroup.AddEditAccessGroup(lLoggedInUserId, objUIDOAccessGroup, out errorMessage));
}
