private void PrepareSelectLists() { using (var fpsrv = new FailPropertiesService()) { using (var plantService = new PlantService()) { using (var securityService = new SecurityService()) { ViewBag.FailProperties = new SelectList(fpsrv.GetAll(), "ID", "Code"); ViewBag.Plants = new SelectList(plantService.GetAll(), "ID", "Code"); var qcTechItems = securityService.GetAll().ToList(); var leadOpItems = securityService.GetAll().ToList(); var supervisorItems = securityService.GetAll().ToList(); var managerItems = securityService.GetAll().ToList(); ViewBag.QCTechs = new SelectList(qcTechItems, "ID", "FullName"); ViewBag.LeadOperators = new SelectList(leadOpItems, "ID", "FullName"); ViewBag.Supervisors = new SelectList(supervisorItems, "ID", "FullName"); ViewBag.Managers = new SelectList(managerItems, "ID", "FullName"); } } } }
// GET: Vendor public ActionResult Index() { IPlantService svc = new PlantService(); var model = svc.GetAll(); return(View("~/Views/Master/Plant/Index.cshtml", model)); }
public IEnumerable <Plant> Get() { return(_plantService.GetAll()); }
public FileResult Download() { XLWorkbook xlWorkBook = new XLWorkbook(); var xlWorkSheet = xlWorkBook.Worksheets.Add("Master Plant"); IPlantService svc = new PlantService(); var model = svc.GetAll(); xlWorkSheet.Cell(1, 1).Value = "PLANTID"; xlWorkSheet.Cell(1, 2).Value = "NAME"; xlWorkSheet.Cell(1, 3).Value = "ALAMAT"; xlWorkSheet.Cell(1, 4).Value = "KELURAHAN"; xlWorkSheet.Cell(1, 5).Value = "KECAMATAN"; xlWorkSheet.Cell(1, 6).Value = "CITY"; xlWorkSheet.Cell(1, 7).Value = "REGION"; xlWorkSheet.Cell(1, 8).Value = "CONTACTPERSONNAME"; xlWorkSheet.Cell(1, 9).Value = "ALAMAT2"; xlWorkSheet.Cell(1, 10).Value = "ALAMAT3"; xlWorkSheet.Cell(1, 11).Value = "ALAMAT4"; xlWorkSheet.Cell(1, 12).Value = "ALAMAT5"; xlWorkSheet.Cell(1, 13).Value = "PROPINSI"; xlWorkSheet.Cell(1, 14).Value = "PIC"; xlWorkSheet.Cell(1, 15).Value = "TITLECP"; xlWorkSheet.Cell(1, 16).Value = "NOHPCP"; xlWorkSheet.Cell(1, 17).Value = "NOTELPPLANT"; xlWorkSheet.Cell(1, 18).Value = "POSTALCODE"; xlWorkSheet.Cell(1, 19).Value = "CUSTOMER_NUMBER"; xlWorkSheet.Range("A1", "T1").Style.Font.Bold = true; int i = 2; foreach (var m in model) { xlWorkSheet.Cell(i, 1).Value = m.PLANTID; xlWorkSheet.Cell(i, 2).Value = m.NAME; xlWorkSheet.Cell(i, 3).Value = m.ALAMAT; xlWorkSheet.Cell(i, 4).Value = m.KELURAHAN; xlWorkSheet.Cell(i, 5).Value = m.KECAMATAN; xlWorkSheet.Cell(i, 6).Value = m.CITY; xlWorkSheet.Cell(i, 7).Value = m.REGION; xlWorkSheet.Cell(i, 8).Value = m.CONTACTPERSONNAME; xlWorkSheet.Cell(i, 9).Value = m.ALAMAT2; xlWorkSheet.Cell(i, 10).Value = m.ALAMAT3; xlWorkSheet.Cell(i, 11).Value = m.ALAMAT4; xlWorkSheet.Cell(i, 12).Value = m.ALAMAT5; xlWorkSheet.Cell(i, 13).Value = m.PROPINSI; xlWorkSheet.Cell(i, 14).Value = m.PIC; xlWorkSheet.Cell(i, 15).Value = m.TITLECP; xlWorkSheet.Cell(i, 16).Value = m.NOHPCP; xlWorkSheet.Cell(i, 17).Value = m.NOTELPPLANT; xlWorkSheet.Cell(i, 18).Value = m.POSTALCODE; xlWorkSheet.Cell(i, 19).Value = m.CUSTOMERNO; i++; } xlWorkSheet.Columns().AdjustToContents(); var path = Server.MapPath("..") + "\\Master-Plant.xlsx"; xlWorkBook.SaveAs(path); xlWorkBook.Dispose(); return(File(path, "application/vnd.ms-excel", "Master-Plant.xlsx")); }