//[AuthorizeUser(ActionName = "Dosare", Recursive = false)]
public ActionResult SedinteIndex()
{
string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
int uid = Convert.ToInt32(Session["CURENT_USER_ID"]);
int sid = Convert.ToInt32(Session["ID_SOCIETATE"]);
SedintaPortalView spv = new SedintaPortalView(uid, conStr, DateTime.Now.Date, sid);
return(PartialView("SedintePortal", spv));
}
public void ExportTermeneToExcel(string _sort, string _order, string _filter, string _limit)
{
string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]);
int sid = Convert.ToInt32(Session["ID_SOCIETATE"]);
SedintaPortalView spv = new SedintaPortalView(_CURENT_USER_ID, conStr, DateTime.Now.Date, sid);
DataTable table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(spv.SedintePortal, Formatting.None, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = SOCISA.CommonFunctions.DATE_FORMAT
}), (typeof(DataTable)));
List <string> columns_to_remove = new List <string>();
foreach (DataColumn dc in table.Columns)
{
if (
!dc.ColumnName.ToLower().Equals("data") &&
!dc.ColumnName.ToLower().Contains("data_sedinta") &&
!dc.ColumnName.ToLower().Contains("instanta") &&
!dc.ColumnName.ToLower().Contains("ora") &&
!dc.ColumnName.ToLower().Contains("complet") &&
!dc.ColumnName.ToLower().Contains("nr_dosar_casco") &&
!dc.ColumnName.ToLower().Contains("nr_dosar_instanta") &&
!dc.ColumnName.ToLower().Contains("monitorizare")
)
{
columns_to_remove.Add(dc.ColumnName);
}
}
foreach (string col_name in columns_to_remove)
{
table.Columns.Remove(col_name);
}
using (ExcelPackage pack = new ExcelPackage())
{
ExcelWorksheet ws = pack.Workbook.Worksheets.Add("Termene");
ws.Cells["A1"].LoadFromDataTable(table, true);
var ms = new System.IO.MemoryStream();
pack.SaveAs(ms);
Response.BinaryWrite(ms.GetBuffer());
}
}
