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