public void DelDispatch(SendSmsDto model)
{
using (IDbConnection conn = SqlConn.OpenConnectionPS())
{
string sql = @"update OrdDispatch set state=2 where ConstId=@ConstId and RoleId=@RoleId";
var result = conn.Execute(sql, new { ConstId = model.ConstId, RoleId = model.RoleId }, commandType: CommandType.Text);
}
}
public async Task <IActionResult> PostAsync(SendSmsDto dto)
{
var result = await _eventsManager.InsertEventAsync(dto);
if (result == Guid.Empty)
{
return(BadRequest("Invalid phone number."));
}
return(Ok(result));
}
private void timer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
IDispatchInterface bll = new DispatchService();
SmsMessage c = new SmsMessage();
List <OrdDispatchDto> list = bll.GetDispatch();
//var ls = t.GroupBy(a => new { a.Sort }).Select(g => new TempList() { Sort = g.Key.Sort, Days = g.Max(item => item.Days) }).ToList();
List <GroupDispatchDto> newlist = list.GroupBy(p => new { p.ConstId, p.Phone }).Select(g => new GroupDispatchDto()
{
ConstId = g.Key.ConstId, Phone = g.Key.Phone
}).ToList();
List <SendSmsDto> sendList = new List <SendSmsDto>();
foreach (var item in newlist)
{
var temp = list.Where(p => p.ConstId == item.ConstId).ToList();
if (temp[0].CreateTime.AddHours(24) < DateTime.Now)
{
SendSmsDto senddto = new SendSmsDto();
senddto.ConstId = item.ConstId;
senddto.Phone = item.Phone;
string roleNames = "";
foreach (var model in temp)
{
roleNames += RoleConvert.GetRoleName(model.RoleId) + ",";
senddto.ConstName = model.Name;
senddto.RoleId = model.RoleId;
bll.DelDispatch(senddto);
}
senddto.RolesName = roleNames.Length > 0 ? roleNames.Substring(0, roleNames.Length - 1) : "";
sendList.Add(senddto);
}
}
//发送
string content = System.Configuration.ConfigurationSettings.AppSettings["content"];
foreach (var temp in sendList)
{
string message = string.Format(content, temp.ConstName, temp.RolesName);
var smsState = c.SendMessages(temp.Phone, message);
}
}
/// <inheritdoc />
public async Task <Guid> SendSmsAsync(SendSmsDto dto)
{
var accountSid = _configuration["Twilio:AccountSid"];
var authToken = _configuration["Twilio:AuthToken"];
TwilioClient.Init(accountSid, authToken);
var phoneNumber = new PhoneNumber(dto.PhoneNumber);
if (!await TwilioHelper.VerifyPhoneNumberAsync(phoneNumber))
{
// TODO Use ReturnResult class
return(new Guid());
}
var messageOptions = new CreateMessageOptions(phoneNumber);
messageOptions.From = new PhoneNumber("+12073863924"); // TODO Store in config after setting up twilio account
messageOptions.Body = dto.Message;
MessageResource.Create(messageOptions);
return(Guid.NewGuid());
}
public void SendSms(SendSmsDto dto)
{
// Sms implementation
}
/// <inheritdoc />
public async Task <Guid> InsertEventAsync(SendSmsDto dto)
{
return(await _smsService.SendSmsAsync(dto));
}
