public int AddFloor(FloorModel floor)
{
using (var connection = new SqlConnection(conS))
{
connection.Open();
var sql = "INSERT INTO Floors(FloorPlan, FloorName, BuildingID) output INSERTED.FloorID VALUES(@FloorPlan, @FloorName, @BuildingID)";
using (var cmd = new SqlCommand(sql, connection))
{
//TODO FloorID
cmd.Parameters.AddWithValue("@FloorPlan", floor.Floorplan);
cmd.Parameters.AddWithValue("@FloorName", floor.FloorName);
cmd.Parameters.AddWithValue("@BuildingID", floor.BuildingID);
int insertedID = (int)cmd.ExecuteScalar();
return(insertedID);
}
}
}
public FloorModel GetFloorPlanByID(int id)
{
FloorModel returnval = new FloorModel();
using (var connection = new SqlConnection(conS))
{
connection.Open();
var sql = "SELECT * From Floors where FloorID =" + id;
using (var cmd = new SqlCommand(sql, connection))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
returnval.BuildingID = reader.GetInt32(2);
returnval.FloorName = reader.GetString(3);
returnval.Floorplan = reader.GetString(1);
}
}
return(returnval);
}
}
}