// Delete Personnel public ActionResult Delete(int ID) { try { var personnel = getPersonnel(ID); deletePersonnelFiles(personnel); db.Delete(personnel); return(RedirectToAction("Index")); } catch (Exception) { throw; } }
private static void Crud() { var petaPoco = new PetaPoco.Database("Chinook"); var customer = new Customer { FirstName = "Ian", LastName = "Russell", Email = "*****@*****.**" }; petaPoco.Insert(customer); var id = customer.CustomerId; customer = petaPoco.Single<Customer>(id); ObjectDumper.Write(customer); customer.Country = "United Kingdom"; petaPoco.Update(customer); customer = petaPoco.Single<Customer>(id); ObjectDumper.Write(customer); petaPoco.Delete<Customer>(id); customer = petaPoco.SingleOrDefault<Customer>(id); ObjectDumper.Write(customer); }
public static bool DeleteLink(int id) { using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection")) { return(db.Delete <Models.Links>(id) > 0); } }
public int DeleteEvent(OurEvent model) { using (PetaPoco.Database context = new PetaPoco.Database("DefaultConnection")) { return((int)context.Delete(model)); } }
public static void DeleteForum(int id) { using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection")) { db.Delete <Models.Forums>("WHERE fid=@0", id); } }
public static bool DeleteCategory(int cid) { using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection")) { return(db.Delete(db.Query <Category>("where cid=@0", cid).SingleOrDefault()) > 0); } }
private static void Crud() { var petaPoco = new PetaPoco.Database("Chinook"); var customer = new Customer { FirstName = "Ian", LastName = "Russell", Email = "*****@*****.**" }; petaPoco.Insert(customer); var id = customer.CustomerId; customer = petaPoco.Single <Customer>(id); ObjectDumper.Write(customer); customer.Country = "United Kingdom"; petaPoco.Update(customer); customer = petaPoco.Single <Customer>(id); ObjectDumper.Write(customer); petaPoco.Delete <Customer>(id); customer = petaPoco.SingleOrDefault <Customer>(id); ObjectDumper.Write(customer); }
public int DeleteLoveStory(OurLoveStory model) { using (PetaPoco.Database context = new PetaPoco.Database("DefaultConnection")) { return((int)context.Delete(model)); } }
public int DeleteEntityImage(EntityImage model) { using (PetaPoco.Database context = new PetaPoco.Database("DefaultConnection")) { return((int)context.Delete(model)); } }
public ActionResult delete(int id, Contacts home) { var dataContext = new PetaPoco.Database("sqladdress"); dataContext.Delete <Contacts>(id); return(RedirectToAction("DBView")); }
public void RemoveYeZhu(YeZhu yz) { if (Config.Conn.State == System.Data.ConnectionState.Closed) { Config.Conn.Open(); } DB.Delete(yz); }
public static void DeleteForum(int id) { using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection")) { db.Delete<Models.Forums>("WHERE fid=@0", id); } }
public static bool DeleteUser(int uid) { using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection")) { var model = db.Query <User>("Where uid=@0", uid).SingleOrDefault(); return(db.Delete(model) > 0); } }
public void DeleteMovie(int id) { using (var db = new PetaPoco.Database(ConnectionString, providerName)) { var Movie = db.SingleOrDefault <Movie>(id); if (Movie != null) { db.Delete(Movie); } } }
public int Delete(HistoryEntry entry) { Debug.Assert(TableExists(SqlTable.WuHistory)); using (var connection = new SQLiteConnection(ConnectionString)) { connection.Open(); using (var database = new PetaPoco.Database(connection)) { return(database.Delete(entry)); } } }
public ActionResult Delete(int id, string confirmButton) { try { var db = new PetaPoco.Database("MissNancy"); db.Delete("tblClasses", "ClassKey", null, id); return RedirectToAction("Index"); } catch { return View(); } }
public void CancelTicket(int id) { using (var db = new PetaPoco.Database(ConnectionString, providerName)) { List <int> SeatIds = db.Fetch <int>("SELECT SeatId from Tickets where Id = @0", id); for (int i = 0; i < SeatIds.Count; i++) { var Seat = db.SingleOrDefault <Seat>(SeatIds[i]); Seat.Occupied = false; db.Update(Seat); } db.Delete <Ticket>(id); } }
public void Delete(DBObject.Image image) { _database.Delete("tblImages", "id", image); }
private static int Delete100Test(string connectionString) { var db = new PetaPoco.Database(connectionString, "System.Data.SqlClient"); var homes = db.Query<Home>("SELECT * FROM home WHERE BuildYear=@0", 2015).ToList(); int count = homes.Count(); foreach (var home in homes) { if (home != null) { home.BuildYear = 2015; db.Delete("Home", "Id", home); } } return count; }
public void Delete(T t) { db.Delete(t); }
public void Delete(DBObject.ImagePath imagePath) { _database.Delete("tblImagesDatabase", "id", imagePath); }
public WriteMonitor() : base("/write/monitor") { this.RequiresAuthentication(); this.RequiresAnyClaim(new[] { "editMonitor", "admin" }); // db reference var db = new PetaPoco.Database("LocalSQLite"); // datatable functions Post["/dt/edit"] = pameters => { // try\catch return success\fail try { Model.Monitor m = new Model.Monitor(); // get the previous verison of the monitor and then set up the monitor event handlers // not doing it like this anymore //m.PropertyChanged += new PropertyChangedEventHandler(App.Monitor.HandleActiveChangeEvent); m = this.Bind(); log.InfoFormat("Updating monitor (ID: {0})", m.MonitorID.ToString()); // change the monitor state in the app layer/ if (Convert.ToBoolean(m.Active) != App.Monitor.IsActive(m)) { App.Monitor.setState(m); } // TODO: get a previous version of the monitor and check if the interval has changed. // Change the interval if (m.Active == 1) { App.Monitor.ChangeInterval(m.MonitorID, m.RunInterval); } // persist the monitor, without the State column db.Update(m, m.ColumnsToUpdateFromWeb); return(Response.AsJson(new { success = true, aaData = m })); } catch (Exception ex) { // Log error on the server - maybe should have ID in the URL so it can be part of the exception log.WarnFormat("Error whilst editing monitor. Exception: {0}", ex.ToString()); // TODO: alert? return(Response.AsJson(new { success = false, message = ex.ToString() })); } }; Post["/dt/new"] = pameters => { // try\catch return success\fail Model.Monitor m = new Model.Monitor(); log.InfoFormat("Adding new monitor (ID: {0})", m.MonitorID.ToString()); try { db.Insert(m); // TODO: check if the monitor needs to start return(Response.AsJson(new { success = true, monitor = m })); } catch (Exception ex) { return(Response.AsJson(new { success = false, message = ex.ToString() })); } }; Post["/dt/delete"] = parameter => { try { Model.Monitor m = new Model.Monitor(); m = this.Bind(); log.InfoFormat("Deleting monitor (ID: {0})", m.MonitorID.ToString()); db.Delete(m); return(Response.AsJson(new { success = true })); } catch (Exception ex) { // Log error on the server - maybe should have ID in the URL so it can be part of the exception log.WarnFormat("Error whilst deleting monitor. Exception: {0}", ex.ToString()); // TODO: alert? return(Response.AsJson(new { success = false, message = ex.ToString() })); } }; }
public int Delete(HistoryEntry entry) { Debug.Assert(TableExists(SqlTable.WuHistory)); using (var connection = new SQLiteConnection(ConnectionString)) { connection.Open(); using (var database = new PetaPoco.Database(connection)) { return database.Delete(entry); } } }
public int DeleteById(int id) { var db = new PetaPoco.Database("umbShow"); return(db.Delete <Show>("WHERE idShow=@0", id)); }
public object DELETE(int id) { var db = new PetaPoco.Database("jlapc"); db.Delete("Novedad", "NovedadID", null, id); JsonResult rta = new JsonResult() { Data = new { ok = true }, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; return rta.Data; }
public void Delete(DBObject.Species species) { _database.Delete("tblFungi", "id", species); }
private void button4_Click(object sender, EventArgs e) { try { // Create a PetaPoco database object var db = new PetaPoco.Database("sqlite"); // find the (presumably) most recently created foo int id = db.ExecuteScalar<int>("SELECT max(id) from foo"); // Delete it db.Delete("foo", "Id", null, id); } catch (Exception ex) { Console.WriteLine(ex.Message + Environment.NewLine + ex.StackTrace); } this.fooQuery1.Refresh(); }