public static bool AddNewNotification(string session, int userId, int courseId, Notification toAdd) { try { int result = new DataAccess(ConnectionString).ExecuteNonQuerySP("SP_AddNewNotification", "@SessionID", session, "@UserID", userId, "@CourseID", courseId, "@Subject", toAdd.Subject, "@Content", toAdd.Content); return result > 0; } catch (Exception) { return false; } }
public bool AddNewNotification(string sessionId, int userId, int courseId, Notification noti) { return CMDal.AddNewNotification(sessionId, userId, courseId, noti); }
public static List<Notification> GetUserHistoryAndNotification(string sessionId, int userId, DateTime lastDate) { List<Notification> toReturn = new List<Notification>(); try { DataTable table = new DataAccess(ConnectionString).ExecuteQuerySP("SP_GetUserNotifications", "@SessionID", sessionId, "@UserID", userId, "@LastNTime", lastDate); if (table == null || table.Rows.Count == 0) return toReturn; foreach (DataRow row in table.Rows) { Notification n = new Notification(); n.Subject = ParseCellDataToString(row["Subject"]); n.Content = ParseCellDataToString(row["Content"]); n.Owner = ParseCellDataToString(row["Owner"]); n.CourseName = ParseCellDataToString(row["CourseName"]); n.CreatedTime = ParseCellDataToDateTime(row["Time"]); toReturn.Add(n); } return toReturn; } catch (Exception) { return toReturn; } }