public ActionResult Download(CUSTOMCITY model) { try { XLWorkbook xlWorkBook = new XLWorkbook(); var xlWorkSheet = xlWorkBook.Worksheets.Add("Master City");// xlWorkSheet; xlWorkSheet.Cell(1, 1).Value = "CityId"; xlWorkSheet.Cell(1, 2).Value = "CityName"; ICityService svc = new CityService(); 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].CITYID; xlWorkSheet.Cell(Row + i, 2).Value = Data[i].CITYNAME; } xlWorkSheet.Columns().AdjustToContents(); var path = Server.MapPath("..") + "\\Master-City.xlsx"; xlWorkBook.SaveAs(path); xlWorkBook.Dispose(); return(File(path, "application/vnd.ms-excel", "Master-City.xlsx")); } return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("Akses Group", ex.Message, ex.StackTrace); return(View("~/Views/Master/City/Index.cshtml")); } }
public CUSTOMCITY Add(CUSTOMCITY model) { var dc = new eprocdbDataContext(); dc.CUSTOMCITies.InsertOnSubmit(model); dc.SubmitChanges(); return(model); }
public ActionResult Edit(string cityId, CUSTOMCITY model) { try { ICityService svc = new CityService(); var result = svc.Edit(cityId, model); return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("City Edit", ex.Message, ex.StackTrace); return(View("~/Views/Master/City/Index.cshtml")); } }
public CUSTOMCITY Edit(string cityId, CUSTOMCITY model) { var dc = new eprocdbDataContext(); var md = (from c in dc.CUSTOMCITies where c.CITYID == cityId select c).SingleOrDefault(); md.CITYNAME = model.CITYNAME; if (model.STATUS == null) { md.STATUS = md.STATUS; } else { md.STATUS = model.STATUS; } dc.SubmitChanges(); return(model); }
public ActionResult Add(CUSTOMCITY model) { try { ICityService svc = new CityService(); var result = svc.Add(model); this.AddNotification("Your Data Has Been Successfully Saved. ", NotificationType.SUCCESS); return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("City Add", ex.Message, ex.StackTrace); this.AddNotification("ID exist", NotificationType.ERROR); this.ViewBag.Status = new SelectList(this.GetStatus(), "Key", "Value"); return(View("~/Views/Master/City/Add.cshtml")); } }