public List <ShiftDTO> GetAllShiftsForClub(string month)
{
string query = "SELECT * FROM dienst WHERE MONTH(startMoment) = @month";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >();
// parameters.Add(new KeyValuePair<string, string>("id", id.ToString()));
parameters.Add(new KeyValuePair <string, string>("month", month));
DataSet results = ExecuteQuery(query, parameters);
List <ShiftDTO> shifts = new List <ShiftDTO>();
if (results != null)
{
for (int i = 0; i < results.Tables[0].Rows.Count; i++)
{
ShiftDTO shift = DataSetParser.DataSetToShift(results, i);
if (shift.ID != 0)
{
// Get members ID
query = "SELECT lidID FROM `lid-dienst-combo` WHERE dienstID=@id";
parameters.Clear();
parameters.Add(new KeyValuePair <string, string>("id", shift.ID.ToString()));
DataSet res = ExecuteQuery(query, parameters);
if (res.Tables[0].Rows.Count != 0)
{
int memberId = (int)res.Tables[0].Rows[0][0];
// Get actual member
query = "SELECT * FROM leden WHERE id = @id";
parameters.Clear();
parameters.Add(new KeyValuePair <string, string>("id", memberId.ToString()));
DataSet member = ExecuteQuery(query, parameters);
// Add member to shift
shift.Members = DataSetParser.DataSetToMember(member, 0);
}
}
shifts.Add(shift);
}
}
return(shifts);
}
public MemberDTO FindMemberById(int id)
{
string query = "Select * from member where id=@id";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >();
parameters.Add(new KeyValuePair <string, string>("id", id.ToString()));
DataSet results = ExecuteQuery(query, parameters);
MemberDTO m = new MemberDTO();
if (results != null && results.Tables[0].Rows.Count > 0)
{
m = DataSetParser.DataSetToMember(results, 0);
}
return(m);
}
public List <MemberDTO> GetAllMembers()
{
string query = "Select * from member";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >();
DataSet results = ExecuteQuery(query, parameters);
List <MemberDTO> members = new List <MemberDTO>();
if (results != null)
{
for (int x = 0; x < results.Tables[0].Rows.Count; x++)
{
MemberDTO m = DataSetParser.DataSetToMember(results, x);
members.Add(m);
}
}
return(members);
}