public Shipper GetShipper(int id)
{
try
{
var shipper = new Shipper { Id = id };
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
var cmd = new SqlCommand("SELECT [ShipperID], [CompanyName], [Phone] FROM [dbo].[Shippers] WHERE [ShipperID] = @Id", conn);
cmd.Parameters.AddWithValue("@Id", id);
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
shipper.CompanyName = reader["CompanyName"].ToString();
shipper.Phone = reader["Phone"].ToString();
}
}
}
return shipper;
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}
public void SaveShipper(Shipper shipper)
{
try
{
repo.SaveShopper(shipper);
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
var host = new ShipperServiceClient();
var shipper = new Shipper
{
ShipperID = int.Parse(TextBoxShipperId.Text),
CompanyName = TextBoxCompanyName.Text,
Phone = TextBoxPhone.Text
};
host.SaveShipper(shipper);
}
public void UpdateShipper(Shipper shipper)
{
using (var context = new NORTHWNDEntities())
{
var shipperToUpdate = context.Shippers.Where(x => x.ShipperID == shipper.ShipperID).Select(x => x).FirstOrDefault();
if (shipperToUpdate != null)
{
shipperToUpdate.CompanyName = shipper.CompanyName;
shipperToUpdate.Phone = shipper.Phone;
}
context.SaveChanges();
}
}
public void SaveShipper(Shipper shipper)
{
using (SqlConnection connection = new SqlConnection(_settings))
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.Parameters.AddWithValue("@companyName", shipper.CompanyName);
cmd.Parameters.AddWithValue("@phone", shipper.Phone);
cmd.Parameters.AddWithValue("@shipperID", shipper.ShipperId);
cmd.CommandText =
"UPDATE Shippers SET CompanyName = @companyName, Phone = @phone WHERE ShipperID = @shipperID";
connection.Open();
cmd.ExecuteNonQuery();
}
}
public void SaveShipper(Shipper shipper)
{
using (SqlConnection connection = new SqlConnection(_settings))
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.Parameters.AddWithValue("@companyName", shipper.CompanyName);
cmd.Parameters.AddWithValue("@phone", shipper.Phone);
cmd.Parameters.AddWithValue("@shipperID", shipper.ShipperId);
cmd.CommandText =
"UPDATE Shippers SET CompanyName = @companyName, Phone = @phone WHERE ShipperID = @shipperID";
connection.Open();
cmd.ExecuteNonQuery();
}
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
var service = new ShipperServiceClient();
var shipper = new Shipper();
try
{
shipper.ID = TextBoxID.Text;
shipper.CompanyName = TextBoxShipperName.Text;
shipper.Phone = TextBoxShipperPhone.Text;
service.SaveShipper(shipper);
}
catch (FaultException ex)
{
Label1.Text = "Service error: Something went wrong" + ex.Message;
}
catch (Exception ex)
{
Label1.Text = "Client error: Something went wrong" + ex.Message;
}
}
public Shipper GetShipperById(int id)
{
var shipper = new Shipper();
var queryString = "SELECT * FROM dbo.Shippers WHERE ShipperID =" + id;
using (var connection = new SqlConnection(_connectionstring))
{
var command = new SqlCommand(queryString, connection);
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
shipper.ShipperID = (int) reader["ShipperID"];
shipper.CompanyName = (string) reader["CompanyName"];
shipper.Phone = (string) reader["Phone"];
}
reader.Close();
}
return shipper;
}
public bool SaveShipper(Shipper shipper)
{
try
{
using (var conn = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("UPDATE [dbo].[Shippers] SET [CompanyName] = @CompanyName, [Phone] = @Phone WHERE [ShipperID] = @Id", conn);
cmd.Parameters.AddWithValue("@CompanyName", shipper.CompanyName);
cmd.Parameters.AddWithValue("@Phone", shipper.Phone);
cmd.Parameters.AddWithValue("@Id", shipper.Id);
conn.Open();
return cmd.ExecuteNonQuery() == 1;
}
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}
public Shipper GetShipperByID(int shipperId)
{
string query = "SELECT[ShipperID] ,[CompanyName] ,[Phone] FROM[NORTHWND].[dbo].[Shippers]" +
"WHERE[ShipperID] =" + shipperId; //Vill bara hämta med rätt id
var shipper = new Shipper();
using (SqlConnection connection = new SqlConnection(_connectionString))
{
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
shipper.ShipperID = Convert.ToInt32(reader["ShipperID"].ToString());
shipper.CompanyName = reader["CompanyName"].ToString();
shipper.Phone = reader["Phone"].ToString();
}
}
return shipper;
}
public Shipper GetShipperById(int id)
{
var shipper = new Shipper();
var queryString = "SELECT * FROM dbo.Shippers WHERE ShipperID =" + id;
using (var connection = new SqlConnection(_connectionstring))
{
var command = new SqlCommand(queryString, connection);
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
shipper.ShipperID = (int)reader["ShipperID"];
shipper.CompanyName = (string)reader["CompanyName"];
shipper.Phone = (string)reader["Phone"];
}
reader.Close();
}
return(shipper);
}
public Shipper GetShipper(int id)
{
var shipper=new Shipper();
var conn = ConfigurationManager.ConnectionStrings["NORTHWND"].ConnectionString;
using (var connection=new SqlConnection(conn))
{
var getShipperCommand = new SqlCommand("Select [ShipperID], [CompanyName], [Phone] from Shippers where ShipperID=@id", connection);
getShipperCommand.Parameters.AddWithValue("@id", id);
connection.Open();
using (var reader = getShipperCommand.ExecuteReader())
{
while (reader.Read())
{
shipper.ShipperID = int.Parse(reader["ShipperID"].ToString());
shipper.CompanyName = reader["CompanyName"].ToString();
shipper.Phone = reader["Phone"].ToString();
}
}
}
return shipper;
}
public Shipper GetShipperId(int shipperId)
{
var shipper = new Shipper();
string queryString =
"SELECT * FROM [dbo].[Shippers] WHERE [ShipperID] =" + shipperId;
using (SqlConnection connection = new SqlConnection(_settings))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
shipper.ShipperId = int.Parse(reader["ShipperID"].ToString());
shipper.CompanyName = reader["CompanyName"].ToString();
shipper.Phone = reader["Phone"].ToString();
}
}
return shipper;
}
public Shipper GetShipperId(int shipperId)
{
var shipper = new Shipper();
string queryString =
"SELECT * FROM [dbo].[Shippers] WHERE [ShipperID] =" + shipperId;
using (SqlConnection connection = new SqlConnection(_settings))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
shipper.ShipperId = int.Parse(reader["ShipperID"].ToString());
shipper.CompanyName = reader["CompanyName"].ToString();
shipper.Phone = reader["Phone"].ToString();
}
}
return(shipper);
}
public bool UpdateShipper(Shipper shipper)
{
using (var context = new NORTHWNDEntities())
{
try
{
var shipperToUpdate = context.Shippers.FirstOrDefault(x => x.ShipperID == shipper.ShipperId);
if (shipperToUpdate != null)
{
shipperToUpdate.ShipperID = shipper.ShipperId;
shipperToUpdate.CompanyName = shipper.CompanyName;
shipperToUpdate.Phone = shipper.Phone;
}
context.SaveChanges();
return true;
}
catch (Exception)
{
return false;
throw;
}
}
}
public Shipper GetShipperByID(int id)
{
var theShipper = new Shipper();
var connectionString = ConfigurationManager.ConnectionStrings["NORTHWND"].ConnectionString;
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
var sqlShipperCommand = new SqlCommand("SELECT * FROM Shippers WHERE ShipperID = @id", conn);
sqlShipperCommand.Parameters.AddWithValue("@id", id);
using (var reader = sqlShipperCommand.ExecuteReader())
{
while (reader.Read())
{
theShipper.ShipperID = (int)reader["ShipperID"];
theShipper.CompanyName = reader["CompanyName"].ToString();
theShipper.Phone = reader["Phone"].ToString();
}
}
conn.Close();
}
return theShipper;
}
public bool UpdateShipper(Shipper shipper)
{
using (var context = new NORTHWNDEntities())
{
try
{
var updatedShipper = context.Shippers.FirstOrDefault(x => x.ShipperID == shipper.ShipperID);
if (updatedShipper != null)
{
updatedShipper.ShipperID = shipper.ShipperID;
updatedShipper.CompanyName = shipper.CompanyName;
updatedShipper.Phone = shipper.Phone;
}
context.SaveChanges();
return true;
}
catch (Exception ex)
{
throw new FaultException($"Shipper not updated {ex.Message}");
}
}
}
