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 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(); }