private Employee FindEmployeeWithUsername(string username)
{
SqlCommand command = new SqlCommand("Select Email From empDetails Where username = @username", DataBaseManager.GetConnector());
command.Parameters.AddWithValue("@username", username);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Employee emp = new Employee {
Email = reader["Email"].ToString()
};
reader.Close();
return(emp);
}
else
{
reader.Close();
return(null);
}
}
