/// <summary> /// Details the error details. /// </summary> /// <param name="vm">The vm.</param> /// <returns></returns> private ErrorDetails GetDetailErrorDetails() { vm.DetailSqlQuery = ConfigurationManager.AppSettings["HALFAILQuery"]; Mapper.MapErrorDetailViewModelToDataModel(this.vm, this.logDataModel); GetExceedData.GetErrorFailed(this.logDataModel); ErrorDetails errorDetails = null; if (this.logDataModel.dataSet.Tables["HAL_ERR_LOG_FAIL"] != null) { var HalErrorLogFailTable = this.logDataModel.dataSet.Tables["HAL_ERR_LOG_FAIL"].AsEnumerable(); errorDetails = new ErrorDetails(); errorDetails.FailedProgrammeName = (from row in HalErrorLogFailTable select row.Field <string>("HELF_FAIL_PGM_NM")).FirstOrDefault(); errorDetails.FailedParagraphName = (from row in HalErrorLogFailTable select row.Field <string>("HELF_FAIL_PARA_NM")).FirstOrDefault(); errorDetails.ErrorAdditionalText = (from row in HalErrorLogFailTable select row.Field <string>("HELF_ERR_ADD_TXT")).FirstOrDefault(); errorDetails.SQLCode = (from row in HalErrorLogFailTable select row.Field <string>("SQL_CODE")).FirstOrDefault(); errorDetails.ErrorCmtText = (from row in HalErrorLogFailTable select row.Field <string>("HELF_ERR_CMT_TXT")).FirstOrDefault(); errorDetails.FailedUOWName = (from row in HalErrorLogFailTable select row.Field <string>("HELF_FAIL_UOW_NM")).FirstOrDefault(); errorDetails.FailedLocationName = (from row in HalErrorLogFailTable select row.Field <string>("HELF_FAIL_LOC_NM")).FirstOrDefault(); errorDetails.SQLErroeMCText = (from row in HalErrorLogFailTable select row.Field <string>("HELF_SQLERRMC_TXT")).FirstOrDefault(); errorDetails.UserId = (from row in HalErrorLogFailTable select row.Field <string>("USERID")).FirstOrDefault(); errorDetails.FailedKeyText = (from row in HalErrorLogFailTable select row.Field <string>("HELF_FAIL_KEY_TXT")).FirstOrDefault(); errorDetails.ACYText = (from row in HalErrorLogFailTable select row.Field <string>("HELF_ACY_TXT")).FirstOrDefault(); errorDetails.PriorityCd = (from row in HalErrorLogFailTable select row.Field <string>("HELF_PRIORITY_CD")).FirstOrDefault(); errorDetails.ErrorText = (from row in HalErrorLogFailTable select row.Field <string>("HELF_ERR_TXT")).FirstOrDefault(); } return(errorDetails); }
/// <summary> /// Creates the PrintIO rows. /// </summary> /// <param name="vm">The vm.</param> /// <returns>Print IO Rows</returns> private List <PrintIORow> CreatePrintIORows() { List <PrintIORow> printIORow = null; //vm.SqlQuery = ConfigurationManager.AppSettings["TXAMDETQuery"]; vm.SqlQuery = ConfigurationManager.AppSettings["PrintQuery"]; Mapper.MapPrintInitialDataToDataModel(vm, this.logDataModel); GetExceedData.GetDetailsPrint(this.logDataModel); if (this.logDataModel.dataSet.Tables["Formatted_POL_BIL_MQ_AUDIT_V"] != null && this.logDataModel.dataSet.Tables["Formatted_POL_BIL_MQ_AUDIT_V"].AsEnumerable() != null) { //printIORow = new List<PrintIORow>(); //var formattedPOL_BIL_MQ_AUDIT_V = this.logDataModel.dataSet.Tables["Formatted_POL_BIL_MQ_AUDIT_V"].AsEnumerable(); //var keyData = (from row in formattedPOL_BIL_MQ_AUDIT_V select new { MSG_TS = row.Field<string>("MSG_TS"), MSG_ID = row.Field<string>("MSG_ID"), TRS_ID = row.Field<string>("TRS_ID") }).ToList(); //string Message_ID = string.Empty; //keyData.ForEach(row => //{ // Message_ID = HelperClass.GetExceedTransaction(row.MSG_ID); // PrintIORow.Add(new PrintIORow { MSG_TS = row.MSG_TS, MSG_ID = Message_ID, TRS_ID = row.TRS_ID }); //}); printIORow = new List <PrintIORow>(); var formattedPOL_BIL_MQ_AUDIT_V = this.logDataModel.dataSet.Tables["Formatted_POL_BIL_MQ_AUDIT_V"].AsEnumerable(); var keyData = (from row in formattedPOL_BIL_MQ_AUDIT_V select new { MSG_TS = row.Field <string>("MSG_TS") }).ToList(); //string Message_ID = string.Empty; keyData.ForEach(row => { // Message_ID = HelperClass.GetExceedTransaction(row.MSG_ID); printIORow.Add(new PrintIORow { MSG_TS = row.MSG_TS }); }); } return(printIORow); //List<PrintIORow> printIORow = null; //vm.SqlQuery = ConfigurationManager.AppSettings["TXAMDETQuery"]; //Mapper.MapEDDInitialDataToDataModel(vm, this.logDataModel); //GetExceedData.GetEddDetails(this.logDataModel); //if (this.logDataModel.dataSet.Tables["Formatted_TXAMDET"] != null && this.logDataModel.dataSet.Tables["Formatted_TXAMDET"].AsEnumerable() != null) //{ // printIORow = new List<EDDIORow>(); // var formattedTXAMDET = this.logDataModel.dataSet.Tables["Formatted_TXAMDET"].AsEnumerable(); // var keyData = (from row in formattedTXAMDET select new { TRANSACTION_TIME = row.Field<string>("TRANSACTION_TIME"), MSG_ID = row.Field<string>("MSG_ID"), IO_CHAR = row.Field<string>("IO_CHAR") }).ToList(); // string Message_ID = string.Empty; // keyData.ForEach(row => // { // Message_ID = HelperClass.GetExceedTransaction(row.MSG_ID); // eDDIORow.Add(new EDDIORow { TRANSACTION_TIME = row.TRANSACTION_TIME, MSG_ID = Message_ID, IO_CHAR = row.IO_CHAR }); // }); //} //return eDDIORow; }
public ActionResult Index(LoginDetailsViewModel vm) { Mapper.MapLoginDetaisToDataModel(vm, logDataModel); if (!GetExceedData.VerifyLogin(this.logDataModel)) { TempData.Add("LoginStatus", "Login Failed"); this.logDataModel = null; return(View(vm)); } return(RedirectToAction("Welcome")); }
/// <summary> /// Gets the poliris data. /// </summary> /// <returns></returns> public List <DataRow> GetPolirisData() { vm.SqlQuery = ConfigurationManager.AppSettings["RATEPARMQuery"]; Mapper.MapPrintRatingQueryToDataModel(vm, this.logDataModel); GetExceedData.GetPolarisIds(this.logDataModel); List <DataRow> polarisData = null; if (this.logDataModel.dataSet.Tables["RATING_PARAMETERS"] != null) { polarisData = this.logDataModel.dataSet.Tables["RATING_PARAMETERS"].AsEnumerable().ToList(); } return(polarisData); }
/// <summary> /// Gets the policy ID from policy number. /// </summary> /// <param name="vm">The vm.</param> /// <returns>Returns Policy ID.</returns> private string GetPolicyIDFromPolicyNumber() { string PolicyId = string.Empty; vm.SqlQuery = ConfigurationManager.AppSettings["POLICYTABQuery"]; Mapper.MapPrintInitialDataToDataModel(vm, this.logDataModel); GetExceedData.GetPolicyTabDetails(this.logDataModel); if (this.logDataModel.dataSet.Tables["POLICY_TAB"] != null) { var PolicyTabDetails = this.logDataModel.dataSet.Tables["POLICY_TAB"].AsEnumerable(); PolicyId = (from row in PolicyTabDetails select row.Field <string>("POLICY_ID")).FirstOrDefault().Trim(); } return(PolicyId); }
/// <summary> /// Gets the last ten time stamps. /// </summary> /// <param name="vm">The vm.</param> /// <returns></returns> private List <string> GetLastTenTimeStamps() { List <string> Last10Occurances = null; vm.DetailSqlQuery = ConfigurationManager.AppSettings["LastTenQuery"]; Mapper.MapErrorDetailViewModelToDataModel(this.vm, this.logDataModel); GetExceedData.GetErrorDetails(this.logDataModel); if (this.logDataModel.dataSet.Tables["HAL_ERR_LOG_DTL"] != null) { Last10Occurances = new List <string>(); var HalErrorLogTable = this.logDataModel.dataSet.Tables["HAL_ERR_LOG_DTL"].AsEnumerable(); List <DateTime> dateTime = (from row in HalErrorLogTable select convertToDateTime(row.Field <string>("FAIL_TS"))).ToList(); dateTime.ForEach(dt => Last10Occurances.Add(dt.ToString())); } return(Last10Occurances); }
/// <summary> /// Gets the basic error details. /// </summary> /// <returns></returns> private BasicErrorDetails GetBasicErrorDetails() { BasicErrorDetails basicErrorDetails = null; vm.DetailSqlQuery = ConfigurationManager.AppSettings["HALDTLQuery"]; Mapper.MapErrorDetailViewModelToDataModel(this.vm, this.logDataModel); GetExceedData.GetErrorDetails(this.logDataModel); if (this.logDataModel.dataSet.Tables["HAL_ERR_LOG_DTL"] != null) { var HalErrorLogTable = this.logDataModel.dataSet.Tables["HAL_ERR_LOG_DTL"].AsEnumerable(); basicErrorDetails = new BasicErrorDetails(); basicErrorDetails.NoOfInstances = (from row in HalErrorLogTable select Int32.Parse(row.Field <string>("COUNTER"))).FirstOrDefault(); basicErrorDetails.EarliestRepoted = (from row in HalErrorLogTable select row.Field <string>("MIN_FAIL_TS")).FirstOrDefault(); basicErrorDetails.LatestReported = (from row in HalErrorLogTable select row.Field <string>("MAX_FAIL_TS")).FirstOrDefault(); } return(basicErrorDetails); }
/// <summary> /// Gets the basic error details. /// </summary> /// <returns></returns> private List <ErrorCodeCount> CreateTopTenErrorCode() { List <ErrorCodeCount> errorCodeCount = null; vm.DetailSqlQuery = ConfigurationManager.AppSettings["TopTenErrorCodeQuery"]; Mapper.MapTopTenErrorCodeQueryToDataModel(this.vm, this.logDataModel); GetExceedData.GetErrorDetails(this.logDataModel); if (this.logDataModel.dataSet.Tables["HAL_ERR_LOG_DTL"] != null) { var HalErrorLogTable = this.logDataModel.dataSet.Tables["HAL_ERR_LOG_DTL"].AsEnumerable(); var errorCount = (from row in HalErrorLogTable select new { errCount = Int32.Parse(row.Field <string>("COUNTER")), errorCode = row.Field <string>("ERRORCODE") }).ToList(); errorCodeCount = new List <ErrorCodeCount>(); errorCount.ForEach(error => errorCodeCount.Add(new ErrorCodeCount { ErrorCode = error.errorCode, Count = error.errCount })); } return(errorCodeCount); }
/// <summary> /// Creates the EDDIO rows. /// </summary> /// <param name="vm">The vm.</param> /// <returns>EDD IO Rows</returns> private List <EDDIORow> CreateEDDIORows() { List <EDDIORow> eDDIORow = null; vm.SqlQuery = ConfigurationManager.AppSettings["TXAMDETQuery"]; Mapper.MapEDDInitialDataToDataModel(vm, this.logDataModel); GetExceedData.GetEddDetails(this.logDataModel); if (this.logDataModel.dataSet.Tables["Formatted_TXAMDET"] != null && this.logDataModel.dataSet.Tables["Formatted_TXAMDET"].AsEnumerable() != null) { eDDIORow = new List <EDDIORow>(); var formattedTXAMDET = this.logDataModel.dataSet.Tables["Formatted_TXAMDET"].AsEnumerable(); var keyData = (from row in formattedTXAMDET select new { TRANSACTION_TIME = row.Field <string>("TRANSACTION_TIME"), MSG_ID = row.Field <string>("MSG_ID"), IO_CHAR = row.Field <string>("IO_CHAR") }).ToList(); string Message_ID = string.Empty; keyData.ForEach(row => { Message_ID = HelperClass.GetExceedTransaction(row.MSG_ID); eDDIORow.Add(new EDDIORow { TRANSACTION_TIME = row.TRANSACTION_TIME, MSG_ID = Message_ID, IO_CHAR = row.IO_CHAR }); }); } return(eDDIORow); }
/// <summary> /// Gets the LOB code. /// </summary> public void GetLOBCode() { string PolicyId = string.Empty; if (this.logDataModel.dataSet.Tables["POLICY_TAB"] != null) { var PolicyTabQuery = this.logDataModel.dataSet.Tables["POLICY_TAB"].AsEnumerable(); PolicyId = (from row in PolicyTabQuery select row.Field <string>("POLICY_ID")).FirstOrDefault().Trim(); } if (this.logDataModel.dataSet.Tables["POLICY_TAB"] == null || !string.Equals(this.logDataModel.PolicyId, PolicyId)) { vm.SqlQuery = ConfigurationManager.AppSettings["LOBCDQuery"]; Mapper.MapPrintLOBCDQueryToDataModel(vm, this.logDataModel); GetExceedData.GetPolicyTabDetails(this.logDataModel); } var PolicyTab = this.logDataModel.dataSet.Tables["POLICY_TAB"].AsEnumerable(); vm.LOBCD = (from row in PolicyTab select row.Field <string>("LOB_CD")).FirstOrDefault().Trim(); vm.MasterCompanyNbr = (from row in PolicyTab select row.Field <string>("MASTER_COMPANY_NBR")).FirstOrDefault().Trim(); Mapper.MapLOBCode(vm, this.logDataModel); }
/// <summary> /// Gets the six month count. /// </summary> /// <param name="vm">The vm.</param> /// <returns></returns> private List <MonthCount> GetSixMonthCount() { List <MonthCount> monthCount = new List <MonthCount>(); vm.DetailSqlQuery = ConfigurationManager.AppSettings["ViewStatQuery"]; Mapper.MapViewStatToDataModel(this.vm, this.logDataModel); GetExceedData.GetErrorDetails(this.logDataModel); if (this.logDataModel.dataSet.Tables["HAL_ERR_LOG_DTL"] != null) { var HalErrorLogTable = this.logDataModel.dataSet.Tables["HAL_ERR_LOG_DTL"].AsEnumerable(); var perMonthCount = (from row in HalErrorLogTable select new { errCount = Int32.Parse(row.Field <string>("COUNTER")), Month = row.Field <string>("MONTH") }).ToList(); for (int i = 0; i >= -5; i--) { string month = DateTime.Now.AddMonths(i).ToString("MMMM"); int errorCount = perMonthCount.Find(x => string.Equals(x.Month, month)).errCount; monthCount.Add(new MonthCount { Count = errorCount, Month = month }); } } return(monthCount); }