public string UploadFaktorBorongan(IEnumerable <HttpPostedFileBase> filesFaktorBorongan) { ResponeModel response = new ResponeModel(); //algoritma if (filesFaktorBorongan != null) { foreach (var file in filesFaktorBorongan) { try { using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { if (workSheet.Cells[rowIterator, 1].Value != null && workSheet.Cells[rowIterator, 2].Value != null && workSheet.Cells[rowIterator, 3].Value != null && workSheet.Cells[rowIterator, 4].Value != null && workSheet.Cells[rowIterator, 5].Value != null && workSheet.Cells[rowIterator, 6].Value != null && workSheet.Cells[rowIterator, 7].Value != null && workSheet.Cells[rowIterator, 8].Value != null && workSheet.Cells[rowIterator, 9].Value != null && workSheet.Cells[rowIterator, 10].Value != null && workSheet.Cells[rowIterator, 11].Value != null) { int id = 0; int resId; if (workSheet.Cells[rowIterator, 19].Value != null) { if (int.TryParse(workSheet.Cells[rowIterator, 19].Value.ToString(), out resId)) { id = resId; } } Context.FaktorBorongan dbitem = new Context.FaktorBorongan(); try { if (id != 0) { if (RepoFaktorBorongan.isExist(RepoMasterPool.FindByNamePool(workSheet.Cells[rowIterator, 1].Value.ToString()).Id, RepoJenisTruck.FindByStrJenisTruck(workSheet.Cells[rowIterator, 2].Value.ToString()).Id, id)) { continue; } dbitem = RepoFaktorBorongan.FindByPK(id); } else { if (RepoFaktorBorongan.isExist(RepoMasterPool.FindByNamePool(workSheet.Cells[rowIterator, 1].Value.ToString()).Id, RepoJenisTruck.FindByStrJenisTruck(workSheet.Cells[rowIterator, 2].Value.ToString()).Id)) { continue; } } dbitem.IdMasterPool = RepoMasterPool.FindByNamePool(workSheet.Cells[rowIterator, 1].Value.ToString()).Id; dbitem.IdJenisTruck = RepoJenisTruck.FindByStrJenisTruck(workSheet.Cells[rowIterator, 2].Value.ToString()).Id; dbitem.RasioDlmKota = Decimal.Parse(workSheet.Cells[rowIterator, 3].Value.ToString()); dbitem.RasioDlmKota2 = Decimal.Parse(workSheet.Cells[rowIterator, 4].Value.ToString()); dbitem.RasioJawaBali = Decimal.Parse(workSheet.Cells[rowIterator, 5].Value.ToString()); dbitem.RasioSumatra = Decimal.Parse(workSheet.Cells[rowIterator, 6].Value.ToString()); dbitem.RasioKosong = Decimal.Parse(workSheet.Cells[rowIterator, 7].Value.ToString()); dbitem.UangMakanJawaBali = Decimal.Parse(workSheet.Cells[rowIterator, 8].Value.ToString()); dbitem.UangMakanSumatra = Decimal.Parse(workSheet.Cells[rowIterator, 9].Value.ToString()); dbitem.FaktorPengaliGaji = Decimal.Parse(workSheet.Cells[rowIterator, 10].Value.ToString()); dbitem.FaktorPengaliTips = Decimal.Parse(workSheet.Cells[rowIterator, 11].Value.ToString()); dbitem.PotonganDriver1 = workSheet.Cells[rowIterator, 12].Value == null?Convert.ToDecimal(null) : Decimal.Parse(workSheet.Cells[rowIterator, 12].Value.ToString()); dbitem.PotonganDriver2 = workSheet.Cells[rowIterator, 13].Value == null?Convert.ToDecimal(null) : Decimal.Parse(workSheet.Cells[rowIterator, 13].Value.ToString()); dbitem.BiayaKapalBali = workSheet.Cells[rowIterator, 14].Value == null?Convert.ToDecimal(null) : Decimal.Parse(workSheet.Cells[rowIterator, 14].Value.ToString()); dbitem.BiayaKapalBaliNTB = workSheet.Cells[rowIterator, 15].Value == null?Convert.ToDecimal(null) : Decimal.Parse(workSheet.Cells[rowIterator, 15].Value.ToString()); dbitem.BiayaKapalSumatra = workSheet.Cells[rowIterator, 16].Value == null?Convert.ToDecimal(null) : Decimal.Parse(workSheet.Cells[rowIterator, 16].Value.ToString()); dbitem.BiayaKapalKalimantan = workSheet.Cells[rowIterator, 17].Value == null?Convert.ToDecimal(null) : Decimal.Parse(workSheet.Cells[rowIterator, 17].Value.ToString()); dbitem.BiayaKapalSulawesi = workSheet.Cells[rowIterator, 18].Value == null?Convert.ToDecimal(null) : Decimal.Parse(workSheet.Cells[rowIterator, 18].Value.ToString()); RepoFaktorBorongan.save(dbitem, UserPrincipal.id, new Context.FaktorBoronganHistory()); } catch (Exception e) { } } } } response.Success = true; } catch (Exception e) { response.Success = false; response.Message = e.Message.ToString(); } } } return(new JavaScriptSerializer().Serialize(new { Response = response })); }
public string UploadDataTruck(IEnumerable <HttpPostedFileBase> filesDataTruck) { ResponeModel response = new ResponeModel(); //algoritma if (filesDataTruck != null) { foreach (var file in filesDataTruck) { try { using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfRow = workSheet.Dimension.End.Row; for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { if (workSheet.Cells[rowIterator, 1].Value != null && workSheet.Cells[rowIterator, 2].Value != null && RepoLookup.FindByName(workSheet.Cells[rowIterator, 2].Value.ToString()) != null) { int id = 0; int resId; if (workSheet.Cells[rowIterator, 38].Value != null) { if (int.TryParse(workSheet.Cells[rowIterator, 38].Value.ToString(), out resId)) { id = resId; } } Context.DataTruck dbitem = new Context.DataTruck(); try { if (id != 0) { dbitem = RepoDataTruck.FindByPK(id); if (RepoDataTruck.IsExist(workSheet.Cells[rowIterator, 1].Value.ToString(), id)) { continue; } } else { if (RepoDataTruck.IsExist(workSheet.Cells[rowIterator, 1].Value.ToString())) { continue; } dbitem.urutan = RepoDataTruck.getUrutan() + 1; dbitem.NoTruck = RepoDataTruck.generateCode(dbitem.urutan); } dbitem.VehicleNo = workSheet.Cells[rowIterator, 1].Value.ToString(); if (workSheet.Cells[rowIterator, 2].Value != null) { dbitem.IdMerk = RepoLookup.FindByName(workSheet.Cells[rowIterator, 2].Value.ToString()).Id; } if (workSheet.Cells[rowIterator, 3].Value != null) { dbitem.IdJenisTruck = JenisTruck.FindByName(workSheet.Cells[rowIterator, 3].Value.ToString()).Id; } if (workSheet.Cells[rowIterator, 4].Value != null) { dbitem.TahunBuat = int.Parse(workSheet.Cells[rowIterator, 4].Value.ToString()); } if (workSheet.Cells[rowIterator, 5].Value != null) { dbitem.TahunBeli = int.Parse(workSheet.Cells[rowIterator, 5].Value.ToString()); } if (workSheet.Cells[rowIterator, 6].Value != null) { dbitem.IdPool = MasterPool.FindByNamePool(workSheet.Cells[rowIterator, 6].Value.ToString()).Id; } if (workSheet.Cells[rowIterator, 7].Value != null && RepoLookup.FindByName(workSheet.Cells[rowIterator, 7].Value.ToString()) != null) { dbitem.IdUnit = RepoLookup.FindByName(workSheet.Cells[rowIterator, 7].Value.ToString()).Id; } dbitem.Keterangan = workSheet.Cells[rowIterator, 8].Value != null ? workSheet.Cells[rowIterator, 8].Value.ToString() : ""; dbitem.Kondisi = workSheet.Cells[rowIterator, 9].Value != null ? workSheet.Cells[rowIterator, 9].Value.ToString() : ""; dbitem.SpecModel = workSheet.Cells[rowIterator, 10].Value != null ? workSheet.Cells[rowIterator, 10].Value.ToString() : ""; dbitem.KmLimit = workSheet.Cells[rowIterator, 11].Value != null?int.Parse(workSheet.Cells[rowIterator, 11].Value.ToString()) : 0; dbitem.NoMesin = workSheet.Cells[rowIterator, 12].Value != null ? workSheet.Cells[rowIterator, 12].Value.ToString() : ""; dbitem.NoRangka = workSheet.Cells[rowIterator, 13].Value != null ? workSheet.Cells[rowIterator, 13].Value.ToString() : ""; if (workSheet.Cells[rowIterator, 14].Value != null) { dbitem.GaransiStr = DateTime.Parse(workSheet.Cells[rowIterator, 14].Value.ToString()); } if (workSheet.Cells[rowIterator, 15].Value != null) { dbitem.GaransiEnd = DateTime.Parse(workSheet.Cells[rowIterator, 15].Value.ToString()); } dbitem.SpecKeterangan = workSheet.Cells[rowIterator, 16].Value != null ? workSheet.Cells[rowIterator, 16].Value.ToString() : ""; dbitem.AtasNama = workSheet.Cells[rowIterator, 17].Value != null ? workSheet.Cells[rowIterator, 17].Value.ToString() : ""; dbitem.BPKB = workSheet.Cells[rowIterator, 18].Value != null ? workSheet.Cells[rowIterator, 18].Value.ToString() : ""; dbitem.keteranganBPKB = workSheet.Cells[rowIterator, 19].Value != null ? workSheet.Cells[rowIterator, 19].Value.ToString() : ""; if (workSheet.Cells[rowIterator, 20].Value != null) { dbitem.STNK = DateTime.Parse(workSheet.Cells[rowIterator, 20].Value.ToString()); } dbitem.keteranganSTNK = workSheet.Cells[rowIterator, 21].Value != null ? workSheet.Cells[rowIterator, 21].Value.ToString() : ""; if (workSheet.Cells[rowIterator, 22].Value != null) { dbitem.KIR = DateTime.Parse(workSheet.Cells[rowIterator, 22].Value.ToString()); } dbitem.keteranganKIR = workSheet.Cells[rowIterator, 23].Value != null ? workSheet.Cells[rowIterator, 23].Value.ToString() : ""; if (workSheet.Cells[rowIterator, 24].Value != null) { dbitem.KIU = DateTime.Parse(workSheet.Cells[rowIterator, 24].Value.ToString()); } dbitem.keteranganKIU = workSheet.Cells[rowIterator, 25].Value != null ? workSheet.Cells[rowIterator, 25].Value.ToString() : ""; if (workSheet.Cells[rowIterator, 26].Value != null) { dbitem.IBM = DateTime.Parse(workSheet.Cells[rowIterator, 26].Value.ToString()); } dbitem.keteranganIBM = workSheet.Cells[rowIterator, 27].Value != null ? workSheet.Cells[rowIterator, 27].Value.ToString() : ""; if (workSheet.Cells[rowIterator, 28].Value != null) { dbitem.Asuransi = DateTime.Parse(workSheet.Cells[rowIterator, 28].Value.ToString()); } dbitem.keteranganAsuransi = workSheet.Cells[rowIterator, 29].Value != null ? workSheet.Cells[rowIterator, 29].Value.ToString() : null; if (workSheet.Cells[rowIterator, 30].Value != null) { dbitem.Reklame = DateTime.Parse(workSheet.Cells[rowIterator, 30].Value.ToString()); } else { dbitem.Reklame = null; } dbitem.keteranganReklame = workSheet.Cells[rowIterator, 31].Value != null ? workSheet.Cells[rowIterator, 31].Value.ToString() : ""; dbitem.NoPolis = workSheet.Cells[rowIterator, 32].Value != null ? workSheet.Cells[rowIterator, 32].Value.ToString() : null; dbitem.keteranganNoPolis = workSheet.Cells[rowIterator, 33].Value != null ? workSheet.Cells[rowIterator, 33].Value.ToString() : ""; dbitem.Peminjam = workSheet.Cells[rowIterator, 34].Value != null ? workSheet.Cells[rowIterator, 34].Value.ToString() : null; dbitem.keteranganPeminjam = workSheet.Cells[rowIterator, 35].Value != null ? workSheet.Cells[rowIterator, 35].Value.ToString() : ""; dbitem.Leasing = workSheet.Cells[rowIterator, 36].Value != null ? workSheet.Cells[rowIterator, 36].Value.ToString() : null; dbitem.keteranganLeasing = workSheet.Cells[rowIterator, 37].Value != null ? workSheet.Cells[rowIterator, 37].Value.ToString() : ""; RepoDataTruck.save(dbitem, UserPrincipal.id); } catch (Exception) { response.Message = response.Message + Environment.NewLine + " " + rowIterator; } } } } response.Success = true; } catch (Exception e) { response.Success = false; response.Message = e.Message.ToString(); } } } return(new JavaScriptSerializer().Serialize(new { Response = response })); }