public Recipient GetRecipient(Guid id)
{
SqlService sql = new SqlService(_sqlConnection);
sql.AddParameter("@pId", System.Data.SqlDbType.UniqueIdentifier, id);
Recipient r = new Recipient();
using (SqlDataReader reader = sql.ExecuteSPReader("ICMS_spGetSMSRecipient"))
{
if (reader.HasRows)
{
while (reader.Read())
{
Int64 mobileOut = 0;
if (Int64.TryParse(reader.SafeGetString(reader.GetOrdinal("MobileNo")), out mobileOut))
{
r.Id = id;
r.FirstName = reader.SafeGetString(reader.GetOrdinal("FirstName"));
r.LastName = reader.SafeGetString(reader.GetOrdinal("LastName"));
r.NickName = reader.SafeGetString(reader.GetOrdinal("NickName"));
r.MobileNo = mobileOut;
r.GroupName = reader.SafeGetString(reader.GetOrdinal("GroupName"));
r.GroupId = reader.SafeGetGuid(reader.GetOrdinal("GroupId")).Value;
}
}
}
}
return r;
}
private void CreateUpdateRecipient(Recipient recipient)
{
// @pId as uniqueidentifier = null,
//@pFirstName as nvarchar(50) = null,
//@pLastName as nvarchar(50) = null,
//@pNickName as nvarchar(50),
//@pMobileNo as nvarchar(50),
//@pGroupName as varchar(50)
SqlService sql = new SqlService(_sqlConnection);
if (recipient.Id != null)
sql.AddParameter("@pId", System.Data.SqlDbType.UniqueIdentifier, recipient.Id);
sql.AddParameter("@pGroupId", System.Data.SqlDbType.UniqueIdentifier, recipient.GroupId);
sql.AddParameter("@pFirstName", System.Data.SqlDbType.VarChar, recipient.FirstName);
sql.AddParameter("@pLastName", System.Data.SqlDbType.VarChar, recipient.LastName);
sql.AddParameter("@pNickName", System.Data.SqlDbType.VarChar, recipient.NickName);
sql.AddParameter("@pMobileNo", System.Data.SqlDbType.VarChar, recipient.MobileNo);
sql.ExecuteSP("ICMS_spCreateUpdateSMSRecipient");
}
public void CreateRecipient(Recipient recipient)
{
CreateUpdateRecipient(recipient);
}
public string SendMessage(Message message, Recipient recipient, string smsUrl)
{
try
{
SendMessage(message.MessageText, recipient.MobileNo.ToString(), smsUrl);
}
catch (Exception ex)
{
return "FAIL send message: " + ex.Message;
}
return "Message sent successfully.";
}
