/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ctxMenuAcknowledgmentClear_Click(object sender, EventArgs e) { if (listEvents.SelectedObjects.Count == 0) { return; } var list = listEvents.SelectedObjects.Cast <Event>().ToList(); (new Thread(() => { SetProcessingStatus(false); using (new HourGlass(this)) using (NPoco.Database db = new NPoco.Database(Db.GetOpenMySqlConnection())) { foreach (Event temp in list) { if (temp.AcknowledgmentId == 0) { continue; } Acknowledgment acknowledgment = new Acknowledgment(); acknowledgment.Id = temp.AcknowledgmentId; var ack = db.SingleById <Acknowledgment>(acknowledgment.Id); db.Delete(ack); } } SetProcessingStatus(true); LoadSearch(_currentPage); })).Start(); }
public T SingleByIdEmployee <T>(long id) { using (NPoco.IDatabase dbContext = new NPoco.Database(connectionString, NPoco.DatabaseType.SqlServer2012)) { return(dbContext.SingleById <T>(id));; } }
public int Delete <T>(int id) { using (NPoco.IDatabase dbContext = new NPoco.Database(connectionString, NPoco.DatabaseType.SqlServer2012)) { var obj = dbContext.SingleById <T>(id); return(dbContext.Delete <T>(obj)); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ctxMenuAcknowledgmentClear_Click(object sender, EventArgs e) { if (listEvents.SelectedObjects.Count == 0) { return; } var list = listEvents.SelectedObjects.Cast<Event>().ToList(); (new Thread(() => { SetProcessingStatus(false); using (new HourGlass(this)) using (NPoco.Database db = new NPoco.Database(Db.GetOpenMySqlConnection())) { foreach (Event temp in list) { if (temp.AcknowledgmentId == 0) { continue; } Acknowledgment acknowledgment = new Acknowledgment(); acknowledgment.Id = temp.AcknowledgmentId; var ack = db.SingleById<Acknowledgment>(acknowledgment.Id); db.Delete(ack); } } SetProcessingStatus(true); LoadRuleEvents(_currentPage); })).Start(); }