public void AddRecord(PagIbigs pagIbig) { connection.Open(); //set up command SqlCommand command = new SqlCommand("bprocedureInsertPagIbig", connection); //set up commandType command.CommandType = CommandType.StoredProcedure; //set up parameters command.Parameters.AddWithValue("@MonthlyCompensationFrom", pagIbig.MonthlyCompensationFrom); command.Parameters.AddWithValue("@MonthlyCompensationTo", pagIbig.MonthlyCompensationTo); command.Parameters.AddWithValue("@EmployeeShare", pagIbig.EmployeeShare); command.Parameters.AddWithValue("@EmployerShare", pagIbig.EmployerShare); command.Parameters.AddWithValue("@TotalMonthlyContribution", pagIbig.TotalMonthlyContribution); command.ExecuteNonQuery(); connection.Close(); }
public void EditRow(PagIbigs pagIbig, int index) { //get selectedRow from the dataTable, tableCourse DataRow selectedRow = dataSet.Tables["PagIbig"].Rows[index]; //replace values from course object selectedRow["PagIbigSalaryBracetNo"] = pagIbig.PagIbigSalaryBracetNo; selectedRow["MonthlyCompensationFrom"] = pagIbig.MonthlyCompensationFrom; selectedRow["MonthlyCompensationFrom"] = pagIbig.MonthlyCompensationTo; selectedRow["EmployeeShare"] = pagIbig.EmployeeShare; selectedRow["EmployerShare"] = pagIbig.EmployerShare; selectedRow["TotalMonthlyContribution"] = pagIbig.TotalMonthlyContribution; EditRecord(pagIbig, index); }
public void DeleteRow(PagIbigs pagIbig, int index) { //get selectedRow from the dataTable, tableCourse DataRow selectedRow = dataSet.Tables["PagIbig"].Rows[index]; //delete selected row from the dataSet selectedRow.Delete(); DeleteRecord(pagIbig, index); }
private void EditRecord(PagIbigs pagIbig, int index) { //set up command SqlCommand command = new SqlCommand(); command.Connection = connection; //set up commandType command.CommandType = CommandType.StoredProcedure; //set up procedure name command.CommandText = "bprocedureUpdatePagIbig"; dataAdapter.UpdateCommand = command; //set up parameters command.Parameters.AddWithValue("@PagIbigSalaryBracetNo", pagIbig.PagIbigSalaryBracetNo); command.Parameters.AddWithValue("@MonthlyCompensationFrom", pagIbig.MonthlyCompensationFrom); command.Parameters.AddWithValue("@MonthlyCompensationTo", pagIbig.MonthlyCompensationTo); command.Parameters.AddWithValue("@EmployeeShare", pagIbig.EmployeeShare); command.Parameters.AddWithValue("@EmployerShare", pagIbig.EmployerShare); command.Parameters.AddWithValue("@TotalMonthlyContribution", pagIbig.TotalMonthlyContribution); //update tableCourse from the dataSet dataAdapter.Update(dataSet, "PagIbig"); }
private void DeleteRecord(PagIbigs pagIbig, int index) { //set up command SqlCommand command = new SqlCommand(); command.Connection = connection; //set up commandType command.CommandType = CommandType.StoredProcedure; //set up procedure name command.CommandText = "bprocedureDeletePagIbig"; dataAdapter.DeleteCommand = command; //set up parameters command.Parameters.AddWithValue("@PagIbigSalaryBracetNo", pagIbig.PagIbigSalaryBracetNo); //update tableCourse from the dataSet dataAdapter.Update(dataSet, "PagIbig"); }
public PagIbig() { InitializeComponent(); admin = new Admin(); pagIbig = new PagIbigs(); }