protected void Page_Load(object sender, EventArgs e) { HttpCookie local = Request.Cookies["user_server"]; if (Request.Cookies["user_server"] != null) { TextBox1.Text = local.Values["user_ID"]; Users_DAL user = new Users_DAL(); foreach (var item in user.select_All()) { if (item.Email == local.Values["user_email"]) { Label1.Text = "Hi" + " " + item.First_Name; } } } else { Response.Redirect("/User_Pages/User_Main_Page.aspx"); } if (Page.IsPostBack == false) { Messages_DAL get_message = new Messages_DAL(); var messages = get_message.select_All(); Users_DAL usres = new Users_DAL(); List <Users_DATA> all_users = usres.select_All(); List <Users_DATA> Users_Message_Recipient = new List <Users_DATA>(); foreach (var item in messages) { if (Users_Message_Recipient.All(x => x.ID != item.FK_Users_Message_Recipient && (Convert.ToInt16(local.Values["user_ID"]) == item.FK_Users_Message_Recipient || Convert.ToInt16(local.Values["user_ID"]) == item.FK_Users_Message_sender))) { Users_Message_Recipient.Add(all_users.Single(x => x.ID == item.FK_Users_Message_Recipient)); } } foreach (var item in Users_Message_Recipient) { if (Convert.ToInt16(local.Values["user_ID"]) != item.ID) { ListItem n = new ListItem(); n.Text = item.First_Name; n.Value = item.ID.ToString(); ListBox1.Items.Add(n); } } } }
protected void Button1_Click(object sender, EventArgs e) { HttpCookie local = Request.Cookies["user_server"]; Apartments_DAL apartment = new Apartments_DAL(); Apartments_DATA a = apartment.select_Item(Convert.ToInt16(Request.QueryString["ID"])); Messages_DATA message = new Messages_DATA(); Messages_DAL sent_message = new Messages_DAL(); message.Message = TextBox1.Text; message.The_Time = DateTime.Now; message.FK_Users_Message_Recipient = Convert.ToInt16(local.Values["user_ID"]); message.FK_Users_Message_sender = a.FK_Users; if (message.FK_Users_Message_sender != message.FK_Users_Message_Recipient && message.Message != "") { sent_message.insert(message); } }