public CUSTOMFILEUPLOAD Add(CUSTOMFILEUPLOAD model) { var dc = new eprocdbDataContext(); dc.CUSTOMFILEUPLOADs.InsertOnSubmit(model); dc.SubmitChanges(); return(model); }
public ActionResult Index(HttpPostedFileBase postedFile, CUSTOMFILEUPLOAD model, string DdlForm) { string filePath = string.Empty; List <ErrorUploadViewModel> errorUpload = new List <ErrorUploadViewModel>(); 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 (DdlForm == "1") { type = "Delivery"; } else if (DdlForm == "2") { type = "Invoice"; } else if (DdlForm == "3") { type = "BPKB"; } string FileName = type + tanggalSekarang + ".xls"; filePath = path + FileName; try { postedFile.SaveAs(filePath); IUploadVehicleService svc = new UploadVehicleService(); model.ID = Convert.ToInt32(UploadVehicleService.GenerateID()); model.FILEUPLOAD = FileName; model.MODIFIED_BY = "namaUser"; model.MODIFIED_DATE = DateTime.Now.Date; var result = svc.Add(model); DataTable dt = postedFile.ToDataTable(); #region Insert #region Delivery if (type == "Delivery") { int i = 1; foreach (DataRow row in dt.Rows) { IUploadVendorService svcUpldVendor = new UploadVendorService(); bool AutheticateData = svcUpldVendor.CheckAutheicatePoNumberByVendorID(row["PONUMBER"].ToString(), System.Web.HttpContext.Current.Session["VendorID"].ToString()); //cek row null atau tidak if (row["PONUMBER"] != DBNull.Value) { if (!svcUpldVendor.IfExist(row["PONUMBER"].ToString())) { //create new model ErrorUploadViewModel error = new ErrorUploadViewModel(); error.row = i; error.column = "PONUMBER"; error.message = "PONUMBER doesn't exis"; errorUpload.Add(error); } else { if (System.Web.HttpContext.Current.Session["GroupID"].ToString() == "Super" || System.Web.HttpContext.Current.Session["GroupID"].ToString() == "PROCUREMENT" || !AutheticateData) { //create new model ErrorUploadViewModel error = new ErrorUploadViewModel(); error.row = i; error.column = "PONUMBER"; error.message = "PONUMBER AND VENDOR ID NOT MATCH"; errorUpload.Add(error); } else { var dc = new eprocdbDataContext(); #region CUSTOMPO CUSTOMPO customPO = new CUSTOMPO(); customPO.HARGADPP_INPUT = TryParseNullDouble(row["HARGADPP_INPUT"].ToString()); customPO.HARGAPPNUNIT_INPUT = TryParseNullDouble(row["HARGAPPNUNIT_INPUT"].ToString());; customPO.HARGABBN_INPUT = TryParseNullDouble(row["HARGABBN_INPUT"].ToString()); customPO.DODATE = TryParseNull(row["DODATE"].ToString()); customPO.DONUMBER = row["DONUMBER"].ToString(); customPO.CARROSERIEVENDORNAME = row["CARROSERIEVENDORNAME"].ToString(); customPO.ACCESORIESADDRESS = row["ACCESORIESADDRESS"].ToString(); customPO.REMARKSCARROSSERIE = row["REMARKSCARROSSERIE"].ToString(); customPO.TGLMASUKKAROSERI = TryParseNull(row["TGLMASUKKAROSERI"].ToString()); customPO.TGLSELESAIKAROSERI = TryParseNull(row["TGLSELESAIKAROSERI"].ToString()); customPO.REMARKS = row["REMARKS"].ToString(); customPO.MODIFIED_BY = Session["UserID"].ToString(); customPO.MODIFIED_DATE = DateTime.Now.Date; customPO.ACTUALDATEDELIVEREDUNIT = TryParseNull(row["TANGGALBSTB"].ToString()); var resultPO = svcUpldVendor.UpdateDeliveryCustPO(row["PONUMBER"].ToString(), customPO); #endregion #region CUSTOMBPKB CUSTOMBPKB customBPKB = new CUSTOMBPKB(); customBPKB.NOPOLISI_INPUT = row["NOPOLISI_INPUT"].ToString(); customBPKB.TGLSTNK_INPUT = TryParseNull(row["TGLSTNK_INPUT"].ToString()); customBPKB.STCKDATE = TryParseNull(row["STCKDATE"].ToString()); customBPKB.TGLSERAHBPKB = TryParseNull(row["TGLSERAHBPKB"].ToString()); customPO.MODIFIED_BY = Session["UserID"].ToString(); customPO.MODIFIED_DATE = DateTime.Now.Date; var resultBPKB = svcUpldVendor.UpdateDeliveryCustBPKB(row["PONUMBER"].ToString(), customBPKB); #endregion #region CUSTOMGR CUSTOMGR customGR = new CUSTOMGR(); customGR.NOCHASIS_INPUT = row["NOCHASIS_INPUT"].ToString(); customGR.NOENGINE_INPUT = row["NOENGINE_INPUT"].ToString(); customPO.MODIFIED_BY = Session["UserID"].ToString(); customPO.MODIFIED_DATE = DateTime.Now.Date; var resultGR = svcUpldVendor.UpdateDeliveryCustGR(row["PONUMBER"].ToString(), customGR); #endregion } } } } i++; } #endregion #region Invoice if (type == "Invoice") { int i = 1; foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["PONUMBER"] != DBNull.Value) { IUploadVendorService svcUpldVendor = new UploadVendorService(); bool AutheticateData = svcUpldVendor.CheckAutheicatePoNumberByVendorID(row["PONUMBER"].ToString(), System.Web.HttpContext.Current.Session["VendorID"].ToString()); if (!svcUpldVendor.IfExist(row["PONUMBER"].ToString())) { //create new model ErrorUploadViewModel error = new ErrorUploadViewModel(); error.row = i; error.column = "PONUMBER"; error.message = "PONUMBER doesn't exist"; errorUpload.Add(error); } else { if (System.Web.HttpContext.Current.Session["GroupID"].ToString() == "Super" || System.Web.HttpContext.Current.Session["GroupID"].ToString() == "PROCUREMENT" || !AutheticateData) { //create new model ErrorUploadViewModel error = new ErrorUploadViewModel(); error.row = i; error.column = "PONUMBER"; error.message = "PONUMBER AND VENDOR ID NOT MATCH"; errorUpload.Add(error); } else { var dc = new eprocdbDataContext(); #region CUSTOMPO CUSTOMPO customPO = new CUSTOMPO(); customPO.TGLGI = TryParseNull(row["TGLGI"].ToString()); customPO.MODIFIED_BY = Session["UserID"].ToString(); customPO.MODIFIED_DATE = DateTime.Now.Date; var resultPO = svcUpldVendor.UpdateInvoiceCustPO(row["PONUMBER"].ToString(), customPO); #endregion #region CUSTOMBPKB CUSTOMBPKB customBpkb = new CUSTOMBPKB(); customBpkb.NOFAKTUR = row["NOFAKTUR"].ToString(); customBpkb.MODIFIED_BY = Session["UserID"].ToString(); customBpkb.MODIFIED_DATE = DateTime.Now.Date; var resultBPKB = svcUpldVendor.UpdateInvoiceCustBpkb(row["PONUMBER"].ToString(), customBpkb); #endregion #region CUSTOMGR CUSTOMGR customGR = new CUSTOMGR(); customGR.STATUSDELIVERYUNIT = row["STATUSDELIVERYUNIT"].ToString(); customGR.MODIFIED_BY = Session["UserID"].ToString(); customGR.MODIFIED_DATE = DateTime.Now.Date; var resultGR = svcUpldVendor.UpdateInvoiceCustGR(row["PONUMBER"].ToString(), customGR); #endregion #region CUSTOMIR CUSTOMIR customIR = new CUSTOMIR(); customIR.INVNO = row["INVNO"].ToString(); customIR.INVDATE = TryParseNull(row["INVDATE"].ToString()); customIR.MODIFIED_BY = Session["UserID"].ToString(); customIR.MODIFIED_DATE = DateTime.Now.Date; var resultIR = svcUpldVendor.UpdateInvoiceCustIR(row["PONUMBER"].ToString(), customIR); #endregion } } } i++; } } #endregion #region Bpkb if (type == "BPKB") { int i = 1; foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["PONUMBER"] != DBNull.Value) { IUploadVendorService svcUpldVendor = new UploadVendorService(); bool AutheticateData = svcUpldVendor.CheckAutheicatePoNumberByVendorID(row["PONUMBER"].ToString(), System.Web.HttpContext.Current.Session["VendorID"].ToString()); if (!svcUpldVendor.IfExist(row["PONUMBER"].ToString())) { //create new model ErrorUploadViewModel error = new ErrorUploadViewModel(); error.row = i; error.column = "PONUMBER"; error.message = "PONUMBER doesn't exist"; errorUpload.Add(error); } else { if (System.Web.HttpContext.Current.Session["GroupID"].ToString() == "Super" || System.Web.HttpContext.Current.Session["GroupID"].ToString() == "PROCUREMENT" || !AutheticateData) { //create new model ErrorUploadViewModel error = new ErrorUploadViewModel(); error.row = i; error.column = "PONUMBER"; error.message = "PONUMBER AND VENDOR ID NOT MATCH"; errorUpload.Add(error); } else { var dc = new eprocdbDataContext(); #region CUSTOMBPKB CUSTOMBPKB customBPKB = new CUSTOMBPKB(); customBPKB.ACTUALDELIVERYBPKBTOFINANCE = TryParseNull(row["ACTUALDELIVERYBPKBTOFINANCE"].ToString()); customBPKB.ACTUALRECEIVEDBPKBDICAB = TryParseNull(row["ACTUALRECEIVEDBPKBDICAB"].ToString()); customBPKB.KETBPKB = row["KETBPKB"].ToString(); customBPKB.NOBPKB = row["NOBPKB"].ToString(); customBPKB.KETSURATUBAHBENTUK = row["KETSURATUBAHBENTUK"].ToString(); customBPKB.KETERANGANSURATRUBAHWARNA = row["KETERANGANSURATRUBAHWARNA"].ToString(); customBPKB.NOFAKTUR = row["NOFAKTUR"].ToString(); customBPKB.TGLFAKTUR = TryParseNull(row["TGLFAKTUR"].ToString()); customBPKB.NOSERTIFIKAT = row["NOSERTIFIKAT"].ToString(); customBPKB.TGLSERTIFIKAT = TryParseNull(row["TGLSERTIFIKAT"].ToString()); customBPKB.NOFORMULIRA = row["NOFORMULIRA"].ToString(); customBPKB.TGLFORMULIRA = TryParseNull(row["TGLFORMULIRA"].ToString()); customBPKB.NOSURATUBAHBENTUK = row["NOSURATUBAHBENTUK"].ToString(); customBPKB.TGLSURATUBAHBENTUK = TryParseNull(row["TGLSURATUBAHBENTUK"].ToString()); customBPKB.NOSURATRUBAHWARNA = row["NOSURATRUBAHWARNA"].ToString(); customBPKB.TANGGALSURATRUBAHWARNA = TryParseNull(row["TANGGALSURATRUBAHWARNA"].ToString()); customBPKB.NOSERTIFIKATREGUJITIPE = row["NOSERTIFIKATREGUJITIPE"].ToString(); customBPKB.ACTUALRECEIVEDBPKBDIHO = TryParseNull(row["ACTUALRECEIVEDBPKBDIHO"].ToString()); customBPKB.ACTUALDELIVERYBPKBTOFINANCE = TryParseNull(row["ACTUALDELIVERYBPKBTOFINANCE"].ToString()); customBPKB.ACTUALRECEIVEDBPKBHOBACK = TryParseNull(row["ACTUALRECEIVEDBPKBHOBACK"].ToString()); customBPKB.DATEDELIVERYTOBRANCHORVENDOR = TryParseNull(row["DATEDELIVERYTOBRANCHORVENDOR"].ToString()); customBPKB.REMARKSDETAILPROBLEM = row["REMARKSDETAILPROBLEM"].ToString(); customBPKB.MODIFIED_BY = Session["UserID"].ToString(); customBPKB.MODIFIED_DATE = DateTime.Now.Date; var resultBPKB = svcUpldVendor.UpdateBpkbCustBPKB(row["PONUMBER"].ToString(), customBPKB); #endregion } } } i++; } } #endregion #endregion if (filePath != null || filePath != string.Empty) { if ((System.IO.File.Exists(filePath))) { System.IO.File.Delete(filePath); } } if (errorUpload.Count > 0) { this.AddNotification("File uploaded failed.", NotificationType.ERROR); } else { this.AddNotification("File uploaded successfully.", NotificationType.SUCCESS); } } catch (Exception ex) { general.AddLogError("Upload Vendor", ex.Message, ex.StackTrace); this.AddNotification("File uploaded failed.", NotificationType.ERROR); return(View("~/Views/Upload/Vendor/Index.cshtml")); throw ex; } } IEnumerable <ErrorUploadViewModel> eu = errorUpload; return(View("~/Views/Upload/Vendor/Index.cshtml", eu)); }
public ActionResult Index(HttpPostedFileBase postedFile, CUSTOMFILEUPLOAD model, string DdlForm) { 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 (DdlForm == "1") { type = "Delivery"; } else if (DdlForm == "2") { type = "Invoice"; } else if (DdlForm == "3") { type = "BPKB"; } string FileName = type + tanggalSekarang + ".xls"; filePath = path + FileName; string errorPoNumber = string.Empty; try { postedFile.SaveAs(filePath); IUploadVehicleService svc = new UploadVehicleService(); model.ID = Convert.ToInt32(UploadVehicleService.GenerateID()); model.FILEUPLOAD = FileName; model.MODIFIED_BY = "namaUser"; model.MODIFIED_DATE = DateTime.Now.Date; var result = svc.Add(model); DataTable dt = postedFile.ToDataTable(); #region Insert #region Delivery if (type == "Delivery") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["PONUMBER"] != DBNull.Value) { var dc = new eprocdbDataContext(); IUploadVehicleService svcUpldVehicle = new UploadVehicleService(); #region CUSTOMPO CUSTOMPO customPO = new CUSTOMPO(); customPO.PURCHASESTATUS = row["PURCHASESTATUS"].ToString(); customPO.CARROSERIEVENDORNAME = row["CARROSERIEVENDORNAME"].ToString(); customPO.ACCESORIESADDRESS = row["ACCESORIESADDRESS"].ToString(); customPO.REMARKSCARROSSERIE = row["REMARKSCARROSSERIE"].ToString(); customPO.PICKAROSERI = row["PICKAROSERI"].ToString(); customPO.NOTELEPONKAROSERI = row["NOTELEPONKAROSERI"].ToString(); customPO.BENTUKKAROSERI = row["BENTUKKAROSERI"].ToString(); customPO.PROMISEDLVDATEPO = TryParseNull(row["PROMISEDLVDATEPO"].ToString()); customPO.TGLSELESAIKAROSERI = TryParseNull(row["PROMISEDLVDATEPO"].ToString()); //DateTime BSTB; //DateTime.TryParse(row["TANGGALBSTB"].ToString(), out BSTB); //customPO.ACTUALDATEDELIVEREDUNIT = BSTB; customPO.REMARKS = row["REMARKS"].ToString(); customPO.MODIFIED_BY = Session["UserID"].ToString(); customPO.MODIFIED_DATE = DateTime.Now.Date; var resultPO = svcUpldVehicle.UpdateDeliveryCustPO(row["PONUMBER"].ToString(), customPO); #endregion } } } #endregion #region Invoice if (type == "Invoice") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["PONUMBER"] != DBNull.Value) { var dc = new eprocdbDataContext(); IUploadVehicleService svcUpldVehicle = new UploadVehicleService(); #region CUSTOMPO CUSTOMPO customPO = new CUSTOMPO(); customPO.TGLMASUKKAROSERI = TryParseNull(row["TGLMASUKKAROSERI"].ToString()); customPO.DONUMBER = row["DONUMBER"].ToString(); customPO.DODATE = TryParseNull(row["DODATE"].ToString()); customPO.REASONREVISEDBYVENDOR = row["REASONREVISEDBYVENDOR"].ToString(); customPO.ACTUALDATEDELIVEREDUNIT = TryParseNull(row["TANGGALBSTB"].ToString()); customPO.MODIFIED_BY = Session["UserID"].ToString(); customPO.MODIFIED_DATE = DateTime.Now.Date; var resultPO = svcUpldVehicle.UpdateInvoiceCustPO(row["PONUMBER"].ToString(), customPO); #endregion /* #region CUSTOMBPKB * CUSTOMBPKB customBpkb = new CUSTOMBPKB(); * * customBpkb.NOFAKTUR = row["NOFAKTUR"].ToString(); * customBpkb.MODIFIED_BY = Session["UserID"].ToString(); * customBpkb.MODIFIED_DATE = DateTime.Now.Date; * * var resultBPKB = svcUpldVehicle.UpdateInvoiceCustBpkb(row["PONUMBER"].ToString(), customBpkb); #endregion * #region CUSTOMGR * CUSTOMGR customGR = new CUSTOMGR(); * * customGR.NOCHASIS_INPUT = row["NOCHASIS_INPUT"].ToString(); * customGR.NOENGINE_INPUT = row["NOENGINE_INPUT"].ToString(); * customGR.ACTUALRECEIVEDUNITINBDEL = TryParseNull(row["ACTUALRECEIVEDUNITINBDEL"].ToString()); * customGR.MODIFIED_BY = Session["UserID"].ToString(); * customGR.MODIFIED_DATE = DateTime.Now.Date; * * var resultGR = svcUpldVehicle.UpdateInvoiceCustGR(row["PONUMBER"].ToString(), customGR); #endregion * #region CUSTOMIR * CUSTOMIR customIR = new CUSTOMIR(); * * customIR.NOFAKTURPAJAK = row["NOFAKTURPAJAK"].ToString(); * customIR.TERMOFPAYMENT = TryParseNullInt(row["TERMOFPAYMENT"].ToString()); * customIR.TGLSERAHTAGIHAN = TryParseNull(row["TGLSERAHTAGIHAN"].ToString()); * customIR.KETBAYAR = row["KETBAYAR"].ToString(); * customIR.KETTAGIHAN = row["KETTAGIHAN"].ToString(); * customIR.MODIFIED_BY = Session["UserID"].ToString(); * customIR.MODIFIED_DATE = DateTime.Now.Date; * * var resultIR = svcUpldVehicle.UpdateInvoiceCustIR(row["PONUMBER"].ToString(), customIR); #endregion */ } } } #endregion #region Bpkb string Message = string.Empty; StringBuilder listPONumber = new StringBuilder(); if (type == "BPKB") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["PONUMBER"] != DBNull.Value) { var dc = new eprocdbDataContext(); var md = (from c in dc.CUSTOMBPKBs where c.PONUMBER == row["PONUMBER"].ToString().Trim() select c).SingleOrDefault(); if (md != null) { IUploadVehicleService svcUpldVehicle = new UploadVehicleService(); #region CUSTOMBPKB CUSTOMBPKB customBPKB = new CUSTOMBPKB(); customBPKB.ACTUALRECEIVEDBPKBDIHO = TryParseNull(row["ACTUALRECEIVEDBPKBDIHO"].ToString()); customBPKB.ACTUALRECEIVEDBPKBDICAB = TryParseNull(row["ACTUALRECEIVEDBPKBDICAB"].ToString()); customBPKB.DETAILPROBLEM = row["DETAILPROBLEM"].ToString(); customBPKB.REASONREVISEBPKB = row["REASONREVISEBPKB"].ToString(); customBPKB.TGLSERAHBPKB = TryParseNull(row["TGLSERAHBPKB"].ToString()); customBPKB.ACTUALDELIVERYBPKBTOFINANCE = TryParseNull(row["ACTUALDELIVERYBPKBTOFINANCE"].ToString()); customBPKB.ACTUALRECEIVEDBPKBHOBACK = TryParseNull(row["ACTUALRECEIVEDBPKBHOBACK"].ToString()); customBPKB.DATEDELIVERYTOBRANCHORVENDOR = TryParseNull(row["DATEDELIVERYTOBRANCHORVENDOR"].ToString()); customBPKB.NOBPKB = row["NOBPKB"].ToString(); customBPKB.NOFAKTUR = row["NOFAKTUR"].ToString(); customBPKB.NOSERTIFIKAT = row["NOSERTIFIKAT"].ToString(); customBPKB.NOFORMULIRA = row["NOFORMULIRA"].ToString(); customBPKB.KETSURATUBAHBENTUK = row["KETSURATUBAHBENTUK"].ToString(); customBPKB.NOSURATUBAHBENTUK = row["NOSURATUBAHBENTUK"].ToString(); customBPKB.TGLSURATUBAHBENTUK = TryParseNull(row["TGLSURATUBAHBENTUK"].ToString()); customBPKB.KETERANGANSURATRUBAHWARNA = row["KETERANGANSURATRUBAHWARNA"].ToString(); customBPKB.NOSURATRUBAHWARNA = row["NOSURATRUBAHWARNA"].ToString(); customBPKB.TANGGALSURATRUBAHWARNA = TryParseNull(row["TANGGALSURATRUBAHWARNA"].ToString()); customBPKB.NOSERTIFIKATREGUJITIPE = row["NOSERTIFIKATREGUJITIPE"].ToString(); customBPKB.REMARKSDETAILPROBLEM = row["REMARKSDETAILPROBLEM"].ToString(); customBPKB.KETBPKB = row["KETBPKB"].ToString(); customBPKB.MODIFIED_BY = Session["UserID"].ToString(); customBPKB.MODIFIED_DATE = DateTime.Now.Date; var resultBPKB = svcUpldVehicle.UpdateBpkbCustBPKB(row["PONUMBER"].ToString(), customBPKB); #endregion } else { Message = "PONUMBER doesn't exist "; listPONumber.Append(row["PONUMBER"].ToString()).Append(", "); } } } } #endregion #endregion if (filePath != null || filePath != string.Empty) { if ((System.IO.File.Exists(filePath))) { System.IO.File.Delete(filePath); } } if (!string.IsNullOrEmpty(Message)) { this.AddNotification("File uploaded failed. " + Message + listPONumber, NotificationType.ERROR); } else { this.AddNotification("File uploaded successfully.", NotificationType.SUCCESS); } } catch (Exception ex) { general.AddLogError("Upload Vehicle", ex.Message, ex.StackTrace); this.AddNotification("File uploaded failed.", NotificationType.ERROR); this.AddNotification("PONumber Tidak ditemukan", NotificationType.ERROR); return(View("~/Views/Upload/Vehicle/Index.cshtml")); throw ex; } } return(View("~/Views/Upload/Vehicle/Index.cshtml")); }
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")); }
public ActionResult Index(HttpPostedFileBase postedFile, CUSTOMFILEUPLOAD model, string DdlForm) { 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 (DdlForm == "1") { type = "Invoice"; } string FileName = type + tanggalSekarang + ".xls"; filePath = path + FileName; try { postedFile.SaveAs(filePath); IUploadVehicleService svc = new UploadVehicleService(); model.ID = Convert.ToInt32(UploadVehicleService.GenerateID()); model.FILEUPLOAD = FileName; model.MODIFIED_BY = "namaUser"; model.MODIFIED_DATE = DateTime.Now.Date; var result = svc.Add(model); DataTable dt = postedFile.ToDataTable(); #region Insert #region Invoice if (type == "Invoice") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["PONUMBER"] != DBNull.Value) { var dc = new eprocdbDataContext(); IUploadVehicleService svcUpldVehicle = new UploadVehicleService(); #region CUSTOMIR CUSTOMIR CUSTOMIR = new CUSTOMIR(); CUSTOMIR.NOAP = row["BPHNUMBER"].ToString(); var resultPO = svcUpldVehicle.UpdateCustomIR(row["PONUMBER"].ToString(), CUSTOMIR); #endregion } } } #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 Vehicle", ex.Message, ex.StackTrace); this.AddNotification("File uploaded failed.", NotificationType.ERROR); return(View("~/Views/Upload/UploadInvoice/Index.cshtml")); throw ex; } } return(View("~/Views/Upload/UploadInvoice/Index.cshtml")); }