public void Delete(int Id)
{
using (MySqlConnection mySqlConnection = DbConnection.GetConnection())
{
string strMySQL = "DELETE FROM Employe WHERE EmployeID=@Id";
MySqlCommand command = new MySqlCommand(strMySQL, mySqlConnection);
command.Parameters.AddWithValue("@Id", Id);
DataBaseAccesUtilities.NonQueryRequest(command);
}
}
public void Add(Employe employe)
{
using (MySqlConnection mySqlConnection = DbConnection.GetConnection())
{
string strMySQL = "INSERT INTO Employe (Name, Position, Office, Age, Salary) VALUES (@Name, @Position, @Office, @Age, @Salary)";
MySqlCommand command = new MySqlCommand(strMySQL, mySqlConnection);
command.Parameters.AddWithValue("@Name", employe.Name);
command.Parameters.AddWithValue("@Position", employe.Position);
command.Parameters.AddWithValue("@Office", employe.Office);
command.Parameters.AddWithValue("@Age", employe.Age);
command.Parameters.AddWithValue("@Salary", employe.Salary);
DataBaseAccesUtilities.NonQueryRequest(command);
}
}
public void Update(int Id, Employe employe)
{
using (MySqlConnection mySqlConnection = DbConnection.GetConnection())
{
string strMySQL = "UPDATE Employe SET Name=@Name, Position=@Position, Office=@Office, Age=@Age, Salary=@Salary WHERE EmployeID=@Id";
MySqlCommand command = new MySqlCommand(strMySQL, mySqlConnection);
command.Parameters.AddWithValue("@Name", employe.Name);
command.Parameters.AddWithValue("@Position", employe.Position);
command.Parameters.AddWithValue("@Office", employe.Office);
command.Parameters.AddWithValue("@Age", employe.Age);
command.Parameters.AddWithValue("@Salary", employe.Salary);
command.Parameters.AddWithValue("@Id", Id);
DataBaseAccesUtilities.NonQueryRequest(command);
}
}
