public Messages_DATA select_Item(int ID)
{
Messages_DATA Messages = new Messages_DATA();
SqlConnection con = new SqlConnection(" Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Select_Item_Messages", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", ID);
SqlDataReader rdr;
con.Open();
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
Messages.FK_Users_Message_Recipient = (int)rdr["FK_Users_Message_Recipient"];
Messages.FK_Users_Message_sender = (int)rdr["FK_Users_Message_sender"];
Messages.ID = (int)rdr["ID"];
Messages.Message = rdr["Message"].ToString();
Messages.The_Time = Convert.ToDateTime(rdr["The_Time"]);
}
con.Close();
return(Messages);
}
public List <Messages_DATA> select_All()
{
List <Messages_DATA> Messages_DATA_list = new List <Messages_DATA>();
SqlConnection con = new SqlConnection(" Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Select_All_Messages", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr;
con.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Messages_DATA Messages = new Messages_DATA();
Messages.FK_Users_Message_Recipient = (int)rdr["FK_Users_Message_Recipient"];
Messages.FK_Users_Message_sender = (int)rdr["FK_Users_Message_sender"];
Messages.ID = (int)rdr["ID"];
Messages.Message = rdr["Messages"].ToString();
Messages.The_Time = Convert.ToDateTime(rdr["The_Time"]);
Messages.First_Name = rdr["First_Name"].ToString();
Messages.Last_Name = rdr["Last_Name"].ToString();
Messages_DATA_list.Add(Messages);
}
con.Close();
return(Messages_DATA_list);
}
public void delete(Messages_DATA Messages)
{
SqlConnection con = new SqlConnection(" Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Delete_Messages", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("ID", Messages.ID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
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);
}
}
public void insert(Messages_DATA Messsages)
{
SqlConnection con = new SqlConnection(" Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Insert_Messages", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("FK_Users_Message_Recipient", Messsages.FK_Users_Message_Recipient);
cmd.Parameters.AddWithValue("FK_Users_Message_sender", Messsages.FK_Users_Message_sender);
cmd.Parameters.AddWithValue("Messages", Messsages.Message);
cmd.Parameters.AddWithValue("The_Time", Messsages.The_Time);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void insert(Messages_DATA message)
{
Messages_DAL insert_messagge = new Messages_DAL();
insert_messagge.insert(message);
}
