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 List <Employe> SelectAll()
{
DataTable table;
using (MySqlConnection connection = DbConnection.GetConnection())
{
connection.Open();
string strMysql = "SELECT * FROM Employe";
MySqlCommand command = new MySqlCommand(strMysql, connection);
table = DataBaseAccesUtilities.SelectRequest(command);
}
return(GetListFromDataTable(table));
}
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);
}
}
public Employe SelectById(int Id)
{
using (MySqlConnection connection = DbConnection.GetConnection())
{
connection.Open();
string strMysql = "SELECT * FROM Employe WHERE EmployeID=@Id";
MySqlCommand command = new MySqlCommand(strMysql, connection);
command.Parameters.AddWithValue("@Id", Id);
DataTable table = DataBaseAccesUtilities.SelectRequest(command);
if (table != null)
{
return(GetEntityFromDataRow(table.Rows[0]));
}
else
{
return(null);
}
}
}
