public bool Insert()
{
//department_id integer NOT NULL,
//department_decs character varying(150),
myString = "Insert into department(department_id, department_decs ) values('" + Department_id + "', '" + Department_decs + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into od_employee_eggs(eggs_id,invoice_no,date,amount,profile_id ) values(" + Eggs_id + ", '" + Invoice_no + "', '" + Date + "', " + Amount + ", " + Profile_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into salaries(salary_id,salary,profile_id,attendance_id,special_pay,legal_pay,regular_pay) values(" + Salary_id + ", " + Salary + ", " + Profile_id + ", " + Attendance_id + ", " + Special_pay + ", " + Legal_pay + ", " + Regular_pay + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into emp_madatory_deduction(emp_mandatory_deduction_id , sss_madatory_deduction_id ,pag_ibig_mandatory_deduction_id , philhealth_deduction_id ) values ( " + Emp_mandatory_deduction_id + ", " + Sss_madatory_deduction_id + "," + Pag_ibig_mandatory_deduction_id + "," + Philhealth_deduction_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into salary_setup(setup_salary_id,status_id,position_id,mode_id,basic_pay,department_id) values(" + Setup_salary_id + ", " + Status_id + ", " + Position_id + ", " + Mode_id + ", " + Basic_pay + ", " + Department_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into od_cash_advances(ca_id , ca_amount , ca_granted,ca_deduction_per_payroll,profile_id) values(" + Ca_id + ", " + Ca_amount + ", '" + Ca_granted + "' , " + Ca_deduction_per_payroll + " ," + Profile_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool insertVotes(int studid, String positionname, int votes)
{
yourString = "Insert into vote values (" + studid + ",'" + positionname + "'," + votes + ");";
return(query.InsertUpdateDelete(yourString));
}
public bool Insert()
{
myString = "Insert into od_phic(phic_id,phic_employee_contribution,phic_employer_contribution,phic_mode,profile_id ) values(" + Phic_id + ", " + Phic_employee_contribution + ", " + Phic_employer_contribution + ", " + Phic_mode + ", " + Profile_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into deductions(deduction_id,profile_id,sss_contribution,pagibig_contribution,philhealth_contribution,od_ca,od_eggs,od_hcard,od_hmo,od_phic,od_tin,od_uniform,od_vehicle,loan_sss,loan_pagibig,deduction_total,attendance_id) values(" + Deduction_id + ", " + Profile_id + ", " + Sss_contribution + ", " + Pagibig_contribution + ", " + Philhealth_contribution + ", " + Od_ca + ", " + Od_eggs + "," + Od_hcard + ", " + Od_hmo + ", " + Od_phic + ", " + Od_tin + ", " + Od_uniform + ", " + Od_vehicle + ", " + Loan_sss + ", " + Loan_pagibig + ", " + Deduction_total + ", " + Attendance_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into net_salary(net_salary_id,employee_net_salary,profile_id,attendance_id) values(" + Net_salary_id + ", " + Employee_net_salary + ", " + Attendance_id + "," + Profile_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into dependents(dependent_id,dependent_name,birth_date ) values(" + Dependent_id + ",' " + Dependent_name + "','" + Birth_date + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into gender(gender_id,gender_desc ) values(" + Gender_id + ", '" + Gender_desc + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into citezenship(citezenship_id,citezenship_desc ) values(" + Citezenship_id + ", '" + Citezenship_desc + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into loan_pagibig(pagibig_loan_id,profile_id,loan_amount,loan_granted,loan_deduc_mode,loan_deduction_amount,loan_deduction_starts,employee_pagibig_id ) values(" + Pagibig_loan_id + ", " + Profile_id + ", " + Loan_amount + ", '" + Loan_granted + "', " + Loan_deduc_mode + ", " + Loan_deduction_amount + ", '" + Loan_deduction_starts + "', '" + Employee_pagibig_id + "')";
return(myQuery.InsertUpdateDelete(myString));
}
// profile_id integer NOT NULL,
//first_name character varying(50),
//last_name character varying(50),
//midle_initial character varying(20),
//suffix character varying(10),
//birthdate timestamp without time zone,
//gender_id integer,
//citezenship_id integer,
//civil_status_id integer,
//address character varying(100),
//mother_name character varying(100),
//fathers_name character varying(100),
public bool Insert()
{
myString = "Insert into employee_profiles(profile_id,first_name,last_name,midle_initial,suffix,birthdate,gender_id,citezenship_id,civil_status_id,address,mother_name,fathers_name,spouse_name ) values(" + Profile_id + ", '" + First_name + "', '" + Last_name + "' , '" + Midle_initial + "', '" + Suffix + "', '" + Birthdate + "', " + Gender_id + ", " + Citezenship_id + ", " + Civil_status_id + ", '" + Address + "', '" + Mother_name + "', '" + Fathers_name + "', '" + Spouse_name + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into od_vehicle_plan(vehicle_plan_id , vehicle_payable , date_granted,mode_id,amount_deducted,deduction_start,profile_id) values(" + Vehicle_plan_id + ", " + Vehicle_payable + ", '" + Date_granted + "' , " + Mode_id + ", " + Amount_deducted + ", '" + Deduction_start + "' ," + Profile_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
//repeatedFunction repfunc = new repeatedFunction();
public bool Insert(string memid)
{
myString = "Insert into member_master(member_id) values('" + memid + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into loan_sss(loan_id,sss_loan_amount,loan_dategranted,loan_deduction_mode,loan_amount_deducted,loan_deduction_start,profile_id,employee_sss_id ) values(" + Loan_id + ", " + Sss_loan_amount + ", '" + Loan_dategranted + "', " + Loan_deduction_mode + ", " + Loan_amount_deducted + ", '" + Loan_deduction_start + "', " + Profile_id + ",'" + Employee_sss_id + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into position(position_id, department_id, position_decs ) values('" + Position_id + "', '" + Department_id + "','" + Position_decs + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into od_health_card(health_card_id,amount,date_granted,mode_id,amount_deducted,deduction_start,profile_id ) values(" + Health_card_id + ", " + Amount + ", '" + Date_granted + "', " + Mode_id + ", " + Amount_deducted + ", '" + Deduction_start + "', " + Profile_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into employee_dependents(dependent_id,profile_id ) values(" + Dependent_id + ", " + Profile_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool UpdateStudent()
{
yourString = "Update student set first_name='" + First_name + "' , last_name = '" + Last_name + "', dept_id=" + Dept_id + " , course_id=" + Course_id + " where stud_id=" + Stud_id + "";
return(query.InsertUpdateDelete(yourString));
}
public bool Insert()
{
myString = "Insert into emp_mandatory_sss_deduction(sss_mandatory_deduction_id,sss_contribution ,employer_contribution ,paymode_id) values(" + Sss_mandatory_deduction_id + ", '" + Sss_contribution + "', '" + Employer_contribution + "', '" + Paymode_id + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into od_hmo(hmo_id , intillecare_pay_amount , date_granted,mode_id,amount_deducted,deduction_start,profile_id) values(" + Hmo_id + ", " + Intillecare_pay_amount + ", '" + Date_granted + "' , " + Mode_id + ", " + Amount_deducted + ", '" + Deduction_start + "' ," + Profile_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
yourString = "Insert into partylist values (" + Partylist_id + ", '" + Partylist_name + "', '" + Platfrom + "')";
return(query.InsertUpdateDelete(yourString));
}
public bool Insert()
{
myString = "Insert into status(status_id,status_desc ) values(" + Status_id + ", '" + Status_desc + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into emp_mandatory_philhealth_deduction(philhealth_contribution_id, philhealth_contribution ,employer_contribution , philhealth_paymode_id) values(" + Philhealth_contribution_id + ", '" + Philhealth_contribution + "', '" + Employer_contribution + "', '" + Philhealth_paymode_id + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into od_tin(tin_id , withholding_taax_rate , tin_mode, profile_id) values(" + Tin_id + ", " + Withholding_taax_rate + ", " + Tin_mode + ", " + Profile_id + ")";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
myString = "Insert into mode(mode_id,mode_desc ) values(" + Mode_id + ", '" + Mode_desc + "')";
return(myQuery.InsertUpdateDelete(myString));
}
public bool Insert()
{
yourString = "Update ballot set counter=1";
return(query.InsertUpdateDelete(yourString));
}
