/// <summary> /// Connects to database and returns message template by message template ID. /// </summary> /// <param name="MessageTemplateID">Message Template ID.</param> /// <param name="PortalID">Portal ID.</param> /// <returns>MessageManagemenetInfo class onject contain message details</returns> public MessageManagementInfo GetMessageTemplate(int MessageTemplateID, int PortalID) { SqlDataReader reader = null; try { SQLHandler SQLH = new SQLHandler(); List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@MessageTemplateID", MessageTemplateID)); ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID)); reader = SQLH.ExecuteAsDataReader("[dbo].[sp_GetMessageTemplate]", ParamCollInput); MessageManagementInfo objList = new MessageManagementInfo(); while (reader.Read()) { objList.Subject = reader["Subject"].ToString(); objList.Body = reader["Body"].ToString(); objList.MailFrom = reader["MailFrom"].ToString(); objList.IsActive = bool.Parse(reader["IsActive"].ToString()); objList.MessageTemplateTypeID = int.Parse(reader["MessageTemplateTypeID"].ToString()); } return(objList); } catch (Exception ex) { throw ex; } finally { if (reader != null) { reader.Close(); } } }
/// <summary> /// Connects to database and returns activation code /// </summary> /// <param name="Username">User's name</param> /// <param name="PortalID">Portal ID</param> /// <returns>Activation code</returns> public MessageManagementInfo GetUserActivationCode(string Username, int PortalID) { SqlDataReader reader = null; try { string sp = "[dbo].[sp_GetUserActivationCode]"; SQLHandler SQLH = new SQLHandler(); List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@UserName", Username)); ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID)); reader = SQLH.ExecuteAsDataReader(sp, ParamCollInput); MessageManagementInfo objInfo = new MessageManagementInfo(); while (reader.Read()) { objInfo.UserId = new Guid(reader["UserId"].ToString()); } return(objInfo); } catch (Exception) { throw; } finally { if (reader != null) { reader.Close(); } } }
/// <summary> /// Connects to database and returns user's first name. /// </summary> /// <param name="Username">User's name.</param> /// <param name="PortalID">Portal ID.</param> /// <returns>User's first name.</returns> public MessageManagementInfo GetUserDetailsByUserName(string Username, int PortalID) { SqlDataReader reader = null; try { string sp = "[dbo].[usp_getUserDetaisByuserName]"; SQLHandler SQLH = new SQLHandler(); List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@UserName", Username)); ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID)); MessageManagementInfo objInfo = SQLH.ExecuteAsObject <MessageManagementInfo>(sp, ParamCollInput); return(objInfo); } catch (Exception) { throw; } finally { if (reader != null) { reader.Close(); } } }
public MessageManagementInfo GetUserActivationCode(string Username, int PortalID) { SqlDataReader reader = null; try { string sp = "[dbo].[sp_GetUserActivationCode]"; SQLHandler SQLH = new SQLHandler(); List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>(); ParamCollInput.Add(new KeyValuePair<string, object>("@UserName", Username)); ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); reader = SQLH.ExecuteAsDataReader(sp, ParamCollInput); MessageManagementInfo objInfo = new MessageManagementInfo(); while (reader.Read()) { objInfo.UserId = new Guid(reader["UserId"].ToString()); } return objInfo; } catch (Exception) { throw; } finally { if (reader != null) { reader.Close(); } } }
public MessageManagementInfo GetMessageTemplate(int MessageTemplateID, int PortalID) { SqlDataReader reader = null; try { SQLHandler SQLH = new SQLHandler(); List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>(); ParamCollInput.Add(new KeyValuePair<string, object>("@MessageTemplateID", MessageTemplateID)); ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); reader = SQLH.ExecuteAsDataReader("[dbo].[sp_GetMessageTemplate]", ParamCollInput); MessageManagementInfo objList = new MessageManagementInfo(); while (reader.Read()) { objList.Subject = reader["Subject"].ToString(); objList.Body = reader["Body"].ToString(); objList.MailFrom = reader["MailFrom"].ToString(); objList.IsActive = bool.Parse(reader["IsActive"].ToString()); objList.MessageTemplateTypeID = int.Parse(reader["MessageTemplateTypeID"].ToString()); } return objList; } catch (Exception ex) { throw ex; } finally { if (reader != null) { reader.Close(); } } }