private async Task SendBirthdaySMS()
{
var response = _birthdayService.GetCustomers();
if (response.Item2.Count() > 0)
{
foreach (var item in response.Item2)
{
string mobNo = item.MobileNumber, message = response.Item1;
var smsResp = await _smsService.SendSMS(mobNo, message);
SmsLogViewModel smsModel = new SmsLogViewModel()
{
MobileNumber = mobNo,
Message = message,
ResponseCode = smsResp,
Remarks = "Birthday Sms"
};
_birthdayService.InsertSmsDataLogs(smsModel);
Console.WriteLine($"\n SMS to {item.MobileNumber}. Status: {smsResp}");
}
Console.WriteLine("****************************");
Console.WriteLine("Completed. Number of customer found: " + response.Item2.Count());
}
}
public void InsertSmsDataLogs(SmsLogViewModel model)
{
try
{
using (SqlConnection con = new SqlConnection(LogDbConn))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "InsertSmsLogs";
cmd.Parameters.AddWithValue("mobileNumber", model.MobileNumber);
cmd.Parameters.AddWithValue("customerId", model.CustomerId);
cmd.Parameters.AddWithValue("message", model.Message);
cmd.Parameters.AddWithValue("messageType", model.MessageType);
cmd.Parameters.AddWithValue("transactionId", model.TransactionId);
cmd.Parameters.AddWithValue("responseCode", model.ResponseCode);
cmd.Parameters.AddWithValue("responseMessage", model.ResponseMessage);
cmd.Parameters.AddWithValue("remarks", model.Remarks);
cmd.Parameters.AddWithValue("lastUpdatedById", model.LastUpdatedById);
cmd.Parameters.AddWithValue("flag", model.Flag);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
catch (Exception ex)
{
}
}
