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() }));
}
}
