public ActionResult Edit([Bind(Include = "Id, Name, AccountId, Date")] Blog blog)
{
if (ModelState.IsValid)
{
_blog.Entry(blog).State = EntityState.Modified;
_blog.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult EditQuarter(Quarter quarter)
{
if (ModelState.IsValid)
{
db.Entry(quarter).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("AddQuarter"));
}
return(View(quarter));
}
public bool EditarNombre(Usuario user)
{
bool status = false;
model.Entry(user).State = EntityState.Modified;
model.SaveChanges();
status = true;
return(status);
}
public void Update(Func <TEntity, bool> predicate, TEntity obj)
{
ctx = new ContextModel();
var atualizar = ctx.Set <TEntity>().AsNoTracking().FirstOrDefault(predicate);
atualizar = obj;
ctx.Set <TEntity>().Attach(obj);
ctx.Entry(atualizar).State = EntityState.Modified;
ctx.Entry(obj).State = EntityState.Modified;
SaveAll();
}
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(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(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(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(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(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 HttpResponseMessage PutProfissao(int id, ProfissoesModel profissoes)
{
if (!ModelState.IsValid)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
if (id != profissoes.IdProfissao)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
db.Entry(profissoes).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
if (!ProfissoesExists(id))
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
}
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
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 HttpResponseMessage PutMunicipiosModel(int id, MunicipiosModel municipiosModel)
{
if (!ModelState.IsValid)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
if (id != municipiosModel.IdMunicipio)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
db.Entry(municipiosModel).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!MunicipiosModelExists(id))
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
else
{
throw;
}
}
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
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(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 ActionResult Edit([Bind(Include = "Id,Surname,Name,Patronymic,PassportNumber,PassportSeries,Birgthday,Telephone")] Client client)
{
foreach (Client c in db.Clients.AsNoTracking().ToList())
{
//Проверка пасспортных данных на уникальность
if ((client.PassportNumber == c.PassportNumber && client.PassportSeries == c.PassportSeries) && (client.Id != c.Id))
{
ModelState.AddModelError("PassportSeries", "Клиент с такими серией или номером паспорта уже зарегистрирован");
}
//Проверка телефона на уникальность
if ((client.Telephone == c.Telephone) && (client.Id != c.Id))
{
ModelState.AddModelError("Telephone", "Клиент с таким телефоном уже зарегистрирован");
}
}
if (ModelState.IsValid)
{
db.Entry(client).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(client));
}
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 HttpResponseMessage PutAreaDeConhecimento(int id, AreaDeConhecimento areaDeConhecimento)
{
if (!ModelState.IsValid)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
db.Entry(areaDeConhecimento).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
if (!AreaExists(id))
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
}
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
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 ActionResult Login(LoginModel model, string returnUrl)
{
var username = model.UserName;
if (string.IsNullOrEmpty(model.UserName) || string.IsNullOrEmpty(model.Password))
{
ViewBag.Message2 = "You must fill the username and password";
return(View("Login"));
}
var userDetail = db.UserProfiles.Where(x => x.UserName == model.UserName).FirstOrDefault();
if (userDetail == null)
{
ViewBag.Message3 = "wrong username and/or password";
return(View("Login"));
}
if (userDetail.Status == 1)
{
ViewBag.Message = "Sorry you are no longer allow to login. Please contact system administrator or Head of Department.";
return(View("Login"));
}
if (userDetail.isLogin == 1)
{
ViewBag.Message1 = "Yor are still login to another device. Please logout first and re-login. ";
return(View("Login"));
}
if (ModelState.IsValid && WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe))
{
var data = db.UserProfiles.Where(x => x.UserName == model.UserName).FirstOrDefault();
FormsAuthentication.SetAuthCookie(model.UserName, model.RememberMe);
userDetail.isLogin = 1;
db.Entry(userDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToDefault(returnUrl, model.UserName));
}
// If we got this far, something failed, redisplay form
ModelState.AddModelError("", "The user name or password provided is incorrect.");
return(View(model));
}
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 ActionResult Edit([Bind(Include = "Id,Type")] ApartmentType apartmentType)
{
if (ModelState.IsValid)
{
db.Entry(apartmentType).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(apartmentType));
}
public void updateStatusToService(string vehicleNo)
{
Context.MonitoringVehicle dbitem = context.MonitoringVehicle.Where(d => d.VehicleNo == vehicleNo).FirstOrDefault();
dbitem.Status = "Service";
context.MonitoringVehicle.Attach(dbitem);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
context.SaveChanges();
}
public ActionResult Edit([Bind(Include = "Id,Name,Age,Email,ConfirmEmail,Gender")] Cliente cliente)
{
if (ModelState.IsValid)
{
db.Entry(cliente).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cliente));
}
public ActionResult Edit([Bind(Include = "Id, Name")] Category category)
{
if (ModelState.IsValid)
{
_blog.Entry(category).State = EntityState.Modified;
_blog.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Edit([Bind(Include = "Id,Photo")] Photos photos)
{
if (ModelState.IsValid)
{
db.Entry(photos).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(photos));
}
public ActionResult Edit([Bind(Include = "Id,ValueOfGuests,ValueOfKids,Settling,Eviction,NumberOfApartments")] Booking booking)
{
if (ModelState.IsValid)
{
db.Entry(booking).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(booking));
}
public ActionResult Edit([Bind(Include = "Id,Img,Cost,Price,Description,BuyTime,IdTipo")] Utiles utiles)
{
if (ModelState.IsValid)
{
db.Entry(utiles).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IdTipo = new SelectList(db.TipoDeMascotas, "IdTipo", "Name", utiles.IdTipo);
return(View(utiles));
}
