public int HasInChairType(Guid chairtypeId)
{
ChairCommandBuilder builder = new ChairCommandBuilder();
SqlCommand query = builder.HasInChairType(chairtypeId);
return(DBManager.ExecuteScalar <int>(base.ConnectionHandler, query));
}
public IEnumerable <Chair> GetListChairByIdList(List <Guid> list)
{
ChairCommandBuilder builder = new ChairCommandBuilder();
SqlCommand query = builder.GetListChairByIdList(list);
return(DBManager.GetCollection <Chair>(base.ConnectionHandler, query));
}
public int AllowDelete(Guid hallId)
{
ChairCommandBuilder builder = new ChairCommandBuilder();
SqlCommand query = builder.AllowDelete(hallId);
return(DBManager.ExecuteScalar <int>(base.ConnectionHandler, query));
}
public List <Chair> GetHallChairs(Guid hallId)
{
ChairCommandBuilder builder = new ChairCommandBuilder();
var query = builder.GetHallChairs(hallId);
return(DBManager.GetCollection <Chair>(base.ConnectionHandler, query));
}
public int InsertChairs(List <Chair> chairs)
{
ChairCommandBuilder builder = new ChairCommandBuilder();
SqlCommand query = builder.InsertChairs(chairs);
return(DBManager.ExecuteNonQuery(base.ConnectionHandler, query));
}
public int UpdateChairs(List <string> chairs)
{
ChairCommandBuilder builder = new ChairCommandBuilder();
var query = builder.UpdateChairs(chairs);
return(DBManager.ExecuteNonQuery(base.ConnectionHandler, query));
}
public Chair GetByPosition(Guid hallId, int column, int row)
{
ChairCommandBuilder builder = new ChairCommandBuilder();
string query = builder.GetByPosition(hallId, column, row);
return(DBManager.GetObject <Chair>(base.ConnectionHandler, query));
}