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