public DataGridView GetMembers(DataGridView 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.ViaDataGridView(myString, myGv));
}
public DataGridView GetAllCandidate(DataGridView appGridView)
{
mystring = "select Distinct c.student_id as stud_id,partylist_id as party_id,s.last_name||', '||s.first_name as Names_of_Candidate ,a.position_name from candidate c,student s ,all_positions a where c.student_id = s.stud_id and a.position_id = c.position_id;";
return(query.ViaDataGridView(mystring, appGridView));
}
public DataGridView getviewposition(DataGridView mtDgv)
{
myString = "select distinct a.position_id, a.position_decs, b.department_decs from position a, department b where b.department_id = a.department_id order by position_id asc";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getviewOD_phic(DataGridView mtDgv)
{
myString = "select initcap(a.last_name)||', '||initcap(a.first_name)||' '||' ' as employee_name, b.phic_employee_contribution , c.mode_desc from employee_profiles a, od_phic b, mode c where c.mode_id = b.phic_mode and b.profile_id = a.profile_id";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getviewOD_vehicle(DataGridView mtDgv)
{
myString = "select initcap(a.last_name)||', '||initcap(a.first_name)||' '||' ' as employee_name, b.vehicle_payable, b.date_granted ,b.amount_deducted ,b.deduction_start , c.mode_desc from employee_profiles a, od_vehicle_plan b, mode c where c.mode_id = b.mode_id and b.profile_id = a.profile_id";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getviewAll_employee(DataGridView mtDgv)
{
myString = "select * from employee_details";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView GetAllCandidate(DataGridView appGridView, int pos_id)
{
yourString = "select S.first_name||', '||S.last_name as Name,A.position_name as Positions from student S,candidate C,all_positions A where S.stud_id = C.student_id AND C.position_id = A.position_id AND C.position_id =" + pos_id + ";";
return(query.ViaDataGridView(yourString, appGridView));
}
public DataGridView GetAllStudent(DataGridView appGridView, string lastname, string firstname)
{
yourString = "Select * from student where last_name = '" + lastname + "' and first_name = '" + firstname + "'";
return(query.ViaDataGridView(yourString, appGridView));
}
public DataGridView getviewstatus(DataGridView mtDgv)
{
myString = "select * from status";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getviewddependents(DataGridView mtDgv)
{
myString = "select initcap(a.last_name)||', '||initcap(a.first_name)||' '||' ' as employee_name, b.dependent_name , birth_date from employee_profiles a, dependents b, employee_dependents c where c.dependent_id = b.dependent_id and a.profile_id = c.profile_id;";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getViewSSSLoan(DataGridView mtDgv)
{
myString = "select initcap(a.last_name)||', '||initcap(a.first_name)||' '||' ' as employee_name, b.sss_loan_amount , b.loan_dategranted from employee_profiles a, loan_sss b where b.profile_id = a.profile_id";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getviewOD_Eggs(DataGridView mtDgv)
{
myString = "select initcap(a.last_name)||', '||initcap(a.first_name)||' '||' ' as employee_name, b.amount, b.invoice_no ,b.date from employee_profiles a, od_employee_eggs b where b.profile_id = a.profile_id";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getAttendance(DataGridView mtDgv)
{
myString = "select initcap(a.last_name)||', '||initcap(a.first_name)||' '||' ' as employee_name , b.days_present , b.days_legal_holiday , b.special_non_workingday from employee_profiles a, dtr_attendance b where b.payroll_date_id = '" + Payroll_date_id + "' and b.profilie_id = a.profile_id";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getviewdepartments(DataGridView mtDgv)
{
myString = "select * from department";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getviewOD_CA(DataGridView mtDgv)
{
myString = "select initcap(a.last_name)||', '||initcap(a.first_name)||' '||' ' as employee_name, b.ca_amount, b.ca_granted ,b.ca_deduction_per_payroll from employee_profiles a, od_cash_advances b where b.profile_id = a.profile_id";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getviewOD_tin(DataGridView mtDgv)
{
myString = "select initcap(a.last_name)||', '||initcap(a.first_name)||' '||' ' as employee_name, b.withholding_taax_rate , c.mode_desc from employee_profiles a, od_tin b, mode c where c.mode_id = b.tin_mode and b.profile_id = a.profile_id";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getviewsalary(DataGridView mtDgv)
{
myString = "select a.department_decs , b.position_decs , c.mode_desc , d.status_desc , e.basic_pay from department a, position b, mode c, status d, salary_setup e where e.department_id = a.department_id and b.position_id = e.position_id and e.mode_id = c.mode_id and e.status_id = d.status_id";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView GetPos(DataGridView appGridView, String pos)
{
yourString = "Select student.first_name||', '||student.last_name as name , candidate.platform from student,candidate,all_positions where candidate.student_id=student.stud_id and candidate.position_id = all_positions.position_id and all_positions.position_name = '" + pos + "'";
return(query.ViaDataGridView(yourString, appGridView));
}
public DataGridView getviewmode(DataGridView mtDgv)
{
myString = "select * from mode";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
public DataGridView getViewPayrollDate(DataGridView mtDgv)
{
myString = "select * from dtr_payroll_date";
return(myQuery.ViaDataGridView(myString, mtDgv));
}
