public void EditRow(Bonus bonus, int index)
{
DataRow selectedRow = dataSet.Tables["JoinEmployeeBonus"].Rows[index];
selectedRow["Date"] = bonus.Date;
selectedRow["Amount"] = bonus.Amount;
selectedRow["Type"] = bonus.Type;
EditRecord(bonus, index);
}
public void DeleteRow(Bonus bonus, int index)
{
DataRow selectedRow = dataSet.Tables["JoinEmployeeBonus"].Rows[index];
selectedRow.Delete();
DeleteRecord(bonus, index);
}
private void EditRecord(Bonus bonus, int index)
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "jprocedureUpdateEmployeeBonus";
dataAdapter.UpdateCommand = command;
command.Parameters.AddWithValue("@EmployeeID", bonus.Employee.EmoloyeeID);
command.Parameters.AddWithValue("@Date", bonus.Date);
command.Parameters.AddWithValue("@Amount", bonus.Amount);
command.Parameters.AddWithValue("@BonusID", bonus.BonusID);
command.Parameters.AddWithValue("@Type", bonus.Type);
dataAdapter.Update(dataSet, "JoinEmployeeBonus");
}
public void AddRecord(Bonus bonus)
{
connection.Open();
//set up command
SqlCommand command = new SqlCommand("jprocedureInsertEmployeeBonus", connection);
//set up commandType
command.CommandType = CommandType.StoredProcedure;
//set up parameters
command.Parameters.AddWithValue("@Date", bonus.Date);
command.Parameters.AddWithValue("@Amount", bonus.Amount);
command.Parameters.AddWithValue("@EmployeeID", bonus.Employee.EmoloyeeID);
command.Parameters.AddWithValue("@Type", bonus.Type);
command.ExecuteNonQuery();
connection.Close();
}
private void DeleteRecord(Bonus bonus, int index)
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "jprocedureDeleteEmployeeBonus";
dataAdapter.DeleteCommand = command;
command.Parameters.AddWithValue("@BonusID",bonus.BonusID );
dataAdapter.Update(dataSet, "JoinEmployeeBonus");
}