public DataTable GetPagedSmses(Common.Sms sms, Guid smsSenderAgentGuid, string userName, string senderNumber, string fromEffectiveDate, string fromTime, string toEffectiveDate, string toTime, int pageNo, int pageSize, string sortField, ref int resultCount)
{
DataSet dataSetSms = base.FetchSPDataSet("GetPagedSmses", "@UserGuid", sms.UserGuid,
"@UserName", userName,
"@SmsSenderAgentGuid", smsSenderAgentGuid,
"@SenderNumber", senderNumber,
"@RecieverNumber", sms.Reciever,
"@FromEffectiveDate", fromEffectiveDate,
"@FromTime", fromTime,
"@ToEffectiveDate", toEffectiveDate,
"@ToTime", toTime,
"@SmsBody", sms.SmsBody,
"@DeliveryStatus", sms.DeliveryStatus,
"@SmsCount", sms.SmsCount,
"@PageNo", pageNo,
"@PageSize", pageSize,
"@SortField", sortField);
resultCount = Helper.GetInt(dataSetSms.Tables[0].Rows[0]["RowCount"]);
return(dataSetSms.Tables[1]);
}
public object UpdateFailedSms(Common.Sms sms)
{
return(FetchSPDataTable("UpdateFailedSms", "@Guid", sms.SmsGuid,
"@DeliveryStatus", sms.DeliveryStatus,
"@OuterMessageID", sms.OuterSystemSmsID));
}