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