public void UpdateWareHouse(WarehouseBL warehouse)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spUpdateWareHouse", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramName = new SqlParameter();
paramName.ParameterName = "@warehouseHTML";
byte[] theBytes = Encoding.UTF8.GetBytes(warehouse.warehouseHtml);
// string ss = Encoding.UTF8.GetString(theBytes);
paramName.Value = theBytes;
cmd.Parameters.Add(paramName);
SqlParameter paramName7 = new SqlParameter();
paramName7.ParameterName = "@managerId";
paramName7.Value = warehouse.managerId;
cmd.Parameters.Add(paramName7);
con.Open();
cmd.ExecuteNonQuery();
}
}
public void UpdateStartWareHouse(WarehouseBL wareHouse)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spUpdateStartWareHouse", con);
cmd.CommandType = CommandType.StoredProcedure;
// SqlParameter paramName99 = new SqlParameter();
// // paramName99.ParameterName = "@warehouseHTML";
// byte[] theBytes = Encoding.UTF8.GetBytes("");
// paramName99.Value = theBytes;
// cmd.Parameters.Add(paramName99);
SqlParameter paramName = new SqlParameter();
paramName.ParameterName = "@warehouseWidth";
paramName.Value = wareHouse.warehouseWidth;
cmd.Parameters.Add(paramName);
SqlParameter paramName2 = new SqlParameter();
paramName2.ParameterName = "@warehouseLength";
paramName2.Value = wareHouse.warehouseLength;
cmd.Parameters.Add(paramName2);
SqlParameter paramName3 = new SqlParameter();
paramName3.ParameterName = "@shelveLength";
paramName3.Value = wareHouse.shelveLength;
cmd.Parameters.Add(paramName3);
SqlParameter paramName4 = new SqlParameter();
paramName4.ParameterName = "@shelveWidth";
paramName4.Value = wareHouse.shelveWidth;
cmd.Parameters.Add(paramName4);
SqlParameter paramName5 = new SqlParameter();
paramName5.ParameterName = "@shelveHeight";
paramName5.Value = wareHouse.shelveHeight;
cmd.Parameters.Add(paramName5);
SqlParameter paramName6 = new SqlParameter();
paramName6.ParameterName = "@shelveRows";
paramName6.Value = wareHouse.shelveRows;
cmd.Parameters.Add(paramName6);
SqlParameter paramName11 = new SqlParameter();
paramName11.ParameterName = "@scaledWarehouseLength";
paramName11.Value = wareHouse.scaledWarehouseLength;
cmd.Parameters.Add(paramName11);
SqlParameter paramName12 = new SqlParameter();
paramName12.ParameterName = "@scaledWarehouseWidth";
paramName12.Value = wareHouse.scaledWarehouseWidth;
cmd.Parameters.Add(paramName12);
SqlParameter paramName13 = new SqlParameter();
paramName13.ParameterName = "@scaledShelfLength";
paramName13.Value = wareHouse.scaledShelfLength;
cmd.Parameters.Add(paramName13);
SqlParameter paramName14 = new SqlParameter();
paramName14.ParameterName = "@scaledShelfWidth";
paramName14.Value = wareHouse.scaledShelfWidth;
cmd.Parameters.Add(paramName14);
SqlParameter paramName1444 = new SqlParameter();
paramName1444.ParameterName = "@shelfSlots";
paramName1444.Value = wareHouse.shelfSlots;
cmd.Parameters.Add(paramName1444);
SqlParameter paramName555 = new SqlParameter();
paramName555.ParameterName = "@sections";
paramName555.Value = wareHouse.sections;
cmd.Parameters.Add(paramName555);
SqlParameter paramName7 = new SqlParameter();
paramName7.ParameterName = "@managerId";
paramName7.Value = wareHouse.managerId;
cmd.Parameters.Add(paramName7);
con.Open();
cmd.ExecuteNonQuery();
}
}
