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);
            }
        }