private void MapCaseDetails(DataSet dsResult, out List <FDRSubmissionRow> lstFDRSubmissionRow)
{
lstFDRSubmissionRow = new List <FDRSubmissionRow>();
if (dsResult != null && dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++)
{
DataRow dr = dsResult.Tables[0].Rows[i];
FDRSubmissionRow objFDRSubmissionRow = new FDRSubmissionRow();
objFDRSubmissionRow.GEN_QueueId = !(DBNull.Value.Equals(dr["GEN_QueueId"])) ? Convert.ToInt64(dr["GEN_QueueId"]) : 0;
objFDRSubmissionRow.RPRRequestedEffectiveDate = !(DBNull.Value.Equals(dr["RPRRequestedEffectiveDate"])) ? Convert.ToDateTime(dr["RPRRequestedEffectiveDate"]).ToString("MM/dd/yyyy") : string.Empty;
objFDRSubmissionRow.EffectiveDate = !(DBNull.Value.Equals(dr["EffectiveDate"])) ? Convert.ToDateTime(dr["EffectiveDate"]).ToString("MM/dd/yyyy") : string.Empty;
objFDRSubmissionRow.EndDate = !(DBNull.Value.Equals(dr["EndDate"])) ? Convert.ToDateTime(dr["EndDate"]).ToString("MM/dd/yyyy") : string.Empty;
objFDRSubmissionRow.ApplicationDate = !(DBNull.Value.Equals(dr["ApplicationDate"])) ? Convert.ToDateTime(dr["ApplicationDate"]).ToString("MM/dd/yyyy") : string.Empty;
objFDRSubmissionRow.MemberCurrentHICN = !(DBNull.Value.Equals(dr["MemberCurrentHICN"])) ? Convert.ToString(dr["MemberCurrentHICN"]) : string.Empty;
objFDRSubmissionRow.MemberFirstName = !(DBNull.Value.Equals(dr["MemberFirstName"])) ? Convert.ToString(dr["MemberFirstName"]) : string.Empty;
objFDRSubmissionRow.MemberLastName = !(DBNull.Value.Equals(dr["MemberLastName"])) ? Convert.ToString(dr["MemberLastName"]) : string.Empty;
objFDRSubmissionRow.MemberContractID = !(DBNull.Value.Equals(dr["MemberContractID"])) ? Convert.ToString(dr["MemberContractID"]) : string.Empty;
objFDRSubmissionRow.MemberPBP = !(DBNull.Value.Equals(dr["MemberPBP"])) ? Convert.ToString(dr["MemberPBP"]) : string.Empty;
objFDRSubmissionRow.ElectionType = !(DBNull.Value.Equals(dr["ElectionType"])) ? Convert.ToString(dr["ElectionType"]) : string.Empty;
objFDRSubmissionRow.RPRActionRequestedLkup = !(DBNull.Value.Equals(dr["RPRActionRequestedLkup"])) ? Convert.ToInt64(dr["RPRActionRequestedLkup"]) : 0;
objFDRSubmissionRow.SCCRPRRequested = !(DBNull.Value.Equals(dr["SCCRPRRequested"])) ? Convert.ToString(dr["SCCRPRRequested"]) : string.Empty;
objFDRSubmissionRow.SCCRPRRequestedZip = !(DBNull.Value.Equals(dr["SCCRPRRequestedZip"])) ? Convert.ToString(dr["SCCRPRRequestedZip"]) : string.Empty;
objFDRSubmissionRow.ResolutionLkup = !(DBNull.Value.Equals(dr["ResolutionLkup"])) ? Convert.ToInt64(dr["ResolutionLkup"]) : 0;
lstFDRSubmissionRow.Add(objFDRSubmissionRow);
}
}
}
public ExceptionTypes InsertFDRSubmissionLog(List <FDRSubmissionRow> lstCases, long LoginUserId, bool IsFDRSubmissionCompleted, string errormessage, out string errorMessage)
{
FDRSubmissionRow objFDRSubmissionRow = new FDRSubmissionRow();
try
{
DAHelper dah = new DAHelper();
List <SqlParameter> parameters = new List <SqlParameter>();
long lErrorCode = 0;
long lErrorNumber = 0;
DataSet dsResultData = new DataSet();
SqlParameter sqlParam;
if (lstCases.Count() > 0)
{
DataTable dtCases;
SetFDRSubmissionLog(lstCases, IsFDRSubmissionCompleted, errormessage, out dtCases);
DataTableReader dtrFDRSubmissionLog = new DataTableReader(dtCases);
//DataSet ds = new DataSet("TVP_FDRStaging");
//ds.Tables.Add(dtCases);
//string xmlData = ds.GetXml();
//sqlParam = new SqlParameter();
//sqlParam.ParameterName = "@XMLData";
//sqlParam.SqlDbType = SqlDbType.NVarChar;
//sqlParam.Value = xmlData;
//parameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@TVP_FDRSubmissionLog";
sqlParam.SqlDbType = SqlDbType.Structured;
sqlParam.Value = dtrFDRSubmissionLog;
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 = dah.ExecuteDMLSP(ConstantTexts.SP_USP_APP_INS_FDRSubmissionLog, parameters.ToArray(), out lErrorCode, out lErrorCode, out lErrorNumber, 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);
}
}
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);
}
}
