//Search Department by Department ID
public ExceptionTypes SearchDepartmentById(long?TimeZone, DOCMN_Department department, out List <DOCMN_Department> lstDOCMN_Department, out string errorMessage)
{
retValue = new ExceptionTypes();
DALDepartment objDALDepartment = new DALDepartment();
return(retValue = objDALDepartment.SearchDepartmentById(TimeZone, department, out lstDOCMN_Department, out errorMessage));
}
//Search Duplicate Department
public ExceptionTypes CheckDuplicateDep(long?TimeZone, DOCMN_Department objDOCMN_Department, out List <DOCMN_Department> lstDOCMN_Department, out string errorMessage)
{
retValue = new ExceptionTypes();
DALDepartment objDALDepartment = new DALDepartment();
return(retValue = objDALDepartment.CheckDuplicateDep(TimeZone, objDOCMN_Department, out lstDOCMN_Department, out errorMessage));
}
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));
}
public ExceptionTypes SaveDepartment(DOCMN_Department objDOCMN_Department, out string errorMessage)
{
retValue = new ExceptionTypes();
DALDepartment objDALDepartment = new DALDepartment();
return(retValue = objDALDepartment.SaveDepartment(objDOCMN_Department, out errorMessage));
}
//Search Department By Department ID
public ExceptionTypes SearchDepartmentById(long?TimeZone, DOCMN_Department department, out List <DOCMN_Department> lstDOCMN_Department, out string errorMessage)
{
lstDOCMN_Department = new List <DOCMN_Department>();
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;
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_DepartmentId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = department.CMN_DepartmentId;
parameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@IsActive";
sqlParam.SqlDbType = SqlDbType.Bit;
sqlParam.Value = department.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_Department, parameters.ToArray(), out dsResultData, out lErrocode, out lErrorNumber, out errorMessage);
if (executionResult == 0)
{
if (dsResultData.Tables.Count > 0 && dsResultData.Tables[0].Rows.Count > 0)
{
MapDepartmentDetails(TimeZone, dsResultData.Tables[0], out lstDOCMN_Department);
return(ExceptionTypes.Success);
}
else
{
return(ExceptionTypes.ZeroRecords);
}
}
else
{
return(ExceptionTypes.UnknownError);
}
}
catch (Exception ex)
{
errorMessage = ex.Message;
return(ExceptionTypes.UnknownError);
}
}
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));
}
// 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;
}
}
//save Department Master
public ExceptionTypes SaveDepartment(DOCMN_Department objDOCMN_Department, out string errorMessage)
{
try
{
DAHelper dah = new DAHelper();
long lErrocode = 0;
long lErrorNumber = 0;
long lRowsEffected = 0;
DataSet dsTable = new DataSet();
errorMessage = string.Empty;
List <SqlParameter> parameters = new List <SqlParameter>();
SqlParameter sqlParam;
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_DepartmentId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOCMN_Department.CMN_DepartmentId;
parameters.Add(sqlParam);
if (!string.IsNullOrEmpty(objDOCMN_Department.ERSDepartmentName))
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ERSDepartmentName";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOCMN_Department.ERSDepartmentName;
parameters.Add(sqlParam);
}
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@BusinessSegmentLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOCMN_Department.BusinessSegmentLkup;
parameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@DepartmentLkup";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOCMN_Department.DepartmentLkup;
parameters.Add(sqlParam);
if (objDOCMN_Department.EffectiveDate != null)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@EffectiveDate";
sqlParam.SqlDbType = SqlDbType.DateTime;
sqlParam.Value = objDOCMN_Department.EffectiveDate;
parameters.Add(sqlParam);
}
if (objDOCMN_Department.InactivationDate != null)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@InactivationDate";
sqlParam.SqlDbType = SqlDbType.DateTime;
sqlParam.Value = objDOCMN_Department.InactivationDate;
parameters.Add(sqlParam);
}
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@IsActive";
sqlParam.SqlDbType = SqlDbType.Bit;
sqlParam.Value = objDOCMN_Department.IsActive;
parameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@LoginUserId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOCMN_Department.CreatedByRef;
parameters.Add(sqlParam);
//Extra parameter when adding or editing record for releasing lock
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ScreenLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = (long)ScreenType.Department;
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 = 0;
//if (objDOADM_UserMaster.ADM_UserMasterId == 0)
//{
executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_APP_INS_UPD_Department, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage);
//}
//else
//{
// executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_APP_UPD_ADM_UserMaster, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage);
//}
if (executionResult == 0)
{
return(ExceptionTypes.Success);
}
else
{
return(ExceptionTypes.UnknownError);
}
}
catch (Exception ex)
{
errorMessage = ex.Message;
return(ExceptionTypes.UnknownError);
}
}
public void MapDepartmentDetails(long?TimeZone, DataTable objDataTable, out List <DOCMN_Department> lstDOCMN_Department)
{
lstDOCMN_Department = new List <DOCMN_Department>();
try
{
foreach (DataRow dr in objDataTable.Rows)
{
DOCMN_Department objDOCMN_Department = new DOCMN_Department();
if (dr.Table.Columns.Contains("CMN_DepartmentId"))
{
if (!DBNull.Value.Equals(dr["CMN_DepartmentId"]))
{
objDOCMN_Department.CMN_DepartmentId = Convert.ToInt32(dr["CMN_DepartmentId"]);
}
}
if (dr.Table.Columns.Contains("ERSDepartmentName"))
{
if (!DBNull.Value.Equals(dr["ERSDepartmentName"]))
{
objDOCMN_Department.ERSDepartmentName = dr["ERSDepartmentName"].ToString();
}
}
if (dr.Table.Columns.Contains("EffectiveDate"))
{
if (!DBNull.Value.Equals(dr["EffectiveDate"]))
{
objDOCMN_Department.EffectiveDate = Convert.ToDateTime(dr["EffectiveDate"]);
}
}
if (dr.Table.Columns.Contains("InactivationDate"))
{
if (!DBNull.Value.Equals(dr["InactivationDate"]))
{
objDOCMN_Department.InactivationDate = Convert.ToDateTime(dr["InactivationDate"]);
}
}
if (dr.Table.Columns.Contains("InactivationDate"))
{
if (!DBNull.Value.Equals(dr["InactivationDate"]))
{
objDOCMN_Department.InactivationDate = Convert.ToDateTime(dr["InactivationDate"]);
}
}
if (dr.Table.Columns.Contains("BusinessSegmentLkup"))
{
if (!DBNull.Value.Equals(dr["BusinessSegmentLkup"]))
{
objDOCMN_Department.BusinessSegmentLkup = (long)(dr["BusinessSegmentLkup"]);
}
}
if (dr.Table.Columns.Contains("DepartmentLkup"))
{
if (!DBNull.Value.Equals(dr["DepartmentLkup"]))
{
objDOCMN_Department.DepartmentLkup = (long)(dr["DepartmentLkup"]);
}
}
if (dr.Table.Columns.Contains("IsActive"))
{
if (!DBNull.Value.Equals(dr["IsActive"]))
{
if (dr["IsActive"].ToString() == "True")
{
objDOCMN_Department.IsActive = true;
}
if (dr["IsActive"].ToString() == "False")
{
objDOCMN_Department.IsActive = false;
}
}
}
if (dr.Table.Columns.Contains("LockedByRef"))
{
if (!DBNull.Value.Equals(dr["LockedByRef"]))
{
objDOCMN_Department.LockedByRef = (long)(dr["LockedByRef"]);
}
}
if (dr.Table.Columns.Contains("UTCCreatedOn"))
{
if (!DBNull.Value.Equals(dr["UTCCreatedOn"]))
{
objDOCMN_Department.UTCCreatedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCCreatedOn"].ToDateTime(), TimeZone);
}
}
if (dr.Table.Columns.Contains("CreatedByName"))
{
if (!DBNull.Value.Equals(dr["CreatedByName"]))
{
objDOCMN_Department.CreatedByName = Convert.ToString(dr["CreatedByName"]);
}
}
if (dr.Table.Columns.Contains("UTCLastUpdatedOn"))
{
if (!DBNull.Value.Equals(dr["UTCLastUpdatedOn"]))
{
objDOCMN_Department.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCLastUpdatedOn"].ToDateTime(), TimeZone);
}
}
if (dr.Table.Columns.Contains("LastUpdatedByName"))
{
if (!DBNull.Value.Equals(dr["LastUpdatedByName"]))
{
objDOCMN_Department.LastUpdatedByName = Convert.ToString(dr["LastUpdatedByName"]);
}
}
if (dr.Table.Columns.Contains("LockedByName"))
{
if (!DBNull.Value.Equals(dr["LockedByName"]))
{
objDOCMN_Department.LockedByName = Convert.ToString(dr["LockedByName"]);
}
}
if (dr.Table.Columns.Contains("UTCLockedOn"))
{
if (!DBNull.Value.Equals(dr["UTCLockedOn"]))
{
objDOCMN_Department.UTCLockedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCLockedOn"].ToDateTime(), TimeZone);
}
}
lstDOCMN_Department.Add(objDOCMN_Department);
}
}
catch
{
}
}
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() }));
}
}
