public ActionResult DeleteReport(string postData, int DaId)
{
try
{
ReportsMappingViewModel transactionAttribute = new ReportsMappingViewModel();
transactionAttribute.DeleteReports(postData, DaId);
return(Json(postData, JsonRequestBehavior.AllowGet));
}
catch (DbUpdateException exception)
{
//Log Exception
errorlogviewmodel = new ErrorLogViewModel();
errorlogviewmodel.LogError(exception);
//Check for Referential Integrity
if (((System.Data.SqlClient.SqlException)exception.InnerException.InnerException).Number == 547)
{
return(View("Error_ReferentialIntegrity"));
}
return(View("Error"));
}
catch (Exception ex)
{
errorlogviewmodel = new ErrorLogViewModel();
errorlogviewmodel.LogError(ex);
return(View("Error"));
}
}
public string GenerateReportsMappingTable(int daId, HttpPostedFileBase path)
{
try
{
ExcelCommonFunctions excelCommonFunctions = new ExcelCommonFunctions();
TransactionMatrix transactionMatrix = new TransactionMatrix();
InterfaceMappingViewModel interfaceMappingView = new InterfaceMappingViewModel();
interfaceMappingView.lstHighLevelTxns = interfaceMappingView.GetTransactionsList(daId).lstTransactions;
ReportsMappingViewModel reportMappingView = new ReportsMappingViewModel();
reportMappingView.lstReportData = reportMappingView.GetReportsList(daId);
using (ExcelPackage objExcelPackage = new ExcelPackage(path.InputStream))
{
int cnt = 1;
foreach (var trans in interfaceMappingView.lstHighLevelTxns)
{
int colIndex = 1, rowIndex = 0;
int rowCountRuleofN;
ExcelWorksheet ws = excelCommonFunctions.OpenSheet(objExcelPackage, trans.HighLevelTxnDesc);
DataTable dtRuleOfN = transactionMatrix.GetRuleOfNDataForAllTables(ws, ref colIndex, ref rowIndex, "Reports - " + trans.HighLevelTxnDesc);
//get merrged cells to find the end row of Rule of N table
if (ws.MergedCells.Count == 1)
{
rowCountRuleofN = dtRuleOfN.Rows.Count;
}
else
{
//the header row of Rule of N is fixed as 17
var c = ws.MergedCells[1];//Assuming the first merged cell is of one mapping table.
ExcelAddress cellAddr = new ExcelAddress(c);
int row = cellAddr.Start.Row;
int lastRow = row - 2;
rowCountRuleofN = lastRow - 17;
}
//create datatable for each transaction
DataTable dtReports = ReportsMappingViewModel.CreateReportsDataTable(reportMappingView.lstReportData, trans.TransactionSeq, dtRuleOfN);
//Table#3
if (dtReports.Rows.Count != 0)
{
rowIndex = rowIndex + 2;
string tblName3 = "Reports - " + trans.HighLevelTxnDesc;
ws.Cells[rowIndex, 1].Value = tblName3;
// ws.Cells[rowIndex, 1, rowIndex, 7].Merge = true; //Merge columns start and end range
ws.Cells[rowIndex, 1, rowIndex, 7].Style.Font.Bold = true; //Font should be bold
ws.Cells[rowIndex, 1, rowIndex, 7].Style.Font.Size = 20;
ws.Cells[rowIndex, 1, rowIndex, 7].Style.HorizontalAlignment = ExcelHorizontalAlignment.Left; // Aligmnet is center
ws.Cells[rowIndex, 1, rowIndex, 7].Style.Fill.PatternType = ExcelFillStyle.Solid; // Aligmnet is center
ws.Cells[rowIndex, 1, rowIndex, 7].Style.Fill.BackgroundColor.SetColor(Color.LightGray); // Aligmnet is center
colIndex = 1;
rowIndex = rowIndex + 2;
excelCommonFunctions.CreateTableHeader(dtReports, ws, ref colIndex, ref rowIndex, tblName3);
Dictionary <string, string> dictReport = excelCommonFunctions.GetMappingID(dtReports);
excelCommonFunctions.AddRowsMapping(dtReports, ws, dictReport, rowCountRuleofN, ref colIndex, ref rowIndex);
}
ws.View.ShowGridLines = false;
ws.View.ZoomScale = 80;
//ws.Cells.AutoFitColumns();
//rearranged
cnt++;
}
tbl_DesignAccelerator da = new tbl_DesignAccelerator();
DAManager daManager = new DAManager();
da = daManager.FindDA(daId);
string filePath = excelCommonFunctions.SaveFile(objExcelPackage, da.daName, path.FileName, "Reports");
return(filePath);
}
}
catch (Exception)
{
throw;
}
}
