public ExceptionTypes UpdateFDRPackageDate(List <long> caseIds, FDRSubmissionCategory submissionCategory, long LoginUserId, out string errorMessage)
{
string strCaseIds = String.Concat(caseIds.Select(x => x.ToString() + ","));
errorMessage = string.Empty;
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 = "@CaseIds";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = strCaseIds;
parameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@FDRSubmissionCategoryLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = (long)submissionCategory;
parameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@LoginUserId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = LoginUserId;
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;
executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_BGP_UPD_FDRPackageDates, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, 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);
}
}
public ExceptionTypes UpdateFDRPackageDate(List <long> caseIds, FDRSubmissionCategory submissionCategory, long LoginUserId, out string errorMessage)
{
_retValue = new ExceptionTypes();
return(_retValue = _objDALFDR.UpdateFDRPackageDate(caseIds, submissionCategory, LoginUserId, out errorMessage));
}
private ExceptionTypes CreateRowData(string strContractId, string strHICN, FDRSubmissionCategory SubmissionCategory, out FDRSubmissionRow objFDRSubmissionRow, out long lResolution, out string errorMessage)
{
objFDRSubmissionRow = new FDRSubmissionRow();
lResolution = 0;
try
{
BLFDR objBLFDR = new BLFDR();
string[] arrHICN = strHICN.Trim().Split(' ');//split HICN to check if specific action requested suffix is present
long lTransactionTypeLkup = 0;
ExceptionTypes result = ExceptionTypes.UnknownError;
if (SubmissionCategory == FDRSubmissionCategory.SCC)
{
//get ERS deatils for current HICN and Contract
result = objBLFDR.GetCaseDetails(strContractId, arrHICN[0], (long)DiscripancyType.SCCRPR, lTransactionTypeLkup, out List <FDRSubmissionRow> lstCases, out errorMessage);
//check for Multiple cases for same HICN and Contract but no Ttransaction type suffix to FIle name
if (lstCases.Count > 0)
{
//check if any case found
if (lstCases.Count == 1)
{
objFDRSubmissionRow = lstCases.FirstOrDefault();
objFDRSubmissionRow.Errormessage = "Case Id for : HICN-" + arrHICN[0] + " , Contract-" + strContractId + " , Discripancy Type-" + DiscripancyType.SCCRPR.ToString() + " is " + objFDRSubmissionRow.GEN_QueueId;
objFDRSubmissionRow.IsFDRSubmissionCompleted = true;
objBLFDR.InsertFDRSubmissionLog(lstCases.ToList(), _lCurrentMasterUserId, objFDRSubmissionRow.IsFDRSubmissionCompleted, objFDRSubmissionRow.Errormessage, out errorMessage);
}
else
{
objFDRSubmissionRow.Errormessage = "Multiple cases present for HICN-" + arrHICN[0] + " , Contract-" + strContractId + " in Discrepancy Type SCC RPR";
objFDRSubmissionRow.IsFDRSubmissionCompleted = false;
objBLFDR.InsertFDRSubmissionLog(lstCases.ToList(), _lCurrentMasterUserId, objFDRSubmissionRow.IsFDRSubmissionCompleted, objFDRSubmissionRow.Errormessage, out errorMessage);
result = ExceptionTypes.UnknownError;
}
}
else
{
objFDRSubmissionRow.MemberContractID = strContractId;
objFDRSubmissionRow.MemberCurrentHICN = arrHICN[0];
objFDRSubmissionRow.IsFDRSubmissionCompleted = false;
lstCases.Add(objFDRSubmissionRow);
//set error msg as no case for HICN and contract
objFDRSubmissionRow.Errormessage = "No case found for : HICN-" + arrHICN[0] + " , Contract-" + strContractId + " , Discripancy Type-" + DiscripancyType.SCCRPR.ToString();
objBLFDR.InsertFDRSubmissionLog(lstCases.ToList(), _lCurrentMasterUserId, objFDRSubmissionRow.IsFDRSubmissionCompleted, objFDRSubmissionRow.Errormessage, out errorMessage);
}
}
else
{
if (arrHICN.Length > 1)
{
lTransactionTypeLkup = GetTransactionTypeFromHICNSuffix(arrHICN[1]);
}
//check weather transaction type is is valid and is present in RPRActionRequested ENUM
if (arrHICN.Length == 1 || lTransactionTypeLkup != 0)
{
//get ERS deatils for current HICN and Contract
result = objBLFDR.GetCaseDetails(strContractId, arrHICN[0], (long)DiscripancyType.RPR, lTransactionTypeLkup, out List <FDRSubmissionRow> lstCases, out errorMessage);
//set error msg as no case for HICN and contract
errorMessage = "No case found for : HICN-" + arrHICN[0] + " , Contract-" + strContractId + " , Discripancy Type-" + DiscripancyType.RPR.ToString() + " , Transaction Type-" + ((FDRTransactionType)lTransactionTypeLkup).ToString();
//check for Multiple cases for same HICN and Contract but no Ttransaction type suffix to FIle name
if (lstCases.Count > 0)
{
//check if any case found
if (lstCases.Count == 1)
{
objFDRSubmissionRow = lstCases.FirstOrDefault();
objFDRSubmissionRow.Errormessage = "Case Id for : HICN-" + arrHICN[0] + " , Contract-" + strContractId + " , Discripancy Type-" + DiscripancyType.RPR.ToString() + " , Transaction Type-" + ((FDRTransactionType)lTransactionTypeLkup).ToString() + " is " + objFDRSubmissionRow.GEN_QueueId;
lResolution = objFDRSubmissionRow.ResolutionLkup;
objFDRSubmissionRow.IsFDRSubmissionCompleted = true;
objBLFDR.InsertFDRSubmissionLog(lstCases.ToList(), _lCurrentMasterUserId, objFDRSubmissionRow.IsFDRSubmissionCompleted, objFDRSubmissionRow.Errormessage, out errorMessage);
}
else
{
objFDRSubmissionRow.Errormessage = "Multiple cases present for HICN-" + arrHICN[0] + " , Contract-" + strContractId + ".Transaction Type Suffix is Required in file Name.";
objFDRSubmissionRow.IsFDRSubmissionCompleted = false;
objBLFDR.InsertFDRSubmissionLog(lstCases.ToList(), _lCurrentMasterUserId, objFDRSubmissionRow.IsFDRSubmissionCompleted, objFDRSubmissionRow.Errormessage, out errorMessage);
result = ExceptionTypes.UnknownError;
}
}
else
{
objFDRSubmissionRow.MemberContractID = strContractId;
objFDRSubmissionRow.MemberCurrentHICN = arrHICN[0];
objFDRSubmissionRow.IsFDRSubmissionCompleted = false;
lstCases.Add(objFDRSubmissionRow);
//set error msg as no case for HICN and contract
objFDRSubmissionRow.Errormessage = "No case found for : HICN-" + arrHICN[0] + " , Contract-" + strContractId + " , Discripancy Type-" + DiscripancyType.RPR.ToString();
objBLFDR.InsertFDRSubmissionLog(lstCases.ToList(), _lCurrentMasterUserId, objFDRSubmissionRow.IsFDRSubmissionCompleted, objFDRSubmissionRow.Errormessage, out errorMessage);
}
}
else
{
errorMessage = "Invalid trasaction type requested in file name : " + strContractId + '-' + strHICN + ".pdf";
}
}
Console.WriteLine(errorMessage);
return(result);
}
catch (Exception ex)
{
//log excepiton if any
Console.WriteLine("Error : " + ex.Message);
errorMessage = ex.Message;
BLCommon.LogError(_lCurrentMasterUserId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.BGPFDRSubmission, (long)ExceptionTypes.Uncategorized, "Exception Creating Excel Row For " + strContractId + " " + strHICN, ex.StackTrace.ToString());
return(ExceptionTypes.Exception);
}
}
