private Truckdriver ReadNextTruckdriver(SqlDataReader reader)
{
Truckdriver truckdriver = new Truckdriver();
truckdriver.Id = reader.GetInt32(0);
truckdriver.TelephoneNo = reader.GetString(1);
truckdriver.EMail = reader.GetString(2);
return(truckdriver);
}
public Truckdriver DeleteDriver(int id)
{
Truckdriver truckdriver = GetDriverFromId(id);
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
using (SqlCommand command = new SqlCommand("Delete from Truckdriver where Id = @Id", conn))
{
command.Parameters.AddWithValue("@Id", id);
command.ExecuteNonQuery();
}
}
return(truckdriver);
}
public bool UpdateTruckdriver(Truckdriver truckdriver, int id)
{
bool updated = false;
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
using (SqlCommand command = new SqlCommand("Update Truckdriver set TelephoneNo = @Tlf, EMail = @Mail, where Id = @Id", conn))
{
command.Parameters.AddWithValue("@Id", id);
command.Parameters.AddWithValue("@Tlf", truckdriver.TelephoneNo);
command.Parameters.AddWithValue("@Mail", truckdriver.EMail);
int rows = command.ExecuteNonQuery();
updated = rows == 1;
}
}
return(updated);
}
public bool CreateDriver(Truckdriver truckdriver)
{
bool created = false;
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
using (SqlCommand command = new SqlCommand("Insert into Truckdriver (Id, TelephoneNo, EMail) values(@Id, @TelephoneNo, @EMail)", conn))
{
command.Parameters.AddWithValue("@Id", truckdriver.Id);
command.Parameters.AddWithValue("@TelephoneNo", truckdriver.TelephoneNo);
command.Parameters.AddWithValue("@EMail", truckdriver.EMail);
int rows = command.ExecuteNonQuery();
created = rows == 1;
}
}
return(created);
}
public Truckdriver GetDriverFromId(int id)
{
Truckdriver truckdriver = new Truckdriver();
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
using (SqlCommand command = new SqlCommand("Select * from Truckdriver where Id = @Id", conn))
{
command.Parameters.AddWithValue("@Id", id);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
truckdriver = ReadNextTruckdriver(reader);
}
}
}
return(truckdriver);
}
public bool Put(int id, [FromBody] Truckdriver value)
{
return(manager.UpdateTruckdriver(value, id));
}
public bool Post([FromBody] Truckdriver value)
{
return(manager.CreateDriver(value));
}
