public ActionResult Download(AksesGroupViewModel model) { try { XLWorkbook xlWorkBook = new XLWorkbook(); var xlWorkSheet = xlWorkBook.Worksheets.Add("Master AksesGroup");// xlWorkSheet; xlWorkSheet.Cell(1, 1).Value = "GroupId"; xlWorkSheet.Cell(1, 2).Value = "Deskripsi"; IAksesGroupService svc = new AksesGroupService(); 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].GroupID; xlWorkSheet.Cell(Row + i, 2).Value = Data[i].Description; } xlWorkSheet.Columns().AdjustToContents(); var path = Server.MapPath("..") + "\\Master-AksesGroup.xlsx"; xlWorkBook.SaveAs(path); xlWorkBook.Dispose(); return(File(path, "application/vnd.ms-excel", "Master-AksesGroup.xlsx")); } return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("Akses Group", ex.Message, ex.StackTrace); return(View("~/Views/Master/AksesGroup/Index.cshtml")); } }
public ActionResult Add() { IAksesGroupService svc = new AksesGroupService(); var model = svc.GetAllMenu(); var viewModel = new AksesGroupViewModel() { AksesGroup = new Master_Group(), Menu = model }; return(View("~/Views/Master/AksesGroup/Add.cshtml", viewModel)); }
public ActionResult Add(AksesGroupViewModel model) { try { IAksesGroupService svc = new AksesGroupService(); var result = svc.Add(model.AksesGroup); this.AddNotification("Your Data Has Been Successfully Saved. ", NotificationType.SUCCESS); return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("AksesGroup Add", ex.Message, ex.StackTrace); this.AddNotification("ID exist", NotificationType.ERROR); return(View("~/Views/Master/AksesGroup/Add.cshtml")); } }