/// <summary>
/// For Lookup Screen (To get Lookpu type & related lookup Master)
/// </summary>
/// <param name="dsResult"></param>
/// <param name="objDOCMN_LookupType"></param>
/// <returns></returns>
private ExceptionTypes MapLookupMaster(DataSet dsResult, out DOCMN_LookupType objDOCMN_LookupType)
{
objDOCMN_LookupType = new DOCMN_LookupType();
try
{
if (dsResult != null && dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
DataRow dr = dsResult.Tables[0].Rows[0];
objDOCMN_LookupType.CMN_LookupTypeId = dr["CMN_LookupTypeId"].ToInt64();
objDOCMN_LookupType.LockedByRef = (!dr["LockedByRef"].IsNull()) ? dr["LockedByRef"].ToInt64() : 0;
objDOCMN_LookupType.UTCLockedOn = (!dr["UTCLockedOn"].IsNull()) ? Convert.ToDateTime(dr["UTCLockedOn"]) : (DateTime?)null;
objDOCMN_LookupType.LookupTypeDescription = (!dr["LookupTypeDescription"].IsNull()) ? dr["LookupTypeDescription"].NullToString() : string.Empty;
objDOCMN_LookupType.UTCCreatedOn = (!dr["UTCCreatedOn"].IsNull()) ? Convert.ToDateTime(dr["UTCCreatedOn"]) : DateTime.UtcNow;
objDOCMN_LookupType.CreatedByRef = (!dr["CreatedByRef"].IsNull()) ? dr["CreatedByRef"].ToInt64() : 0;
objDOCMN_LookupType.UTCLastUpdatedOn = (!dr["UTCLastUpdatedOn"].IsNull()) ? Convert.ToDateTime(dr["UTCLastUpdatedOn"]) : DateTime.UtcNow;
objDOCMN_LookupType.LastUpdatedByRef = (!dr["LastUpdatedByRef"].IsNull()) ? dr["LastUpdatedByRef"].ToInt64() : 0;
objDOCMN_LookupType.LockedByName = (!dr["LockedByName"].IsNull()) ? dr["LockedByName"].NullToString() : string.Empty;
objDOCMN_LookupType.CreatedByName = (!dr["CreatedByName"].IsNull()) ?dr["CreatedByName"].NullToString() : string.Empty;
objDOCMN_LookupType.LastUpdatedByName = (!dr["LastUpdatedByName"].IsNull()) ? dr["LastUpdatedByName"].NullToString() : string.Empty;
objDOCMN_LookupType.IsActive = Convert.ToBoolean(dr["IsActive"]);
}
if (dsResult != null && dsResult.Tables.Count > 1 && dsResult.Tables[1].Rows.Count > 0)
{
objDOCMN_LookupType.lstDOCMN_LookupMaster = dsResult.Tables[1].AsEnumerable().Select(dr => new DOCMN_LookupMaster
{
CMN_LookupMasterId = Convert.ToInt64(dr["CMN_LookupMasterId"]),
CMN_LookupTypeRef = Convert.ToInt64(dr["CMN_LookupTypeRef"]),
LookupDescription = (!dr["LookupDescription"].IsNull()) ? dr["LookupDescription"].NullToString() : string.Empty,
LookupValue = (!dr["LookupValue"].IsNull()) ? dr["LookupValue"].NullToString() : string.Empty,
LookupValue1 = (!dr["LookupValue1"].IsNull()) ? dr["LookupValue1"].NullToString() : string.Empty,
LookupValue2 = (!dr["LookupValue2"].IsNull()) ? dr["LookupValue2"].NullToString() : string.Empty,
DisplayOrder = (!dr["DisplayOrder"].IsNull()) ? dr["DisplayOrder"].ToInt64() : (Int64?)null,
UTCCreatedOn = (!dr["UTCCreatedOn"].IsNull()) ? Convert.ToDateTime(dr["UTCCreatedOn"]) : DateTime.UtcNow,
CreatedByRef = (!dr["CreatedByRef"].IsNull()) ? dr["CreatedByRef"].ToInt64() : 0,
UTCLastUpdatedOn = (!dr["UTCLastUpdatedOn"].IsNull()) ? Convert.ToDateTime(dr["UTCLastUpdatedOn"]) : DateTime.UtcNow,
LastUpdatedByRef = (!dr["LastUpdatedByRef"].IsNull()) ? dr["LastUpdatedByRef"].ToInt64() : (Int64?)null,
CreatedByName = (!dr["CreatedByName"].IsNull()) ? dr["CreatedByName"].NullToString() : string.Empty,
LastUpdatedByName = (!dr["LastUpdatedByName"].IsNull()) ? dr["LastUpdatedByName"].NullToString() : string.Empty,
IsActive = dr["IsActive"].ToBoolean()
}).ToList();
}
return(ExceptionTypes.Success);
}
catch (Exception ex)
{
//need log
throw ex;
}
}
/// <summary>
/// GetLookupMasterByLkupTypeID
/// </summary>
/// <param name="lookupTypeId"></param>
/// <param name="lstDOCMN_LookupType"></param>
/// <returns></returns>
public ExceptionTypes GetLookupMasterByLkupTypeID(long?lookupTypeId, out DOCMN_LookupType objDOCMN_LookupType)
{
_dsResult = new DataSet();
_lstParameters = new List <SqlParameter>();
SqlParameter sqlParam;
long lErrocode = 0;
long lErrorNumber = 0;
string errorMessage = string.Empty;
objDOCMN_LookupType = new DOCMN_LookupType();
try
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_LookupTypeId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = lookupTypeId;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ErrorMessage";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = string.Empty;
sqlParam.Direction = ParameterDirection.Output;
sqlParam.Size = 2000;
_lstParameters.Add(sqlParam);
long executionResult = _daHelper.ExecuteSelectSP(ConstantTexts.SP_APP_SEL_Lookups, _lstParameters.ToArray(), out _dsResult, out lErrocode, out lErrorNumber, out errorMessage);
if (executionResult == 0)
{
return(MapLookupMaster(_dsResult, out objDOCMN_LookupType));
}
return(ExceptionTypes.SqlException);
}
catch (Exception)
{
return(ExceptionTypes.UnknownError);
}
finally
{
_dsResult = null;
_lstParameters = null;
}
}
/// <summary>
/// Save / Modify lookup Type
/// </summary>
/// <param name="objDOCMN_LookupType"></param>
/// <returns></returns>
public ActionResult SaveLookupType(DOCMN_LookupType objDOCMN_LookupType)
{
errorMessage = string.Empty;
ExceptionTypes result = new ExceptionTypes();
try
{
long loginUserId = currentUser.ADM_UserMasterId;
string returnMessage = string.Empty;
if (objDOCMN_LookupType.CMN_LookupTypeId > 0) //Edit Mode
{
BLCommon objCommon = new BLCommon();
if (!objCommon.ValidateLockBeforeSave(loginUserId, (long)ScreenType.LookupType, objDOCMN_LookupType.CMN_LookupTypeId))
{
errorMessage = "Record not locked, please reload the page.";
result = ExceptionTypes.UnknownError;
return(Json(new { ID = result, Message = errorMessage }));
}
objDOCMN_LookupType.LastUpdatedByRef = loginUserId;
returnMessage = "Record updated successfully.";
}
else
{
objDOCMN_LookupType.CreatedByRef = loginUserId; //Add Mode
returnMessage = "Record saved successfully.";
}
result = _objBLLookup.SaveLookupType(objDOCMN_LookupType, out errorMessage);
if (result != (long)ExceptionTypes.Success)
{
BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Lookups, (long)ExceptionTypes.Uncategorized, string.Empty, errorMessage);
return(Json(new { ID = result, Message = "An error occured while updating DB." }));
}
return(Json(new { ID = result, Message = returnMessage }));
}
catch (Exception ex)
{
ViewBag.ErrorMessage = ex.ToString();
BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Lookups, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
return(Json(new { ID = result, Message = "An error occured while updating DB." }));
}
}
private DOCMN_LookupType PGetLookupMasterByLkupTypeID(long?lookupTypeId)
{
DOCMN_LookupType objDOCMN_LookupType = new DOCMN_LookupType();
try
{
ExceptionTypes result = _objBLLookup.GetLookupMasterByLkupTypeID(lookupTypeId, out objDOCMN_LookupType);
if (result != (long)ExceptionTypes.Success)
{
//Log Error
BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Lookups, (long)ExceptionTypes.Uncategorized, string.Empty, "Something Went Wrong in PGetLookupMasterByLkupTypeID");
}
return(objDOCMN_LookupType);
}
catch (Exception ex)
{
BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.LookupsCorrelation, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
throw ex;
}
}
public ExceptionTypes SaveLookupType(DOCMN_LookupType objDOCMN_LookupType, out string errorMessage)
{
_retValue = new ExceptionTypes();
return(_retValue = _objDALLookup.SaveLookupType(objDOCMN_LookupType, out errorMessage));
}
public ExceptionTypes GetLookupMasterByLkupTypeID(long?lookupTypeId, out DOCMN_LookupType objDOCMN_LookupType)
{
_retValue = new ExceptionTypes();
return(_retValue = _objDALLookup.GetLookupMasterByLkupTypeID(lookupTypeId, out objDOCMN_LookupType));
}
/// <summary>
/// Save/Update LookupType
/// </summary>
/// <param name="objDOCMN_LookupType"></param>
/// <param name="errorMessage"></param>
/// <returns></returns>
public ExceptionTypes SaveLookupType(DOCMN_LookupType objDOCMN_LookupType, out string errorMessage)
{
_lstParameters = new List <SqlParameter>();
SqlParameter sqlParam;
long lErrocode = 0;
long lErrorNumber = 0;
errorMessage = string.Empty;
long lRowsEffected = 0;
try
{
if (objDOCMN_LookupType.CMN_LookupTypeId > 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_LookupTypeId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOCMN_LookupType.CMN_LookupTypeId;
_lstParameters.Add(sqlParam);
}
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@LookupTypeDescription";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOCMN_LookupType.LookupTypeDescription;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@IsActive";
sqlParam.SqlDbType = SqlDbType.Bit;
sqlParam.Value = objDOCMN_LookupType.IsActive;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ScreenLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = ScreenType.LookupType;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@LoginUserId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = (objDOCMN_LookupType.CMN_LookupTypeId > 0) ? objDOCMN_LookupType.LastUpdatedByRef : objDOCMN_LookupType.CreatedByRef;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ErrorMessage";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = string.Empty;
sqlParam.Direction = ParameterDirection.Output;
sqlParam.Size = 2000;
_lstParameters.Add(sqlParam);
long executionResult = _daHelper.ExecuteDMLSP(ConstantTexts.SP_APP_INS_UPD_LookupType, _lstParameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage);
sqlParam = _lstParameters.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);
}
finally
{
_lstParameters = null;
}
}
