public override int Delete(IEnumerable <T> models)
{
try
{
int affected = 0;
string tableName = DataBaseServices.GetTableName(default(T));
using (SqlConnection connection = new SqlConnection(ConnectionIdentifier))
using (QueryFactory db = new QueryFactory(connection, new SqlServerCompiler()))
{
foreach (T model in models)
{
int id = model.Id;
affected += db.Query(tableName)
.Where("Id", id)
.Delete();
}
return(affected);
}
}
catch (Exception ex)
{
Log.Error(ex, "SQL Data Manager Delete error");
return(0);
}
}
public void UpdateRecord(ITable vmRecord, string keyColumnName, object keyColValue)
{
IEnumerable <KeyValuePair <string, object> > values = DataBaseServices.GetKeyValuePairs(vmRecord);
string tableName = DataBaseServices.GetTableName(vmRecord);
RegisterOperation(new SqlOperation(tableName, values, SqlOperationTypeEnum.Update, keyColumnName, keyColValue));
}
public void InsertRecord(ITable vmRecord)
{
IEnumerable <KeyValuePair <string, object> > values = DataBaseServices.GetKeyValuePairs(vmRecord);
string tableName = DataBaseServices.GetTableName(vmRecord);
RegisterOperation(new SqlOperation(tableName, values, SqlOperationTypeEnum.Insert));
}
public override T FindById(int id)
{
try
{
string tableName = DataBaseServices.GetTableName(default(T));
using (SqlConnection connection = new SqlConnection(ConnectionIdentifier))
using (QueryFactory db = new QueryFactory(connection, new SqlServerCompiler()))
{
return(db.Query(tableName).Where("Id", id).First <T>());
}
}
catch (Exception ex)
{
Log.Error(ex, "SQL Data Manager FindById error", id);
return(default);
public override List <T> FindAll()
{
try
{
string tableName = DataBaseServices.GetTableName(default(T));
using (SqlConnection connection = new SqlConnection(ConnectionIdentifier))
using (QueryFactory db = new QueryFactory(connection, new SqlServerCompiler()))
{
return(db.Query(tableName)
.Get <T>()
.ToList());
}
}
catch (Exception ex)
{
Log.Error(ex, "SQL Data Manager Find All error");
return(null);
}
}
public override int Delete(T model)
{
try
{
string tableName = DataBaseServices.GetTableName(model);
int id = model.Id;
using (SqlConnection connection = new SqlConnection(ConnectionIdentifier))
using (QueryFactory db = new QueryFactory(connection, new SqlServerCompiler()))
{
return(db.Query(tableName)
.Where("Id", id)
.Delete());
}
}
catch (Exception ex)
{
Log.Error(ex, "SQL Data Manager Delete error", model);
return(0);
}
}