public void SendMessage(string Messagtxt, DateTime senddate, string Tittle, int UserID)
{
Message mess = new Message();
mess.SendMessage(Messagtxt, senddate, Tittle, UserID);
}
public List<Message> GetMessage(int UserID)
{
trans = new Transaction();
trans.BegindTransactions();
try
{
cmd = new SqlCommand("GetMessage", trans.getcon(), trans.GetTransaction());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserID", UserID));
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.HasRows && rdr.Read())
{
messageList = new List<Message>();
Message A = new Message(
rdr["Message"].ToString(),
DateTime.Parse(rdr["sendDate"].ToString()),
rdr["Tittle"].ToString(),
new Costumer(rdr["Name"].ToString()));
messageList.Add(A);
}
}
catch (Exception e)
{
trans.RollBack();
throw e;
}
trans.getcon().Close();
return messageList;
}
public List<Message> GetMessage(int UserID)
{
Message mess = new Message();
List<Message> messList = mess.GetMessage(UserID);
return messList;
}
