public PenetapanDriver(Context.PenetapanDriver dbitem)
{
Id = dbitem.Id;
IdDataTruck = dbitem.IdDataTruck;
VehicleNo = dbitem.DataTruck.VehicleNo;
JenisTruck = dbitem.DataTruck.IdJenisTruck.HasValue ? dbitem.DataTruck.JenisTrucks.StrJenisTruck : "";
IdDriver1 = dbitem.IdDriver1;
Kode1 = dbitem.Driver1.KodeDriver;
Nama1 = dbitem.Driver1.NamaDriver;
Panggilan1 = dbitem.Driver1.NamaPangilan;
NoHp1Driver1 = dbitem.NoHp1Driver1;
NoHp2Driver1 = dbitem.NoHp2Driver1;
Sim1 = dbitem.Driver1.LookupCodeJenisSim.Nama;
BerlakuSim1 = dbitem.Driver1.TglBerlakuSim.Value.Date;
IdDitetapkanOleh1 = dbitem.DitetapkanOleh1;
if (dbitem.IdDriver2.HasValue)
{
IdDriver2 = dbitem.IdDriver2;
Kode2 = dbitem.Driver2.KodeDriver;
Nama2 = dbitem.Driver2.NamaDriver;
Panggilan2 = dbitem.Driver2.NamaPangilan;
NoHp1Driver2 = dbitem.NoHp1Driver2;
NoHp2Driver2 = dbitem.NoHp2Driver2;
Sim2 = dbitem.Driver2.LookupCodeJenisSim.Nama;
BerlakuSim2 = dbitem.Driver2.TglBerlakuSim.Value.Date;
IdDitetapkanOleh2 = dbitem.DitetapkanOleh2;
}
}
public ActionResult Edit(int id)
{
Context.PenetapanDriver dbitem = RepoPenetapanDriver.FindByPK(id);
PenetapanDriver model = new PenetapanDriver(dbitem);
ViewBag.name = model.VehicleNo;
return(View("Form", model));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.PenetapanDriver dbItem = RepoPenetapanDriver.FindByPK(id);
RepoPenetapanDriver.delete(dbItem);
return(Json(response));
}
public string BindingHistory(int id)
{
Context.PenetapanDriver db = RepoPenetapanDriver.FindByPK(id);
return(new JavaScriptSerializer().Serialize(db.PenetapanDriverHistory.
Select(d => new {
Driver1 = d.Driver1,
Driver2 = d.Driver2,
CreatedBy = d.CreatedBy,
ModifiedBy = d.ModifiedBy,
ModifiedDate = d.ModifiedDate
})));
}
public void SetDb(Context.PenetapanDriver dbitem, string user)
{
dbitem.IdDataTruck = IdDataTruck;
dbitem.IdDriver1 = IdDriver1;
dbitem.NoHp1Driver1 = NoHp1Driver1;
dbitem.NoHp2Driver1 = NoHp1Driver1;
dbitem.IdDriver2 = IdDriver2;
dbitem.NoHp1Driver2 = NoHp1Driver2;
dbitem.NoHp2Driver2 = NoHp2Driver2;
dbitem.DitetapkanOleh1 = IdDitetapkanOleh1;
dbitem.DitetapkanOleh2 = IdDitetapkanOleh2;
dbitem.ModifiedBy = user;
dbitem.ModifiedDate = DateTime.Now;
}
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 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 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 }));
}