public SalesOrderKontrakItemTruck(Context.DataTruck dbitem, List <Context.SalesOrder> dbso)
{
Id = 1;
IdTruk = dbitem.Id;
VehicleNumber = dbitem.VehicleNo;
JenisTruck = dbitem.JenisTrucks == null ? "" : dbitem.JenisTrucks.StrJenisTruck;
Status = "Available";
if (dbso != null)
{
if (dbso.Any(d => (d.Status == "save" || d.Status == "draft planning") &&
((d.SalesOrderOncallId.HasValue ? d.SalesOrderOncall.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderPickupId.HasValue ? d.SalesOrderPickup.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderProsesKonsolidasiId.HasValue ? d.SalesOrderProsesKonsolidasi.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderKontrakId.HasValue ? d.SalesOrderKontrak.SalesOrderKontrakTruck.Any(k => k.DataTruckId == dbitem.Id) : false))))
{
Status = "On Duty";
}
else if (dbso.Any(d => (d.Status == "save planning" || d.Status == "draft konfirmasi") &&
((d.SalesOrderOncallId.HasValue ? d.SalesOrderOncall.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderPickupId.HasValue ? d.SalesOrderPickup.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderProsesKonsolidasiId.HasValue ? d.SalesOrderProsesKonsolidasi.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderKontrakId.HasValue ? d.SalesOrderKontrak.SalesOrderKontrakTruck.Any(k => k.DataTruckId == dbitem.Id) : false))))
{
Status = "On Duty";
}
else if (dbso.Any(d => (d.Status == "save konfirmasi" || d.Status == "dispatched") &&
((d.SalesOrderOncallId.HasValue ? d.SalesOrderOncall.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderPickupId.HasValue ? d.SalesOrderPickup.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderProsesKonsolidasiId.HasValue ? d.SalesOrderProsesKonsolidasi.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderKontrakId.HasValue ? d.SalesOrderKontrak.SalesOrderKontrakTruck.Any(k => k.DataTruckId == dbitem.Id) : false))))
{
Status = "On Duty";
}
}
}
public ActionResult Edit(DataGPS model)
{
if (ModelState.IsValid)
{
if (RepoDataGps.IsBoxExist(model.IdDataTruck.Value, model.Id))
{
ModelState.AddModelError("IdDataTruck", "Truck sudah tepasang gps, harap ganti dengan truck yang lain");
return(View("Form", model));
}
Context.DataGPS dbitem = RepoDataGps.FindByPK(model.Id);
model.SetDb(dbitem);
Context.DataGPSHistory dbitemHistory = new Context.DataGPSHistory();
model.SetDbHistory(dbitemHistory, UserPrincipal.firstname + " " + UserPrincipal.lastname);
dbitem.DataGPSHistory.Add(dbitemHistory);
Context.DataTruckGPSHistory dbtruckHistory = new Context.DataTruckGPSHistory();
model.SetDbTruckHistory(dbtruckHistory, UserPrincipal.firstname + " " + UserPrincipal.lastname);
RepoDataGps.save(dbitem, UserPrincipal.id, dbitemHistory);
Context.DataTruck dbtruck = RepoDataTruck.FindByPK(model.IdDataTruck.Value);
dbtruck.DataTruckGPSHistory.Add(dbtruckHistory);
RepoDataTruck.save(dbtruck, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public ActionResult Edit(DataPendingin model)
{
if (ModelState.IsValid)
{
if (RepoPendingin.IsBoxExist(model.IdDataTruk.Value, model.Id))
{
ModelState.AddModelError("IdDataTruk", "Truck sudah tepasang pendingin, harap ganti dengan truck yang lain");
return(View("Form", model));
}
Context.DataPendingin dbitem = RepoPendingin.FindByPK(model.Id);
model.setDb(dbitem);
Context.DataPendinginHistory dbitemhistory = new Context.DataPendinginHistory();
model.setDbHistory(dbitemhistory, UserPrincipal.firstname + ' ' + UserPrincipal.lastname);
dbitem.ListHistoryPendingin.Add(dbitemhistory);
Context.DataTruckPendinginHistory dbtruckhistory = new Context.DataTruckPendinginHistory();
model.setDbTruckHistory(dbtruckhistory, UserPrincipal.firstname + ' ' + UserPrincipal.lastname);
RepoPendingin.save(dbitem, UserPrincipal.id, dbitemhistory, dbtruckhistory);
Context.DataTruck dbtruck = RepoDataTruck.FindByPK(model.IdDataTruk.Value);
dbtruck.DataTruckPendinginHistory.Add(dbtruckhistory);
RepoDataTruck.save(dbtruck, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public string BindingDataBox(int id)
{
Context.DataTruck dbtruck = RepoDataTruck.FindByPK(id);
List <DataBox> ListModel = new List <DataBox>();
foreach (Context.DataTruckBoxHistory item in dbtruck.DataTruckBoxHistory.OrderByDescending(d => d.Id))
{
if (ListModel.Count == 0)
{
ListModel.Add(new DataBox(item));
}
else
{
if (ListModel.Last().NoBox == item.NoBox)
{
var data = ListModel.Last();
data = new DataBox(item);
}
else
{
ListModel.Add(new DataBox(item));
}
}
}
return(new JavaScriptSerializer().Serialize(new { data = ListModel }));
}
public ActionResult Detail(int id)
{
Context.DataTruck dbitem = RepoDataTruck.FindByPK(id);
UnitList model = new UnitList(dbitem);
return(View("Form", model));
}
public ActionResult Edit(int id)
{
Context.DataTruck dbitem = RepoDataTruck.FindByPK(id);
DataTruck model = new DataTruck(dbitem);
ViewBag.name = model.NoTruck;
return(View("Form", model));
}
public string OnDutyDetail(string VehicleNo, string NoSo)
{
Context.DataTruck item = RepoDataTruck.FindByName(VehicleNo);
UnitList unit = new UnitList(item);
Context.MonitoringDetailSo mon_so = RepoMonitoringVehicle.FindMonitoringDetailSo(NoSo);
return(new JavaScriptSerializer().Serialize(new { unit = unit, Delay = mon_so.TglTiba - mon_so.TargetTiba }));
}
public void SetDb(Context.DataTruck dbitem)
{
dbitem.Id = Id;
dbitem.NoTruck = NoTruck;
dbitem.VehicleNo = VehicleNo;
dbitem.IdMerk = IdMerk;
dbitem.IdJenisTruck = IdJenisTruck;
dbitem.TahunBuat = TahunBuat;
dbitem.TahunBeli = TahunBeli;
dbitem.IdPool = IdPool;
dbitem.IdUnit = IdUnit;
dbitem.Keterangan = Keterangan;
dbitem.Kondisi = Kondisi;
dbitem.SpecModel = SpecModel;
dbitem.KmLimit = KmLimit;
dbitem.NoMesin = NoMesin;
dbitem.NoRangka = NoRangka;
dbitem.GaransiStr = GaransiStr;
dbitem.GaransiEnd = GaransiEnd;
dbitem.SpecKeterangan = SpecKeterangan;
dbitem.MaxSpeed = MaxSpeed;
dbitem.AtasNama = AtasNama;
dbitem.BPKB = BPKB;
dbitem.STNK = STNK;
dbitem.KIR = KIR;
dbitem.KIU = KIU;
dbitem.IBM = IBM;
dbitem.Asuransi = Asuransi;
dbitem.Reklame = Reklame;
dbitem.NoPolis = NoPolis;
dbitem.Peminjam = Peminjam;
dbitem.Leasing = Leasing;
dbitem.keteranganBPKB = keteranganBPKB;
dbitem.keteranganSTNK = keteranganSTNK;
dbitem.keteranganKIR = keteranganKIR;
dbitem.keteranganKIU = keteranganKIU;
dbitem.keteranganIBM = keteranganIBM;
dbitem.keteranganAsuransi = keteranganAsuransi;
dbitem.keteranganReklame = keteranganReklame;
dbitem.keteranganNoPolis = keteranganNoPolis;
dbitem.keteranganPeminjam = keteranganPeminjam;
dbitem.keteranganLeasing = keteranganLeasing;
dbitem.urlBPKB = urlBPKB;
dbitem.urlSTNK = urlSTNK;
dbitem.urlKIR = urlKIR;
dbitem.urlKIU = urlKIU;
dbitem.urlIBM = urlIBM;
dbitem.urlAsuransi = urlAsuransi;
dbitem.urlReklame = urlReklame;
dbitem.urlNoPolis = urlNoPolis;
dbitem.urlPeminjam = urlPeminjam;
dbitem.urlLeasing = urlLeasing;
}
public UnitList(Context.DataTruck dbitem)
{
Id = dbitem.Id;
VehicleNo = dbitem.VehicleNo;
JenisTruck = dbitem.IdJenisTruck.HasValue ? dbitem.JenisTrucks.StrJenisTruck : "";
MerkTruck = dbitem.IdMerk.HasValue ? dbitem.LookupCodeMerk.Nama : "";
ModelTruck = dbitem.SpecModel;
MerkPendingin = dbitem.DataPendingin.Count() == 0 ? "" : dbitem.DataPendingin.FirstOrDefault().Merk;
ModelPendingin = dbitem.DataPendingin.Count() == 0 ? "" : dbitem.DataPendingin.FirstOrDefault().Model;
KaroseriBox = dbitem.DataBox.Count() == 0 ? "" : dbitem.DataBox.FirstOrDefault().Karoseri;
TypeBox = dbitem.DataBox.Count() == 0 ? "" : dbitem.DataBox.FirstOrDefault().IdType.HasValue ? dbitem.DataBox.FirstOrDefault().LookupCodeType.Nama : "";
VendorGps = dbitem.DataGPS.Count() == 0 ? "" : dbitem.DataGPS.FirstOrDefault().IdVendor.HasValue ? dbitem.DataGPS.FirstOrDefault().VendorGps.Nama : "";
}
public ActionResult Edit(DataTruck model)
{
if (ModelState.IsValid)
{
if (RepoDataTruck.IsExist(model.VehicleNo, model.Id))
{
ModelState.AddModelError("VehicleNo", "Vehicle No sudah terdaftar.");
return(View("Form", model));
}
Context.DataTruck dbitem = RepoDataTruck.FindByPK(model.Id);
model.SetDb(dbitem);
RepoDataTruck.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
if (RepoDataTruck.IsValidDelete(id))
{
Context.DataTruck dbItem = RepoDataTruck.FindByPK(id);
RepoDataTruck.delete(dbItem, UserPrincipal.id);
}
else
{
response.SetFail("Data truck terpasang Box,Gps atau Pendingin, data tidak dapat dihapus.");
}
return(Json(response));
}
public ActionResult Add(DataTruck model)
{
if (ModelState.IsValid)
{
if (RepoDataTruck.IsExist(model.VehicleNo))
{
ModelState.AddModelError("VehicleNo", "Vehicle No sudah terdaftar.");
return(View("Form", model));
}
Context.DataTruck dbitem = new Context.DataTruck();
model.SetDb(dbitem);
//generate code
dbitem.urutan = RepoDataTruck.getUrutan() + 1;
dbitem.NoTruck = RepoDataTruck.generateCode(dbitem.urutan);
RepoDataTruck.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public ActionResult Add(DataBox model)
{
if (ModelState.IsValid)
{
if (RepoDataBox.IsBoxExist(model.IdDataTruck.Value))
{
ModelState.AddModelError("IdDataTruck", "Truck sudah tepasang box, harap ganti dengan truck yang lain");
return(View("Form", model));
}
Context.DataBox dbitem = new Context.DataBox();
model.SetDb(dbitem);
//generate code
dbitem.Urutan = RepoDataBox.getUrutan() + 1;
dbitem.NoBox = RepoDataBox.generateCode(dbitem.Urutan);
Context.DataBoxHistory dbitemHistory = new Context.DataBoxHistory();
model.SetDbHistory(dbitemHistory, UserPrincipal.firstname + " " + UserPrincipal.lastname);
dbitemHistory.Vehicle = RepoDataTruck.FindByPK(model.IdDataTruck.Value).VehicleNo;
dbitemHistory.NoBox = dbitem.NoBox;
dbitemHistory.strKategori = model.IdKategori.HasValue ? RepoLookup.FindByPK(model.IdKategori.Value).Nama : "";
dbitemHistory.strType = model.IdType.HasValue ? RepoLookup.FindByPK(model.IdType.Value).Nama : "";
dbitem.DataBoxHistory.Add(dbitemHistory);
Context.DataTruckBoxHistory dbtruckHistory = new Context.DataTruckBoxHistory();
model.SetDbTruckHistory(dbtruckHistory, UserPrincipal.firstname + " " + UserPrincipal.lastname);
RepoDataBox.save(dbitem, UserPrincipal.id, dbitemHistory, dbtruckHistory);
Context.DataTruck dbtruck = RepoDataTruck.FindByPK(model.IdDataTruck.Value);
dbtruckHistory.Vehicle = dbtruck.VehicleNo;
dbtruckHistory.NoBox = dbitem.NoBox;
dbtruckHistory.strKategori = model.IdKategori.HasValue ? RepoLookup.FindByPK(model.IdKategori.Value).Nama : "";
dbtruckHistory.strType = model.IdType.HasValue ? RepoLookup.FindByPK(model.IdType.Value).Nama : "";
dbtruck.DataTruckBoxHistory.Add(dbtruckHistory);
RepoDataTruck.save(dbtruck, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public ActionResult Add(DataPendingin model)
{
if (ModelState.IsValid)
{
if (RepoPendingin.IsBoxExist(model.IdDataTruk.Value))
{
ModelState.AddModelError("IdDataTruk", "Truck sudah tepasang pendingin, harap ganti dengan truck yang lain");
return(View("Form", model));
}
Context.DataPendingin dbitem = new Context.DataPendingin();
model.setDb(dbitem);
//generate code
dbitem.Urutan = RepoPendingin.getUrutan() + 1;
dbitem.NoPendingin = RepoPendingin.generateCode(dbitem.Urutan);
Context.DataPendinginHistory dbitemhistory = new Context.DataPendinginHistory();
model.setDbHistory(dbitemhistory, UserPrincipal.firstname + ' ' + UserPrincipal.lastname);
dbitemhistory.NoPendingin = dbitem.NoPendingin;
dbitemhistory.strDataTruk = RepoDataTruck.FindByPK(dbitem.IdDataTruk).VehicleNo;
dbitemhistory.strJenisPendingin = dbitem.IdJenisPendingin.HasValue ? RepoLookup.FindByPK(dbitem.IdJenisPendingin).Nama : "";
dbitem.ListHistoryPendingin.Add(dbitemhistory);
Context.DataTruckPendinginHistory dbtruckhistory = new Context.DataTruckPendinginHistory();
model.setDbTruckHistory(dbtruckhistory, UserPrincipal.firstname + ' ' + UserPrincipal.lastname);
RepoPendingin.save(dbitem, UserPrincipal.id, dbitemhistory, dbtruckhistory);
Context.DataTruck dbtruck = RepoDataTruck.FindByPK(model.IdDataTruk.Value);
dbtruckhistory.NoPendingin = dbitem.NoPendingin;
dbtruckhistory.strDataTruk = RepoDataTruck.FindByPK(dbitem.IdDataTruk).VehicleNo;
dbtruckhistory.strJenisPendingin = dbitem.IdJenisPendingin.HasValue ? RepoLookup.FindByPK(dbitem.IdJenisPendingin).Nama : "";
dbtruck.DataTruckPendinginHistory.Add(dbtruckhistory);
RepoDataTruck.save(dbtruck, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public ActionResult Add(DataGPS model)
{
if (ModelState.IsValid)
{
if (RepoDataGps.IsBoxExist(model.IdDataTruck.Value))
{
ModelState.AddModelError("IdDataTruck", "Truck sudah tepasang gps, harap ganti dengan truck yang lain");
return(View("Form", model));
}
Context.DataGPS dbitem = new Context.DataGPS();
model.SetDb(dbitem);
//generate code
dbitem.urutan = RepoDataGps.getUrutan() + 1;
dbitem.NoGPS = RepoDataGps.generateCode(dbitem.urutan);
Context.DataGPSHistory dbitemHistory = new Context.DataGPSHistory();
model.SetDbHistory(dbitemHistory, UserPrincipal.firstname + " " + UserPrincipal.lastname);
dbitemHistory.Vehicle = RepoDataTruck.FindByPK(dbitem.IdDataTruck.Value).VehicleNo;
dbitemHistory.NoGPS = dbitem.NoGPS;
dbitemHistory.strVendor = dbitem.IdVendor.HasValue ? RepoVendorGPS.FindByPK(dbitem.IdVendor.Value).Nama : "";
dbitem.DataGPSHistory.Add(dbitemHistory);
Context.DataTruckGPSHistory dbtruckHistory = new Context.DataTruckGPSHistory();
model.SetDbTruckHistory(dbtruckHistory, UserPrincipal.firstname + " " + UserPrincipal.lastname);
RepoDataGps.save(dbitem, UserPrincipal.id, dbitemHistory);
Context.DataTruck dbtruck = RepoDataTruck.FindByPK(model.IdDataTruck.Value);
dbtruckHistory.Vehicle = dbtruck.VehicleNo;
dbtruckHistory.NoGPS = dbitem.NoGPS;
dbtruckHistory.strVendor = dbitem.IdVendor.HasValue ? RepoVendorGPS.FindByPK(dbitem.IdVendor.Value).Nama : "";
dbtruck.DataTruckGPSHistory.Add(dbtruckHistory);
RepoDataTruck.save(dbtruck, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
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 }));
}
public ActionResult Add(PenetapanDriver model)
{
if (ModelState.IsValid)
{
bool isPalid = true;
if (RepoPenetapanDriver.IsExist(model.IdDataTruck.Value))
{
isPalid = false;
ModelState.AddModelError("IdDataTruck", "Data truck sudah digunakan.");
}
if (RepoPenetapanDriver.isExistDriver(model.IdDriver1.Value, 0))
{
isPalid = false;
ModelState.AddModelError("idDriver1", "Driver sudah digunakan.");
}
if (model.IdDriver2.HasValue)
{
if (RepoPenetapanDriver.isExistDriver(model.IdDriver2.Value, 0))
{
isPalid = false;
ModelState.AddModelError("IdDriver2", "Driver sudah digunakan.");
}
if (model.IdDriver1 == model.IdDriver2)
{
isPalid = false;
ModelState.AddModelError("IdDriver1", "Driver tidak boleh sama.");
ModelState.AddModelError("IdDriver2", "Driver tidak boleh sama.");
}
if (model.IdDitetapkanOleh2 == null)
{
isPalid = false;
ModelState.AddModelError("IdDitetapkanOleh2", "Penetap Driver 2 Belum Ditentukan.");
}
}
if (model.IdDitetapkanOleh1 == null)
{
isPalid = false;
ModelState.AddModelError("IdDitetapkanOleh1", "Penetap Driver 1 Belum Ditentukan.");
}
if (!isPalid)
{
return(View("Form", model));
}
Context.PenetapanDriver dbitem = new Context.PenetapanDriver();
Context.PenetapanDriverHistory dbitemHistory = new Context.PenetapanDriverHistory();
//history
model.SetDb(dbitem, UserPrincipal.firstname + ' ' + UserPrincipal.lastname);
model.SetDbHistory(dbitemHistory, UserPrincipal.firstname + " " + UserPrincipal.lastname);
dbitemHistory.CreatedBy = UserPrincipal.firstname + " " + UserPrincipal.lastname;
dbitemHistory.CreatedDate = DateTime.Now;
dbitem.PenetapanDriverHistory.Add(dbitemHistory);
//history driver
Context.DataTruck dbtruck = RepoTruck.FindByPK(model.IdDataTruck.Value);
Context.Driver dbdriver1 = RepoDriver.FindByPK(model.IdDriver1.Value);
Context.DriverTruckHistory dbdriverHistory1 = new Context.DriverTruckHistory();
dbdriver1.NoHp1 = model.NoHp1Driver1;
dbdriver1.NoHp2 = model.NoHp2Driver1;
dbdriverHistory1.Tanggal = DateTime.Now;
dbdriverHistory1.Nopol = dbtruck.VehicleNo;
dbdriverHistory1.Type = model.JenisTruck;
dbdriver1.DriverTruckHistory.Add(dbdriverHistory1);
RepoDriver.save(dbdriver1);
string query = "UPDATE dbo.\"Driver\" SET \"NoHp1\" = " + dbdriver1.NoHp1 + ", \"NoHp2\" = " + dbdriver1.NoHp2 + " WHERE \"Id\" = " + dbdriver1.Id + ";INSERT INTO dbo.\"DriverTruckHistory\" (\"IdDriver\", " +
"\"Tanggal\", \"Type\", \"Nopol\") VALUES (" + dbdriverHistory1.IdDriver + ", " + dbdriverHistory1.Tanggal + ", " + dbdriverHistory1.Type + ", " + dbdriverHistory1.Nopol + ");";
RepoAuditrail.SetAuditTrail(query, "Penetapan Driver", "Add", UserPrincipal.id);
if (model.IdDriver2.HasValue)
{
Context.Driver dbdriver2 = RepoDriver.FindByPK(model.IdDriver2.Value);
Context.DriverTruckHistory dbdriverHistory2 = new Context.DriverTruckHistory();
dbdriver2.NoHp1 = model.NoHp1Driver2;
dbdriver2.NoHp2 = model.NoHp2Driver2;
dbdriverHistory2.Tanggal = DateTime.Now;
dbdriverHistory2.Nopol = dbtruck.VehicleNo;
dbdriverHistory2.Type = model.JenisTruck;
dbdriver2.DriverTruckHistory.Add(dbdriverHistory2);
RepoDriver.save(dbdriver2);
query = "UPDATE dbo.\"Driver\" SET \"NoHp1\" = " + dbdriver2.NoHp1 + ", \"NoHp2\" = " + dbdriver2.NoHp2 + " WHERE \"Id\" = " + dbdriver2.Id + ";INSERT INTO dbo.\"DriverTruckHistory\" ( " +
"\"IdDriver\", \"Tanggal\", \"Type\", \"Nopol\") VALUES (" + dbdriverHistory2.IdDriver + ", " + dbdriverHistory2.Tanggal + ", " + dbdriverHistory2.Type + ", " + dbdriverHistory2.Nopol + ");";
RepoAuditrail.SetAuditTrail(query, "Penetapan Driver", "Add", UserPrincipal.id);
}
RepoPenetapanDriver.save(dbitem);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public DataTruck(Context.DataTruck dbitem)
{
Id = dbitem.Id;
NoTruck = dbitem.NoTruck;
VehicleNo = dbitem.VehicleNo;
IdMerk = dbitem.IdMerk != null ? dbitem.IdMerk : null;
strMerk = dbitem.IdMerk != null ? dbitem.LookupCodeMerk.Nama : "";
IdJenisTruck = dbitem.IdJenisTruck != null ? dbitem.IdJenisTruck : null;
strJenisTruck = dbitem.IdJenisTruck != null ? dbitem.JenisTrucks.StrJenisTruck : "";
TahunBuat = dbitem.TahunBuat;
TahunBeli = dbitem.TahunBeli;
IdPool = dbitem.IdPool != null ? dbitem.IdPool : null;
strPool = dbitem.IdPool != null ? dbitem.MasterPool.NamePool : "";
IdUnit = dbitem.IdUnit != null ? dbitem.IdUnit : null;
strUnit = dbitem.IdUnit != null ? dbitem.LookupCodeUnit.Nama : "";
Keterangan = dbitem.Keterangan;
Kondisi = dbitem.Kondisi;
SpecModel = dbitem.SpecModel;
KmLimit = dbitem.KmLimit;
NoMesin = dbitem.NoMesin;
NoRangka = dbitem.NoRangka;
GaransiStr = dbitem.GaransiStr;
GaransiEnd = dbitem.GaransiEnd;
SpecKeterangan = dbitem.SpecKeterangan;
MaxSpeed = dbitem.MaxSpeed;
AtasNama = dbitem.AtasNama;
BPKB = dbitem.BPKB;
STNK = dbitem.STNK;
KIR = dbitem.KIR;
KIU = dbitem.KIU;
IBM = dbitem.IBM;
Asuransi = dbitem.Asuransi;
Reklame = dbitem.Reklame;
NoPolis = dbitem.NoPolis;
Peminjam = dbitem.Peminjam;
Leasing = dbitem.Leasing;
keteranganBPKB = dbitem.keteranganBPKB;
keteranganSTNK = dbitem.keteranganSTNK;
keteranganKIR = dbitem.keteranganKIR;
keteranganKIU = dbitem.keteranganKIU;
keteranganIBM = dbitem.keteranganIBM;
keteranganAsuransi = dbitem.keteranganAsuransi;
keteranganReklame = dbitem.keteranganReklame;
keteranganNoPolis = dbitem.keteranganNoPolis;
keteranganPeminjam = dbitem.keteranganPeminjam;
keteranganLeasing = dbitem.keteranganLeasing;
urlBPKB = dbitem.urlBPKB;
urlSTNK = dbitem.urlSTNK;
urlKIR = dbitem.urlKIR;
urlKIU = dbitem.urlKIU;
urlIBM = dbitem.urlIBM;
urlAsuransi = dbitem.urlAsuransi;
urlReklame = dbitem.urlReklame;
urlNoPolis = dbitem.urlNoPolis;
urlPeminjam = dbitem.urlPeminjam;
urlLeasing = dbitem.urlLeasing;
}
public ActionResult EditOncall(SalesOrderOncall model, string btnsave)
{
//validasi manual
bool palid = true;
int urutan = 1;
if (btnsave != "draft" && model.Status != "draft")
{
if (!model.IdDataTruck.HasValue)
{
ModelState.AddModelError("IdDataTruck", "Truk harus diisi.");
palid = false;
}
if (!model.Driver1Id.HasValue || model.Driver1Id.Value == 0)
{
ModelState.AddModelError("Driver1Id", "Driver harus diisi.");
palid = false;
}
if (model.Driver1Id != null)
{
Context.Driver item = RepoDriver.FindAll().Where(d => d.Id == model.Driver1Id.Value).FirstOrDefault();
List <Context.SalesOrder> dbso = RepoSalesOrder.FindAll().ToList();
List <Context.SettlementBatal> dbsb = RepoSettlementBatal.FindAll().Where(s => s.IsProses == false).ToList();
Driver driver = new Driver(item, dbso, dbsb);
Context.SalesOrder dbsoDriver = RepoSalesOrder.FindAll().Where(d =>
(d.Status == "save" || d.Status == "draft planning" || d.Status == "draft konfirmasi" || d.Status == "save konfirmasi" || d.Status == "dispatched") && (
(d.SalesOrderOncallId.HasValue && (d.SalesOrderOncall.Driver1Id == model.Driver1Id || d.SalesOrderOncall.Driver2Id == model.Driver1Id)) ||
(d.SalesOrderPickupId.HasValue && (d.SalesOrderPickup.Driver1Id == model.Driver1Id || d.SalesOrderPickup.Driver2Id == model.Driver1Id)) ||
(d.SalesOrderProsesKonsolidasiId.HasValue && (d.SalesOrderProsesKonsolidasi.Driver1Id == model.Driver1Id || d.SalesOrderProsesKonsolidasi.Driver2Id == model.Driver1Id))
)
).FirstOrDefault();
if (driver.StatusSo != "Available" && dbsoDriver != null && RepoSalesOrder.FindArea(dbsoDriver.SalesOrderOncall.IdDaftarHargaItem.Value) != "YES")
{
List <Context.SalesOrder> dbsoDriverList = RepoSalesOrder.FindAll().Where(d =>
(d.Status == "save" || d.Status == "draft planning" || d.Status == "draft konfirmasi" || d.Status == "save konfirmasi" || d.Status == "dispatched") && (
(d.SalesOrderOncallId.HasValue && (d.SalesOrderOncall.Driver1Id == model.Driver1Id || d.SalesOrderOncall.Driver2Id == model.Driver1Id)) ||
(d.SalesOrderPickupId.HasValue && (d.SalesOrderPickup.Driver1Id == model.Driver1Id || d.SalesOrderPickup.Driver2Id == model.Driver1Id)) ||
(d.SalesOrderProsesKonsolidasiId.HasValue && (d.SalesOrderProsesKonsolidasi.Driver1Id == model.Driver1Id || d.SalesOrderProsesKonsolidasi.Driver2Id == model.Driver1Id))
)
).ToList();
urutan = dbsoDriver.urutan + 1;
//SO yg sdh jalan
Context.Rute rute = RepoSalesOrder.FindRute(dbsoDriver.SalesOrderOncall.IdDaftarHargaItem.Value);
int waktuKerja = int.Parse(rute.WaktuKerja.ToString());
//SO yg sedang diplanning
Context.SalesOrder so = RepoSalesOrder.FindByOnCall(model.SalesOrderId.Value);
Context.Rute rutePlanning = null;
if (so != null && so.SalesOrderOncall != null && so.SalesOrderOncall.IdDaftarHargaItem != null)
{
rutePlanning = RepoSalesOrder.FindRute(so.SalesOrderOncall.IdDaftarHargaItem.Value);
int waktuKerjaPlanning = int.Parse(rutePlanning.WaktuKerja.ToString());
bool used_at_that_date = dbsoDriverList.Any(d =>
DateTime.Parse(d.SalesOrderOncall.TanggalMuat.ToString()).AddDays(waktuKerja) >= model.TanggalMuat ||
DateTime.Parse(d.SalesOrderOncall.TanggalMuat.ToString()) <= DateTime.Parse(model.TanggalMuat.ToString()).AddDays(waktuKerja)
);
if (used_at_that_date)
{
ModelState.AddModelError("Driver1Id", "Driver tidak tersedia, harap pilih driver lain.");
palid = false;
}
else if (urutan > 2 && rutePlanning.IsAreaPulang != true)
{
ModelState.AddModelError("Driver1Id", "Driver tidak tersedia, harap pilih driver lain.");
palid = false;
}
}
}
}
}
if (model.Status == "draft")
{
if (model.CommentUser == "" || model.CommentUser == null)
{
ModelState.AddModelError("CommentUser", "Comment harus diisi.");
palid = false;
}
}
if (palid)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(model.SalesOrderId.Value);
dbitem.isReturn = false;
dbitem.UpdatedBy = UserPrincipal.id;
dbitem.urutan = urutan;
string act = "";
if (btnsave != null && btnsave != "")
{
act = "Draft";
dbitem.Status = btnsave;
}
else
{
if (model.Status.ToLower() == "save")
{
act = "Return";
dbitem.isReturn = true;
}
else
{
act = "Submit";
dbitem.isReturn = false;
}
dbitem.Status = model.Status;
}
model.setDbOperasional(dbitem.SalesOrderOncall, act, "Operational");
RepoSalesOrder.save(dbitem);
RepoAuditrail.savePlanningHistory(dbitem);
Context.so_mstr dbptnr = Reposo_mstr.FindByPK(dbitem.SalesOrderOncall.SONumber);
Context.DataTruck truck = RepoDataTruck.FindByPK(model.IdDataTruck);
try
{
dbptnr.so_vehicle = Repocode_mstr.FindByCodeName(truck.VehicleNo).id;
Reposo_mstr.UpdateSoMstrVehicle(dbptnr);
}
catch (Exception)
{
}
return(RedirectToAction("Index"));
}
else
{
ViewBag.kondisi = "planning";
ViewBag.name = model.SONumber;
ViewBag.Title = "Planning Sales Order Oncall " + model.SONumber;
ViewBag.PostData = "EditOncall";
return(View("SalesOrderOncall/FormReadOnly", model));
}
}
public DataTruckDetail(Context.DataTruck dbitem, List <Context.PenetapanDriver> dbPenetapanDriver = null, List <Context.SalesOrder> dbso = null)
{
Id = dbitem.Id;
//cek status order
StatusOrder = "";
StatusTruk = "Available";
if (dbso != null)
{
if (dbso.Any(d => (d.Status == "save" || d.Status == "draft planning") &&
((d.SalesOrderOncallId.HasValue ? d.SalesOrderOncall.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderPickupId.HasValue ? d.SalesOrderPickup.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderProsesKonsolidasiId.HasValue ? d.SalesOrderProsesKonsolidasi.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderKontrakId.HasValue ? d.SalesOrderKontrak.SalesOrderKontrakTruck.Any(k => k.DataTruckId == dbitem.Id) : false))))
{
StatusOrder = "Planning";
StatusTruk = "On Duty";
}
else if (dbso.Any(d => (d.Status == "save planning" || d.Status == "draft konfirmasi") &&
((d.SalesOrderOncallId.HasValue ? d.SalesOrderOncall.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderPickupId.HasValue ? d.SalesOrderPickup.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderProsesKonsolidasiId.HasValue ? d.SalesOrderProsesKonsolidasi.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderKontrakId.HasValue ? d.SalesOrderKontrak.SalesOrderKontrakTruck.Any(k => k.DataTruckId == dbitem.Id) : false))))
{
StatusOrder = "Konfirmasi";
StatusTruk = "On Duty";
}
else if (dbso.Any(d => (d.Status == "save konfirmasi" || d.Status == "dispatched") &&
((d.SalesOrderOncallId.HasValue ? d.SalesOrderOncall.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderPickupId.HasValue ? d.SalesOrderPickup.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderProsesKonsolidasiId.HasValue ? d.SalesOrderProsesKonsolidasi.IdDataTruck == dbitem.Id : false) ||
(d.SalesOrderKontrakId.HasValue ? d.SalesOrderKontrak.SalesOrderKontrakTruck.Any(k => k.DataTruckId == dbitem.Id) : false))))
{
StatusOrder = "Dispatched";
StatusTruk = "On Duty";
}
}
//StatusTruk =
VehicleNo = dbitem.VehicleNo;
Merk = dbitem.IdMerk != null ? dbitem.LookupCodeMerk.Nama : "";
JenisTruk = !dbitem.IdJenisTruck.HasValue ? "" : dbitem.JenisTrucks.StrJenisTruck;
if (dbitem.DataPendingin.Count > 0)
{
Context.DataPendingin dbpendingin = dbitem.DataPendingin.FirstOrDefault();
Pendingin = dbpendingin.Merk + " - " + dbpendingin.Model;
}
if (dbitem.DataBox.Count > 0)
{
Context.DataBox dbbox = dbitem.DataBox.FirstOrDefault();
List <string> _lantai = new List <string>();
List <string> _dinding = new List <string>();
if (dbbox.Lantai != null && dbbox.Lantai != "")
{
_lantai.Add(dbbox.Lantai);
}
if (dbbox.Dinding != null && dbbox.Dinding != "")
{
_dinding.Add(dbbox.Dinding);
}
foreach (DataBoxLantai item in dbbox.DataBoxLantai)
{
_lantai.Add(item.LookupCodeLantaiCode.Nama);
}
foreach (DataBoxDinding item in dbbox.DataBoxDinding)
{
_dinding.Add(item.LookupCodeDinding.Nama);
}
if (_lantai.Count() > 0)
{
Lantai = string.Join(", ", _lantai);
}
if (_dinding.Count() > 0)
{
Dinding = string.Join(", ", _dinding);
}
}
KondisiKhusus = dbitem.Kondisi;
List <string> _dok = new List <string>();
if (dbitem.STNK != null && dbitem.STNK.Value >= DateTime.Now)
{
_dok.Add("STNK");
}
if (dbitem.KIR != null && dbitem.KIR.Value >= DateTime.Now)
{
_dok.Add("KIR");
}
if (dbitem.KIU != null && dbitem.KIU.Value >= DateTime.Now)
{
_dok.Add("KIU/SIPA");
}
if (dbitem.IBM != null && dbitem.IBM.Value >= DateTime.Now)
{
_dok.Add("IBM");
}
if (dbitem.Asuransi != null && dbitem.Asuransi.Value >= DateTime.Now)
{
_dok.Add("Asuransi");
}
if (dbitem.Reklame != null && dbitem.Reklame.Value >= DateTime.Now)
{
_dok.Add("Pajak Reklame");
}
if (_dok.Count > 0)
{
DokumenExp = string.Join(", ", _dok);
}
if (dbPenetapanDriver != null)
{
Context.PenetapanDriver dbPenetapan = dbPenetapanDriver.Where(d => d.IdDataTruck == dbitem.Id).FirstOrDefault();
if (dbPenetapan != null)
{
IdDriver1 = dbPenetapan.IdDriver1.Value;
KodeDriver1 = dbPenetapan.Driver1.KodeDriver;
NamaDriver1 = dbPenetapan.Driver1.NamaDriver;
StatusDriver1 = dbPenetapan.Driver1.LookupCodeStatus.Nama;
if (dbPenetapan.IdDriver2.HasValue)
{
IdDriver2 = dbPenetapan.IdDriver2.Value;
KodeDriver2 = dbPenetapan.Driver2.KodeDriver;
NamaDriver2 = dbPenetapan.Driver2.NamaDriver;
StatusDriver2 = dbPenetapan.Driver2.LookupCodeStatus.Nama;
}
}
}
}
public string Upload(IEnumerable <HttpPostedFileBase> filesPenetapanDriver)
{
ResponeModel response = new ResponeModel();
if (filesPenetapanDriver != null)
{
foreach (var file in filesPenetapanDriver)
{
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 && RepoTruck.FindByName(workSheet.Cells[rowIterator, 1].Value.ToString()) != null)
{
int id = 0;
int resId;
if (workSheet.Cells[rowIterator, 10].Value != null)
{
if (int.TryParse(workSheet.Cells[rowIterator, 10].Value.ToString(), out resId))
{
id = resId;
}
}
Context.PenetapanDriver db = new Context.PenetapanDriver();
try
{
if (id != 0)
{
db = RepoPenetapanDriver.FindByPK(id);
}
Context.Driver dr1 = RepoDriver.FindByCode(workSheet.Cells[rowIterator, 2].Value.ToString());
Context.Driver dr2 = workSheet.Cells[rowIterator, 6].Value == null ? null : RepoDriver.FindByCode(workSheet.Cells[rowIterator, 6].Value.ToString());
db.IdDataTruck = RepoTruck.FindByName(workSheet.Cells[rowIterator, 1].Value.ToString()).Id;
if (id == 0 && RepoPenetapanDriver.IsExist(db.IdDataTruck.Value))
{
continue;
}
if (dr1 != null)
{
if (RepoPenetapanDriver.isExistDriver(dr1.Id, id))
{
continue;
}
}
if (dr2 != null)
{
if (RepoPenetapanDriver.isExistDriver(dr2.Id, id))
{
continue;
}
}
if (dr1 != null && dr2 != null)
{
if (dr2.Id.Equals(dr1.Id))
{
continue;
}
}
db.IdDriver1 = dr1.Id;
db.NoHp1Driver1 = workSheet.Cells[rowIterator, 3].Value == null ? dr1.NoHp1 : workSheet.Cells[rowIterator, 3].Value.ToString();
db.NoHp2Driver1 = workSheet.Cells[rowIterator, 4].Value == null ? dr1.NoHp2 : workSheet.Cells[rowIterator, 4].Value.ToString();
db.DitetapkanOleh1 = workSheet.Cells[rowIterator, 5].Value == null ? null : workSheet.Cells[rowIterator, 5].Value.ToString();
if (dr2 != null)
{
db.IdDriver2 = dr2.Id;
db.NoHp1Driver2 = workSheet.Cells[rowIterator, 7].Value == null ? dr2.NoHp1 : workSheet.Cells[rowIterator, 7].Value.ToString();
db.NoHp2Driver2 = workSheet.Cells[rowIterator, 8].Value == null ? dr2.NoHp2 : workSheet.Cells[rowIterator, 8].Value.ToString();
db.DitetapkanOleh2 = workSheet.Cells[rowIterator, 9].Value == null ? null : workSheet.Cells[rowIterator, 9].Value.ToString();
dr2.NoHp1 = db.NoHp1Driver2;
dr2.NoHp2 = db.NoHp2Driver2;
}
db.ModifiedBy = UserPrincipal.username;
db.ModifiedDate = DateTime.Now;
dr1.NoHp1 = db.NoHp1Driver1;
dr1.NoHp2 = db.NoHp2Driver1;
RepoPenetapanDriver.save(db);
int resultId = db.Id;
//save penetapan driver history
Context.PenetapanDriverHistory dbItemHistory = new Context.PenetapanDriverHistory();
Context.PenetapanDriver pd = RepoPenetapanDriver.FindByPK(resultId);
dbItemHistory.IdPenetapanDriver = resultId;
dbItemHistory.Driver1 = dr1.NamaDriver;
if (dr2 != null)
{
dbItemHistory.Driver2 = dr2.NamaDriver;
}
dbItemHistory.CreatedBy = UserPrincipal.firstname + " " + UserPrincipal.lastname;
dbItemHistory.ModifiedBy = UserPrincipal.firstname + " " + UserPrincipal.lastname;
dbItemHistory.ModifiedDate = DateTime.Now;
pd.PenetapanDriverHistory.Add(dbItemHistory);
//history driver
Context.DriverTruckHistory dbdriverHistory1 = new Context.DriverTruckHistory();
Context.DriverTruckHistory dbdriverHistory2 = new Context.DriverTruckHistory();
Context.DataTruck dbtruck = RepoTruck.FindByPK(db.IdDataTruck.Value);
dbdriverHistory1.Tanggal = DateTime.Now;
dbdriverHistory1.Nopol = dbtruck.VehicleNo;
dbdriverHistory1.Type = dbtruck.JenisTrucks.StrJenisTruck;
dbdriverHistory2.Tanggal = DateTime.Now;
dbdriverHistory2.Nopol = dbtruck.VehicleNo;
dbdriverHistory2.Type = dbtruck.JenisTrucks.StrJenisTruck;
dr1.DriverTruckHistory.Add(dbdriverHistory1);
RepoDriver.save(dr1);
string query = "UPDATE dbo.\"Driver\" SET \"NoHp1\" = " + dr1.NoHp1 + ", \"NoHp2\" = " + dr1.NoHp2 + " WHERE \"Id\" = " + dr1.Id + ";INSERT INTO dbo.\"DriverTruckHistory\" ( " +
"\"IdDriver\", \"Tanggal\", \"Type\", \"Nopol\") VALUES (" + dbdriverHistory1.IdDriver + ", " + dbdriverHistory1.Tanggal + ", " + dbdriverHistory1.Type + ", " +
dbdriverHistory1.Nopol + ");";
RepoAuditrail.SetAuditTrail(query, "Penetapan Driver", "Import", UserPrincipal.id);
if (dr2 != null)
{
dr2.NoHp1 = db.NoHp1Driver2;
dr2.NoHp2 = db.NoHp2Driver2;
dr2.DriverTruckHistory.Add(dbdriverHistory2);
RepoDriver.save(dr2);
query = "UPDATE dbo.\"Driver\" SET \"NoHp1\" = " + dr2.NoHp1 + ", \"NoHp2\" = " + dr2.NoHp2 + " WHERE \"Id\" = " + dr2.Id + ";INSERT INTO dbo.\"DriverTruckHistory\" ( " +
"\"IdDriver\", \"Tanggal\", \"Type\", \"Nopol\") VALUES (" + dbdriverHistory2.IdDriver + ", " + dbdriverHistory2.Tanggal + ", " + dbdriverHistory2.Type + ", " +
dbdriverHistory2.Nopol + ");";
RepoAuditrail.SetAuditTrail(query, "Penetapan Driver", "Import", UserPrincipal.id);
}
RepoPenetapanDriver.save(pd);
}
catch (Exception)
{
}
}
}
}
response.Success = true;
}
catch (Exception e)
{
response.Success = false;
response.Message = e.Message.ToString();
}
}
}
return(new JavaScriptSerializer().Serialize(new { Response = response }));
}
