public bool SaveShipper(Shipper shipper)
{
try
{
return repo.SaveShipper(shipper);
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}
public bool SaveShipper(Shipper shipper)
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["northwindDb"].ToString()))
{
const string cmdText = "UPDATE [dbo].[Shippers] SET [CompanyName] = @CompanyName, [Phone] = @Phone WHERE [ShipperID] = @ShipperId";
var command = new SqlCommand(cmdText, conn);
command.Parameters.AddWithValue("@CompanyName", shipper.CompanyName);
command.Parameters.AddWithValue("@Phone", shipper.Phone);
command.Parameters.AddWithValue("@ShipperId", shipper.ShipperId);
conn.Open();
return command.ExecuteNonQuery() > 0;
}
}
public Shipper GetShipperById(int shipperId)
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["northwindDb"].ToString()))
{
var command = new SqlCommand("Select [ShipperID], [CompanyName], [Phone] FROM [dbo].[Shippers] WHERE [ShipperID] = @ShipperId", conn);
command.Parameters.AddWithValue("@ShipperId", shipperId);
conn.Open();
var shipper = new Shipper();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
shipper.CompanyName = reader["CompanyName"].ToString();
shipper.Phone = reader["Phone"].ToString();
}
}
shipper.ShipperId = shipperId;
return shipper;
}
}
