public Formula GetEntity(string id, EnmOrganization type, EnmFormula formulaType)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100),
new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@FormulaType", SqlDbType.Int) };
parms[0].Value = id;
parms[1].Value = (int)type;
parms[2].Value = (int)formulaType;
Formula entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_Formula_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new Formula();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Type = SqlTypeConverter.DBNullEnmOrganizationHandler(rdr["Type"]);
entity.FormulaType = SqlTypeConverter.DBNullEnmFormulaHandler(rdr["FormulaType"]);
entity.FormulaText = SqlTypeConverter.DBNullStringHandler(rdr["Formula"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]);
}
}
return(entity);
}
public List <NodesInReservation> GetEntities(EnmOrganization type)
{
SqlParameter[] parms = { new SqlParameter("@NodeType", SqlDbType.Int) };
parms[0].Value = (int)type;
var entities = new List <NodesInReservation>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_NodesInReservation_Repository_GetEntitiesByNodeType, parms)) {
while (rdr.Read())
{
var entity = new NodesInReservation();
entity.ReservationId = SqlTypeConverter.DBNullStringHandler(rdr["ReservationId"]);
entity.NodeId = SqlTypeConverter.DBNullStringHandler(rdr["NodeId"]);
entity.NodeType = SqlTypeConverter.DBNullEnmOrganizationHandler(rdr["NodeType"]);
entities.Add(entity);
}
}
return(entities);
}
public void DeleteEntities(string id, EnmOrganization type, EnmFormula formulaType, DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100),
new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@FormulaType", SqlDbType.Int),
new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullDateTimeHandler(start);
parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(end);
using (var conn = new SqlConnection(this._databaseConnectionString)) {
conn.Open();
var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
try {
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlCommands_Cs.Sql_V_Elec_Repository_DeleteEntities, parms);
trans.Commit();
} catch {
trans.Rollback();
throw;
}
}
}
