public void Create(TaskItem user)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
SqlMapperExtensions.Insert(db, user);
}
}
public void CreateAndGetAllComments(string UserName, string Comment)
{
Comment comment = new Comment()
{
UserName = UserName, Message = Comment, createTime = DateTime.Now
};
SqlMapperExtensions.Insert(_connectionString, comment);
}
public void AddCategory(Category category)
{
using (DbConnection connection = new SqlConnection(DataConfig.GetPrimaryConnectionString()))
{
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
//TODO: SqlMapperExtensions 这里还没有测试通过
SqlMapperExtensions.Insert <Category>(connection, category);
}
}
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 long Save(TEntity entity)
{
using (var sqlConnection = new SqlConnection(DbConstant.DatabaseConnection))
return(SqlMapperExtensions.Insert(sqlConnection, entity));
}
public long Insert(IEnumerable <TEntity> entities)
{
return(SqlMapperExtensions.Insert(_connection, entities, _transaction, _commandTimeout));
}
public long Insert(TEntity entityToInsert)
{
return(SqlMapperExtensions.Insert(_connection, entityToInsert, _transaction, _commandTimeout));
}
public long Insert(TEntity entity)
{
var added = SqlMapperExtensions.Insert <TEntity>(connection.Connect, entity);
return(added);
}
