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))); }