public ActionResult Index() { IModulService objIMS = new ModulService(); var model = objIMS.GetAll(); return(View("~/Views/Master/Modul/Index.cshtml", model)); }
public ActionResult Download(Master_Menu model) { try { XLWorkbook xlWorkBook = new XLWorkbook(); var xlWorkSheet = xlWorkBook.Worksheets.Add("Master Modul");// xlWorkSheet; xlWorkSheet.Cell(1, 1).Value = "MenuId"; xlWorkSheet.Cell(1, 2).Value = "MenuName"; xlWorkSheet.Cell(1, 3).Value = "Text"; xlWorkSheet.Cell(1, 4).Value = "Order"; IModulService svc = new ModulService(); var Data = svc.GetAll(); int Row = 2; if (Data.Count > 0) { for (int i = 0; i < Data.Count; i++) { xlWorkSheet.Cell(Row + i, 1).Value = Data[i].MenuID; xlWorkSheet.Cell(Row + i, 2).Value = Data[i].MenuName; xlWorkSheet.Cell(Row + i, 3).Value = Data[i].Text; xlWorkSheet.Cell(Row + i, 4).Value = Data[i].OrderNumber; } xlWorkSheet.Columns().AdjustToContents(); var path = Server.MapPath("..") + "\\Master-Modul.xlsx"; xlWorkBook.SaveAs(path); xlWorkBook.Dispose(); return(File(path, "application/vnd.ms-excel", "Master-Modul.xlsx")); } return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("Function Download", ex.Message, ex.StackTrace); return(View("~/Views/Master/Function/Index.cshtml")); } }