public MessageStatus GetCurrentMessageStatusByMessageId(int id) { MessageStatus status = null; using (var proxy = new SqlDataReaderProxy("[dbo].[MessageStatusGetMostRecentByMessageId]", CommandType.StoredProcedure)) { proxy.Parameters.Add(new SqlParameter("@MessageId", id) { DbType = DbType.Int32 }); while (proxy.Read()) { status = new MessageStatus { MessageId = (int)proxy["MessageId"], TypeMessageStatusId = (int)proxy["TypeMessageStatusId"], Description = proxy["MessageStatusText"] as string, AdditionalMessage = proxy["AdditionalMessage"] as string, Exception = JsonSerializer.DeserializeFromString <Exception>(proxy["Exception"] as string), CreateDate = (DateTime)proxy["CreateDate"] }; } } return(status); }
private IEnumerable <TypeMessageStatus> GetAllTypeMessageStatus() { var list = new List <TypeMessageStatus>(); using (var proxy = new SqlDataReaderProxy("[dbo].[MessageReplyToSelectByMessageId]", CommandType.StoredProcedure)) { while (proxy.Read()) { list.Add(new TypeMessageStatus { Id = (int)proxy["Id"], MessageStatusText = proxy["MessageStatusText"] as string }); } } return(list); }
private IEnumerable <string> GetMessageReplyToByMessageId(int id) { var list = new List <string>(); using (var proxy = new SqlDataReaderProxy("[dbo].[MessageReplyToSelectByMessageId]", CommandType.StoredProcedure)) { proxy.Parameters.Add(new SqlParameter("@MessageId", id) { DbType = DbType.Int32 }); while (proxy.Read()) { list.Add(proxy["ReplyTo"] as string); } } return(list); }
public Credential GetCredential(int id) { Credential credential = null; using (var proxy = new SqlDataReaderProxy("[dbo].[CredentialSelectByMessageId]", CommandType.StoredProcedure)) { proxy.Parameters.Add(new SqlParameter("@MessageId", id) { DbType = DbType.Int32 }); while (proxy.Read()) { credential = new Credential { Username = proxy["Username"] as string, Password = proxy["Password"] as string, Domain = proxy["Domain"] as string }; } } return credential; }
public List<Application> GetAllApplications() { var list = new List<Application>(); using (var proxy = new SqlDataReaderProxy("[dbo].[SelectAllApplications]", CommandType.StoredProcedure)) { while (proxy.Read()) { var app = new Application { Id = (int)proxy["Id"], ApplicationName = proxy["ApplicationName"] as string, }; list.Add(app); } } return list; }
public List <Application> GetAllApplications() { var list = new List <Application>(); using (var proxy = new SqlDataReaderProxy("[dbo].[SelectAllApplications]", CommandType.StoredProcedure)) { while (proxy.Read()) { var app = new Application { Id = (int)proxy["Id"], ApplicationName = proxy["ApplicationName"] as string, }; list.Add(app); } } return(list); }
public List <Message> GetMessagesByApplicationId(int id) { var list = new List <Message>(); using (var proxy = new SqlDataReaderProxy("[dbo].[MessageSelectByApplication]", CommandType.StoredProcedure)) { proxy.Parameters.Add(new SqlParameter("@ApplicationId", id) { DbType = DbType.Int32 }); while (proxy.Read()) { var msg = new Message { Id = (int)proxy["Id"], From = proxy["From"] as string, Sender = proxy["Sender"] as string, Subject = proxy["Subject"] as string, Body = proxy["Body"] as string, }; list.Add(msg); } } // Load children foreach (var msg in list) { msg.To = GetMessageToByMessageId(msg.Id); msg.ReplyTo = GetMessageReplyToByMessageId(msg.Id); msg.Cc = GetMessageCcByMessageId(msg.Id); msg.Bcc = GetMessageBccByMessageId(msg.Id); msg.Status = GetCurrentMessageStatusByMessageId(msg.Id); msg.Credential = GetCredential(msg.Id); } return(list); }
public Message GetMessage(int id) { Message msg = null; using (var proxy = new SqlDataReaderProxy("[dbo].[MessageSelectById]", CommandType.StoredProcedure)) { proxy.Parameters.Add(new SqlParameter("@Id", id) { DbType = DbType.Int32 }); while (proxy.Read()) { msg = new Message { Id = (int)proxy["Id"], From = proxy["From"] as string, Sender = proxy["Sender"] as string, Subject = proxy["Subject"] as string, Body = proxy["Body"] as string, To = GetMessageToByMessageId(id), ReplyTo = GetMessageReplyToByMessageId(id), Cc = GetMessageCcByMessageId(id), Bcc = GetMessageBccByMessageId(id), CreateDate = proxy.GetDateTime(proxy.GetOrdinal("CreateDate")), Status = GetCurrentMessageStatusByMessageId(id), Connection = new Connection { EnableSsl = proxy.GetBoolean(proxy.GetOrdinal("EnableSsl")), Host = proxy["Host"] as string, Port = proxy.GetInt32(proxy.GetOrdinal("Port")) }, Credential = GetCredential(id), }; } } return(msg); }
public MessageStatus GetCurrentMessageStatusByMessageId(int id) { MessageStatus status = null; using (var proxy = new SqlDataReaderProxy("[dbo].[MessageStatusGetMostRecentByMessageId]", CommandType.StoredProcedure)) { proxy.Parameters.Add(new SqlParameter("@MessageId", id) { DbType = DbType.Int32 }); while (proxy.Read()) { status = new MessageStatus { MessageId = (int) proxy["MessageId"], TypeMessageStatusId = (int) proxy["TypeMessageStatusId"], Description = proxy["MessageStatusText"] as string, AdditionalMessage = proxy["AdditionalMessage"] as string, Exception = JsonSerializer.DeserializeFromString<Exception>(proxy["Exception"] as string), CreateDate = (DateTime) proxy["CreateDate"] }; } } return status; }
public Credential GetCredential(int id) { Credential credential = null; using (var proxy = new SqlDataReaderProxy("[dbo].[CredentialSelectByMessageId]", CommandType.StoredProcedure)) { proxy.Parameters.Add(new SqlParameter("@MessageId", id) { DbType = DbType.Int32 }); while (proxy.Read()) { credential = new Credential { Username = proxy["Username"] as string, Password = proxy["Password"] as string, Domain = proxy["Domain"] as string }; } } return(credential); }
public Message GetMessage(int id) { Message msg = null; using (var proxy = new SqlDataReaderProxy("[dbo].[MessageSelectById]", CommandType.StoredProcedure)) { proxy.Parameters.Add(new SqlParameter("@Id", id) { DbType = DbType.Int32 }); while (proxy.Read()) { msg = new Message { Id = (int) proxy["Id"], From = proxy["From"] as string, Sender = proxy["Sender"] as string, Subject = proxy["Subject"] as string, Body = proxy["Body"] as string, To = GetMessageToByMessageId(id), ReplyTo = GetMessageReplyToByMessageId(id), Cc = GetMessageCcByMessageId(id), Bcc = GetMessageBccByMessageId(id), CreateDate = proxy.GetDateTime(proxy.GetOrdinal("CreateDate")), Status = GetCurrentMessageStatusByMessageId(id), Connection = new Connection { EnableSsl = proxy.GetBoolean(proxy.GetOrdinal("EnableSsl")), Host = proxy["Host"] as string, Port = proxy.GetInt32(proxy.GetOrdinal("Port")) }, Credential = GetCredential(id), }; } } return msg; }
private IEnumerable<string> GetMessageToByMessageId(int id) { var list = new List<string>(); using (var proxy = new SqlDataReaderProxy("[dbo].[MessageToSelectByMessageId]", CommandType.StoredProcedure)) { proxy.Parameters.Add(new SqlParameter("@MessageId", id) {DbType = DbType.Int32}); while (proxy.Read()) { list.Add(proxy["To"] as string); } } return list; }
private IEnumerable<TypeMessageStatus> GetAllTypeMessageStatus() { var list = new List<TypeMessageStatus>(); using (var proxy = new SqlDataReaderProxy("[dbo].[MessageReplyToSelectByMessageId]", CommandType.StoredProcedure)) { while (proxy.Read()) { list.Add(new TypeMessageStatus { Id = (int)proxy["Id"], MessageStatusText = proxy["MessageStatusText"] as string }); } } return list; }
public List<Message> GetMessagesByApplicationId(int id) { var list = new List<Message>(); using (var proxy = new SqlDataReaderProxy("[dbo].[MessageSelectByApplication]", CommandType.StoredProcedure)) { proxy.Parameters.Add(new SqlParameter("@ApplicationId", id) {DbType = DbType.Int32}); while (proxy.Read()) { var msg = new Message { Id = (int)proxy["Id"], From = proxy["From"] as string, Sender = proxy["Sender"] as string, Subject = proxy["Subject"] as string, Body = proxy["Body"] as string, }; list.Add(msg); } } // Load children foreach (var msg in list) { msg.To = GetMessageToByMessageId(msg.Id); msg.ReplyTo = GetMessageReplyToByMessageId(msg.Id); msg.Cc = GetMessageCcByMessageId(msg.Id); msg.Bcc = GetMessageBccByMessageId(msg.Id); msg.Status = GetCurrentMessageStatusByMessageId(msg.Id); msg.Credential = GetCredential(msg.Id); } return list; }