public void Update(TaskItem user)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
SqlMapperExtensions.Update(db, user);
}
}
public virtual void Update(TEntity entity)
{
using (var connection = this.GetDbConnection())
{
SqlMapperExtensions.Update(connection, entity);
}
}
public void Update(Task task)
{
using (var cnn = GetDbConnection())
{
SqlMapperExtensions.Update(cnn, task);
}
}
public void Update(Board board)
{
using (var cnn = GetDbConnection())
{
SqlMapperExtensions.Update(cnn, board);
}
}
public static void Update <T>(this T entity) where T : IDbTable
{
using (var db = ConFactory.GetConnection())
{
db.Open();
SqlMapperExtensions.Update(db, entity);
}
}
private void ProcessQueue()
{
while (!DataService.DataQueue.IsEmpty)
{
if (!DataService.DataQueue.TryDequeue(out DatabaseAction request))
{
Console.WriteLine("DATABASE WORKER: Was unable to process an object. Will try again...");
return;
}
try
{
if (request.Action == DatabaseActionType.Insert)
{
foreach (var record in request.Data)
{
SqlMapperExtensions.Insert(_connection, record);
}
}
else if (request.Action == DatabaseActionType.Update)
{
foreach (var record in request.Data)
{
SqlMapperExtensions.Update(_connection, record);
}
}
else if (request.Action == DatabaseActionType.Delete)
{
foreach (var record in request.Data)
{
SqlMapperExtensions.Delete(_connection, record);
}
}
}
catch (MySqlException ex)
{
Console.WriteLine("****EXCEPTION ON DATABASE BACKGROUND THREAD****");
Console.WriteLine("Data Type: " + request.DataType);
Console.WriteLine("Action: " + request.Action);
LoggingService.LogError(ex, request.Action.ToString());
}
catch (Exception ex)
{
Console.WriteLine("****EXCEPTION ON DATABASE BACKGROUND THREAD****");
Console.WriteLine("Data Type: " + request.DataType);
Console.WriteLine("Action: " + request.Action);
LoggingService.LogError(ex, request.Action.ToString());
}
}
}
private void Save()
{
if (Authorizer.Instance.Guest != 1)
{
if (Ev.Id == null)
{
SqlMapperExtensions.Insert(AnomalEventConnection.Connection, Ev);
}
else
{
SqlMapperExtensions.Update(AnomalEventConnection.Connection, Ev);
}
}
}
private void button4_Click(object sender, EventArgs e)
{
if (Authorizer.Instance.Guest != 1)
{
if (Action.Id == null)
{
SqlMapperExtensions.Insert(AnomalEventConnection.Connection, Action);
}
else
{
SqlMapperExtensions.Update(AnomalEventConnection.Connection, Action);
}
}
this.Close();
}
public void Update(T entity)
{
SqlMapperExtensions.Update <T>(_connection, entity);
}
public bool Update(TEntity entity)
{
using (var sqlConnection = new SqlConnection(DbConstant.DatabaseConnection))
return(SqlMapperExtensions.Update(sqlConnection, entity));
}
public bool ExecuteUpdata <Table>(Table table) where Table : class
{
SqlMapperExtensions.Update(_sQLiteConnection, table);
return(true);
}
public bool Update(IEnumerable <TEntity> entities)
{
return(SqlMapperExtensions.Update(_connection, entities, _transaction, _commandTimeout));
}
public bool Update(TEntity entityToUpdate)
{
return(SqlMapperExtensions.Update(_connection, entityToUpdate, _transaction, _commandTimeout));
}
public bool Update(TEntity entity)
{
var updated = SqlMapperExtensions.Update <TEntity>(connection.Connect, entity);
return(updated);
}
