public GetWordsResponse GetWords(GetWordsRequest request)
{
try
{
return(DB.GetWords(request.SongId));
}
catch (Exception ex)
{
var x = new GetWordsResponse()
{
Words = new List <Tuple <Guid, string> >()
};
x.Words.Add(new Tuple <Guid, string>(Guid.Empty, ex.ToString()));
return(x);
}
}
internal static GetWordsResponse GetWords(Guid?songId)
{
using (SqlConnection conn = GetConnection())
{
GetWordsResponse ret = new GetWordsResponse()
{
Words = new List <Tuple <Guid, string> >(),
};
if (!songId.HasValue)
{
using (SqlCommand comm = new SqlCommand("SELECT word_id, word FROM word", conn))
using (SqlDataReader dr = comm.ExecuteReader())
{
while (dr.Read())
{
ret.Words.Add(new Tuple <Guid, string>(Guid.Parse(dr["word_id"].ToString()), dr["word"].ToString()));
}
}
}
else
{
using (SqlCommand comm = new SqlCommand("SELECT DISTINCT w.word_id, word " +
"FROM word w " +
"JOIN location l ON w.word_id = l.word_id " +
"WHERE song_id = @song_id", conn))
{
comm.Parameters.AddWithValue("@song_id", songId.Value);
using (SqlDataReader dr = comm.ExecuteReader())
{
while (dr.Read())
{
ret.Words.Add(new Tuple <Guid, string>(Guid.Parse(dr["word_id"].ToString()), dr["word"].ToString()));
}
}
}
}
return(ret);
}
}
protected void Page_Load(object sender, EventArgs e)
{
relations = ServiceAccessor.MakeRequest <RelationAllRequest, RelationAllResponse>(new RelationAllRequest(), "RelationAll");
relTypes = ServiceAccessor.MakeRequest <RelationTypesRequest, RelationTypesResponse>(new RelationTypesRequest(), "RelationTypes");
words = ServiceAccessor.MakeRequest <GetWordsRequest, GetWordsResponse>(new GetWordsRequest(), "GetWords");
}
protected void Page_Load(object sender, EventArgs e)
{
groups = ServiceAccessor.MakeRequest <GroupAllRequest, GroupAllResponse>(new GroupAllRequest(), "GroupAll");
words = ServiceAccessor.MakeRequest <GetWordsRequest, GetWordsResponse>(new GetWordsRequest(), "GetWords");
}