public DataTable GetMembers(DataTable myGv, string status)
{ //id, member, gender, address,
if (status == "all")
{
myString = "Select upper(member_id) as id, initcap(member_lname)||', '||initcap(member_fname)||' '||initcap(member_mi) as member, initcap(member_gender) as gender, initcap(member_address) as address, member_meterno as meter_no from member_master order by member";
}
else
{
myString = "Select upper(member_id) as id, initcap(member_lname)||', '||initcap(member_fname)||' '||initcap(member_mi) as member, initcap(member_gender) as gender, initcap(member_address) as address, member_meterno as meter_no from member_master where member_status = '" + status + "' order by member";
}
return(myQuery.ViaDataTable(myString, myGv));
}
public DataTable GetMemberDetails(DataTable myDt)
{
mystring = "Select S.stud_id as Stud_id,S.first_name||', '||S.last_name as Names_Of_Candidates,A.position_name as Position_Name, v.vote as Votes from student S,candidate C,all_positions A,vote v where S.stud_id = C.student_id AND C.position_id = A.position_id AND A.position_name ='Governor' AND S.stud_id = v.std_id ;";
return(query.ViaDataTable(mystring, myDt));
}
