public void delete(Rekenings dbitem)
{
context.Rekenings.Remove(dbitem);
var auditrail = new Auditrail { Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Product", QueryDetail = "Delete " + dbitem.NamaRekening, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 };
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void save(MasterPool dbitem, int id)
{
var query = "";
if (dbitem.Id == 0) //create
{
context.MasterPool.Add(dbitem);
}
else //edit
{
context.MasterPool.Attach(dbitem);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
query += "DELETE FROM dbo.\"ZoneParkir\" WHERE \"IdPool\" = " + dbitem.Id + ";";
}
context.SaveChanges();
foreach (Context.ZoneParkir item in dbitem.ListZoneParkir)
{
query += "INSERT INTO dbo.\"ZoneParkir\" (\"IdPool\", \"IdZone\", \"Pit\") VALUES (" + item.IdPool + ", " + dbitem.Id + ", " + item.Pit + ");";
}
var auditrail = new Auditrail {
Actionnya = dbitem.Id == 0 ? "Add" : "Edit", EventDate = DateTime.Now, Modulenya = "Master Pool", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(),
IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void save(DataGPS dbitem, int id, DataGPSHistory dgh)
{
var hstq = "INSERT INTO dbo.\"DataGPSHistory\" (\"IdDataGPS\", \"NoGPS\", \"Vehicle\", \"strVendor\", \"ModelGps\", \"NoDevice\", \"SensorSuhu\", \"SensorPintu\", \"Tahun\", \"TanggalPasang\", " +
"\"TanggalGaransi\", \"Tanggal\", \"Username\") VALUES (" + dgh.IdDataGPS + ", " + dgh.NoGPS + ", " + dgh.Vehicle + ", " + dgh.strVendor + ", " + dgh.ModelGps + ", " + dgh.NoDevice + ", " + dgh.SensorSuhu +
", " + dgh.SensorPintu + ", " + dgh.Tahun + ", " + dgh.TanggalPasang + ", " + dgh.TanggalGaransi + ", " + dgh.Tanggal + ", " + dgh.Username + ");";
if (dbitem.Id == 0) //create
{
context.DataGPS.Add(dbitem);
var query = "INSERT INTO dbo.\"DataGPS\" (\"NoGPS\", \"IdDataTruck\", \"IdVendor\", \"ModelGps\", \"NoDevice\", \"SensorSuhu\", \"SensorPintu\", \"Tahun\", \"TanggalPasang\", \"TanggalGaransi\", urutan) " +
"VALUES (" + dbitem.NoGPS + "," + dbitem.IdDataTruck + "," + dbitem.IdVendor + "," + dbitem.ModelGps + "," + dbitem.NoDevice + "," + dbitem.SensorSuhu + "," + dbitem.SensorPintu + "," + dbitem.Tahun +
"," + dbitem.TanggalPasang + "," + dbitem.TanggalGaransi + "," + dbitem.urutan + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Data GPS", QueryDetail = query + hstq, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.DataGPS.Attach(dbitem);
var query = "UPDATE dbo.\"DataGPS\" SET \"NoGPS\" = " + dbitem.NoGPS + ", \"IdDataTruck\" = " + dbitem.IdDataTruck + ", \"IdVendor\" = " + dbitem.IdVendor + ", \"ModelGps\" = " + dbitem.ModelGps +
", \"NoDevice\" = " + dbitem.NoDevice + ", \"SensorSuhu\" = " + dbitem.SensorSuhu + ", \"SensorPintu\" = " + dbitem.SensorPintu + ", \"Tahun\" = " + dbitem.Tahun + ", \"TanggalPasang\" = " +
dbitem.TanggalPasang + ", \"TanggalGaransi\" = " + dbitem.TanggalGaransi + ", urutan = " + dbitem.urutan + " WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Data GPS", QueryDetail = query + hstq, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void save(JenisTrucks dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.JenisTrucks.Add(dbitem);
var query = "INSERT INTO dbo.\"JenisTrucks\" (\"StrJenisTruck\", \"GolTol\", \"Alias\", \"Biaya\", \"AcInterval\") VALUES (" + dbitem.StrJenisTruck + ", " + dbitem.GolTol + ", " + dbitem.Alias + ", " +
dbitem.Biaya + ", " + dbitem.AcInterval + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Jenis Truk", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.JenisTrucks.Attach(dbitem);
var query = "UPDATE dbo.\"JenisTrucks\" SET \"StrJenisTruck\" = " + dbitem.StrJenisTruck + ", \"GolTol\" = " + dbitem.GolTol + ", \"Alias\" = " + dbitem.Alias + ", \"Biaya\" = " + dbitem.Biaya +
", \"AcInterval\" = " + dbitem.AcInterval + "WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Jenis Truk", QueryDetail = "Edit " + dbitem.StrJenisTruck, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void save(Atm dbitem, int usr_id)
{
if (dbitem.Id == 0) //create
{
context.Atm.Add(dbitem);
var query = "INSERT INTO dbo.\"Atm\" (\"NoKartu\", \"IdBank\", \"NoRekening\", \"AtasNama\", \"IdDriver\") VALUES (" + dbitem.NoKartu + ", " + dbitem.IdBank + ", " + dbitem.NoRekening +
", " + dbitem.AtasNama + ", " + dbitem.IdDriver + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Atm", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = usr_id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.Atm.Attach(dbitem);
var query = "UPDATE dbo.\"Atm\" SET \"NoKartu\" = " + dbitem.NoKartu + ", \"IdBank\" = " + dbitem.IdBank + ", \"NoRekening\" = " + dbitem.NoRekening + ", \"AtasNama\" = " +
dbitem.AtasNama + ", \"IdDriver\" = " + dbitem.IdDriver + ", WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Atm", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = usr_id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void save(TimeAlert dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.TimeAlert.Add(dbitem);
var query = "INSERT INTO dbo.\"TimeAlert\" (\"idProses\", \"keteranganBagian\", status, \"over\", \"overSatuan\", \"idUserAlert\", \"AlertPopup\", \"AlertSound\", \"AlertEmail\", " +
"\"rowColor\") VALUES ( " + dbitem.idProses + ", " + dbitem.keteranganBagian + ", " + dbitem.status + ", " + dbitem.over + ", " + dbitem.overSatuan + ", " + dbitem.idUserAlert + ", " +
dbitem.AlertPopup + ", " + dbitem.AlertSound + ", " + dbitem.AlertEmail + ", " + dbitem.rowColor + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Time Alert", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.TimeAlert.Attach(dbitem);
var query = "UPDATE dbo.\"TimeAlert\" SET \"idProses\" = " + dbitem.idProses + ", \"keteranganBagian\" = " + dbitem.keteranganBagian + ", status = " + dbitem.status +
", \"over\" = " + dbitem.over + ", \"overSatuan\" = " + dbitem.overSatuan + ", \"idUserAlert\" = " + dbitem.idUserAlert + ", \"AlertPopup\" = " + dbitem.AlertPopup +
", \"AlertSound\" = " + dbitem.AlertSound + ", \"AlertEmail\" = " + dbitem.AlertEmail + ", \"rowColor\" = " + dbitem.rowColor + " WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Time Alert", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void save(TrainingSetting dbitem, int id)
{
var query = "";
if (dbitem.Id == 0) //create
{
context.TrainingSetting.Add(dbitem);
query += "INSERT INTO dbo.\"TrainingSetting\" (\"Nama\", \"Interval\") VALUES (" + dbitem.Nama + ", " + dbitem.Interval + ");";
}
else //edit
{
context.TrainingSetting.Attach(dbitem);
query += "UPDATE dbo.\"TrainingSetting\" SET \"Nama\" = " + dbitem.Nama + ", \"Interval\" = " + dbitem.Interval + " WHERE \"Id\" = " + dbitem.Id + ";";
query += "DELETE FROM dbo.\"TrainingSettingDetail\" WHERE \"TrainingSettingId\" = " + dbitem.Id + ";";
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
foreach (Context.TrainingSettingDetail tsd in dbitem.TrainingSettingDetail)
{
query += "INSERT INTO dbo.\"TrainingSettingDetail\" (\"TrainingSettingId\", \"Materi\", \"NilaiMinimum\") VALUES (" + tsd.TrainingSettingId + ", " + tsd.Materi + ", " + tsd.NilaiMinimum + ");";
}
var auditrail = new Auditrail {
Actionnya = dbitem.Id == 0 ? "Add" : "Edit", EventDate = DateTime.Now, Modulenya = "Training", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(),
IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void save(Inventaris dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.Inventaris.Add(dbitem);
var query = "INSERT INTO dbo.\"Inventaris\" (\"TanggalPemberian\", \"TanggalPengembalian\", \"IdNamaBarang\", \"Keterangan\", \"DriverId\") VALUES (" + dbitem.TanggalPemberian + ", " +
dbitem.TanggalPengembalian + ", " + dbitem.IdNamaBarang + ", " + dbitem.Keterangan + ", " + dbitem.DriverId + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Inventaris", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.Inventaris.Attach(dbitem);
var query = "UPDATE dbo.\"Inventaris\" SET \"TanggalPemberian\" = " + dbitem.TanggalPemberian + ", \"TanggalPengembalian\" = " + dbitem.TanggalPengembalian + ", \"IdNamaBarang\" = " + dbitem.IdNamaBarang +
", \"Keterangan\" = " + dbitem.Keterangan + ", \"DriverId\" = " + dbitem.DriverId + " WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Inventaris", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void save(UserReference dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.UserReference.Add(dbitem);
var query = "INSERT INTO dbo.\"UserReference\" (\"IdUser\", \"Action\", \"Controller\", \"Coloumn\", \"HideShow\") VALUES (" + dbitem.IdUser + ", " + dbitem.Action + ", " +
dbitem.Controller + ", " + dbitem.Coloumn + ", " + dbitem.HideShow + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "User Reference", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.UserReference.Attach(dbitem);
var query = "UPDATE dbo.\"UserReference\" SET \"IdUser\" = " + dbitem.IdUser + ", \"Action\" = " + dbitem.Action + ", \"Controller\" = " + dbitem.Controller + ", \"Coloumn\" = " +
dbitem.Coloumn + ", \"HideShow\" = " + dbitem.HideShow + " WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "User Reference", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void save(BAP dbitem, int id)
{
string query = "";
if (dbitem.Id == 0) //create
{
context.BAP.Add(dbitem);
query = "INSERT INTO dbo.\"BAP\" (\"NoBAP\", \"TanggalKejadian\", \"JamKejadian\", \"KategoriId\", \"LaporanKejadian\", \"DilaporkanOleh\", \"Departemen1Id\", \"HasilPemeriksaan\"," +
"\"Penyelesaian\", \"DiperiksaOleh\", \"Departemen2Id\", \"SalesOrderId\", \"Driver1Id\", \"Driver2Id\", \"IdDataTruck\", \"Status\", \"File\", \"SalesOrderKontrakId\") VALUES (" +
dbitem.NoBAP + ", " + dbitem.TanggalKejadian + ", " + dbitem.JamKejadian + ", " + dbitem.KategoriId + ", " + dbitem.LaporanKejadian + ", " + dbitem.DilaporkanOleh + ", " +
dbitem.Departemen1Id + ", " + dbitem.HasilPemeriksaan + ", " + dbitem.Penyelesaian + ", " + dbitem.DiperiksaOleh + ", " + dbitem.Departemen2Id + ", " + dbitem.SalesOrderId + ", " +
dbitem.Driver1Id + ", " + dbitem.Driver2Id + ", " + dbitem.IdDataTruck + ", " + dbitem.Status + ", " + dbitem.File + ", " + dbitem.SalesOrderKontrakId + ");";
}
else //edit
{
context.BAP.Attach(dbitem);
query = "UPDATE dbo.\"BAP\" SET \"NoBAP\" = " + dbitem.NoBAP + ",\"TanggalKejadian\" = " + dbitem.TanggalKejadian + ",\"JamKejadian\" = " + dbitem.JamKejadian + ",\"KategoriId\" = " +
dbitem.KategoriId + ",\"LaporanKejadian\" = " + dbitem.LaporanKejadian + ",\"DilaporkanOleh\" = " + dbitem.DilaporkanOleh + ",\"Departemen1Id\" = " + dbitem.Departemen1Id +
",\"HasilPemeriksaan\" = " + dbitem.HasilPemeriksaan + ",\"Penyelesaian\" = " + dbitem.Penyelesaian + ",\"DiperiksaOleh\"; = " + dbitem.DiperiksaOleh + ",\"Departemen2Id\" = " +
dbitem.Departemen2Id + ",\"SalesOrderId\" = " + dbitem.SalesOrderId + ",\"Driver1Id\" = " + dbitem.Driver1Id + ",\"Driver2Id\" = " + dbitem.Driver2Id + ",\"IdDataTruck\" = " +
dbitem.IdDataTruck + ",\"Status\" = " + dbitem.Status + ",\"File\" = " + dbitem.File + ",\"SalesOrderKontrakId\" = " + dbitem.SalesOrderKontrakId + "WHERE \"Id\" = " + dbitem.Id + ";";
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
var auditrail = new Auditrail {
Actionnya = "Update", EventDate = DateTime.Now, Modulenya = "BAP", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void save(RuteTol dbitem, int id)
{
var query = "";
if (dbitem.Id == 0) //create
{
context.RuteTol.Add(dbitem);
}
else //edit
{
context.RuteTol.Attach(dbitem);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
query += "DELETE FROM dbo.\"TolBerangkat\" WHERE \"IdRuteTol\" = " + dbitem.Id + ";";
query += "DELETE FROM dbo.\"TolPulang\" WHERE \"IdRuteTol\" = " + dbitem.Id + ";";
}
context.SaveChanges();
foreach (Context.TolBerangkat tp in dbitem.ListTolBerangkat)
{
query += "INSERT INTO dbo.\"TolBerangkat\" (\"IdRuteTol\", \"IdTol\") VALUES (" + tp.IdRuteTol + ", " + tp.IdTol + ");";
}
foreach (Context.TolPulang tp in dbitem.ListTolPulang)
{
query += "INSERT INTO dbo.\"TolPulang\" (\"IdRuteTol\", \"IdTol\") VALUES (" + tp.IdRuteTol + ", " + tp.IdTol + ");";
}
var auditrail = new Auditrail {
Actionnya = dbitem.Id == 0 ? "Add" : "Edit", EventDate = DateTime.Now, Modulenya = "Rute Tol", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(),
IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
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 void save(VendorGps dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.VendorGps.Add(dbitem);
var query = "INSERT INTO dbo.\"VendorGps\" (\"Nama\", \"Merk\", \"Alamat\", \"Email\", \"Telp\", \"Web\") VALUES (" + dbitem.Nama + ", " + dbitem.Merk + ", " + dbitem.Alamat + ", " +
dbitem.Email + ", " + dbitem.Telp + ", " + dbitem.Web + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Vendor List", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.VendorGps.Attach(dbitem);
var query = "UPDATE dbo.\"VendorGps\" SET \"Nama\" = " + dbitem.Nama + ", \"Merk\" = " + dbitem.Merk + ", \"Alamat\" = " + dbitem.Alamat + ", \"Email\" = " + dbitem.Email + ", \"Telp\" = " +
dbitem.Telp + ", \"Web\" = " + dbitem.Web + " WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Vendor List", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void save(JnsTols dbitem, int id, HistoryJnsTols hjt)
{
var h_query = "INSERT INTO dbo.\"HistoryJnsTols\" (\"IdTol\", \"Tanggal\", \"NamaTol\", \"GolonganTol1\", \"GolonganTol2\", \"GolonganTol3\", \"GolonganTol4\", \"Keterangan\", \"IdUser\") VALUES (" + hjt.IdTol +
", " + hjt.Tanggal + ", " + hjt.NamaTol + ", " + hjt.GolonganTol1 + ", " + hjt.GolonganTol2 + ", " + hjt.GolonganTol3 + ", " + hjt.GolonganTol4 + ", " + hjt.Keterangan + ", " + hjt.IdUser + ");";
if (dbitem.Id == 0) //create
{
context.JnsTols.Add(dbitem);
var query = "INSERT INTO dbo.\"JnsTols\" (\"NamaTol\", \"GolonganTol1\", \"GolonganTol2\", \"GolonganTol3\", \"GolonganTol4\", \"Keterangan\") VALUES (" + dbitem.NamaTol + ", " + dbitem.GolonganTol1 + ", " +
dbitem.GolonganTol2 + ", " + dbitem.GolonganTol3 + ", " + dbitem.GolonganTol4 + ", " + dbitem.Keterangan + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Jenis Tol", QueryDetail = query + h_query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.JnsTols.Attach(dbitem);
var query = "UPDATE dbo.\"JnsTols\" SET \"NamaTol\" = " + dbitem.NamaTol + ", \"GolonganTol1\" = " + dbitem.GolonganTol1 + ", \"GolonganTol2\" = " + dbitem.GolonganTol2 + ", \"GolonganTol3\" = " +
dbitem.GolonganTol3 + ", \"GolonganTol4\" = " + dbitem.GolonganTol4 + ", \"Keterangan\" = " + dbitem.Keterangan + " WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Jenis Tol", QueryDetail = query + h_query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
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 void save(DataBox dbitem, int id, DataBoxHistory dbh, DataTruckBoxHistory dtbh = null, DataTruckGPSHistory dtgh = null)
{
var query = "";
if (dbitem.Id == 0) //create
{
context.DataBox.Add(dbitem);
query += "INSERT INTO dbo.\"DataBox\" (\"NoBox\", \"IdDataTruck\", \"Karoseri\", \"Tahun\", \"IdType\", \"IdKategori\", \"Lantai\", \"Dinding\", \"PintuSamping\", \"Sekat\", \"garansiStr\", " +
"\"garansiEnd\", \"asuransiStr(\"garansiEnd\", asuransiEnd\"garansiEnd\", tglPasang\"garansiEnd\", \"Urutan\") VALUES (" + dbitem.NoBox + ", " + dbitem.IdDataTruck + ", " + dbitem.Karoseri + ", " +
dbitem.Tahun + ", " + dbitem.IdType + ", " + dbitem.IdKategori + ", " + dbitem.Lantai + ", " + dbitem.Dinding + ", " + dbitem.PintuSamping + ", " + dbitem.Sekat + ", " + dbitem.garansiStr + ", " +
dbitem.garansiEnd + ", " + dbitem.asuransiStr + ", " + dbitem.asuransiEnd + ", " + dbitem.tglPasang + ", " + dbitem.Urutan + ");";
}
else //edit
{
context.DataBox.Attach(dbitem);
query += "UPDATE dbo.\"DataBox\" SET \"NoBox\" = " + dbitem.NoBox + ",\"IdDataTruck\" = " + dbitem.IdDataTruck + " ,\"Karoseri\" = " + dbitem.Karoseri + ",\"Tahun\" = " + dbitem.Tahun + ", \"IdType\" = " +
dbitem.IdType + ", \"IdKategori\" = " + dbitem.IdKategori + ", \"Lantai\" = " + dbitem.Lantai + ", \"Dinding\" = " + dbitem.Dinding + ", \"PintuSamping\" = " + dbitem.PintuSamping + ", \"Sekat\" = " +
dbitem.Sekat + ", \"garansiStr\" = " + dbitem.garansiStr + ", \"garansiEnd\" = " + dbitem.garansiEnd + ", \"asuransiStr\" = \" = " + dbitem.asuransiStr + ", \"asuransiEnd\" = \" = " + dbitem.asuransiEnd +
", \"tglPasang\" = " + dbitem.tglPasang + ", \"Urutan\" = " + dbitem.Urutan + "WHERE \"Id\" = " + dbitem.Id + ";";
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
query += "DELETE FROM dbo.\"DataBoxDinding\" WHERE \"IdDataBox\" = " + dbitem.Id + ";";
foreach (Context.DataBoxDinding dbd in dbitem.DataBoxDinding)
{
query += "INSERT INTO dbo.\"DataBoxDinding\" (\"IdDataBox\", \"IdDindingCode\") VALUES (" + dbitem.Id + ", " + dbd.IdDindingCode + ");";
}
query += "DELETE FROM dbo.\"DataBoxLantai\" WHERE \"IdDataBox\" = " + dbitem.Id + ";";
foreach (Context.DataBoxLantai dbd in dbitem.DataBoxLantai)
{
query += "INSERT INTO dbo.\"DataBoxLantai\" (\"IdDataBox\", \"IdLantaiCode\") VALUES (" + dbitem.Id + ", " + dbd.IdLantaiCode + ");";
}
query += "INSERT INTO dbo.\"DataBoxHistory\" (\"IdDataBox\", \"Vehicle\", \"NoBox\", \"Karoseri\", \"Tahun\", \"strType\", \"strKategori\", \"Lantai\", \"Dinding\", \"PintuSamping\", \"Sekat\", \"garansiStr\", " +
"\"garansiEnd\", \"asuransiStr\", \"asuransiEnd\", \"tglPasang\", \"Tanggal, username) VALUES (" + dbitem.Id + ", " + dbitem.IdDataTruck + ", " + dbitem.NoBox + ", " + dbitem.Karoseri + ", " + dbitem.Tahun +
", " + dbh.strType + ", " + dbh.strKategori + ", " + dbitem.Lantai + ", " + dbitem.Dinding + ", " + dbitem.PintuSamping + ", " + dbitem.Sekat + ", " + dbitem.garansiStr + ", " + dbitem.garansiEnd +
", " + dbitem.asuransiStr + ", " + dbitem.asuransiEnd + ", " + dbitem.tglPasang + ", " + dbh.Tanggal + ", " + dbh.username + ");";
if (dtbh != null)
{
query += "INSERT INTO dbo.\"DataTruckBoxHistory\" (\"IdDataTruck\", \"Vehicle\", \"NoBox\", \"Karoseri\", \"Tahun\", \"strType\", \"strKategori\", \"Lantai\", \"Dinding\", \"PintuSamping\", \"Sekat\", " +
"\"garansiStr\", \"garansiEnd\", \"asuransiStr\", \"asuransiEnd\", \"tglPasang\", \"Tanggal\", username) VALUES (" + dtbh.IdDataTruck + ", " + dtbh.Vehicle + ", " + dtbh.NoBox + ", " + dtbh.Karoseri +
", " + dtbh.Tahun + ", " + dtbh.strType + ", " + dtbh.strKategori + ", " + dtbh.Lantai + ", " + dtbh.Dinding + ", " + dtbh.PintuSamping + ", " + dtbh.Sekat + ", " + dtbh.garansiStr + ", " +
dtbh.garansiEnd + ", " + dtbh.asuransiStr + ", " + dtbh.asuransiEnd + ", " + dtbh.tglPasang + ", " + dtbh.Tanggal + ", " + dtbh.username + ");";
}
if (dtgh != null)
{
query += "INSERT INTO dbo.\"DataTruckGPSHistory\" (\"IdDataTruck\", \"NoGPS\", \"Vehicle\", \"strVendor\", \"ModelGps\", \"NoDevice\", \"SensorSuhu\", \"SensorPintu\", \"Tahun\", \"TanggalPasang\", " +
"\"TanggalGaransi\", \"Tanggal\", \"Username\") VALUES (" + dtgh.IdDataTruck + ", " + dtgh.NoGPS + ", " + dtgh.Vehicle + ", " + dtgh.strVendor + ", " + dtgh.ModelGps + ", " + dtgh.NoDevice + ", " +
dtgh.SensorSuhu + ", " + dtgh.SensorPintu + ", " + dtgh.Tahun + ", " + dtgh.TanggalPasang + ", " + dtgh.TanggalGaransi + ", " + dtgh.Tanggal + ", " + dtgh.Username + ");";
}
var auditrail = new Auditrail {
Actionnya = dbitem.Id == 0 ? "Add" : "Edit", EventDate = DateTime.Now, Modulenya = "Data Box", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(PelaksanaanTraining dbitem)
{
context.PelaksanaanTraining.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Pelaksanaan Training", QueryDetail = "Delete " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(AuthorizationRule dbitem)
{
context.AuthorizationRule.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "General Setting", QueryDetail = "Delete " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(Multidrop dbitem)
{
context.Multidrop.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Multidrop", QueryDetail = "Delete " + dbitem.tujuan, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(BatalTruk dbitem)
{
context.BatalTruk.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Batal Truk", QueryDetail = "Delete Batal Truk " + dbitem.SalesOrder, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(DaftarHargaKontrak dbitem)
{
context.DaftarHargaKontrak.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Daftar Harga Kontrak", QueryDetail = "Delete " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(RevisiTanggal dbitem)
{
context.RevisiTanggal.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Revisi Rute", QueryDetail = "Delete " + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(Location dbitem)
{
context.Location.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Jenis Tol", QueryDetail = "Delete " + dbitem.Nama, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(LookupCode dbitem)
{
context.LookupCode.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Lookup Code", QueryDetail = "Delete " + dbitem.Deskripsi, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(AdminUangJalan dbitem)
{
context.AdminUangJalan.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Admin Uang Jalan", QueryDetail = "Delete Admin Uang Jalan no" + dbitem.Id, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(Mekanik dbitem)
{
context.Mekanik.Remove(dbitem);
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Mekanik", QueryDetail = "Edit " + dbitem.NamaMekanik, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void save(DaftarHargaKonsolidasi dbitem, int id, string dhki = null)
{
var query = "";
if (dbitem.Id == 0) //create
{
context.DaftarHargaKonsolidasi.Add(dbitem);
query += "INSERT INTO dbo.\"DaftarHargaKonsolidasi\" (\"IdCust\", \"PeriodStart\", \"PeriodEnd\") VALUES (" + dbitem.IdCust + ", " + dbitem.PeriodStart + ", " + dbitem.PeriodEnd + ");";
}
else //edit
{
context.DaftarHargaKonsolidasi.Attach(dbitem);
query += "UPDATE dbo.\"DaftarHargaKonsolidasi\" SET \"IdCust\" = " + dbitem.IdCust + ", \"PeriodStart\" = " + dbitem.PeriodStart + ", \"PeriodEnd\" = " + dbitem.PeriodEnd +
" WHERE \"Id\" = " + dbitem.Id + ";";
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
query += "DELETE FROM dbo.\"DaftarHargaKonsolidasiAttachment\" WHERE \"IdDaftarHargaKonsolidasi\" = " + dbitem.Id + ";";
foreach (Context.DaftarHargaKonsolidasiAttachment dhka in dbitem.DaftarHargaKonsolidasiAttachment)
{
query += "INSERT INTO dbo.\"DaftarHargaKonsolidasiAttachment\" (\"IdDaftarHargaKonsolidasi\", \"FileName\", \"RFileName\") VALUES (" + dbitem.Id + ", " + dhka.FileName + ", " + dhka.RFileName + ");";
}
query += "DELETE FROM dbo.\"DaftarHargaKonsolidasiKondisi\" WHERE \"IdDaftarHargaKonsolidasi\" = " + dbitem.Id + ";";
foreach (Context.DaftarHargaKonsolidasiKondisi dhkk in dbitem.DaftarHargaKonsolidasiKondisi)
{
query += "INSERT INTO dbo.\"DaftarHargaKonsolidasiKondisi\" (\"IdDaftarHargaKonsolidasi\", kondisi, \"IsInclude\", \"IsBill\", value, \"IsDefault\", \"IsKota\", \"IsTitik\", " +
"\"ValKota\", \"ValTitik\", \"IsDelete\") VALUES (" + dhkk.Id + ", " + dhkk.kondisi + ", " + dhkk.IsInclude + ", " + dhkk.IsBill + ", " + dhkk.value + ", " + dhkk.IsDefault + ", " +
dhkk.IsKota + ", " + dhkk.IsTitik + ", " + dhkk.ValKota + ", " + dhkk.ValTitik + ", " + dhkk.IsDelete + ");";
}
if (dbitem.Id == 0) //create
{
context.DaftarHargaKonsolidasi.Add(dbitem);
foreach (Context.DaftarHargaKonsolidasiItem item in dbitem.DaftarHargaKonsolidasiItem)
{
query += "INSERT INTO dbo.\"DaftarHargaKonsolidasiItem\" (\"IdDaftarHargaKonsolidasi\", \"NamaDaftarHargaRute\", \"ListIdRute\", \"ListNamaRute\", \"IdJenisKendaraan\", " +
"\"MinKg\", \"MaxKg\", \"Harga\", \"IsAsuransi\", \"Premi\", \"NilaiTanggungan\", \"Keterangan\", \"PihakPenanggung\", \"TipeNilaiTanggungan\", \"IdSatuanHarga\") VALUES ( " +
dbitem.Id + ", " + item.NamaDaftarHargaRute + ", " + item.ListIdRute + ", " + item.ListNamaRute + ", " + item.IdJenisKendaraan + ", " + item.MinKg + ", " + item.MaxKg + ", " +
item.Harga + ", " + item.IsAsuransi + ", " + item.Premi + ", " + item.NilaiTanggungan + ", " + item.Keterangan + ", " + item.PihakPenanggung + ", " + item.TipeNilaiTanggungan +
", " + item.IdSatuanHarga + ");";
}
}
else
{
query += dhki;
}
var auditrail = new Auditrail {
Actionnya = dbitem.Id == 0 ? "Add" : "Edit", EventDate = DateTime.Now, Modulenya = "Daftar Harga Konsolidasi", QueryDetail = query,
RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public void delete(JenisTrucks dbitem, int id)
{
context.JenisTrucks.Remove(dbitem);
var query = "DELETE FROM dbo.\"JenisTrucks\" WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Jenis Truk", QueryDetail = "Delete " + dbitem.StrJenisTruck, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
public ActionResult Add(Auditrail model)
{
if (ModelState.IsValid)
{
Context.Auditrail dbitem = new Context.Auditrail();
model.setDb(dbitem);
RepoAuditrail.save(dbitem);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public void save(DataTruck dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.DataTruck.Add(dbitem);
var query = "INSERT INTO dbo.\"DataTruck\" (\"NoTruck\", \"VehicleNo\", \"IdMerk\", \"IdJenisTruck\", \"TahunBuat\", \"TahunBeli\", \"IdPool\", \"IdUnit\", \"Keterangan\", \"Kondisi\", \"SpecModel\", " +
"\"KmLimit\", \"NoMesin\", \"NoRangka\", \"GaransiStr\", \"GaransiEnd\", \"SpecKeterangan\", \"AtasNama\", \"BPKB\", \"urlBPKB\", \"fnameBPKB\", \"keteranganBPKB\", \"STNK\", \"urlSTNK\", \"fnameSTNK\"," +
"\"keteranganSTNK\", \"KIR\", \"urlKIR\", \"fnameKIR\", \"keteranganKIR\", \"KIU\", \"urlKIU\", \"fnameKIU\", \"keteranganKIU\", \"IBM\", \"urlIBM\", \"fnameIBM\", \"keteranganIBM\", \"Asuransi\", " +
"\"urlAsuransi\", \"fnameAsuransi\", \"keteranganAsuransi\", \"Reklame\", \"urlReklame\", \"fnameReklame\", \"keteranganReklame\", \"NoPolis\", \"urlNoPolis\", \"fnameNoPolis\", \"keteranganNoPolis\", " +
"\"Peminjam\", \"urlPeminjam\", \"fnamePeminjam\", \"keteranganPeminjam\", \"Leasing\", \"urlLeasing\", \"fnameLeasing\", \"keteranganLeasing\", urutan) VALUES (" + dbitem.NoTruck + ", " +
dbitem.VehicleNo + ", " + dbitem.IdMerk + ", " + dbitem.IdJenisTruck + ", " + dbitem.TahunBuat + ", " + dbitem.TahunBeli + ", " + dbitem.IdPool + ", " + dbitem.IdUnit + ", " + dbitem.Keterangan + ", " +
dbitem.Kondisi + ", " + dbitem.SpecModel + ", " + dbitem.KmLimit + ", " + dbitem.NoMesin + ", " + dbitem.NoRangka + ", " + dbitem.GaransiStr + ", " + dbitem.GaransiEnd + ", " + dbitem.SpecKeterangan +
", " + dbitem.AtasNama + ", " + dbitem.BPKB + ", " + dbitem.urlBPKB + ", " + dbitem.fnameBPKB + ", " + dbitem.keteranganBPKB + ", " + dbitem.STNK + ", " + dbitem.urlSTNK + ", " + dbitem.fnameSTNK + ", " +
dbitem.keteranganSTNK + ", " + dbitem.KIR + ", " + dbitem.urlKIR + ", " + dbitem.fnameKIR + ", " + dbitem.keteranganKIR + ", " + dbitem.KIU + ", " + dbitem.urlKIU + ", " + dbitem.fnameKIU + ", " +
dbitem.keteranganKIU + ", " + dbitem.IBM + ", " + dbitem.urlIBM + ", " + dbitem.fnameIBM + ", " + dbitem.keteranganIBM + ", " + dbitem.Asuransi + ", " + dbitem.urlAsuransi + ", " + dbitem.fnameAsuransi +
", " + dbitem.keteranganAsuransi + ", " + dbitem.Reklame + ", " + dbitem.urlReklame + ", " + dbitem.fnameReklame + ", " + dbitem.keteranganReklame + ", " + dbitem.NoPolis + ", " + dbitem.urlNoPolis +
", " + dbitem.fnameNoPolis + ", " + dbitem.keteranganNoPolis + ", " + dbitem.Peminjam + ", " + dbitem.urlPeminjam + ", " + dbitem.fnamePeminjam + ", " + dbitem.keteranganPeminjam + ", " + dbitem.Leasing +
", " + dbitem.urlLeasing + ", " + dbitem.fnameLeasing + ", " + dbitem.keteranganLeasing + ", " + dbitem.urutan + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Data Truk", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.DataTruck.Attach(dbitem);
var query = "UPDATE dbo.\"DataTruck\" SET \"NoTruck\" = " + dbitem.NoTruck + ", \"VehicleNo\" = " + dbitem.VehicleNo + ", \"IdMerk\" = " + dbitem.IdMerk + ", \"IdJenisTruck\" = \" = " + dbitem.IdJenisTruck +
", \"TahunBuat\" = \" = " + dbitem.TahunBuat + ", \"TahunBeli\" = \" = " + dbitem.TahunBeli + ", \"IdPool\" = \" = " + dbitem.IdPool + ", \"IdUnit\" = \" = " + dbitem.IdUnit + ", \"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 + ", \"AtasNama\" = " +
dbitem.AtasNama + ", \"BPKB\" = " + dbitem.BPKB + ", \"urlBPKB\" = " + dbitem.urlBPKB + ", \"fnameBPKB\" = \" = " + dbitem.fnameBPKB + ", \"keteranganBPKB\" = " + dbitem.keteranganBPKB + ", \"STNK\" = " +
dbitem.STNK + ", \"urlSTNK\" = " + dbitem.urlSTNK + ", \"fnameSTNK\" = " + dbitem.fnameSTNK + ", \"keteranganSTNK\" = " + dbitem.keteranganSTNK + ", \"KIR\" = " + dbitem.KIR + ", \"urlKIR\" = " +
dbitem.urlKIR + ", \"fnameKIR\" = " + dbitem.fnameKIR + ", \"keteranganKIR\" = " + dbitem.keteranganKIR + ", \"KIU\" = " + dbitem.KIU + ", \"urlKIU\" = " + dbitem.urlKIU + ", \"fnameKIU\" = " +
dbitem.fnameKIU + ", \"keteranganKIU\" = " + dbitem.keteranganKIU + ", \"IBM\" = " + dbitem.IBM + ", \"urlIBM\" = " + dbitem.urlIBM + ", \"fnameIBM\" = " + dbitem.fnameIBM + ", \"keteranganIBM\" = " +
dbitem.keteranganIBM + ", \"Asuransi\" = " + dbitem.Asuransi + ", \"urlAsuransi\" = " + dbitem.urlAsuransi + ", \"fnameAsuransi\" = " + dbitem.fnameAsuransi + ", \"keteranganAsuransi\" = " +
dbitem.keteranganAsuransi + ", \"Reklame\" = " + dbitem.Reklame + ", \"urlReklame\" = " + dbitem.urlReklame + ", \"fnameReklame\" = " + dbitem.fnameReklame + ", \"keteranganReklame\" = " +
dbitem.keteranganReklame + ", \"NoPolis\" = " + dbitem.NoPolis + ", \"urlNoPolis\" = " + dbitem.urlNoPolis + ", \"fnameNoPolis\" = " + dbitem.fnameNoPolis + ", \"keteranganNoPolis\" = " +
dbitem.keteranganNoPolis + ", \"Peminjam\" = " + dbitem.Peminjam + ", \"urlPeminjam\" = " + dbitem.urlPeminjam + ", \"fnamePeminjam\" = " + dbitem.fnamePeminjam + ", \"keteranganPeminjam\" = " +
dbitem.keteranganPeminjam + ", \"Leasing\" = " + dbitem.Leasing + ", \"urlLeasing\" = " + dbitem.urlLeasing + ", \"fnameLeasing\" = " + dbitem.fnameLeasing + ", \"keteranganLeasing\" = " +
dbitem.keteranganLeasing + ", urutan = " + dbitem.urutan + " WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Data Truk", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}