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