public ExceptionTypes SearchSkills(long?TimeZone, DOADM_SkillsMaster objDOADM_SkillsDetails, out List <DOADM_SkillsMaster> lstDOADM_SkillsMaster, out string errorMessage)
{
retValue = new ExceptionTypes();
DALSkills objDALResources = new DALSkills();
return(retValue = objDALResources.SearchSkills(TimeZone, objDOADM_SkillsDetails, out lstDOADM_SkillsMaster, out errorMessage));
}
public ExceptionTypes SaveSkills(DOADM_SkillsMaster objDOADM_SkillsMaster, long lLoginId, out string errorMessage)
{
retValue = new ExceptionTypes();
DALSkills objDALSkills = new DALSkills();
return(retValue = objDALSkills.AddSkills(objDOADM_SkillsMaster, lLoginId, out errorMessage));
}
private void GetSkillForEdit(long lSkillsID, bool isActive, out DOADM_SkillsMaster objDOADM_SkillsMaster)
{
long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
string errorMessage = string.Empty;
ExceptionTypes result;
List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>();
objDOADM_SkillsMaster = new DOADM_SkillsMaster();
try
{
objDOADM_SkillsMaster.ADM_SkillsMasterId = lSkillsID;
objDOADM_SkillsMaster.IsActive = isActive;
result = _objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out errorMessage);
if (result != (long)ExceptionTypes.Success)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, "error occured while retrving skill data", "error occured while retrving skill data");
}
if (lstDOADM_SkillsMaster.Count > 0)
{
objDOADM_SkillsMaster = lstDOADM_SkillsMaster.FirstOrDefault();
}
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString());
}
}
public ActionResult Search()
{
try
{
string strErrorMessage = string.Empty;
BLSkills _objBLSkills = new BLSkills();
DOADM_SkillMasterExtended objDOADM_SkillMasterExtended = new DOADM_SkillMasterExtended();
objDOADM_SkillMasterExtended.lstRoles = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Role);
objDOADM_SkillMasterExtended.lstBusinessSegment = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.BusinessSegment);
objDOADM_SkillMasterExtended.lstDepartment = GetERSDepartments();
objDOADM_SkillMasterExtended.lstWorkBasket = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.WorkBasket);
List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>();
DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster();
objDOADM_SkillsMaster.IsActive = true;
long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
ExceptionTypes result = _objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out strErrorMessage);
objDOADM_SkillMasterExtended.lstSkillsMaster = lstDOADM_SkillsMaster;
return(View(objDOADM_SkillMasterExtended));
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString());
return(RedirectToAction("Maintenance", "Error", routeValues: ex.ToString()));
}
}
public ActionResult Add(long lSkillsID = 0, bool isActive = true)
{
string errorMessage = string.Empty;
try
{
Session[ConstantTexts.SkillWorkQueueSessionKey] = null;
DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster();
objDOADM_SkillsMaster.IsActive = true;
ViewBag.Roles = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Role);
ViewBag.BusinessSegment = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.BusinessSegment);
ViewBag.WorkBasket = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.WorkBasket);
ViewBag.lstDiscrepancyCategories = GetDiscrepancyCategories();
ViewBag.lstDepartments = GetERSDepartments();
if (lSkillsID != 0)
{
GetSkillForEdit(lSkillsID, isActive, out objDOADM_SkillsMaster);
List <DOCMN_LookupMasterCorrelations> lstDOCMN_LookupMaster = CacheUtility.GetAllLookupMasterCorrelationFromCache((long)LookupTypesCorrelation.DiscripancyCategoryVQueue, objDOADM_SkillsMaster.DiscrepancyCategoryLkup);
lstDOCMN_LookupMaster = lstDOCMN_LookupMaster.Where(x => x.CMN_LookupMasterParentRef == objDOADM_SkillsMaster.DiscrepancyCategoryLkup).ToList();
ViewBag.WorkQueues = lstDOCMN_LookupMaster;
Session[ConstantTexts.SkillWorkQueueSessionKey] = objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation;
objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation = objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation.Where(x => x.IsActive == true).ToList();
}
return(View(objDOADM_SkillsMaster));
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString());
return(RedirectToAction("Maintenance", "Error", routeValues: ex.ToString()));
}
}
public ActionResult Add(DOADM_SkillsMaster objDOADM_SkillsMaster)
{
string errorMessage = string.Empty;
string returnMessage = string.Empty;
ExceptionTypes result = new ExceptionTypes();
try
{
string sreturnMessage = string.Empty;
if (objDOADM_SkillsMaster.ADM_SkillsMasterId > 0)
{
BLCommon objCommon = new BLCommon();
if (!objCommon.ValidateLockBeforeSave(currentUser.ADM_UserMasterId, (long)ScreenType.Skills, objDOADM_SkillsMaster.ADM_SkillsMasterId))
{
errorMessage = "Record not locked, please reload the page.";
result = ExceptionTypes.UnknownError;
return(Json(new { ID = result, Message = errorMessage }));
}
objDOADM_SkillsMaster.LastUpdatedByRef = currentUser.ADM_UserMasterId;
sreturnMessage = "Record updated successfully.";
}
else
{
objDOADM_SkillsMaster.CreatedByRef = currentUser.ADM_UserMasterId;
sreturnMessage = "Record saved successfully.";
}
BLSkills _objBLSkills = new BLSkills();
if (Session[ConstantTexts.SkillWorkQueueSessionKey] != null)
{
objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation = Session[ConstantTexts.SkillWorkQueueSessionKey] as
List <DOADM_SkillWorkQueuesCorrelation>;
}
result = _objBLSkills.SaveSkills(objDOADM_SkillsMaster, currentUser.ADM_UserMasterId, out errorMessage);
if (result != (long)ExceptionTypes.Success)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage);
return(Json(new { ID = result, Message = "An error occured while updating DB." }));
}
Session[ConstantTexts.SkillWorkQueueSessionKey] = null;
return(Json(new { ID = result, Message = sreturnMessage }));
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString());
return(Json(new { ID = result, Message = "An error occured while updating DB." }));
}
}
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 static void GetAllSkillsIfNoCache()
{
long?TimeZone = (long)DefaultTimeZone.CentralStandardTime;
if (System.Web.HttpContext.Current.Cache[ConstantTexts.SkillCacheKey] == null)
{
BLSkills objBLSkills = new BLSkills();
List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>();
DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster();
objDOADM_SkillsMaster.IsActive = true;
string errorMessage;
ExceptionTypes skillResult = objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out errorMessage);
if (skillResult != ExceptionTypes.Success)
{
//Log
}
AddToCache(ConstantTexts.SkillCacheKey, lstDOADM_SkillsMaster);
}
}
public ActionResult Search(string SkillsName = "", long RoleLkup = 0, long BusinessSegmentLkup = 0, long CMN_DepartmentRef = 0, long WorkBasketLkup = 0, bool isActive = true)
{
try
{
BLSkills _objBLSkills = new BLSkills();
DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster();
List <DOADM_SkillsMaster> lstDOADM_SkillsMaster;
string errorMessage = string.Empty;
objDOADM_SkillsMaster.IsActive = isActive;
objDOADM_SkillsMaster.SkillsName = SkillsName;
objDOADM_SkillsMaster.RoleLkup = RoleLkup;
objDOADM_SkillsMaster.BusinessSegmentLkup = BusinessSegmentLkup;
objDOADM_SkillsMaster.CMN_DepartmentRef = CMN_DepartmentRef;
objDOADM_SkillsMaster.WorkBasketLkup = WorkBasketLkup;
long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
ExceptionTypes result = _objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out errorMessage);
if (result != (long)ExceptionTypes.Success)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, "error while retriving search results", "error while retriving search results");
}
else if (result == ExceptionTypes.ZeroRecords)
{
lstDOADM_SkillsMaster.Add(objDOADM_SkillsMaster);
lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>();
}
DOADM_SkillMasterExtended objDOADM_SkillMasterExtended = new DOADM_SkillMasterExtended();
objDOADM_SkillMasterExtended.lstRoles = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Role);
objDOADM_SkillMasterExtended.lstBusinessSegment = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.BusinessSegment);
objDOADM_SkillMasterExtended.lstDepartment = GetERSDepartments();
objDOADM_SkillMasterExtended.lstWorkBasket = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.WorkBasket);
objDOADM_SkillMasterExtended.lstSkillsMaster = lstDOADM_SkillsMaster;
return(PartialView("_SearchResults", objDOADM_SkillMasterExtended));
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString());
return(RedirectToAction("Maintenance", "Error", routeValues: ex.ToString()));
}
}
public ActionResult CheckSkillExistsUsingSkillName(string skillsName)
{
long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
string strErrorMessage = string.Empty;
string strMessage = string.Empty;
bool skillExists = false;
try
{
BLSkills _objBLSkills = new BLSkills();
DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster();
objDOADM_SkillsMaster.SkillsName = skillsName;
objDOADM_SkillsMaster.IsActive = true;
List <DOADM_SkillsMaster> lstDOADM_SkillsMaster;
ExceptionTypes result = _objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out strErrorMessage);
if (lstDOADM_SkillsMaster.Count > 0)
{
skillExists = true;
}
else
{
objDOADM_SkillsMaster.IsActive = false;//search again to check for not active records
result = _objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out strErrorMessage);
if (lstDOADM_SkillsMaster.Count > 0)
{
skillExists = true;
}
else
{
skillExists = false;
}
}
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (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 { skillExists = skillExists, strMessage = strMessage }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetSkillsBasedOnRoleAndWB(long lWorkBasketLkup, long lRoleLkup)
{
long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
string errorMessage = string.Empty;
try
{
DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster();
List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>();
BLSkills objBLSkills = new BLSkills();
objDOADM_SkillsMaster.WorkBasketLkup = lWorkBasketLkup;
objDOADM_SkillsMaster.RoleLkup = lRoleLkup;
objDOADM_SkillsMaster.IsActive = true;
objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out errorMessage);
return(Json(lstDOADM_SkillsMaster));
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString());
return(RedirectToAction("Maintenance", "Error", routeValues: ex.ToString()));
}
}
public ActionResult AddSkillsToSession(DOADM_AccessGroupSkillsCorrelation objDOADM_AccessGroupSkillsCorrelation, long lPreviousSkill = 0, long lWorkBasketLkup = 0, long lRoleLkup = 0, int mode = 0)
{
long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
List <DOADM_AccessGroupSkillsCorrelation> lstDOADM_AccessGroupSkillsCorrelation = new List <DOADM_AccessGroupSkillsCorrelation>();
try
{
DOADM_AccessGroupSkillsCorrelation objOldDOADM_AccessGroupSkillsCorrelation = new DOADM_AccessGroupSkillsCorrelation();
if (Session[ConstantTexts.AccessGroupSkillSessionKey] != null)
{
lstDOADM_AccessGroupSkillsCorrelation = Session[ConstantTexts.AccessGroupSkillSessionKey] as List <DOADM_AccessGroupSkillsCorrelation>;
}
switch (mode)
{
case 0: //Add new skill to the list
if (lstDOADM_AccessGroupSkillsCorrelation.Where(xx => xx.ADM_SkillsMasterRef == objDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef).Count() == 0)
{
objDOADM_AccessGroupSkillsCorrelation.IsActive = true;
objDOADM_AccessGroupSkillsCorrelation.CreatedByRef = currentUser.ADM_UserMasterId;
objDOADM_AccessGroupSkillsCorrelation.CreatedByName = currentUser.FullName;
objDOADM_AccessGroupSkillsCorrelation.UTCCreatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone);
objDOADM_AccessGroupSkillsCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId;
objDOADM_AccessGroupSkillsCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone);
objDOADM_AccessGroupSkillsCorrelation.LastUpdatedByName = currentUser.FullName;
lstDOADM_AccessGroupSkillsCorrelation.Add(objDOADM_AccessGroupSkillsCorrelation);
}
else
{
objOldDOADM_AccessGroupSkillsCorrelation = lstDOADM_AccessGroupSkillsCorrelation.Where(xx => xx.ADM_SkillsMasterRef == objDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef).FirstOrDefault();
objOldDOADM_AccessGroupSkillsCorrelation.CanCreate = objDOADM_AccessGroupSkillsCorrelation.CanCreate;
objOldDOADM_AccessGroupSkillsCorrelation.CanClone = objDOADM_AccessGroupSkillsCorrelation.CanClone;
objOldDOADM_AccessGroupSkillsCorrelation.CanHistory = objDOADM_AccessGroupSkillsCorrelation.CanHistory;
objOldDOADM_AccessGroupSkillsCorrelation.CanMassUpdate = objDOADM_AccessGroupSkillsCorrelation.CanMassUpdate;
objOldDOADM_AccessGroupSkillsCorrelation.CanModify = objDOADM_AccessGroupSkillsCorrelation.CanModify;
objOldDOADM_AccessGroupSkillsCorrelation.CanReassign = objDOADM_AccessGroupSkillsCorrelation.CanReassign;
objOldDOADM_AccessGroupSkillsCorrelation.CanReopen = objDOADM_AccessGroupSkillsCorrelation.CanReopen;
objOldDOADM_AccessGroupSkillsCorrelation.CanSearch = objDOADM_AccessGroupSkillsCorrelation.CanSearch;
objOldDOADM_AccessGroupSkillsCorrelation.CanUnlock = objDOADM_AccessGroupSkillsCorrelation.CanUnlock;
objOldDOADM_AccessGroupSkillsCorrelation.CanUpload = objDOADM_AccessGroupSkillsCorrelation.CanUpload;
objOldDOADM_AccessGroupSkillsCorrelation.CanView = objDOADM_AccessGroupSkillsCorrelation.CanView;
objOldDOADM_AccessGroupSkillsCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId;
objOldDOADM_AccessGroupSkillsCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone);
objDOADM_AccessGroupSkillsCorrelation.LastUpdatedByName = currentUser.FullName;
objOldDOADM_AccessGroupSkillsCorrelation.IsActive = true;
}
break;
case 1: //delete skill from added list
if (lstDOADM_AccessGroupSkillsCorrelation.Where(xx => xx.ADM_SkillsMasterRef == objDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef).Count() > 0)
{
objDOADM_AccessGroupSkillsCorrelation = lstDOADM_AccessGroupSkillsCorrelation.Where(xx => xx.ADM_SkillsMasterRef == objDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef).FirstOrDefault();
objDOADM_AccessGroupSkillsCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId;
objDOADM_AccessGroupSkillsCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone);
objDOADM_AccessGroupSkillsCorrelation.IsActive = false;
}
break;
case 2: //update existing skill
objOldDOADM_AccessGroupSkillsCorrelation = lstDOADM_AccessGroupSkillsCorrelation.Where(x => x.ADM_SkillsMasterRef == lPreviousSkill).FirstOrDefault();
if (objOldDOADM_AccessGroupSkillsCorrelation.ADM_AccessGroupSkillsCorrelationId == 0) //updating a queue for new record
{
objOldDOADM_AccessGroupSkillsCorrelation.CreatedByRef = currentUser.ADM_UserMasterId;
}
objOldDOADM_AccessGroupSkillsCorrelation.CanCreate = objDOADM_AccessGroupSkillsCorrelation.CanCreate;
objOldDOADM_AccessGroupSkillsCorrelation.CanClone = objDOADM_AccessGroupSkillsCorrelation.CanClone;
objOldDOADM_AccessGroupSkillsCorrelation.CanHistory = objDOADM_AccessGroupSkillsCorrelation.CanHistory;
objOldDOADM_AccessGroupSkillsCorrelation.CanMassUpdate = objDOADM_AccessGroupSkillsCorrelation.CanMassUpdate;
objOldDOADM_AccessGroupSkillsCorrelation.CanModify = objDOADM_AccessGroupSkillsCorrelation.CanModify;
objOldDOADM_AccessGroupSkillsCorrelation.CanReassign = objDOADM_AccessGroupSkillsCorrelation.CanReassign;
objOldDOADM_AccessGroupSkillsCorrelation.CanReopen = objDOADM_AccessGroupSkillsCorrelation.CanReopen;
objOldDOADM_AccessGroupSkillsCorrelation.CanSearch = objDOADM_AccessGroupSkillsCorrelation.CanSearch;
objOldDOADM_AccessGroupSkillsCorrelation.CanUnlock = objDOADM_AccessGroupSkillsCorrelation.CanUnlock;
objOldDOADM_AccessGroupSkillsCorrelation.CanUpload = objDOADM_AccessGroupSkillsCorrelation.CanUpload;
objOldDOADM_AccessGroupSkillsCorrelation.CanView = objDOADM_AccessGroupSkillsCorrelation.CanView;
objOldDOADM_AccessGroupSkillsCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId;
objOldDOADM_AccessGroupSkillsCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone);
objOldDOADM_AccessGroupSkillsCorrelation.LastUpdatedByName = currentUser.FullName;
objOldDOADM_AccessGroupSkillsCorrelation.IsActive = true;
objOldDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef = objDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef;
break;
case 3: //removing all the lists from Session
foreach (var item in lstDOADM_AccessGroupSkillsCorrelation)
{
item.LastUpdatedByRef = currentUser.ADM_UserMasterId;
item.UTCLastUpdatedOn = DateTime.UtcNow;
item.IsActive = false;
}
break;
}
DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster();
List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>();
BLSkills objBLSkills = new BLSkills();
objDOADM_SkillsMaster.WorkBasketLkup = lWorkBasketLkup;
objDOADM_SkillsMaster.RoleLkup = lRoleLkup;
objDOADM_SkillsMaster.IsActive = true;
objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out string errorMessage);
ViewBag.Skills = lstDOADM_SkillsMaster;
Session[ConstantTexts.AccessGroupSkillSessionKey] = lstDOADM_AccessGroupSkillsCorrelation;
return(PartialView("_Skills", lstDOADM_AccessGroupSkillsCorrelation.Where(xx => xx.IsActive == true).ToList()));
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString());
return(RedirectToAction("Maintenance", "Error", routeValues: ex.ToString()));
}
}
private void MapSkillsDOSkillsMaster(long?TimeZone, DataSet objDataTable, out List <DOADM_SkillsMaster> lstDOADM_SkillsDetails)
{
lstDOADM_SkillsDetails = new List <DOADM_SkillsMaster>();
try
{
foreach (DataRow dr in objDataTable.Tables[0].Rows)
{
DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster();
if (dr.Table.Columns.Contains("ADM_SkillsMasterId"))
{
if (!DBNull.Value.Equals(dr["ADM_SkillsMasterId"]))
{
objDOADM_SkillsMaster.ADM_SkillsMasterId = (long)dr["ADM_SkillsMasterId"];
}
}
if (dr.Table.Columns.Contains("SkillsName"))
{
if (!DBNull.Value.Equals(dr["SkillsName"]))
{
objDOADM_SkillsMaster.SkillsName = dr["SkillsName"].ToString();
}
}
if (dr.Table.Columns.Contains("RoleLkup"))
{
if (!DBNull.Value.Equals(dr["RoleLkup"]))
{
objDOADM_SkillsMaster.RoleLkup = (long)dr["RoleLkup"];
}
}
if (dr.Table.Columns.Contains("BusinessSegmentLkup"))
{
if (!DBNull.Value.Equals(dr["BusinessSegmentLkup"]))
{
objDOADM_SkillsMaster.BusinessSegmentLkup = (long)dr["BusinessSegmentLkup"];
}
}
if (dr.Table.Columns.Contains("DiscrepancyCategoryLkup"))
{
if (!DBNull.Value.Equals(dr["DiscrepancyCategoryLkup"]))
{
objDOADM_SkillsMaster.DiscrepancyCategoryLkup = (long)dr["DiscrepancyCategoryLkup"];
}
}
if (dr.Table.Columns.Contains("CMN_DepartmentRef"))
{
if (!DBNull.Value.Equals(dr["CMN_DepartmentRef"]))
{
objDOADM_SkillsMaster.CMN_DepartmentRef = (long)dr["CMN_DepartmentRef"];
}
}
if (dr.Table.Columns.Contains("WorkBasketLkup"))
{
if (!DBNull.Value.Equals(dr["WorkBasketLkup"]))
{
objDOADM_SkillsMaster.WorkBasketLkup = (long)dr["WorkBasketLkup"];
}
}
if (dr.Table.Columns.Contains("IsActive"))
{
if (!DBNull.Value.Equals(dr["IsActive"]))
{
objDOADM_SkillsMaster.IsActive = Convert.ToBoolean(dr["IsActive"]);
}
}
if (dr.Table.Columns.Contains("UTCCreatedOn"))
{
if (!DBNull.Value.Equals(dr["UTCCreatedOn"]))
{
objDOADM_SkillsMaster.UTCCreatedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCCreatedOn"].ToDateTime(), TimeZone);
}
}
if (dr.Table.Columns.Contains("CreatedByRef"))
{
if (!DBNull.Value.Equals(dr["CreatedByRef"]))
{
objDOADM_SkillsMaster.CreatedByRef = (long)dr["CreatedByRef"];
}
}
if (dr.Table.Columns.Contains("UTCLastUpdatedOn"))
{
if (!DBNull.Value.Equals(dr["UTCLastUpdatedOn"]))
{
objDOADM_SkillsMaster.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCLastUpdatedOn"].ToDateTime(), TimeZone);
}
}
if (dr.Table.Columns.Contains("LastUpdatedByRef"))
{
if (!DBNull.Value.Equals(dr["LastUpdatedByRef"]))
{
objDOADM_SkillsMaster.LastUpdatedByRef = (long)dr["LastUpdatedByRef"];
}
}
if (dr.Table.Columns.Contains("CreatedByName"))
{
if (!DBNull.Value.Equals(dr["CreatedByName"]))
{
objDOADM_SkillsMaster.CreatedByName = dr["CreatedByName"].ToString();
}
}
if (dr.Table.Columns.Contains("RoleValue"))
{
if (!DBNull.Value.Equals(dr["RoleValue"]))
{
objDOADM_SkillsMaster.RoleValue = dr["RoleValue"].ToString();
}
}
if (dr.Table.Columns.Contains("BusinessSegmentValue"))
{
if (!DBNull.Value.Equals(dr["BusinessSegmentValue"]))
{
objDOADM_SkillsMaster.BusinessSegmentValue = dr["BusinessSegmentValue"].ToString();
}
}
if (dr.Table.Columns.Contains("WorkBasketValue"))
{
if (!DBNull.Value.Equals(dr["WorkBasketValue"]))
{
objDOADM_SkillsMaster.WorkBasketValue = dr["WorkBasketValue"].ToString();
}
}
if (dr.Table.Columns.Contains("DepartmentName"))
{
if (!DBNull.Value.Equals(dr["DepartmentName"]))
{
objDOADM_SkillsMaster.DepartmentName = dr["DepartmentName"].ToString();
}
}
if (dr.Table.Columns.Contains("LastUpdatedByName"))
{
if (!DBNull.Value.Equals(dr["LastUpdatedByName"]))
{
objDOADM_SkillsMaster.LastUpdatedByName = dr["LastUpdatedByName"].ToString();
}
}
if (dr.Table.Columns.Contains("LockedByRef"))
{
if (!DBNull.Value.Equals(dr["LockedByRef"]))
{
objDOADM_SkillsMaster.LockedByRef = Convert.ToInt64(dr["LockedByRef"].ToString());
}
}
if (dr.Table.Columns.Contains("LockedByName"))
{
if (!DBNull.Value.Equals(dr["LockedByName"]))
{
objDOADM_SkillsMaster.LockedByName = dr["LockedByName"].ToString();
}
}
if (dr.Table.Columns.Contains("UTCLockedOn"))
{
if (!DBNull.Value.Equals(dr["UTCLockedOn"]))
{
objDOADM_SkillsMaster.UTCLockedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCLockedOn"].ToDateTime(), TimeZone);
}
}
objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation = new List <DOADM_SkillWorkQueuesCorrelation>();
if (objDataTable.Tables[1].Rows.Count > 0)
{
foreach (DataRow sklwrkQ in objDataTable.Tables[1].Rows)
{
DOADM_SkillWorkQueuesCorrelation objDOADM_SkillWorkQueuesCorrelation = new DOADM_SkillWorkQueuesCorrelation();
if (sklwrkQ.Table.Columns.Contains("ADM_SkillWorkQueuesCorrelationId"))
{
if (!DBNull.Value.Equals(sklwrkQ["ADM_SkillWorkQueuesCorrelationId"]))
{
objDOADM_SkillWorkQueuesCorrelation.ADM_SkillWorkQueuesCorrelationId = (long)sklwrkQ["ADM_SkillWorkQueuesCorrelationId"];
}
}
if (sklwrkQ.Table.Columns.Contains("ADM_SkillsMasterRef"))
{
if (!DBNull.Value.Equals(sklwrkQ["ADM_SkillsMasterRef"]))
{
objDOADM_SkillWorkQueuesCorrelation.ADM_SkillsMasterRef = (long)sklwrkQ["ADM_SkillsMasterRef"];
}
}
if (sklwrkQ.Table.Columns.Contains("WorkQueuesLkup"))
{
if (!DBNull.Value.Equals(sklwrkQ["WorkQueuesLkup"]))
{
objDOADM_SkillWorkQueuesCorrelation.WorkQueuesLkup = (long)sklwrkQ["WorkQueuesLkup"];
}
}
if (sklwrkQ.Table.Columns.Contains("LastUpdatedByRef"))
{
if (!DBNull.Value.Equals(sklwrkQ["LastUpdatedByRef"]))
{
objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByRef = (long)sklwrkQ["LastUpdatedByRef"];
}
}
if (sklwrkQ.Table.Columns.Contains("LastUpdatedByName"))
{
if (!DBNull.Value.Equals(sklwrkQ["LastUpdatedByName"]))
{
objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByName = sklwrkQ["LastUpdatedByName"].ToString();
}
}
if (sklwrkQ.Table.Columns.Contains("CreatedByName"))
{
if (!DBNull.Value.Equals(sklwrkQ["CreatedByName"]))
{
objDOADM_SkillWorkQueuesCorrelation.CreatedByName = sklwrkQ["CreatedByName"].ToString();
}
}
if (dr.Table.Columns.Contains("UTCCreatedOn"))
{
if (!DBNull.Value.Equals(dr["UTCCreatedOn"]))
{
objDOADM_SkillWorkQueuesCorrelation.UTCCreatedOn = ZoneLookupUI.ConvertToTimeZone(sklwrkQ["UTCCreatedOn"].ToDateTime(), TimeZone);
}
}
if (dr.Table.Columns.Contains("UTCLastUpdatedOn"))
{
if (!DBNull.Value.Equals(dr["UTCLastUpdatedOn"]))
{
objDOADM_SkillWorkQueuesCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(sklwrkQ["UTCLastUpdatedOn"].ToDateTime(), TimeZone);
}
}
//if (sklwrkQ.Table.Columns.Contains("DiscrepancyCategoryLkup"))
//{
// if (!DBNull.Value.Equals(sklwrkQ["DiscrepancyCategoryLkup"]))
// {
// objDOADM_SkillWorkQueuesCorrelation.DiscrepancyCategoryLkup = (long)sklwrkQ["DiscrepancyCategoryLkup"];
// }
//}
if (sklwrkQ.Table.Columns.Contains("IsActive"))
{
if (!DBNull.Value.Equals(sklwrkQ["IsActive"]))
{
objDOADM_SkillWorkQueuesCorrelation.IsActive = (bool)sklwrkQ["IsActive"];
}
}
objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation.Add(objDOADM_SkillWorkQueuesCorrelation);
}
}
lstDOADM_SkillsDetails.Add(objDOADM_SkillsMaster);
}
}
catch
{
}
}
public ExceptionTypes SearchSkills(long?TimeZone, DOADM_SkillsMaster objDOADM_SkillsDetails, out List <DOADM_SkillsMaster> lstDOADM_SkillsDetails, out string errorMessage)
{
lstDOADM_SkillsDetails = new List <DOADM_SkillsMaster>();
objDOADM_SkillsDetails.lstDOADM_SkillWorkQueuesCorrelation = new List <DOADM_SkillWorkQueuesCorrelation>();
errorMessage = string.Empty;
try
{
DAHelper dah = new DAHelper();
long lErrocode = 0;
long lErrorNumber = 0;
DataSet dsResultData = new DataSet();
List <SqlParameter> parameters = new List <SqlParameter>();
SqlParameter sqlParam;
if (objDOADM_SkillsDetails.ADM_SkillsMasterId != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ADM_SkillsMasterId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOADM_SkillsDetails.ADM_SkillsMasterId;
parameters.Add(sqlParam);
}
if (!string.IsNullOrEmpty(objDOADM_SkillsDetails.SkillsName))
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@SkillsName";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.SkillsName;
parameters.Add(sqlParam);
}
if (objDOADM_SkillsDetails.RoleLkup != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@RoleLkup";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.RoleLkup;
parameters.Add(sqlParam);
}
if (objDOADM_SkillsDetails.BusinessSegmentLkup != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@BusinessSegmentLkup";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.BusinessSegmentLkup;
parameters.Add(sqlParam);
}
if (objDOADM_SkillsDetails.DiscrepancyCategoryLkup != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@DiscrepancyCategoryLkup";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.DiscrepancyCategoryLkup;
parameters.Add(sqlParam);
}
if (objDOADM_SkillsDetails.CMN_DepartmentRef != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_DepartmentRef";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.CMN_DepartmentRef;
parameters.Add(sqlParam);
}
if (objDOADM_SkillsDetails.WorkBasketLkup != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@WorkBasketLkup";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.WorkBasketLkup;
parameters.Add(sqlParam);
}
//Uncomment after User search SP modofication
//No Null check, IsActive key boolean key by defaut will be false and cannot be null
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@IsActive";
sqlParam.SqlDbType = SqlDbType.Bit;
sqlParam.Value = objDOADM_SkillsDetails.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_Skills, parameters.ToArray(), out dsResultData, out lErrocode, out lErrorNumber, out errorMessage);
if (executionResult == 0)
{
if (dsResultData.Tables.Count > 0 && dsResultData.Tables[0].Rows.Count > 0)
{
MapSkillsDOSkillsMaster(TimeZone, dsResultData, out lstDOADM_SkillsDetails);
return(ExceptionTypes.Success);
}
else
{
return(ExceptionTypes.ZeroRecords);
}
}
else
{
return(ExceptionTypes.UnknownError);
}
}
catch (Exception ex)
{
errorMessage = ex.Message;
return(ExceptionTypes.UnknownError);
}
}
public ExceptionTypes AddSkills(DOADM_SkillsMaster objDOADM_SkillsDetails, long lLoginId, out string errorMessage)
{
errorMessage = string.Empty;
try
{
DAHelper dah = new DAHelper();
List <SqlParameter> parameters = new List <SqlParameter>();
long lErrorCode = 0;
long lErrorNumber = 0;
DataSet dsResultData = new DataSet();
SqlParameter sqlParam;
if (objDOADM_SkillsDetails.ADM_SkillsMasterId != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ADM_SkillsMasterId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOADM_SkillsDetails.ADM_SkillsMasterId;
parameters.Add(sqlParam);
}
if (!string.IsNullOrEmpty(objDOADM_SkillsDetails.SkillsName))
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@SkillsName";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.SkillsName;
parameters.Add(sqlParam);
}
if (objDOADM_SkillsDetails.RoleLkup != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@RoleLkup";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.RoleLkup;
parameters.Add(sqlParam);
}
if (objDOADM_SkillsDetails.BusinessSegmentLkup != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@BusinessSegmentLkup";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.BusinessSegmentLkup;
parameters.Add(sqlParam);
}
if (objDOADM_SkillsDetails.DiscrepancyCategoryLkup != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@DiscrepancyCategoryLkup";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.DiscrepancyCategoryLkup;
parameters.Add(sqlParam);
}
if (objDOADM_SkillsDetails.CMN_DepartmentRef != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_DepartmentRef";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.CMN_DepartmentRef;
parameters.Add(sqlParam);
}
if (objDOADM_SkillsDetails.WorkBasketLkup != 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@WorkBasketLkup";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOADM_SkillsDetails.WorkBasketLkup;
parameters.Add(sqlParam);
}
if (!string.IsNullOrEmpty(objDOADM_SkillsDetails.IsActive.ToString()))
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@IsActive";
sqlParam.SqlDbType = SqlDbType.Bit;
sqlParam.Value = objDOADM_SkillsDetails.IsActive;
parameters.Add(sqlParam);
}
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@LoginUserId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = lLoginId;
parameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ScreenLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = ScreenType.Skills;
parameters.Add(sqlParam);
if (objDOADM_SkillsDetails.lstDOADM_SkillWorkQueuesCorrelation.Count() > 0)
{
DataTable skillsWorkQueue;
SetSkillsWorkQueue(objDOADM_SkillsDetails.lstDOADM_SkillWorkQueuesCorrelation, out skillsWorkQueue);
DataTableReader dtrSkillWorkQueues = new DataTableReader(skillsWorkQueue);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@TV_Queues";
sqlParam.SqlDbType = SqlDbType.Structured;
sqlParam.Value = dtrSkillWorkQueues;
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_Skills, parameters.ToArray(), out lErrorCode, out lErrorCode, out lErrorNumber, 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)
{
errorMessage = ex.Message;
return(ExceptionTypes.UnknownError);
}
}
