/// <summary> /// GetListAlertForLogin /// Calls [usp_selectAll_ToDo_Alert_for_Login] /// </summary> public override List <ToDoDetails> GetListAlertForLogin(System.Int32?loginNo, System.DateTime?now) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_selectAll_ToDo_Alert_for_Login", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@LoginNo", SqlDbType.Int).Value = loginNo; cmd.Parameters.Add("@Now", SqlDbType.DateTime).Value = now; cn.Open(); DbDataReader reader = ExecuteReader(cmd); List <ToDoDetails> lst = new List <ToDoDetails>(); while (reader.Read()) { ToDoDetails obj = new ToDoDetails(); obj.ToDoId = GetReaderValue_Int32(reader, "ToDoId", 0); obj.DueDate = GetReaderValue_NullableDateTime(reader, "DueDate", null); obj.ReminderText = GetReaderValue_String(reader, "ReminderText", ""); lst.Add(obj); obj = null; } return(lst); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get ToDos", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// Get /// Calls [usp_select_ToDo] /// </summary> public override ToDoDetails Get(System.Int32?toDoId) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_ToDo", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@ToDoId", SqlDbType.Int).Value = toDoId; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { //return GetToDoFromReader(reader); ToDoDetails obj = new ToDoDetails(); obj.ToDoId = GetReaderValue_Int32(reader, "ToDoId", 0); obj.LoginNo = GetReaderValue_NullableInt32(reader, "LoginNo", null); obj.Subject = GetReaderValue_String(reader, "Subject", ""); obj.DateAdded = GetReaderValue_NullableDateTime(reader, "DateAdded", null); obj.DueDate = GetReaderValue_NullableDateTime(reader, "DueDate", null); obj.ToDoText = GetReaderValue_String(reader, "ToDoText", ""); obj.Priority = GetReaderValue_NullableInt32(reader, "Priority", null); obj.IsComplete = GetReaderValue_Boolean(reader, "IsComplete", false); obj.ReminderDate = GetReaderValue_NullableDateTime(reader, "ReminderDate", null); obj.ReminderText = GetReaderValue_String(reader, "ReminderText", ""); obj.CompanyNo = GetReaderValue_NullableInt32(reader, "CompanyNo", null); obj.ReminderHasBeenNotified = GetReaderValue_Boolean(reader, "ReminderHasBeenNotified", false); obj.RelatedMailMessageNo = GetReaderValue_NullableInt32(reader, "RelatedMailMessageNo", null); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); obj.LoginName = GetReaderValue_String(reader, "LoginName", ""); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get ToDo", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// GetListForMailMessage /// Calls [usp_selectAll_ToDo_for_MailMessage] /// </summary> public override List <ToDoDetails> GetListForMailMessage(System.Int32?mailMessageNo) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_selectAll_ToDo_for_MailMessage", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@MailMessageNo", SqlDbType.Int).Value = mailMessageNo; cn.Open(); DbDataReader reader = ExecuteReader(cmd); List <ToDoDetails> lst = new List <ToDoDetails>(); while (reader.Read()) { ToDoDetails obj = new ToDoDetails(); obj.ToDoId = GetReaderValue_Int32(reader, "ToDoId", 0); obj.LoginNo = GetReaderValue_NullableInt32(reader, "LoginNo", null); obj.Subject = GetReaderValue_String(reader, "Subject", ""); obj.DateAdded = GetReaderValue_NullableDateTime(reader, "DateAdded", null); obj.DueDate = GetReaderValue_NullableDateTime(reader, "DueDate", null); obj.ToDoText = GetReaderValue_String(reader, "ToDoText", ""); obj.Priority = GetReaderValue_NullableInt32(reader, "Priority", null); obj.IsComplete = GetReaderValue_Boolean(reader, "IsComplete", false); obj.ReminderDate = GetReaderValue_NullableDateTime(reader, "ReminderDate", null); obj.ReminderText = GetReaderValue_String(reader, "ReminderText", ""); obj.CompanyNo = GetReaderValue_NullableInt32(reader, "CompanyNo", null); obj.ReminderHasBeenNotified = GetReaderValue_Boolean(reader, "ReminderHasBeenNotified", false); obj.RelatedMailMessageNo = GetReaderValue_NullableInt32(reader, "RelatedMailMessageNo", null); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); obj.LoginName = GetReaderValue_String(reader, "LoginName", ""); lst.Add(obj); obj = null; } return(lst); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get ToDos", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
private static ToDo PopulateFromDBDetailsObject(ToDoDetails obj) { ToDo objNew = new ToDo(); objNew.ToDoId = obj.ToDoId; objNew.LoginNo = obj.LoginNo; objNew.Subject = obj.Subject; objNew.DateAdded = obj.DateAdded; objNew.DueDate = obj.DueDate; objNew.ToDoText = obj.ToDoText; objNew.Priority = obj.Priority; objNew.IsComplete = obj.IsComplete; objNew.ReminderDate = obj.ReminderDate; objNew.ReminderText = obj.ReminderText; objNew.CompanyNo = obj.CompanyNo; objNew.ReminderHasBeenNotified = obj.ReminderHasBeenNotified; objNew.RelatedMailMessageNo = obj.RelatedMailMessageNo; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; objNew.LoginName = obj.LoginName; return(objNew); }