protected void ListView2_SelectedIndexChanged(object sender, EventArgs e)
{
var x = ListView2.Items[ListView2.SelectedIndex];
foreach (Control item in x.Controls)
{
if (item.ID == "IDLabel")
{
Label m = (Label)item;
id = Convert.ToInt16(m.Text);
}
}
HttpCookie local = Request.Cookies["user_server"];
Saved_Apartment_DAL s = new Saved_Apartment_DAL();
Saved_Apartment_DATA saved = new Saved_Apartment_DATA();
saved.ID_User = Convert.ToInt16(local.Values["user_ID"]);
Apartments_DAL apartments = new Apartments_DAL();
saved.Apartment_ID = id;
if (saved.ID_User != apartments.select_Item(id).FK_Users)
{
if (s.select_All().Any(q => q.ID_User == saved.ID_User && q.Apartment_ID == id) == false)
{
s.insert(saved);
}
}
}
public List <Saved_Apartment_DATA> select_All()
{
List <Saved_Apartment_DATA> Saved_Apartments_DATA_list = new List <Saved_Apartment_DATA>();
SqlConnection con = new SqlConnection("Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Select_All_Saved_Apartment", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr;
con.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Saved_Apartment_DATA Saved_Apartments_DATA = new Saved_Apartment_DATA();
Saved_Apartments_DATA.ID = (int)rdr["ID"];
Saved_Apartments_DATA.ID_User = (int)rdr["ID_User"];
Saved_Apartments_DATA.Apartment_ID = (int)rdr["Apartment_ID"];
Saved_Apartments_DATA_list.Add(Saved_Apartments_DATA);
}
con.Close();
return(Saved_Apartments_DATA_list);
}
public void delete(Saved_Apartment_DATA Saved_Apartment)
{
SqlConnection con = new SqlConnection(" Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Delete_Saved_Apartment", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("ID", Saved_Apartment.ID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public List <Apartments_DATA> select_All_saved_Apartments(int ID)
{
List <Saved_Apartment_DATA> Saved_Apartments_DATA_list = new List <Saved_Apartment_DATA>();
SqlConnection con = new SqlConnection("Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Select_All_Saved_Apartment", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr;
con.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Saved_Apartment_DATA Saved_Apartments_DATA = new Saved_Apartment_DATA();
Saved_Apartments_DATA.ID = (int)rdr["ID"];
Saved_Apartments_DATA.ID_User = (int)rdr["ID_User"];
Saved_Apartments_DATA.Apartment_ID = (int)rdr["Apartment_ID"];
Saved_Apartments_DATA_list.Add(Saved_Apartments_DATA);
}
con.Close();
Apartments_DAL select_apartment = new Apartments_DAL();
Apartments_DATA apartment = new Apartments_DATA();
List <Apartments_DATA> list = select_apartment.select_All();
List <Apartments_DATA> returned_list = new List <Apartments_DATA>();
if (Saved_Apartments_DATA_list.Count != 0)
{
foreach (var item in Saved_Apartments_DATA_list)
{
if (item.ID_User == ID)
{
var m = list.Where(x => item.Apartment_ID == x.ID && x.FK_Users != ID).ToList();
foreach (var it in m)
{
returned_list.Add(it);
}
}
}
}
return(returned_list);
}
