public JsonResult CheckDuplicateDep(long BusinessSegment, long DepName) { long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; var data = ""; BLDepartment objBLDepartment = new BLDepartment(); List <DOCMN_Department> lstDOCMN_Department; DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.BusinessSegmentLkup = BusinessSegment; objDOCMN_Department.DepartmentLkup = DepName; string errorMessage = string.Empty; ExceptionTypes result = objBLDepartment.CheckDuplicateDep(TimeZone, objDOCMN_Department, out lstDOCMN_Department, out errorMessage); if (result != (long)ExceptionTypes.Success) { //Log error BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, errorMessage.ToString(), errorMessage.ToString()); } else if (result == ExceptionTypes.ZeroRecords) { lstDOCMN_Department.Add(objDOCMN_Department); lstDOCMN_Department = new List <DOCMN_Department>(); } int i = lstDOCMN_Department.Count; if (i > 0) { data = "Department Name already exists."; } return(Json(new { Data = data }, JsonRequestBehavior.AllowGet)); }
protected void InitialDropdown() { try { DataSet ds = new DataSet(); BLDepartment blDepartment = new BLDepartment(); BLStatus blStatus = new BLStatus(); ds = blDepartment.GetDepartment(""); ddlDepartment.DataSource = ds; ddlDepartment.DataValueField = "DEPT_ID"; ddlDepartment.DataTextField = "DEPT_NAME"; ddlDepartment.DataBind(); ds = blStatus.GetStatus(""); ddlStatus.DataSource = ds; ddlStatus.DataValueField = "STATUS_ID"; ddlStatus.DataTextField = "STATUS_NAME"; ddlStatus.DataBind(); ddlStatus.Items.Insert(0, new ListItem("ALL", "")); ddlDepartment.SelectedValue = hdDepartment.Value; } catch (Exception ex) { throw ex; } }
public ActionResult Add(long ResourceId = 0, bool isActive = true) { long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; DOADM_ResourceDetails objDOADM_ResourceDetails = new DOADM_ResourceDetails(); objDOADM_ResourceDetails.IsActive = true; string errorMessage = string.Empty; try { ExceptionTypes result; //get list of Depatments for Department drop down List <DOCMN_Department> lstCMN_Department; BLDepartment objBLDepartment = new BLDepartment(); DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.IsActive = true; result = objBLDepartment.SearchDepartment(TimeZone, objDOCMN_Department, out lstCMN_Department, out errorMessage); //check result for DB action if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Resources, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } //sort list by Depatment name lstCMN_Department = lstCMN_Department.OrderBy(x => x.ERSDepartmentName).ToList(); if (ResourceId != 0) { //temporary list to hold search Resource results List <DOADM_ResourceDetails> lstDOADM_ResourceDetails = new List <DOADM_ResourceDetails>(); //temporary object for search resources function DOADM_ResourceDetails objDOADM_ResourceDetails_Find = new DOADM_ResourceDetails(); objDOADM_ResourceDetails_Find.ADM_ResourceDetailsId = ResourceId; objDOADM_ResourceDetails_Find.IsActive = isActive; result = _objBLResources.SearchResources(TimeZone, objDOADM_ResourceDetails_Find, out lstDOADM_ResourceDetails, out errorMessage); //check result for DB action if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Resources, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } if (lstDOADM_ResourceDetails.Count > 0) { objDOADM_ResourceDetails = lstDOADM_ResourceDetails.FirstOrDefault(); } } //Alert Time Zone lookup from Cache objDOADM_ResourceDetails.lstTimeZone = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Timezone); objDOADM_ResourceDetails.lstCMN_Department = lstCMN_Department; return(View(objDOADM_ResourceDetails)); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Resources, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(RedirectToAction("Maintenance", "Error", ex.ToString())); } }
public ActionResult Add(DOCMN_Department Department) { string errorMessage = string.Empty; string returnMessage = string.Empty; ExceptionTypes result = new ExceptionTypes(); try { long loginUserId = currentUser.ADM_UserMasterId; BLDepartment objBLDepartment = new BLDepartment(); DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.CMN_DepartmentId = Department.CMN_DepartmentId; if (objDOCMN_Department.CMN_DepartmentId > 0) // Edit Mode { BLCommon objCommon = new BLCommon(); if (!objCommon.ValidateLockBeforeSave(loginUserId, (long)ScreenType.Department, objDOCMN_Department.CMN_DepartmentId)) { errorMessage = "Record not locked, please reload the page."; result = ExceptionTypes.UnknownError; return(Json(new { ID = result, Message = errorMessage })); } objDOCMN_Department.CreatedByRef = loginUserId; returnMessage = "Record updated successfully."; } else { objDOCMN_Department.CreatedByRef = loginUserId; //Add Mode returnMessage = "Record saved successfully."; } objDOCMN_Department.ERSDepartmentName = Department.ERSDepartmentName; objDOCMN_Department.BusinessSegmentLkup = Department.BusinessSegmentLkup; objDOCMN_Department.DepartmentLkup = Department.DepartmentLkup; objDOCMN_Department.EffectiveDate = Department.EffectiveDate; objDOCMN_Department.InactivationDate = Department.InactivationDate; objDOCMN_Department.IsActive = Department.IsActive; objDOCMN_Department.UTCCreatedOn = Department.UTCCreatedOn; result = objBLDepartment.SaveDepartment(objDOCMN_Department, out errorMessage); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, errorMessage.ToString(), errorMessage.ToString()); return(Json(new { ID = result, Message = "An error occured while updating DB." })); } return(Json(new { ID = result, Message = returnMessage })); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(Json(new { ID = result, Message = "An error occured while performing Save action." })); } }
public List <DOCMN_Department> GetERSDepartments() { long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; string strErrorMessage = string.Empty; List <DOCMN_Department> lstCMN_Department = new List <DOCMN_Department>(); BLDepartment objBLDepartment = new BLDepartment(); DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.IsActive = true; ExceptionTypes result = objBLDepartment.SearchDepartment(TimeZone, objDOCMN_Department, out lstCMN_Department, out strErrorMessage); return(lstCMN_Department); }
public ActionResult Add(long DepId = 0, bool isActive = true) { long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; // Bind Dropdown List for Business Segment and Department. string errorMessage = string.Empty; List <DOCMN_LookupMaster> lstBusinessSegment; List <DOCMN_LookupMaster> lstDepartment; List <DOCMN_LookupMaster> lstTimezone; BLDepartment objBLDepartment = new BLDepartment(); List <DOCMN_Department> lstDOCMN_Department = new List <DOCMN_Department>(); DOCMN_Department objDOCMN_Department = new DOCMN_Department(); lstBusinessSegment = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.BusinessSegment); lstDepartment = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Department); lstTimezone = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Timezone); objDOCMN_Department.IsActive = true; if (DepId != 0) { // Fetch Record By Department ID. objDOCMN_Department.CMN_DepartmentId = DepId; objDOCMN_Department.IsActive = isActive; ExceptionTypes result = objBLDepartment.SearchDepartmentById(TimeZone, objDOCMN_Department, out lstDOCMN_Department, out errorMessage); if (result != (long)ExceptionTypes.Success) { //Log Error BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, errorMessage.ToString(), errorMessage.ToString()); } if (lstDOCMN_Department.Count > 0) { objDOCMN_Department = lstDOCMN_Department.FirstOrDefault(); } } else { objDOCMN_Department.EffectiveDate = DateTime.UtcNow; } objDOCMN_Department.lstBusinessSegment = lstBusinessSegment; objDOCMN_Department.lstCMN_Department = lstDepartment; objDOCMN_Department.lstTimeZone = lstTimezone; return(View("Add", objDOCMN_Department)); }
public static string GetDepartment(string condition) { DataSet ds = new DataSet(); BLDepartment blDepartment = new BLDepartment(); string result = ""; Utility utility = new Utility(); try { ds = blDepartment.GetDepartment(condition == "1" ? "DEPT_STATUS = 'T'" : ""); result = utility.DataTableToJSONWithJavaScriptSerializer(ds.Tables[0]); } catch (Exception ex) { //throw ex; } return(result); }
// Get Department In Search Page. private List <DOCMN_Department> PGetDepartment(string strDepName = "", bool isActive = true) { long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; BLDepartment objBLDepartment = new BLDepartment(); List <DOCMN_Department> lstDOCMN_Department; try { DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.ERSDepartmentName = strDepName; if (isActive) { objDOCMN_Department.IsActive = Convert.ToBoolean(isActive); } else { objDOCMN_Department.IsActive = false; } string errorMessage = string.Empty; ExceptionTypes result = objBLDepartment.SearchDepartment(TimeZone, objDOCMN_Department, out lstDOCMN_Department, out errorMessage); if (result != (long)ExceptionTypes.Success) { //Log error BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, errorMessage.ToString(), errorMessage.ToString()); } else if (result == ExceptionTypes.ZeroRecords) { lstDOCMN_Department.Add(objDOCMN_Department); lstDOCMN_Department = new List <DOCMN_Department>(); } return(lstDOCMN_Department); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); throw ex; } }
public ActionResult Add(long AlertId = 0, bool isActive = true) { DOADM_AlertDetails objDOADM_AlertDetails = new DOADM_AlertDetails(); objDOADM_AlertDetails.IsActive = true; string errorMessage = string.Empty; try { ExceptionTypes result; //get list of users for Send ALert to Indiviual drop down List <DOADM_UserMaster> lstUsers; BLUserAdministration objBLUserAdministration = new BLUserAdministration(); DOADM_UserMaster objDOADM_UserMaster = new DOADM_UserMaster(); objDOADM_UserMaster.IsActive = true; long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; result = objBLUserAdministration.SearchUser(TimeZone, objDOADM_UserMaster, out lstUsers, out errorMessage); //check result for DB action if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Alerts, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } //Filtered 1st three Users as Admin.sort list by email id lstUsers = lstUsers.Where(x => x.ADM_UserMasterId > 1000).OrderBy(x => x.Email).ToList(); //get list of Depatments for Send ALert to Department drop down List <DOCMN_Department> lstCMN_Department; BLDepartment objBLDepartment = new BLDepartment(); DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.IsActive = true; result = objBLDepartment.SearchDepartment(TimeZone, objDOCMN_Department, out lstCMN_Department, out errorMessage); //check result for DB action if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Alerts, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } //sort list by Depatment name lstCMN_Department = lstCMN_Department.OrderBy(x => x.ERSDepartmentName).ToList(); if (AlertId != 0) { //temporary list to hold search alerts results List <DOADM_AlertDetails> lstDOADM_AlertDetails = new List <DOADM_AlertDetails>(); //temporary object for search alerts function DOADM_AlertDetails objDOADM_AlertDetails_Find = new DOADM_AlertDetails(); objDOADM_AlertDetails_Find.ADM_AlertDetailsId = AlertId; objDOADM_AlertDetails_Find.IsActive = isActive; result = _objBLAlerts.SearchAlerts(TimeZone, objDOADM_AlertDetails_Find, out lstDOADM_AlertDetails, out errorMessage); //check result for DB action if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Alerts, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } if (lstDOADM_AlertDetails.Count > 0) { objDOADM_AlertDetails = lstDOADM_AlertDetails.FirstOrDefault(); } } objDOADM_AlertDetails.lstUsers = lstUsers; objDOADM_AlertDetails.lstCMN_Department = lstCMN_Department; //Alert criticality lookup from Cache objDOADM_AlertDetails.lstAlertCriticalityLkup = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.AlertCriticality); //Send Alert To lookup from Cache objDOADM_AlertDetails.lstSendAlertToLkup = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.SendAlertTo); //Alert Time Zone lookup from Cache objDOADM_AlertDetails.lstTimeZone = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Timezone); return(View(objDOADM_AlertDetails)); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Alerts, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(RedirectToAction("Maintenance", "Error", new { Error = ex.ToString() })); } }