public ActionResult Download(CUSTOMCOMPANY model) { try { XLWorkbook xlWorkBook = new XLWorkbook(); var xlWorkSheet = xlWorkBook.Worksheets.Add("Master Material");// xlWorkSheet; //xlWorkBook = xlApp.Workbooks.Add(Type.Missing); //xlWorkSheet = (Worksheet)xlWorkBook.Worksheets.get_Item(1); xlWorkSheet.Cell(1, 1).Value = "PLANTID"; xlWorkSheet.Cell(1, 1).Value = "MATERIALNUMBER"; xlWorkSheet.Cell(1, 2).Value = "DESCRIPTION"; xlWorkSheet.Cell(1, 3).Value = "MATERIALTYPE"; xlWorkSheet.Cell(1, 4).Value = "MATERIALGROUP"; xlWorkSheet.Cell(1, 5).Value = "OLDMATERIAL"; xlWorkSheet.Cell(1, 6).Value = "BOMMATERIAL"; xlWorkSheet.Cell(1, 7).Value = "BRAND"; xlWorkSheet.Cell(1, 8).Value = "MODEL"; xlWorkSheet.Cell(1, 9).Value = "GARDAN"; xlWorkSheet.Cell(1, 10).Value = "YEAR"; xlWorkSheet.Cell(1, 11).Value = "PURCHASEGROUPID"; xlWorkSheet.Cell(1, 12).Value = "MATERIALIDVENDOR"; xlWorkSheet.Cell(1, 13).Value = "PRICELIST"; IMaterialService svc = new MaterialService(); 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].MATERIALNUMBER; xlWorkSheet.Cell(Row + i, 2).Value = Data[i].DESCRIPTION; xlWorkSheet.Cell(Row + i, 3).Value = Data[i].MATERIALTYPE; xlWorkSheet.Cell(Row + i, 4).Value = Data[i].MATERIALGROUP; xlWorkSheet.Cell(Row + i, 5).Value = Data[i].OLDMATERIAL; xlWorkSheet.Cell(Row + i, 6).Value = Data[i].BOMMATERIAL; xlWorkSheet.Cell(Row + i, 7).Value = Data[i].BRAND; xlWorkSheet.Cell(Row + i, 8).Value = Data[i].MODEL; xlWorkSheet.Cell(Row + i, 9).Value = Data[i].GARDAN; xlWorkSheet.Cell(Row + i, 10).Value = Data[i].YEAR; xlWorkSheet.Cell(Row + i, 11).Value = Data[i].PURCHASEGROUPID; xlWorkSheet.Cell(Row + i, 12).Value = Data[i].MATERIALIDVENDOR; xlWorkSheet.Cell(Row + i, 13).Value = Data[i].PRICELIST; } xlWorkSheet.Columns().AdjustToContents(); var path = Server.MapPath("..") + "\\Master-Material.xlsx"; xlWorkBook.SaveAs(path); xlWorkBook.Dispose(); return(File(path, "application/vnd.ms-excel", "Master-Material.xlsx")); } return(RedirectToAction("Index")); } catch (Exception) { throw; } }
public CUSTOMCOMPANY AddCompany(CUSTOMCOMPANY model) { var dc = new eprocdbDataContext(); dc.CUSTOMCOMPANies.InsertOnSubmit(model); dc.SubmitChanges(); return(model); }
public ActionResult Download(CUSTOMCOMPANY model) { try { XLWorkbook xlWorkBook = new XLWorkbook(); var xlWorkSheet = xlWorkBook.Worksheets.Add("Master Company");// xlWorkSheet; xlWorkSheet.Cell(1, 1).Value = "COMPANYCODE"; xlWorkSheet.Cell(1, 2).Value = "COMPANYCODETSO"; xlWorkSheet.Cell(1, 3).Value = "COMPANYNAME"; xlWorkSheet.Cell(1, 4).Value = "ALAMAT"; xlWorkSheet.Cell(1, 5).Value = "KOTA"; xlWorkSheet.Cell(1, 6).Value = "REGION"; xlWorkSheet.Cell(1, 7).Value = "POSTALCODE"; xlWorkSheet.Cell(1, 8).Value = "TELEPON"; xlWorkSheet.Cell(1, 9).Value = "NPWP"; xlWorkSheet.Cell(1, 10).Value = "KTPTDP"; ICompanyService svc = new CompanyService(); 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].COMPANYCODE; xlWorkSheet.Cell(Row + i, 2).Value = Data[i].COMPANYCODETSO; xlWorkSheet.Cell(Row + i, 3).Value = Data[i].COMPANYNAME; xlWorkSheet.Cell(Row + i, 4).Value = Data[i].ALAMAT; xlWorkSheet.Cell(Row + i, 5).Value = Data[i].KOTA; xlWorkSheet.Cell(Row + i, 6).Value = Data[i].REGION; xlWorkSheet.Cell(Row + i, 7).Value = Data[i].POSTALCODE; xlWorkSheet.Cell(Row + i, 8).Value = Data[i].TELEPON; xlWorkSheet.Cell(Row + i, 9).Value = Data[i].NPWP; xlWorkSheet.Cell(Row + i, 10).Value = Data[i].KTPTDP; } xlWorkSheet.Columns().AdjustToContents(); var path = Server.MapPath("..") + "\\Master-Company.xlsx"; xlWorkBook.SaveAs(path); xlWorkBook.Dispose(); return(File(path, "application/vnd.ms-excel", "Master-Company.xlsx")); } return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("Company Edit", ex.Message, ex.StackTrace); return(View("~/Views/Master/Company/Index.cshtml", model)); } }
public ActionResult Edit(CUSTOMCOMPANY model) { try { ICompanyService svc = new CompanyService(); var result = svc.Edit(model.COMPANYCODE, model); return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("Company Edit", ex.Message, ex.StackTrace); return(View("~/Views/Master/Company/Index.cshtml")); } }
public ActionResult Add(CUSTOMCOMPANY model) { try { ICompanyService svc = new CompanyService(); var result = svc.Add(model); this.AddNotification("Your Data Has Been Successfully Saved. ", NotificationType.SUCCESS); return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("Company Add", ex.Message, ex.StackTrace); this.AddNotification("ID exist", NotificationType.ERROR); return(View("~/Views/Master/Company/Add.cshtml")); } }
public CUSTOMCOMPANY Edit(string companyId, CUSTOMCOMPANY model) { var dc = new eprocdbDataContext(); var md = (from c in dc.CUSTOMCOMPANies where c.COMPANYCODE == companyId select c).SingleOrDefault(); md.COMPANYNAME = model.COMPANYNAME; md.ALAMAT = model.ALAMAT; md.KOTA = model.KOTA; md.REGION = model.REGION; md.POSTALCODE = model.POSTALCODE; md.TELEPON = model.TELEPON; md.NPWP = model.NPWP; md.KTPTDP = model.KTPTDP; md.COMPANYCODETSO = model.COMPANYCODETSO; dc.SubmitChanges(); return(model); }
public CUSTOMCOMPANY UpdateCompany(string CompCode, CUSTOMCOMPANY model) { var dc = new eprocdbDataContext(); var md = (from c in dc.CUSTOMCOMPANies where c.COMPANYCODE == CompCode select c).SingleOrDefault(); md.COMPANYCODE = model.COMPANYCODE; md.COMPANYNAME = model.COMPANYNAME; md.ALAMAT = model.ALAMAT; md.KOTA = model.KOTA; md.REGION = model.REGION; md.POSTALCODE = model.POSTALCODE; md.TELEPON = model.TELEPON; md.NPWP = model.NPWP; md.KTPTDP = model.KTPTDP; md.COMPANYCODETSO = model.COMPANYCODETSO; md.DIUBAHOLEH = model.DIUBAHOLEH; md.DIUBAHTGL = model.DIUBAHTGL; dc.SubmitChanges(); return(model); }
public ActionResult Index(HttpPostedFileBase postedFile, CUSTOMFILEUPLOAD model, string DdlMasterType) { string filePath = string.Empty; if (postedFile != null) { string path = Server.MapPath("~/Uploads/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } string tahun = DateTime.Now.Year.ToString(); string bulan = DateTime.Now.Month.ToString(); string tgl = DateTime.Now.Day.ToString(); string jam = DateTime.Now.Hour.ToString(); string menit = DateTime.Now.Minute.ToString(); string detik = DateTime.Now.Second.ToString(); string tanggalSekarang = "_" + tahun + bulan + tgl + jam + menit + detik; string type = ""; if (DdlMasterType == "CUSTOMCOMPANY") { type = "CUSTOMCOMPANY"; } else if (DdlMasterType == "MSMATERIAL") { type = "MSMATERIAL"; } else if (DdlMasterType == "MSPLANT") { type = "MSPLANT"; } else if (DdlMasterType == "MSVENDOR") { type = "MSVENDOR"; } else if (DdlMasterType == "MSUSER") { type = "MSUSER"; } string FileName = type + tanggalSekarang + ".xls"; filePath = path + FileName; try { postedFile.SaveAs(filePath); IUploadVehicleService svcUploadFilename = new UploadVehicleService(); model.ID = Convert.ToInt32(UploadVehicleService.GenerateID()); model.FILEUPLOAD = FileName; model.MODIFIED_BY = "UserName"; model.MODIFIED_DATE = DateTime.Now; svcUploadFilename.Add(model); DataTable dt = postedFile.ToDataTable(); #region Insert #region CUSTOMCOMPANY if (type == "CUSTOMCOMPANY") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["COMPANYCODE"] != DBNull.Value) { var dc = new eprocdbDataContext(); //cek code ada atau tidak var compCode = (from c in dc.CUSTOMCOMPANies where c.COMPANYCODE == row["COMPANYCODE"].ToString() select new { c.COMPANYCODE }).ToList(); string code = string.Empty; foreach (var value in compCode) { code = value.COMPANYCODE; } //isi model customcompany sesuai row data table CUSTOMCOMPANY objModelComp = new CUSTOMCOMPANY(); objModelComp.COMPANYCODE = row["COMPANYCODE"].ToString(); objModelComp.COMPANYNAME = row["COMPANYNAME"].ToString(); objModelComp.ALAMAT = row["ALAMAT"].ToString(); objModelComp.KOTA = row["KOTA"].ToString(); objModelComp.REGION = row["REGION"].ToString(); objModelComp.POSTALCODE = row["POSTALCODE"].ToString(); objModelComp.TELEPON = row["TELEPON"].ToString(); objModelComp.NPWP = row["NPWP"].ToString(); objModelComp.KTPTDP = row["KTPTDP"].ToString(); objModelComp.COMPANYCODETSO = row["COMPANYCODETSO"].ToString(); //jika ada update if (code.ToString() != "") { objModelComp.DIUBAHOLEH = Session["UserID"].ToString(); objModelComp.DIUBAHTGL = DateTime.Now.Date; IUploadMasterService svc = new UploadMasterService(); var result = svc.UpdateCompany(row["COMPANYCODE"].ToString(), objModelComp); } //jika tidak ada Insert else { objModelComp.DIBUATOLEH = Session["UserID"].ToString(); objModelComp.DIBUATTGL = DateTime.Now.Date; IUploadMasterService svc = new UploadMasterService(); var result = svc.AddCompany(objModelComp); } } } } #endregion #region MSMATERIAL if (type == "MSMATERIAL") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["MATERIALNUMBER"] != DBNull.Value) { var dc = new eprocdbDataContext(); //cek code ada atau tidak var materialNumber = (from c in dc.MSMATERIALs where c.MATERIALNUMBER == row["MATERIALNUMBER"].ToString() select new { c.MATERIALNUMBER }).ToList(); string code = string.Empty; foreach (var value in materialNumber) { code = value.MATERIALNUMBER; } //isi model MSMATERIAL sesuai row data table MSMATERIAL objModelMaterial = new MSMATERIAL(); objModelMaterial.MATERIALNUMBER = row["MATERIALNUMBER"].ToString(); //objModelMaterial.DESCRIPTION = row["DESCRIPTION"].ToString(); //objModelMaterial.MATERIALTYPE = row["MATERIALTYPE"].ToString(); //objModelMaterial.MATERIALGROUP = row["MATERIALGROUP"].ToString(); //objModelMaterial.OLDMATERIAL = row["OLDMATERIAL"].ToString(); //objModelMaterial.BOMMATERIAL = row["BOMMATERIAL"].ToString(); //objModelMaterial.BRAND = row["BRAND"].ToString(); //objModelMaterial.MODEL = row["MODEL"].ToString(); //objModelMaterial.GARDAN = row["GARDAN"].ToString(); //objModelMaterial.YEAR = row["YEAR"].ToString(); //objModelMaterial.PURCHASEGROUPID = row["PURCHASEGROUPID"].ToString(); objModelMaterial.MATERIALIDVENDOR = row["MATERIALIDVENDOR"].ToString(); //double price = 0; //Double.TryParse(row["PRICELIST"].ToString(), out price); //objModelMaterial.PRICELIST = price; //jika ada update if (code.ToString() != "") { IUploadMasterService svc = new UploadMasterService(); var result = svc.UpdateMaterial(row["MATERIALNUMBER"].ToString(), objModelMaterial); } //jika tidak ada Insert else { IUploadMasterService svc = new UploadMasterService(); //var result = svc.AddMaterial(objModelMaterial); } } } } #endregion #region MSPLANT if (type == "MSPLANT") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["PLANTID"] != DBNull.Value) { var dc = new eprocdbDataContext(); //cek code ada atau tidak var plantID = (from c in dc.MSPLANTs where c.PLANTID == row["PLANTID"].ToString() select new { c.PLANTID }).ToList(); string code = string.Empty; foreach (var value in plantID) { code = value.PLANTID; } //isi model MSPLANT sesuai row data table MSPLANT objModelPlant = new MSPLANT(); objModelPlant.PLANTID = row["PLANTID"].ToString(); objModelPlant.NAME = row["NAME"].ToString(); objModelPlant.ALAMAT = row["ALAMAT"].ToString(); objModelPlant.KELURAHAN = row["KELURAHAN"].ToString(); objModelPlant.KECAMATAN = row["KECAMATAN"].ToString(); objModelPlant.CITY = row["CITY"].ToString(); objModelPlant.REGION = row["REGION"].ToString(); objModelPlant.CONTACTPERSONNAME = row["CONTACTPERSONNAME"].ToString(); objModelPlant.ALAMAT2 = row["ALAMAT2"].ToString(); objModelPlant.ALAMAT3 = row["ALAMAT3"].ToString(); objModelPlant.ALAMAT4 = row["ALAMAT4"].ToString(); objModelPlant.ALAMAT5 = row["ALAMAT5"].ToString(); objModelPlant.PROPINSI = row["PROPINSI"].ToString(); objModelPlant.PIC = row["PIC"].ToString(); objModelPlant.TITLECP = row["TITLECP"].ToString(); objModelPlant.NOHPCP = row["NOHPCP"].ToString(); objModelPlant.NOTELPPLANT = row["NOTELPPLANT"].ToString(); objModelPlant.POSTALCODE = row["POSTALCODE"].ToString(); objModelPlant.CUSTOMERNO = row["CUSTOMER_NUMBER"].ToString(); //jika ada update if (code.ToString() != "") { IUploadMasterService svc = new UploadMasterService(); var result = svc.UpdatePlant(row["PLANTID"].ToString(), objModelPlant); } //jika tidak ada Insert else { IUploadMasterService svc = new UploadMasterService(); var result = svc.AddPlant(objModelPlant); } } } } #endregion #region MSVENDOR if (type == "MSVENDOR") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["VENDORID"] != DBNull.Value) { var dc = new eprocdbDataContext(); //cek code ada atau tidak var vendorID = (from c in dc.MSVENDORs where c.VENDORID == row["VENDORID"].ToString() select new { c.VENDORID }).ToList(); string code = string.Empty; foreach (var value in vendorID) { code = value.VENDORID; } //isi model MSVENDOR sesuai row data table MSVENDOR objModelVendor = new MSVENDOR(); objModelVendor.VENDORID = row["VENDORID"].ToString(); //objModelVendor.VENDORNAME = row["VENDORNAME"].ToString(); //objModelVendor.STREET = row["STREET"].ToString(); //objModelVendor.DISTRIC = row["DISTRIC"].ToString(); //objModelVendor.CITY = row["CITY"].ToString(); //objModelVendor.POSTALCODE = row["POSTALCODE"].ToString(); //objModelVendor.TELEPHONE = row["TELEPHONE"].ToString(); //objModelVendor.EMAIL = row["EMAIL"].ToString(); //objModelVendor.EMAIL2 = row["EMAIL2"].ToString(); //objModelVendor.EMAIL3 = row["EMAIL3"].ToString(); //objModelVendor.EMAIL4 = row["EMAIL4"].ToString(); //objModelVendor.EMAIL5 = row["EMAIL5"].ToString(); //objModelVendor.EMAIL6 = row["EMAIL6"].ToString(); //objModelVendor.EMAIL7 = row["EMAIL7"].ToString(); //objModelVendor.EMAIL8 = row["EMAIL8"].ToString(); //objModelVendor.PLANTIDTSO = row["PLANTIDTSO"].ToString(); objModelVendor.B2B = row["ISB2B"].ToString() == "1" ? '1' : '0'; //jika ada update if (code.ToString() != "") { IUploadMasterService svc = new UploadMasterService(); var result = svc.UpdateVendor(row["VENDORID"].ToString(), objModelVendor); } //jika tidak ada Insert else { //IUploadMasterService svc = new UploadMasterService(); //var result = svc.AddVendor(objModelVendor); } } } } #endregion #region MSUSER if (type == "MSUSER") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["UserId"] != DBNull.Value) { var dc = new eprocdbDataContext(); //cek code ada atau tidak var UserId = (from c in dc.Master_Users where c.UserID == row["UserId"].ToString() select new { c.UserID }).ToList(); string code = string.Empty; foreach (var value in UserId) { code = value.UserID; } //isi model MSVENDOR sesuai row data table Master_User objModelUser = new Master_User(); objModelUser.UserID = row["UserId"].ToString(); objModelUser.FullName = row["NamaLengkap"].ToString(); objModelUser.GroupID = row["Group"].ToString(); objModelUser.id_vendor = row["IdVendor"].ToString(); //jika ada update if (code.ToString() != "") { IUploadMasterService svc = new UploadMasterService(); var result = svc.UpdateUser(row["UserId"].ToString(), objModelUser); } //jika tidak ada Insert else { IUploadMasterService svc = new UploadMasterService(); var result = svc.AddUser(objModelUser); } } } } #endregion #endregion if (filePath != null || filePath != string.Empty) { if ((System.IO.File.Exists(filePath))) { System.IO.File.Delete(filePath); } } this.AddNotification("File uploaded successfully.", NotificationType.SUCCESS); } catch (Exception ex) { general.AddLogError("Upload Master", ex.Message, ex.StackTrace); this.AddNotification("File uploaded failed.", NotificationType.ERROR); return(View("~/Views/Master/UploadMaster/Index.cshtml")); throw ex; } } return(View("~/Views/Master/UploadMaster/Index.cshtml")); }