public string BindingDataPendingin(int id)
{
Context.DataTruck dbtruck = RepoDataTruck.FindByPK(id);
List <DataPendingin> ListModel = new List <DataPendingin>();
foreach (Context.DataTruckPendinginHistory item in dbtruck.DataTruckPendinginHistory.OrderByDescending(d => d.Id))
{
if (ListModel.Count == 0)
{
ListModel.Add(new DataPendingin(item));
}
else
{
if (ListModel.Last().NoPendingin == item.NoPendingin)
{
var data = ListModel.Last();
data = new DataPendingin(item);
}
else
{
ListModel.Add(new DataPendingin(item));
}
}
}
return(new JavaScriptSerializer().Serialize(new { data = ListModel }));
}
public void save(DataPendingin dbitem, int id, DataPendinginHistory dph, DataTruckPendinginHistory dtph=null)
{
var dphq = "INSERT INTO dbo.\"DataPendinginHistory\" (\"IdPendingin\", \"NoPendingin\", \"Tanggal\", \"strDataTruk\", \"Merk\", \"Model\", \"HmLimit\", \"Tahun\", \"strJenisPendingin\", " +
"\"NoMesin\", \"NoKompresor\", \"tglPasang, user) VALUES (" + dph.IdPendingin + ", " + dph.NoPendingin + ", " + dph.Tanggal + ", " + dph.strDataTruk + ", " + dph.Merk + ", " + dph.Model +
", " + dph.HmLimit + ", " + dph.Tahun + ", " + dph.strJenisPendingin + ", " + dph.NoMesin + ", " + dph.NoKompresor + ", " + dph.tglPasang + ", " + dph.user + ");";
if (dtph != null){
dphq += "INSERT INTO dbo.\"DataTruckPendinginHistory\" (\"IdDataTruck\", \"NoPendingin\", \"Tanggal\", \"strDataTruk\", \"Merk\", \"Model\", \"HmLimit\", \"Tahun\", \"strJenisPendingin\", \"NoMesin\", " +
"\"NoKompresor\", \"tglPasang\", user) VALUES (" + dtph.IdDataTruck + ", " + dtph.NoPendingin + ", " + dtph.Tanggal + ", " + dtph.strDataTruk + ", " + dtph.Merk + ", " + dtph.Model + ", " + dtph.HmLimit + ", " +
dtph.Tahun + ", " + dtph.strJenisPendingin + ", " + dtph.NoMesin + ", " + dtph.NoKompresor + ", " + dtph.tglPasang + ", " + dtph.user + ");";
}
if (dbitem.Id == 0) //create
{
context.DataPendingin.Add(dbitem);
var query = "INSERT INTO dbo.\"DataPendingin\" (\"NoPendingin\", \"IdDataTruk\", \"Merk\", \"Model\", \"HmLimit\", \"Tahun\", \"IdJenisPendingin\", \"NoMesin\", \"NoKompresor\", \"tglPasang\", \"Urutan\")" +
"VALUES (" + dbitem.NoPendingin + ", " + dbitem.IdDataTruk + ", " + dbitem.Merk + ", " + dbitem.Model + ", " + dbitem.HmLimit + ", " + dbitem.Tahun + ", " + dbitem.IdJenisPendingin + ", " +
dbitem.NoMesin + ", " + dbitem.NoKompresor + ", " + dbitem.tglPasang + ", " + dbitem.Urutan + ");";
var auditrail = new Auditrail { Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Data Pendingin", QueryDetail = query + dphq, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id };
context.Auditrail.Add(auditrail);
}
else //edit
{
context.DataPendingin.Attach(dbitem);
var query = "UPDATE dbo.\"DataPendingin\" SET \"NoPendingin\" = " + dbitem.NoPendingin + ", \"IdDataTruk\" = " + dbitem.IdDataTruk + ", \"Merk\" = " + dbitem.Merk + ", \"Model\" = \" = " + dbitem.Model +
", \"HmLimit\" = " + dbitem.HmLimit + ", \"Tahun\" = " + dbitem.Tahun + ", \"IdJenisPendingin\" = " + dbitem.IdJenisPendingin + ", \"NoMesin\" = " + dbitem.NoMesin + ", \"NoKompresor\" = " +
dbitem.NoKompresor + ", \"tglPasang\" = " + dbitem.tglPasang + ", \"Urutan\" = " + dbitem.Urutan + " WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Data Pendingin", QueryDetail = query + dphq, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id };
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
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 ActionResult Edit(int id)
{
DataPendingin model = new DataPendingin(RepoPendingin.FindByPK(id));
ViewBag.name = model.NoPendingin;
return(View("Form", model));
}
public void delete(DataPendingin dbitem, int id)
{
context.DataPendingin.Remove(dbitem);
var query = "DELETE FROM dbo.\"DataPendingin\" WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail { Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Data Pendingin", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id };
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
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()
{
DataPendingin model = new DataPendingin();
return(View("Form", model));
}
