protected void btnGenerate_Click(object sender, EventArgs e)
{
if (LMIS.Portal.Helpers.Utils.LoggedUser == null)
{
Response.Redirect("~/login");
}
if (LMIS.Portal.Helpers.Utils.CheckPermission(2, 9, LMIS.Portal.Helpers.Utils.LoggedUser.Roles) < 1)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", @" noty({
type: 'error',
text: '" + GetGlobalResourceObject("MessagesResource", "X_NotAuthorized") + @"',
layout: 'center', closeWith: ['click', 'backdrop'],
modal: true, killer: true
});", true);
return;
}
int lang = (int)LMIS.Portal.Helpers.Utils.GetLanguage();
var dt = MgrReports.GetReportsChangingValues(int.Parse(ddlReports.SelectedValue), lang);
var result = MgrReports.GetReportsRunningValues(int.Parse(ddlReports.SelectedValue), lang);
// var runningVariable = result[0].GeneralID + "-" + result[0].GeneralName;
System.Data.DataTable dtResult = new System.Data.DataTable();
if (dt.Count > 0)
{
dtResult.Columns.Add(dt[0].GeneralID + "-" + dt[0].GeneralName);
}
//for (int i = 0; i < chkRunnningVariables.Items.Count; i++)
//{
// if (chkRunnningVariables.Items[i].Selected)
// {
// runnigvalue = chkRunnningVariables.Items[i].Value + "-" + chkRunnningVariables.Items[i].Text;
// break;
// }
//}
foreach (var item in dt)
{
DataRow row = dtResult.NewRow();
if (item.SubID.Substring(3) == "00001")
{
continue;
}
row[dt[0].GeneralID + "-" + dt[0].GeneralName] = item.SubID + "-" + item.Name;
dtResult.Rows.Add(row);
}
DumpExcel(dtResult);
#region old
// string runnigvaiable="";
// string fileName = Server.MapPath("/") + "Temp\\" + ddlReports.SelectedItem.Text.Trim() + ".xls";
// SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(fileName, SpreadsheetDocumentType.Workbook);
// // Add a WorkbookPart to the document.
// WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();
// workbookpart.Workbook = new Workbook();
// // Add a WorksheetPart to the WorkbookPart.
// WorksheetPart worksheetPart = workbookpart.AddNewPart<WorksheetPart>();
// worksheetPart.Worksheet = new Worksheet(new SheetData());
// // Add Sheets to the Workbook.
// Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.
// AppendChild<Sheets>(new Sheets());
// // Append a new worksheet and associate it with the workbook.
// var index = 0;
// for (int i = 0; i < chkRunnningVariables.Items.Count;i++)
// {
// if (chkRunnningVariables.Items[i].Selected)
// {
// runnigvaiable =chkRunnningVariables.Items[i].Value+"-"+ chkRunnningVariables.Items[i].Text ;
// break;
// }
// }
// Sheet sheet = new Sheet()
// {
// Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart),
// SheetId = 1,
// Name = runnigvaiable
// };
// var sheetData = new SheetData();
// var headerRow = new Row();
// List<String> columns = new List<string>();
// Cell cell = new Cell();
// cell.DataType = CellValues.String;
// columns.Add(dt[0].GeneralID+"-"+ dt[0].GeneralName );
// cell.CellValue = new CellValue(dt[0].GeneralID + "-" + dt[0].GeneralName);
// headerRow.AppendChild(cell);
// cell = new Cell();
// columns.Add(runningVariable);
// cell.CellValue = new CellValue(runningVariable);
// headerRow.AppendChild(cell);
// EpplusExcelDataProvider ep = new EpplusExcelDataProvider();
// sheetData.AppendChild(headerRow);
// Row newRow = new Row();
// foreach (var dsrow in dt)
// {
// foreach (String col in columns)
// {
// cell.CellValue = new CellValue(dsrow.Name.ToString()); //
// newRow.AppendChild(cell.CloneNode(true));
// }
// sheetData.AppendChild(newRow.CloneNode(true));
// }
//// sheet.AppendChild(sheetData.CloneNode(true));
// sheets.Append(sheetData);
// workbookpart.Workbook.Save();
// // Close the document.
// spreadsheetDocument.Close();
// //try
// //{
// // foreach (var dsrow in dt)
// // {
// // System.Data.OleDb.OleDbConnection MyConnection;
// // System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
// // string sql = null;
// // MyConnection =
// // new System.Data.OleDb.OleDbConnection(
// // "PROVIDER=Microsoft.ACE.OLEDB.12.0;Data Source='" + fileName + "';Extended Properties=Excel 8.0;");
// // MyConnection.Open();
// // myCommand.Connection = MyConnection;
// // sql = "Insert into [" + runnigvaiable + "] (" + dt[0].GeneralName + "," + runningVariable + ") values('5','e')";
// // myCommand.CommandText = sql;
// // myCommand.ExecuteNonQuery();
// // MyConnection.Close();
// // }
// //}
// //catch (Exception ex)
// //{
// // var x = ex.Message;
// //}
#endregion
}
