public List <Rate> rates()
{
var data = new List <Rate>();
try
{
var db = new DB();
var Query = @"select ap.id, ap.images, ap.min_price, ap.type_description, ap.num_beds, r.message_rate,r.rate, ap.free_from, ap.free_to,ap.address, ap.num_baths,ap.num_bedrooms, ap.area,ap.cost_per_person from rate r
Right JOIN apartments ap ON (r.apartment_id = ap.id)";
var cmd = new NpgsqlCommand();
cmd.CommandText = Query;
cmd.Connection = db.npgsqlConnection;
NpgsqlDataReader DataReader;
DataReader = cmd.ExecuteReader();
cmd.Dispose();
if (DataReader.HasRows)
{
while (DataReader.Read())
{
var ap = new Apartments();
ap.id = Convert.ToInt32(DataReader.GetValue(0));
ap.free_from = Convert.ToDateTime(DataReader.GetValue(7));
ap.free_to = Convert.ToDateTime(DataReader.GetValue(8));
ap.address = DataReader.GetValue(9).ToString();
var apartment = new ApartmentsDetails();
var imagestring = "<img src=' " + DataReader.GetValue(1).ToString() + " ' style='height:80px; width:80px'>";
apartment.images = imagestring;
apartment.min_price = Convert.ToSingle(DataReader.GetValue(2));
apartment.type_description = DataReader.GetValue(3).ToString();
apartment.num_beds = Convert.ToInt32(DataReader.GetValue(4));
apartment.num_baths = Convert.ToInt32(DataReader.GetValue(10));
apartment.num_bedrooms = Convert.ToInt32(DataReader.GetValue(11));
apartment.area = Convert.ToInt32(DataReader.GetValue(12));
apartment.cost_per_person = Convert.ToSingle(DataReader.GetValue(13));
apartment.apartment = ap;
var temp = 0;
if (DataReader["rate"] != DBNull.Value)
{
temp = Convert.ToInt32(DataReader.GetValue(6));
}
data.Add(new Rate
{
message_rate = DataReader.GetValue(5).ToString(),
apartment = apartment,
rate = temp
});
}
}
DataReader.Close();
DataReader.Dispose();
db.close();
data = data.OrderByDescending(a => a.apartment.min_price).ToList();
}
catch (Exception ex)
{
}
return(data);
}
public ApartmentsDetails GetApartment(string value)
{
var service = new ApartmentsListService();
var all = new ApartmentsList(service);
apartment = all.GetByID(Convert.ToInt32(value));
return(apartment);
}
public ApartmentsDetails GetInfoApartments(string value)
{
var ap = new ApartmentsListService();
var apartments = new ApartmentsList(ap);
var current_apartment = new ApartmentsDetails();
try
{
current_apartment = apartments.GetByID(Convert.ToInt32(value));
}
catch (Exception ex)
{
}
apartment = current_apartment;
return(current_apartment);
}
public IActionResult UpdatePlace([FromBody] string value)
{
try
{
ApartmentsDetails values = JsonConvert.DeserializeObject <ApartmentsDetails>(value);
var db = new DB();
var Query = @"UPDATE apartments SET address = @m_address, reach_place = @m_reach_place, free_from = @m_free_from, free_to = @m_free_to, " +
"max_people = @m_max_people, min_price= @m_min_price, cost_per_person= @m_cost_per_person, description= @m_description, " +
"num_beds= @m_num_beds, num_baths= @m_num_baths, num_bedrooms= @m_num_bedrooms, area= @m_area, " +
"rules= @m_rules, images= @m_images, lonlat= @m_lonlat, type_description= @m_type_description WHERE id = @m_id";
var cmd = new NpgsqlCommand();
cmd.CommandText = Query;
cmd.Parameters.AddWithValue("@m_id", values.apartment.id);
cmd.Parameters.AddWithValue("@m_address", values.apartment.address);
cmd.Parameters.AddWithValue("@m_reach_place", values.reach_place);
cmd.Parameters.AddWithValue("@m_free_from", values.apartment.free_from);
cmd.Parameters.AddWithValue("@m_free_to", values.apartment.free_to);
cmd.Parameters.AddWithValue("@m_max_people", values.max_people);
cmd.Parameters.AddWithValue("@m_min_price", values.min_price);
cmd.Parameters.AddWithValue("m_cost_per_person", values.cost_per_person);
cmd.Parameters.AddWithValue("@m_description", values.description);
cmd.Parameters.AddWithValue("@m_num_beds", values.num_beds);
cmd.Parameters.AddWithValue("@m_num_baths", values.num_baths);
cmd.Parameters.AddWithValue("@m_num_bedrooms", values.num_bedrooms);
cmd.Parameters.AddWithValue("@m_area", values.area);
cmd.Parameters.AddWithValue("@m_rules", values.rules);
cmd.Parameters.AddWithValue("@m_images", values.images);
cmd.Parameters.AddWithValue("@m_lonlat", values.lonlat);
cmd.Parameters.AddWithValue("@m_type_description", values.type_description);
cmd.Connection = db.npgsqlConnection;
cmd.ExecuteNonQuery();
db.close();
}
catch (Exception ex)
{
}
return(Ok());
}
public IActionResult InsertApartment([FromBody] string value)
{
try
{
ApartmentsDetails values = JsonConvert.DeserializeObject <ApartmentsDetails>(value);
var db = new DB();
var Query = @"INSERT INTO apartments (user_id, address, reach_place, free_from, free_to, max_people,min_price, cost_per_person,description,num_beds,num_baths,num_bedrooms,area,rules,images,lonlat, type_description)
VALUES (@m_user_id, @m_address, @m_reach_place, @m_free_from, @m_free_to, @m_max_people,@m_min_price, @m_cost_per_person,@m_description,@m_num_beds,@m_num_baths,@m_num_bedrooms,@m_area,@m_rules,@m_images,@m_lonlat,@m_type_description)";
var cmd = new NpgsqlCommand();
cmd.CommandText = Query;
cmd.Parameters.AddWithValue("@m_user_id", values.user_id);
cmd.Parameters.AddWithValue("@m_address", values.apartment.address);
cmd.Parameters.AddWithValue("@m_reach_place", values.reach_place);
cmd.Parameters.AddWithValue("@m_free_from", values.apartment.free_from);
cmd.Parameters.AddWithValue("@m_free_to", values.apartment.free_to);
cmd.Parameters.AddWithValue("@m_max_people", values.max_people);
cmd.Parameters.AddWithValue("@m_min_price", values.min_price);
cmd.Parameters.AddWithValue("m_cost_per_person", values.cost_per_person);
cmd.Parameters.AddWithValue("@m_description", values.description);
cmd.Parameters.AddWithValue("@m_num_beds", values.num_beds);
cmd.Parameters.AddWithValue("@m_num_baths", values.num_baths);
cmd.Parameters.AddWithValue("@m_num_bedrooms", values.num_bedrooms);
cmd.Parameters.AddWithValue("@m_area", values.area);
cmd.Parameters.AddWithValue("@m_rules", values.rules);
cmd.Parameters.AddWithValue("@m_images", values.images);
cmd.Parameters.AddWithValue("@m_lonlat", values.lonlat);
cmd.Parameters.AddWithValue("@m_type_description", values.type_description);
cmd.Connection = db.npgsqlConnection;
cmd.ExecuteNonQuery();
db.close();
}
catch (Exception Ex)
{
}
return(View("/Views/Apartments.cshtml"));
}
