public ActionResult ModelingReport(long?nodeId, bool isActive, int?fileType, string currentDateTime)
{
string fileName = string.Empty;
string reportFormat = fileType == 1
? Enums.DownloadFileType.Pdf.ToString()
: Enums.DownloadFileType.Xls.ToString();
ModelingReport modelingReport = new ModelingReport
{
NodeId = nodeId,
IsActive = isActive,
UserName = GetCurrentUserName(),
CommandTimeoutForModelingReport = Convert.ToInt32(GlobalConfigVariable.CommandTimeout),
LoggedInUser = GetLoggedInUserName()
};
ModelingReport modelingReportInfo = PostApiResponse <ModelingReport>(Constants.ModelingReport,
Constants.GetAllModelingDetails,
modelingReport);
ModelingReportViewModel modellingReportlist =
AutoMapper.Mapper.Map <ModelingReport, ModelingReportViewModel>(modelingReportInfo);
modellingReportlist.NodeId = nodeId;
modellingReportlist.LoggedInUser = GetCurrentUserName();
// Gets the current CST time.
modellingReportlist.CurrentDateTime = Utilities.GetLocalTimeString(currentDateTime);
if (modellingReportlist.ModelingReports != null && modellingReportlist.ModelingReports.Count > 0)
{
fileName = Export(new ContractModeling(modellingReportlist), reportFormat);
}
return(Json(fileName));
}
/// <summary>
/// Gets all modeling details.
/// </summary>
/// <param name="modelingReport">The modeling report.</param>
/// <returns></returns>
public ModelingReport GetAllModelingDetails(ModelingReport modelingReport)
{
TextInfo textInfo = new CultureInfo("en-US", false).TextInfo;
if (modelingReport != null)
{
var modelingDetails = new ModelingReport();
var modelingReportlist = new List <ModelingReport>();
// Initialize the Stored Procedure
_databaseCommandObj = _databaseObj.GetStoredProcCommand("GetCMSModellingReport");
// Pass parameters to Stored Procedure(i.e., @ParamName), add values for
_databaseObj.AddInParameter(_databaseCommandObj, "@NodeID", DbType.Int64, modelingReport.NodeId);
_databaseObj.AddInParameter(_databaseCommandObj, "@IsActive", DbType.String, modelingReport.IsActive);
_databaseObj.AddInParameter(_databaseCommandObj, "@LoggedInUser", DbType.String, modelingReport.LoggedInUser);
_databaseCommandObj.CommandTimeout = modelingReport.CommandTimeoutForModelingReport;
// Retrieve the results of the Stored Procedure in Datatable
DataSet modelingDataSet = _databaseObj.ExecuteDataSet(_databaseCommandObj);
long?totalRecords = 0;
if (modelingDataSet.IsTableDataPopulated(1) && modelingDataSet.Tables[1].Rows[0]["TotalRecords"] != DBNull.Value)
{
totalRecords = Convert.ToInt64(modelingDataSet.Tables[1].Rows[0]["TotalRecords"]);
}
if (modelingDataSet.IsTableDataPopulated(0))
{
//populating ContractBasicInfo data
DataTable dataTable = modelingDataSet.Tables[0];
modelingReportlist.AddRange(dataTable.Rows.Cast <object>().Select((t, indexCount) => new ModelingReport
{
ContractId = Convert.ToInt64(modelingDataSet.Tables[0].Rows[indexCount]["ContractId"]),
ContractName = Convert.ToString(modelingDataSet.Tables[0].Rows[indexCount]["Contract"]),
PayerName = textInfo.ToTitleCase(Convert.ToString(modelingDataSet.Tables[0].Rows[indexCount]["Payers"]).ToLower()),
StartDate = Convert.ToDateTime(modelingDataSet.Tables[0].Rows[indexCount]["BeginEffectiveDate"]),
EndDate = Convert.ToDateTime(modelingDataSet.Tables[0].Rows[indexCount]["EndEffectiveDate"]),
ServiceType = Convert.ToString(modelingDataSet.Tables[0].Rows[indexCount]["ServType"]),
ClaimTools = Convert.ToString(modelingDataSet.Tables[0].Rows[indexCount]["ServiceLine"]).Replace(Environment.NewLine, ""),
PaymentTool = Convert.ToString(modelingDataSet.Tables[0].Rows[indexCount]["PaymentType"]).Replace(Environment.NewLine, ""),
FacilityName = Convert.ToString(modelingDataSet.Tables[0].Rows[indexCount]["FacilityName"]),
ModelName = Convert.ToString(modelingDataSet.Tables[0].Rows[indexCount]["ModelName"]),
IsCarveOut = Convert.ToString(modelingDataSet.Tables[0].Rows[indexCount]["IsCarveOut"]).Equals("true", StringComparison.CurrentCultureIgnoreCase),
IsContractSpecific = Convert.ToString(modelingDataSet.Tables[0].Rows[indexCount]["IsContractSpecific"]).Equals("true", StringComparison.CurrentCultureIgnoreCase),
TotalRecords = totalRecords,
PayerCodes = Convert.ToString(modelingDataSet.Tables[0].Rows[indexCount]["PayerCode"])
}));
modelingDetails.FacilityName = modelingReportlist[0].FacilityName;
modelingDetails.ReportDate = DateTime.UtcNow.ToShortDateString();
modelingDetails.UserName = modelingReport.UserName;
modelingDetails.IsActive = modelingReport.IsActive;
modelingDetails.ModelingReports = modelingReportlist;
}
return(modelingDetails);
}
return(null);
}
public void GetAllModelingDetailsIfnotNullUnitTest()
{
ModelingReport result = new ModelingReport
{
ContractId = 1,
ContractName = "Contract 1",
PayerName = "payer 1",
ServiceType = "service type 1",
ClaimTools = "claimtool",
PaymentTool = "paymenttool"
};
Mock <IModelingReportRepository> mockGetAllVarianceReport = new Mock <IModelingReportRepository>();
mockGetAllVarianceReport.Setup(f => f.GetAllModelingDetails(It.IsAny <ModelingReport>())).Returns(result);
new ModelingReportLogic(mockGetAllVarianceReport.Object).GetAllModelingDetails(new ModelingReport());
mockGetAllVarianceReport.VerifyAll();
}
public void notify()
{
form.label12Elem.Text = "";
if (form.progressBar1Elem.Value >= 100)
{
form.progressBar1Elem.Value = 0;
}
ModelingReport report = model.getResult();
step = 100 / report.getConfig().getNumberOfStartsModeling();
if (report.getConfig().getNumberOfStartsModeling() ==
report.getNumberOfReportsUpdates())
{
form.progressBar1Elem.Value = 100;
form.label12Elem.Text = "Статус: анализ завершен";
}
if (report.getConfig().getNumberOfStartsModeling() >
report.getNumberOfReportsUpdates() & report.getNumberOfReportsUpdates() != 0)
{
form.progressBar1Elem.Value += step;
}
//Проверка строк в таблицах
if (form.dataGridView2Elem.Rows.Count != report.getAvgTranzactsInQueue().Count() &&
report.getAvgTranzactsInQueue().Count() > 0)
{
form.dataGridView2Elem.Rows.Clear();
form.dataGridView2Elem.Rows.Add(report.getAvgTranzactsInQueue().Count());
form.dataGridView2Elem.Rows.RemoveAt(0);
}
if (report.getAvgTranzactsInQueue().Count == 0)
{
form.dataGridView2Elem.Rows.Clear();
}
//Заполнение таблиц
for (int i = 0; i < report.getAvgTranzactsInQueue().Count(); i++)
{
form.dataGridView2Elem.Rows[i].Cells[0].Value =
report.getMaxTranzactsInQueue().ElementAt(i).name;
form.dataGridView2Elem.Rows[i].Cells[1].Value =
report.getMaxTranzactsInQueue().ElementAt(i).value;
form.dataGridView2Elem.Rows[i].Cells[2].Value =
report.getAvgTranzactsInQueue().ElementAt(i).value;
form.dataGridView2Elem.Update();
}
//Обновление управляющих элементов
if (report.getConfig() != null)
{
switch (report.getConfig().getInterval().getType())
{
case "year":
form.comboBox1Elem.SelectedIndex = 0;
break;
case "month":
form.comboBox1Elem.SelectedIndex = 1;
break;
case "day":
form.comboBox1Elem.SelectedIndex = 2;
break;
case "hour":
form.comboBox1Elem.SelectedIndex = 3;
break;
case "minute":
form.comboBox1Elem.SelectedIndex = 4;
break;
case "second":
form.comboBox1Elem.SelectedIndex = 5;
break;
default:
throw new UnknownTimeIntervalType("Unknown time interval type");
}
form.numericUpDown1Elem.Value = report.getConfig().getNumberOfStartsModeling();
form.checkBox1Elem.Checked = report.getConfig().getWithKovar();
}
}
public ModelingReport GetAllModelingDetails(ModelingReport modelingReport)
{
return(_modelingReportLogic.GetAllModelingDetails(modelingReport));
}
/// <summary>
/// Gets all modeling details.
/// </summary>
/// <param name="modelingReport">The modeling report.</param>
/// <returns></returns>
public ModelingReport GetAllModelingDetails(ModelingReport modelingReport)
{
return(_modelingReportRepository.GetAllModelingDetails(modelingReport));
}
