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"));
}
