public DataTable InsertProperty(PropertyBO oPropertyBO, PropertyImageBO oPropertyImageBO, AgentBO oAgentBO)
{
try
{
return oPropertyDAL.InsertProperty(oPropertyBO, oPropertyImageBO, oAgentBO);
}
catch
{
throw;
}
}
public DataTable InsertProperty(PropertyBO oPropertyBO, PropertyImageBO oPropertyImageBO, AgentBO oAgentBO)
{
try
{
cmd = new SqlCommand("InsertProperty", con);
cmd.CommandType = CommandType.StoredProcedure;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Parameters.AddWithValue("@pName", oPropertyBO.name);
cmd.Parameters.AddWithValue("@description", oPropertyBO.description);
cmd.Parameters.AddWithValue("@address", oPropertyBO.address);
cmd.Parameters.AddWithValue("@city", oPropertyBO.city);
cmd.Parameters.AddWithValue("@neighborhood", oPropertyBO.neighborhood);
cmd.Parameters.AddWithValue("@latitude", oPropertyBO.latitude);
cmd.Parameters.AddWithValue("@longitude", oPropertyBO.longitude);
cmd.Parameters.AddWithValue("@zipCode", oPropertyBO.zipCode);
cmd.Parameters.AddWithValue("@type", oPropertyBO.type);
cmd.Parameters.AddWithValue("@buyorrent", oPropertyBO.buyorrent);
cmd.Parameters.AddWithValue("@size", oPropertyBO.size);
cmd.Parameters.AddWithValue("@rate", oPropertyBO.rate);
cmd.Parameters.AddWithValue("@totalImages", oPropertyBO.totalImages);
cmd.Parameters.AddWithValue("@parkings", oPropertyBO.parkings);
cmd.Parameters.AddWithValue("@toilets", oPropertyBO.toilets);
cmd.Parameters.AddWithValue("@kitchens", oPropertyBO.kitchens);
cmd.Parameters.AddWithValue("@hasReception", oPropertyBO.hasReception);
cmd.Parameters.AddWithValue("@isFurnished", oPropertyBO.isFurnished);
cmd.Parameters.AddWithValue("@image", oPropertyImageBO.image);
cmd.Parameters.AddWithValue("@name", oAgentBO.name);
cmd.Parameters.AddWithValue("@business", oAgentBO.business);
cmd.Parameters.AddWithValue("@email", oAgentBO.email);
cmd.Parameters.AddWithValue("@phone", oAgentBO.phone);
cmd.Parameters.AddWithValue("@status", oAgentBO.status);
dad = new SqlDataAdapter(cmd);
dt = new DataTable();
dad.Fill(dt);
return dt;
}
catch
{
throw;
}
finally
{
con.Close();
}
}
