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