public void deleteOrganisationLeader(OrganisationLeader organisationLeader)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "EXEC delete_organisationleader " + organisationLeader.Id;
cmd.Connection = dbHelper.connection;
cmd.ExecuteNonQuery();
}
public void setOrganisationLeader(OrganisationLeader organisationLeader)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "EXEC set_organisationleader " + organisationLeader.Id + ", " + organisationLeader.EmployeeNumber + ", " + organisationLeader.Organisation.Id + ", '" + organisationLeader.Surname + "', '" + organisationLeader.Prename + "', " + organisationLeader.IsChairman + ", " + organisationLeader.IsBoard;
cmd.Connection = dbHelper.connection;
cmd.ExecuteNonQuery();
}
public OrganisationLeader newOrganisationLeader(OrganisationLeader organisationLeader)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "EXEC new_organisationleader " + organisationLeader.EmployeeNumber + ", " + organisationLeader.Organisation.Id + ", '" + organisationLeader.Surname + "', '" + organisationLeader.Prename + "', " + organisationLeader.IsChairman + ", " + organisationLeader.IsBoard;
cmd.Connection = dbHelper.connection;
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
organisationLeader.Id = Convert.ToInt32(reader["ID"]);
reader.Close();
return(organisationLeader);
}
public OrganisationLeader getOrganisationLeader(int id)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "EXEC get_organisationleader " + id;
cmd.Connection = dbHelper.connection;
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
OrganisationLeader organisationLeader = mapOrganisationLeader(reader);
reader.Close();
return(organisationLeader);
}
