public int GenerateCandidate_ID()
{
container = "Select coalesce(max(candidate_id),0) + 1 from candidate";
return(int.Parse(query1.ViaSingleData(container)));
}
public int totalStudent()
{
yourString = "Select count(stud_id) from student";
return(int.Parse(query.ViaSingleData(yourString)));
}
public int generate_ca_id()
{
myString = "Select coalesce(max(ca_id), 0) + 1 from od_cash_advances;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public string getuserlogin()
{
myString = "select username from login";
return(myQuery.ViaSingleData(myString));
}
public int generate_vehicle_plan_id()
{
myString = "Select coalesce(max(vehicle_plan_id), 0) + 1 from od_vehicle_plan;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int generate_position_id()
{
myString = "Select coalesce(max(position_id), 0) + 1 from position;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int generate_eggs_id()
{
myString = "Select coalesce(max(eggs_id), 0) + 1 from od_employee_eggs;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int generate_status_id()
{
myString = "Select coalesce(max(status_id), 0) + 1 from status;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int StudentAccessID(String fullname, String password)
{
yourString = "Select count(L.access_id) from student S,log_in L where S.access_id = L.access_id AND S.first_name||', '||S.last_name ='" + fullname + "' and S.password='******';";
count = Convert.ToInt16(query.ViaSingleData(yourString));
return(count);
}
public int generate_emp_gross_earning_id()
{
myString = "Select coalesce(max(emp_gross_earning_id), 0) + 1 from employee_gross_earnings;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int generate_attendance_id()
{
myString = "Select coalesce(max(attendance_id), 0) + 1 from dtr_attendance;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int generate_master_employee_id()
{
myString = "Select coalesce(max(master_employee_id), 0) + 1 from master_employee;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public string GetID(int id, string pos)
{
yourString = "Select a.last_name||', 'a.first_name from student a,candidate b where a.stud_id = " + id + ";";
return(query.ViaSingleData(yourString));
}
public static int getid(String Full_name)
{
yourString1 = "Select stud_id from student where first_name||', '||last_name='" + Full_name + "'";
return(int.Parse(query1.ViaSingleData(yourString1)));
}
public int GetPosition_id(String a)
{
yourString = "Select position_id from all_positions where position_name ='" + a + "';";
return(int.Parse(query.ViaSingleData(yourString)));
}
public int generate_hmo_id()
{
myString = "Select coalesce(max(hmo_id), 0) + 1 from od_hmo;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int generate_profile_id()
{
myString = "Select coalesce(max(profile_id), 0) + 1 from employee_profiles;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int getAccess(String username, String password)
{
yourString = "Select count(ballot_id) from ballot where username='******' and password='******';";
return(int.Parse(query.ViaSingleData(yourString)));
}
public int generate_citezen_id()
{
myString = "Select coalesce(max(citezenship_id), 0) + 1 from citezenship;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public string GetEmployeeCompleteName(string id)
{
myString = "select initcap(member_lname)||', '||initcap(member_fname)||' '||initcap(member_mi) from member_master where member_id = '" + id + "'";
return(myQuery.ViaSingleData(myString));
}
public int generate_gender_id()
{
myString = "Select coalesce(max(gender_id), 0) + 1 from gender;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int countGov()
{
yourString = "Select count(candidate_id) from candidate where position_id=1";
return(int.Parse(query.ViaSingleData(yourString)));
}
public int generate_dependent_id()
{
myString = "Select coalesce(max(dependent_id), 0) + 1 from dependents;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int generate_setup_salary_id()
{
myString = "Select coalesce(max(setup_salary_id), 0) + 1 from salary_setup;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int generate_loan_id()
{
myString = "Select coalesce(max(loan_id), 0) + 1 from loan_sss;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int generate_pag_ibig_mandatory_deduction_idid()
{
myString = "Select coalesce(max(pag_ibig_mandatory_deduction_id), 0) + 1 from emp_mandatory_pag_ibig_deduction;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
public int generate_payroll_date_id()
{
myString = "Select coalesce(max(payroll_date_id), 0) + 1 from dtr_payroll_date;";
return(int.Parse(myQuery.ViaSingleData(myString)));
}
