public IEnumerable <EventSubCategory> GetSubCategories()
{
List <EventSubCategory> subCategories = new List <EventSubCategory>();
using (conn = new NpgsqlConnection(_conStr))
{
conn.Open();
using (var command = new NpgsqlCommand())
{
command.CommandText = "SELECT * FROM \"EventSubCategory\"";
command.Connection = conn;
var dr = command.ExecuteReader();
while (dr.Read())
{
EventSubCategory newSubCategory = new EventSubCategory()
{
Id = (Guid)dr["Id"],
Abrv = (string)dr["Abrv"],
Name = (dr["SubCategoryName"] is DBNull) ? string.Empty : (string)dr["SubCategoryName"],
DateCreated = (dr["DateCreated"] is DBNull) ? DateTime.Now : (DateTime)dr["DateCreated"]
};
subCategories.Add(newSubCategory);
}
return(subCategories);
}
}
}
public EventSubCategory GetSubCategoryById(Guid subCategoryId)
{
using (conn = new NpgsqlConnection(_conStr))
{
conn.Open();
using (var command = new NpgsqlCommand())
{
command.CommandText = "SELECT * FROM \"EventSubCategory\" WHERE \"Id\" = @id";
command.Parameters.AddWithValue("id", subCategoryId);
command.Connection = conn;
var dr = command.ExecuteReader();
dr.Read();
EventSubCategory newSubCategory = new EventSubCategory()
{
Id = (Guid)dr["Id"],
Abrv = (string)dr["Abrv"],
Name = (dr["SubCategoryName"] is DBNull) ? string.Empty : (string)dr["SubCategoryName"],
DateCreated = (dr["DateCreated"] is DBNull) ? DateTime.Now : (DateTime)dr["DateCreated"]
};
return(newSubCategory);
}
}
}