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