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(); } }