public FaktorBorongan(Context.FaktorBorongan dbitem) { Id = dbitem.Id; IdMasterPool = dbitem.IdMasterPool; StrMasterPool = dbitem.MasterPool.NamePool; IdJenisTruck = dbitem.IdJenisTruck; StrJenisTruck = dbitem.JenisTrucks.StrJenisTruck; RasioDlmKota = dbitem.RasioDlmKota; RasioDlmKota2 = dbitem.RasioDlmKota2; RasioJawaBali = dbitem.RasioJawaBali; RasioSumatra = dbitem.RasioSumatra; RasioKosong = dbitem.RasioKosong; //RasioSolar = dbitem.RasioSolar; UangMakanJawaBali = dbitem.UangMakanJawaBali; UangMakanSumatra = dbitem.UangMakanSumatra; FaktorPengaliGaji = dbitem.FaktorPengaliGaji; FaktorPengaliTips = dbitem.FaktorPengaliTips; PotonganDriver1 = dbitem.PotonganDriver1; PotonganDriver2 = dbitem.PotonganDriver2; BiayaKapalBali = dbitem.BiayaKapalBali; BiayaKapalBaliNTB = dbitem.BiayaKapalBaliNTB; BiayaKapalSumatra = dbitem.BiayaKapalSumatra; BiayaKapalKalimantan = dbitem.BiayaKapalKalimantan; BiayaKapalSulawesi = dbitem.BiayaKapalSulawesi; }
public string GetUangMakan(string AreaMakan, int idpool, int idjenistruck) { ResponeModel response = new ResponeModel(); Decimal UangMakan = 0; Context.FaktorBorongan dbitem = RepoFaktorBorongan.FindAll().Where(d => d.IdMasterPool == idpool && d.IdJenisTruck == idjenistruck).FirstOrDefault(); if (dbitem != null) { //ambil data berdasarkan rasio if (AreaMakan == "JAWABALI") { UangMakan = dbitem.UangMakanJawaBali; } else if (AreaMakan == "SUMATRA") { UangMakan = dbitem.UangMakanSumatra; } response.Success = true; response.Data = new JavaScriptSerializer().Serialize(new { UangMakan = UangMakan }); } else { response.Success = false; } return(new JavaScriptSerializer().Serialize(response)); }
public ActionResult Edit(int id) { Context.FaktorBorongan dbitem = RepoFaktorBorongan.FindByPK(id); FaktorBorongan model = new FaktorBorongan(dbitem); ViewBag.name = model.IdJenisTruck; return(View("Form", model)); }
public JsonResult Delete(int id) { ResponeModel response = new ResponeModel(true); Context.FaktorBorongan dbItem = RepoFaktorBorongan.FindByPK(id); RepoFaktorBorongan.delete(dbItem, UserPrincipal.id); return(Json(response)); }
public string BindingHistory(int id) { Context.FaktorBorongan db = RepoFaktorBorongan.FindByPK(id); List <FaktorBoronganHistory> ListModel = new List <FaktorBoronganHistory>(); foreach (Context.FaktorBoronganHistory item in db.FaktorBoronganHistory.ToList()) { ListModel.Add(new FaktorBoronganHistory(item)); } return(new JavaScriptSerializer().Serialize(ListModel)); }
public string GetBiayaKapal(string kapal, int idpool, int idjenistruck) { ResponeModel response = new ResponeModel(); Decimal BiayaKapal = 0; Context.FaktorBorongan dbitem = RepoFaktorBorongan.FindAll().Where(d => d.IdMasterPool == idpool && d.IdJenisTruck == idjenistruck).FirstOrDefault(); if (dbitem != null) { //ambil data berdasarkan rasio if (kapal == "BALI") { BiayaKapal = dbitem.BiayaKapalBali; } else if (kapal == "BALI_NTB") { BiayaKapal = dbitem.BiayaKapalBaliNTB; } else if (kapal == "SUMATRA") { BiayaKapal = dbitem.BiayaKapalSumatra; } else if (kapal == "KALIMANTAN") { BiayaKapal = dbitem.BiayaKapalKalimantan; } else if (kapal == "SULAWESI") { BiayaKapal = dbitem.BiayaKapalSulawesi; } response.Success = true; response.Data = new JavaScriptSerializer().Serialize(new { BiayaKapal = BiayaKapal }); } else { response.Success = false; } return(new JavaScriptSerializer().Serialize(response)); }
public string GetFaktorPengali(int idpool, int idjenistruck) { ResponeModel response = new ResponeModel(); Context.FaktorBorongan dbitem = RepoFaktorBorongan.FindAll().Where(d => d.IdMasterPool == idpool && d.IdJenisTruck == idjenistruck).FirstOrDefault(); if (dbitem != null) { response.Success = true; response.Data = new JavaScriptSerializer().Serialize(new { FaktorPengaliTips = dbitem.FaktorPengaliTips, FaktorPengaliGaji = dbitem.FaktorPengaliGaji, }); } else { response.Success = false; } return(new JavaScriptSerializer().Serialize(response)); }
public ActionResult Edit(FaktorBorongan model) { if (ModelState.IsValid) { if (RepoFaktorBorongan.isExist(model.IdMasterPool.Value, model.IdJenisTruck.Value, model.Id)) { ModelState.AddModelError("IdMasterPool", "Alokasi Pool dan Jenis Truk sudah terdaftar."); ModelState.AddModelError("IdJenisTruck", "Alokasi Pool dan Jenis Truk sudah terdaftar."); return(View("Form", model)); } Context.FaktorBorongan dbitem = RepoFaktorBorongan.FindByPK(model.Id); model.SetDb(dbitem); Context.FaktorBoronganHistory dbitemHistory = new Context.FaktorBoronganHistory(); model.SetDbHistory(dbitemHistory, UserPrincipal.firstname + ' ' + UserPrincipal.lastname); dbitem.FaktorBoronganHistory.Add(dbitemHistory); RepoFaktorBorongan.save(dbitem, UserPrincipal.id, dbitemHistory); return(RedirectToAction("Index")); } return(View("Form", model)); }
public string GetSolarRasio(int IdPool, int IdJenisTruck, string typeRasion) { ResponeModel response = new ResponeModel(); Decimal rasio = 0; Context.FaktorBorongan dbitem = RepoFaktorBorongan.FindAll().Where(d => d.IdMasterPool == IdPool && d.IdJenisTruck == IdJenisTruck).FirstOrDefault(); if (dbitem != null) { //ambil data berdasarkan rasio if (typeRasion == "KOTA1") { rasio = dbitem.RasioDlmKota; } else if (typeRasion == "KOTA2") { rasio = dbitem.RasioDlmKota2; } else if (typeRasion == "JAWABALI") { rasio = dbitem.RasioJawaBali; } else if (typeRasion == "SUMATRA") { rasio = dbitem.RasioSumatra; } else if (typeRasion == "KOSONG") { rasio = dbitem.RasioKosong; } response.Success = true; response.Data = new JavaScriptSerializer().Serialize(new { Rasio = rasio }); } else { response.Success = false; } return(new JavaScriptSerializer().Serialize(response)); }
public void SetDb(Context.FaktorBorongan dbitem) { dbitem.IdMasterPool = IdMasterPool; dbitem.IdJenisTruck = IdJenisTruck; dbitem.RasioDlmKota = RasioDlmKota.Value; dbitem.RasioDlmKota2 = RasioDlmKota2.Value; dbitem.RasioJawaBali = RasioJawaBali.Value; dbitem.RasioSumatra = RasioSumatra.Value; dbitem.RasioKosong = RasioKosong.Value; //dbitem.RasioSolar = RasioSolar.Value; dbitem.UangMakanJawaBali = UangMakanJawaBali.Value; dbitem.UangMakanSumatra = UangMakanSumatra.Value; dbitem.FaktorPengaliGaji = FaktorPengaliGaji.Value; dbitem.FaktorPengaliTips = FaktorPengaliTips.Value; dbitem.PotonganDriver1 = PotonganDriver1.HasValue ? PotonganDriver1.Value : 0; dbitem.PotonganDriver2 = PotonganDriver2.HasValue ? PotonganDriver2.Value : 0; dbitem.BiayaKapalBali = BiayaKapalBali.HasValue ? BiayaKapalBali.Value : 0; dbitem.BiayaKapalBaliNTB = BiayaKapalBaliNTB.HasValue ? BiayaKapalBaliNTB.Value : 0; dbitem.BiayaKapalSumatra = BiayaKapalSumatra.HasValue ? BiayaKapalSumatra.Value : 0; dbitem.BiayaKapalKalimantan = BiayaKapalKalimantan.HasValue ? BiayaKapalKalimantan.Value : 0; dbitem.BiayaKapalSulawesi = BiayaKapalSulawesi.HasValue ? BiayaKapalSulawesi.Value : 0; }
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 })); }