public int GetAllCompleteTaskCountByDate(string date) { string sql = "SELECT Count(*) as Sajib from Tasks where Task_Date = '" + date + "' and Complete = " + 1; using (SqlDataReader reader = dataAccess.GetData(sql)) { reader.Read(); return((int)reader["Sajib"]); } }
public List <NotificationPopUp> GetAllTodayNotificationTime() { string sql = "SELECT t.Task_ID,t.Notify_Via,Task_Tittle,Task_Description,Notify_Time FROM NotifiyTime n,Tasks t where Notify_Date = '" + DateTime.Now.ToShortDateString() + "' and t.Task_ID = n.Task_ID and t.Task_Repeat_Date = n.Repeat_Task_ID"; List <NotificationPopUp> timeList = new List <NotificationPopUp>(); using (SqlDataReader reader = dataAccess.GetData(sql)) { if (reader.HasRows) { while (reader.Read()) { NotificationPopUp npu = new NotificationPopUp(); npu.Time = reader["Notify_Time"].ToString(); npu.Name = reader["Task_Tittle"].ToString(); npu.Description = reader["Task_Description"].ToString(); npu.Task_ID = (int)reader["Task_ID"]; npu.Notify_Via = (int)reader["Notify_Via"]; timeList.Add(npu); } } return(timeList); } }