public ServiceDeliveryDescription GetDeliveryDescriptionById(int deliveryId)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmdGetDeliveryDescription = connection.CreateCommand())
{
ServiceDeliveryDescription deliveryDescription = new ServiceDeliveryDescription();
cmdGetDeliveryDescription.CommandText = "SELECT deliveryId, name, address, zipCode, phoneNo, customerId FROM DeliveryDescription WHERE deliveryId = @deliveryId";
cmdGetDeliveryDescription.Parameters.AddWithValue("deliveryId", deliveryId);
SqlDataReader deliveryDescriptionReader = cmdGetDeliveryDescription.ExecuteReader();
while (deliveryDescriptionReader.Read())
{
deliveryDescription.DeliveryId = deliveryDescriptionReader.GetInt32(deliveryDescriptionReader.GetOrdinal("deliveryId"));
deliveryDescription.Name = deliveryDescriptionReader.GetString(deliveryDescriptionReader.GetOrdinal("name"));
deliveryDescription.Address = deliveryDescriptionReader.GetString(deliveryDescriptionReader.GetOrdinal("address"));
deliveryDescription.ZipCode = deliveryDescriptionReader.GetInt32(deliveryDescriptionReader.GetOrdinal("zipCode"));
deliveryDescription.PhoneNo = deliveryDescriptionReader.GetString(deliveryDescriptionReader.GetOrdinal("phoneNo"));
deliveryDescription.CustomerId = deliveryDescriptionReader.GetInt32(deliveryDescriptionReader.GetOrdinal("customerId"));
}
return(deliveryDescription);
}
}
}
public void TestInsertDeliveryDescription()
{
//Arrange
DataDeliveryDescription dataDeliveryDescription = new DataDeliveryDescription();
ServiceDeliveryDescription deliveryDescription = new ServiceDeliveryDescription();
deliveryDescription.Name = "Scheelsminde Hotel";
deliveryDescription.Address = "Scheelsmindevej 35";
deliveryDescription.ZipCode = 9200;
deliveryDescription.PhoneNo = "12345678";
//deliveryDescription.CustomerId = 100;
bool check = false;
//Act
try
{
dataDeliveryDescription.InsertDeliveryDescription(deliveryDescription);
check = true;
}
catch
{
check = false;
}
//Assert
Assert.IsTrue(check);
}
public DeliveryDescription ConvertFromServiceDeliveryDescription(ServiceDeliveryDescription serviceDeliveryDescription)
{
DeliveryDescription deliveryDescriptionToReturn = new DeliveryDescription();
deliveryDescriptionToReturn.DeliveryId = serviceDeliveryDescription.DeliveryId;
deliveryDescriptionToReturn.Name = serviceDeliveryDescription.Name;
deliveryDescriptionToReturn.Address = serviceDeliveryDescription.Address;
deliveryDescriptionToReturn.ZipCode = serviceDeliveryDescription.ZipCode;
deliveryDescriptionToReturn.PhoneNo = serviceDeliveryDescription.PhoneNo;
deliveryDescriptionToReturn.CustomerId = serviceDeliveryDescription.CustomerId;
return(deliveryDescriptionToReturn);
}
public ServiceDeliveryDescription ConvertToServiceDeliveryDescription(DeliveryDescription webshopDeliveryDescription)
{
ServiceDeliveryDescription deliveryDescriptionToReturn = new ServiceDeliveryDescription();
deliveryDescriptionToReturn.DeliveryId = webshopDeliveryDescription.DeliveryId;
deliveryDescriptionToReturn.Name = webshopDeliveryDescription.Name;
deliveryDescriptionToReturn.Address = webshopDeliveryDescription.Address;
deliveryDescriptionToReturn.ZipCode = webshopDeliveryDescription.ZipCode;
deliveryDescriptionToReturn.PhoneNo = webshopDeliveryDescription.PhoneNo;
deliveryDescriptionToReturn.CustomerId = webshopDeliveryDescription.CustomerId;
return(deliveryDescriptionToReturn);
}
public void InsertDeliveryDescription(ServiceDeliveryDescription deliveryDescription)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmdInsertDeliveryDescription = connection.CreateCommand())
{
cmdInsertDeliveryDescription.CommandText = "INSERT INTO DeliveryDescription (name, address, zipCode, phoneNo, customerId) VALUES (@name, @address, @zipCode, @phoneNo, @customerId)";
cmdInsertDeliveryDescription.Parameters.AddWithValue("name", deliveryDescription.Name);
cmdInsertDeliveryDescription.Parameters.AddWithValue("address", deliveryDescription.Address);
cmdInsertDeliveryDescription.Parameters.AddWithValue("zipCode", deliveryDescription.ZipCode);
cmdInsertDeliveryDescription.Parameters.AddWithValue("phoneNo", deliveryDescription.PhoneNo);
cmdInsertDeliveryDescription.Parameters.AddWithValue("customerId", deliveryDescription.CustomerId);
cmdInsertDeliveryDescription.ExecuteNonQuery();
}
}
}
public int UpdateDeliveryDescription(ServiceDeliveryDescription deliveryDescription)
{
int rowsAffected;
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmdUpdateDeliveryDescription = connection.CreateCommand())
{
cmdUpdateDeliveryDescription.CommandText = "UPDATE DeliveryDescription SET name = @name, address = @address, zipCode = @zipCode, phoneNo = @phoneNo, customerId = @customerId WHERE deliveryId = @deliveryId";
cmdUpdateDeliveryDescription.Parameters.AddWithValue("name", deliveryDescription.Name);
cmdUpdateDeliveryDescription.Parameters.AddWithValue("address", deliveryDescription.Address);
cmdUpdateDeliveryDescription.Parameters.AddWithValue("zipCode", deliveryDescription.ZipCode);
cmdUpdateDeliveryDescription.Parameters.AddWithValue("phoneNo", deliveryDescription.PhoneNo);
cmdUpdateDeliveryDescription.Parameters.AddWithValue("customerId", deliveryDescription.CustomerId);
cmdUpdateDeliveryDescription.Parameters.AddWithValue("deliveryId", deliveryDescription.DeliveryId);
rowsAffected = cmdUpdateDeliveryDescription.ExecuteNonQuery();
}
}
return(rowsAffected);
}
public void UpdateDeliveryDescription(ServiceDeliveryDescription deliveryDescription)
{
deliveryDescriptionControl.UpdateDeliveryDescription(deliveryDescription);
}
public void InsertDeliveryDescription(ServiceDeliveryDescription deliveryDescription)
{
deliveryDescriptionControl.InsertDeliveryDescription(deliveryDescription);
}
public void UpdateDeliveryDescription(ServiceDeliveryDescription deliveryDescription)
{
dataDeliveryDescription.UpdateDeliveryDescription(deliveryDescription);
}
public ServiceDeliveryDescription GetDeliveryDescriptionById(int deliveryId)
{
ServiceDeliveryDescription deliveryDescription = dataDeliveryDescription.GetDeliveryDescriptionById(deliveryId);
return(deliveryDescription);
}
public void InsertDeliveryDescription(ServiceDeliveryDescription deliveryDescription)
{
dataDeliveryDescription.InsertDeliveryDescription(deliveryDescription);
}
