public async Task <ActionResult <SmsTemplate_SmsTemplateDTO> > Create([FromBody] SmsTemplate_SmsTemplateDTO SmsTemplate_SmsTemplateDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
if (!await HasPermission(SmsTemplate_SmsTemplateDTO.Id))
{
return(Forbid());
}
SmsTemplate SmsTemplate = ConvertDTOToEntity(SmsTemplate_SmsTemplateDTO);
SmsTemplate = await SmsTemplateService.Create(SmsTemplate);
SmsTemplate_SmsTemplateDTO = new SmsTemplate_SmsTemplateDTO(SmsTemplate);
if (SmsTemplate.IsValidated)
{
return(SmsTemplate_SmsTemplateDTO);
}
else
{
return(BadRequest(SmsTemplate_SmsTemplateDTO));
}
}
public ActionResult InsOrUpd_Server(SmsTemplate info)
{
CommonResult result = new CommonResult();
var endcode = Session["EndCode"].ToString() ?? "0";
info.IntEndCode = endcode.ToIntOrZero();
try
{
ServiceDbClient DbServer = new ServiceDbClient();
var flag = DbServer.SMS_Template_InsOrUpd(info);
info.DtLstUpd = DateTime.Now;
if (flag == "0")
{
result.IsSuccess = true;
}
else
{
result.ErrorMsg = flag;
}
}
catch (Exception ex)
{
result.ErrorMsg = ex.Message;
}
return(ToJsonContent(result));
}
private void BindSmsTemplate()
{
htmlAppend += "<div id=\"myDataForSmsTemplate\" style=\"display:none;\">";
SmsTemplate bll = new SmsTemplate();
var list = bll.GetList(pageIndex, pageSize, out totalRecords, "");
if (list != null && list.Count > 0)
{
string itemAppend = "";
foreach (var model in list)
{
string templateType = "";
if (model.TemplateType == "auto")
{
templateType = "自动";
}
else if (model.TemplateType == "custom")
{
templateType = "自定义";
}
itemAppend += "{\"Id\":\"" + model.Id + "\",\"Title\":\"" + model.Title + "\",\"TemplateType\":\"" + templateType + "\",\"IsDefault\":\"" + model.IsDefault + "\",}";
}
itemAppend = itemAppend.Trim(',');
itemAppend = "{\"total\":" + totalRecords + ",\"rows\":[" + itemAppend + "]}";
htmlAppend += itemAppend;
}
htmlAppend += "</div>";
}
public IActionResult StartProcessing(int id)
{
OrderHeader orderHeader = _unitofwork.OrderHeader.GetFirstOrDefault(u => u.Id == id);
orderHeader.OrderStatus = SD.StatusInProcess;
_unitofwork.Save();
//code sms in processing
SmsTemplate smsTemplate = _db.SmsTemplates.Where(e => e.Id == Convert.ToInt32(EnSmsTemplate.OrderInProcessing)).FirstOrDefault();
smsTemplate.Content = smsTemplate.Content.Replace("###Name###", orderHeader.Name);
TwilioClient.Init(_twilioOptions.AccountSid, _twilioOptions.AuthToken);
try
{
var message = MessageResource.Create(
from: new Twilio.Types.PhoneNumber(_twilioOptions.PhoneNumber),
to: new Twilio.Types.PhoneNumber(orderHeader.PhoneNumber),
body: smsTemplate.Content + orderHeader.Id);
}
catch (Exception x)
{
}
return(RedirectToAction("Index"));
}
public SmsTemplateModel GetSmsTemplate(SmsTemplate sms)
{
if (sms != null)
{
this.SenderId = sms.SenderId;
this.Phone = sms.Phone;
this.Message = sms.Message;
this.CreateDate = sms.CreateDate;
this.Result = sms.Result;
this.StatusId = sms.StatusId;
this.Statuses = ReferencesProvider.GetReferences(Constants.ClientVisitStatusRef, null, true);
}
else
{
this.SenderId = "";
this.Phone = "";
this.Message = "";
this.CreateDate = null;
this.Result = "";
this.StatusId = 9;
this.Statuses = ReferencesProvider.GetReferences(Constants.ClientVisitStatusRef, null, true);
}
return(this);
}
public async Task <bool> Create(SmsTemplate SmsTemplate)
{
await ValidateCode(SmsTemplate);
await ValidateName(SmsTemplate);
return(SmsTemplate.IsValidated);
}
public async Task <SmsTemplate> Get(long Id)
{
SmsTemplate SmsTemplate = await DataContext.SmsTemplate.AsNoTracking()
.Where(x => x.Id == Id).Select(x => new SmsTemplate()
{
CreatedAt = x.CreatedAt,
UpdatedAt = x.UpdatedAt,
Id = x.Id,
Code = x.Code,
Name = x.Name,
Content = x.Content,
StatusId = x.StatusId,
Status = x.Status == null ? null : new Status
{
Id = x.Status.Id,
Code = x.Status.Code,
Name = x.Status.Name,
},
}).FirstOrDefaultAsync();
if (SmsTemplate == null)
{
return(null);
}
return(SmsTemplate);
}
public string SetDefaultSmgTemplate(object Id)
{
try
{
if (Id == null)
{
return(MessageContent.Request_InvalidArgument);
}
Guid gId = Guid.Empty;
if (!Guid.TryParse(Id.ToString(), out gId))
{
return(MessageContent.Request_InvalidArgument);
}
SmsTemplate smstBll = new SmsTemplate();
using (TransactionScope scope = new TransactionScope())
{
smstBll.SetDefault(gId);
scope.Complete();
}
return("1");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public SmsTemplate SetSmsTemplate()
{
SmsTemplate sms = new SmsTemplate();
sms.SenderId = this.SenderId.Trim();
sms.Message = this.Message;
sms.CreateDate = DateTime.Now;
sms.Result = this.Result;
sms.StatusId = this.StatusId;
if (string.IsNullOrEmpty(this.Phone))
{
sms.Phone = this.Phone;
}
else
{
string str = this.Phone;
string[] trimChars = { "-", "(", ")" };
str = "8" + str.Trim();
foreach (var ch in trimChars)
{
str = str.Replace(ch, "");
}
sms.Phone = str;
}
return(sms);
}
public ActionResult TemplateList_Server()
{
var Status = Request["WHC_IntStatus"] ?? "-1";
var id = Request["WHC_IntID"] ?? "0";
var SmsTemplate_info = new SmsTemplate
{
NvcName = Request["WHC_TempName"] ?? "",
IntID = id == "" ? 0 : Convert.ToInt32(id),
IntStatus = Status == "" ? 0 : Convert.ToInt32(Status)
};
ServiceDbClient DbServer = new ServiceDbClient();
var dts = DbServer.SMS_Template_Qry(endcode, SmsTemplate_info);
int rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int page = Request["page"] == null ? 1 : int.Parse(Request["page"]);
DataTable dat = new DataTable();
//复制源的架构和约束
dat = dts.Clone();
// 清除目标的所有数据
dat.Clear();
//对数据进行分页
for (int i = (page - 1) * rows; i < page * rows && i < dts.Rows.Count; i++)
{
dat.ImportRow(dts.Rows[i]);
}
//最重要的是在后台取数据放在json中要添加个参数total来存放数据的总行数，如果没有这个参数则不能分页
int total = dts.Rows.Count;
var result = new { total, rows = dat };
return(ToJsonContentDate(result));
}
public ActionResult SendTestSms(SmsTemplateModel model)
{
SmsTemplate smsTemplate = smsBusinessLogic.SmsTemplate_Get();
smsTemplate.Phone = model.Phone;
model.GetSmsTemplate(smsTemplate);
smsTemplate = model.SetSmsTemplate();
SMSMessage smsMessage = new SMSMessage()
{
Id = 1,//в тестовой отправке смс ID не критично
SenderId = smsTemplate.SenderId,
Phone = smsTemplate.Phone,
Message = smsTemplate.Message
};
if (!string.IsNullOrEmpty(smsMessage.Phone))
{
model.Result = SmsSender.SmsSender.SendOneSms(smsMessage);
if (string.IsNullOrEmpty(model.Result))
{
model.Result = "Смс успешно отправлено.";
}
}
else
{
model.Result = "Введите номер телефона!";
}
return(View("Index", model));
}
public async Task <bool> Delete(SmsTemplate SmsTemplate)
{
if (await ValidateId(SmsTemplate))
{
}
return(SmsTemplate.IsValidated);
}
public string PreviewTemplate(SmsTemplateInfo model)
{
try
{
model.TemplateType = model.TemplateType.Trim();
model.SmsContent = model.SmsContent.Trim();
model.OrderCode = model.OrderCode.Trim();
model.ParamsCode = model.ParamsCode.Trim();
model.ParamsCode = model.ParamsCode.Trim();
if (model.TemplateType == "auto")
{
if (model.OrderCode == "")
{
return("订单号不能为空字符串，自动模板类型必须有订单号才能预览");
}
}
SmsTemplate smstBll = new SmsTemplate();
return(smstBll.GetTemplateContent(model.OrderCode, model));
}
catch (Exception ex)
{
return("异常：" + ex.Message + "");
}
}
public IActionResult ShipOrder()
{
OrderHeader orderHeader = _unitofwork.OrderHeader.GetFirstOrDefault(u => u.Id == OrderVM.OrderHeader.Id);
orderHeader.TrackingNumber = OrderVM.OrderHeader.TrackingNumber;
orderHeader.Carrier = OrderVM.OrderHeader.Carrier;
orderHeader.OrderStatus = SD.StatusShipped;
orderHeader.ShippingDate = DateTime.Now;
_unitofwork.Save();
//code SMS for ShipOrder
SmsTemplate smsTemplate = _db.SmsTemplates.Where(e => e.Id == Convert.ToInt32(EnSmsTemplate.ShipOrder)).FirstOrDefault();
smsTemplate.Content = smsTemplate.Content.Replace("###Name###", orderHeader.Name);
TwilioClient.Init(_twilioOptions.AccountSid, _twilioOptions.AuthToken);
try
{
var message = MessageResource.Create(
from: new Twilio.Types.PhoneNumber(_twilioOptions.PhoneNumber),
to: new Twilio.Types.PhoneNumber(orderHeader.PhoneNumber),
body: smsTemplate.Content + orderHeader.Id);
}
catch (Exception x)
{
}
return(RedirectToAction("Index"));
}
public async Task CreateDefaultTemplatesAsync()
{
var templateEntities = (await _templateWriter.GetAsync())?.ToArray();
var templateIds = Enum.GetValues(typeof(TemplateEnum)).Cast <TemplateEnum>();
foreach (var templateId in templateIds)
{
var template = templateEntities?.FirstOrDefault(e => e.Template.Id == templateId)?.Template;
if (template == null)
{
template = new SmsTemplate
{
Id = templateId,
DefaultLang = _defaultLang,
DefaultBrand = _defaultBrand,
BrandLangBodies = GetTemplateLangBodies(templateId),
Params = GetTemplateBodyParams(templateId)
};
var newTemplateEntity = TemplateMyNoSqlEntity.Create(template);
await _templateWriter.InsertAsync(newTemplateEntity);
_logger.LogInformation("Template (ID: {templateId}) doesn't exist, creating the new one.", templateId);
}
}
}
public string GetJsonBySmgTemplate(int pageIndex, int pageSize, string title)
{
string json = "";
if (pageIndex < 1)
{
pageIndex = 1;
}
if (pageSize < 1)
{
pageSize = 10;
}
int totalRecords = 0;
string sqlWhere = "";
try
{
ParamsHelper parms = new ParamsHelper();
if (!string.IsNullOrWhiteSpace(title))
{
sqlWhere += "and Title like @Title ";
SqlParameter parm = new SqlParameter("@Title", SqlDbType.NVarChar, 50);
parm.Value = "%" + title + "%";
parms.Add(parm);
}
SmsTemplate bll = new SmsTemplate();
var list = bll.GetList(pageIndex, pageSize, out totalRecords, sqlWhere, parms.ToArray());
if (list != null && list.Count > 0)
{
string itemAppend = "";
foreach (var model in list)
{
string isAutoText = "";
if (model.TemplateType == "auto")
{
isAutoText = "自动";
}
else if (model.TemplateType == "custom")
{
isAutoText = "自定义";
}
string isDefaultText = model.IsDefault ? "是" : "否";
itemAppend += "{\"Id\":\"" + model.Id + "\",\"Title\":\"" + model.Title + "\",\"IsAuto\":\"" + isAutoText + "\",\"IsDefault\":\"" + isDefaultText + "\"},";
}
itemAppend = itemAppend.Trim(',');
itemAppend = "{\"total\":" + totalRecords + ",\"rows\":[" + itemAppend + "]}";
json = itemAppend;
}
return(json);
}
catch (Exception ex)
{
return("异常：" + ex.Message);
}
}
public async Task <bool> ValidateName(SmsTemplate SmsTemplate)
{
if (string.IsNullOrWhiteSpace(SmsTemplate.Name))
{
SmsTemplate.AddError(nameof(SmsTemplateValidator), nameof(SmsTemplate.Name), ErrorCode.NameEmpty);
}
return(SmsTemplate.IsValidated);
}
public ActionResult Index()
{
SmsTemplate sms = smsBusinessLogic.SmsTemplate_Get();
SmsTemplateModel model = new SmsTemplateModel();
model.GetSmsTemplate(sms);
return(View(model));
}
public async Task <bool> Delete(SmsTemplate SmsTemplate)
{
await DataContext.SmsTemplate.Where(x => x.Id == SmsTemplate.Id).UpdateFromQueryAsync(x => new SmsTemplateDAO {
DeletedAt = StaticParams.DateTimeNow
});
return(true);
}
public static TemplateMyNoSqlEntity Create(SmsTemplate template)
{
return(new TemplateMyNoSqlEntity
{
PartitionKey = GeneratePartitionKey(),
RowKey = GenerateRowKey(template.Id.ToString()),
Template = template
});
}
public async Task <bool> Update(SmsTemplate SmsTemplate)
{
if (await ValidateId(SmsTemplate))
{
await ValidateCode(SmsTemplate);
await ValidateName(SmsTemplate);
}
return(SmsTemplate.IsValidated);
}
public async Task <SmsTemplate> Get(long Id)
{
SmsTemplate SmsTemplate = await UOW.SmsTemplateRepository.Get(Id);
if (SmsTemplate == null)
{
return(null);
}
return(SmsTemplate);
}
public SmsTemplate SmsTemplate_Get()
{
List <SqlParameter> parameters = new List <SqlParameter>();
SqlParameter SenderId = parameters.AddInputOutputParameter("@SenderId", SqlDbType.NVarChar, "sdfds");
SqlParameter Message = parameters.AddInputOutputParameter("@Message", SqlDbType.NVarChar, "fsdf");
SqlParameter StatusId = parameters.AddInputOutputParameter("@StatusId", SqlDbType.BigInt, 9);
SmsTemplate SmsTemplate = Execute_Get(SmsTemplateMaterializer.Instance, "SMSTemplate_Get", parameters);
return(SmsTemplate);
}
public Contact_SmsTemplateDTO(SmsTemplate SmsTemplate)
{
this.Id = SmsTemplate.Id;
this.Code = SmsTemplate.Code;
this.Name = SmsTemplate.Name;
this.Content = SmsTemplate.Content;
this.StatusId = SmsTemplate.StatusId;
this.CreatedAt = SmsTemplate.CreatedAt;
this.UpdatedAt = SmsTemplate.UpdatedAt;
this.Errors = SmsTemplate.Errors;
}
public void SmsTemplate_Set(SmsTemplate smsTemplate)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@SenderId", SqlDbType.NVarChar, smsTemplate.SenderId);
parameters.AddInputParameter("@Message", SqlDbType.NVarChar, smsTemplate.Message);
parameters.AddInputParameter("@Phone", SqlDbType.NVarChar, smsTemplate.Phone);
parameters.AddInputParameter("@CreateDate", SqlDbType.DateTime, DateTime.Now);
parameters.AddInputParameter("@StatusId", SqlDbType.BigInt, smsTemplate.StatusId);
Execute_StoredProcedure("SMSTemplate_Set", parameters);
}
public TicketIssueLevel_SmsTemplateDTO(SmsTemplate SmsTemplate)
{
this.Id = SmsTemplate.Id;
this.Code = SmsTemplate.Code;
this.Name = SmsTemplate.Name;
this.Content = SmsTemplate.Content;
this.StatusId = SmsTemplate.StatusId;
this.Status = SmsTemplate.Status == null ? null : new TicketIssueLevel_StatusDTO(SmsTemplate.Status);
this.CreatedAt = SmsTemplate.CreatedAt;
this.UpdatedAt = SmsTemplate.UpdatedAt;
this.Errors = SmsTemplate.Errors;
}
public IActionResponse <SmsTemplate> Add(SmsTemplate SmsTemplate)
{
_SmsTemplate.Add(SmsTemplate);
var rep = _uow.SaveChanges();
return(new ActionResponse <SmsTemplate>
{
Result = SmsTemplate,
Message = rep.ToSaveChangeMessageResult(BusinessMessage.Success, BusinessMessage.Error),
IsSuccessful = rep.ToSaveChangeResult()
});
}
public async Task WhenISendTheUserNotificationTemplateAPIARequestToUpdateAnExistingSmsNotificationTemplateWithoutAnETag(Table table)
{
IJsonSerializerSettingsProvider serializerSettingsProvider = this.serviceProvider.GetRequiredService <IJsonSerializerSettingsProvider>();
SmsTemplate notificationTemplate = DataSetupSteps.BuildSmsNotificationTemplateFrom(table.Rows[0]);
string? requestJson = JsonConvert.SerializeObject(notificationTemplate, serializerSettingsProvider.Instance);
var requestContent = new StringContent(requestJson, Encoding.UTF8, "application/json");
string transientTenantId = this.featureContext.GetTransientTenantId();
var uri = new Uri(FunctionsApiBindings.ManagementApiBaseUri, $"/{transientTenantId}/marain/usernotifications/templates");
await this.SendRequest(uri, HttpMethod.Put, requestContent, notificationTemplate.ETag).ConfigureAwait(false);
}
public static bool Sms(string name, int type, DataSource ds)
{
try
{
PassportSection section = PassportSection.GetSection();
if (!section.VerifyMobile)
{
throw new Exception();
}
HttpRequest Request = HttpContext.Current.Request;
string captcha = Request.Form["Captcha"];
if (!string.IsNullOrEmpty(captcha))
{
if (!Captcha.CheckCaptcha(Request.Form["CaptchaName"], captcha))
{
throw new Exception();
}
}
long mobile = long.Parse(Request.Form["Mobile"]);
int timespan = SMSCaptchaSection.GetSection().TimeSpan;
MobileHash hash = MobileHash.Create(ds, mobile, type, timespan);
if (hash == null)
{
throw new Exception();
}
string md5 = string.Concat(Request.UserHostAddress, "\r\n", Request.UserAgent).MD5();
StringHash sh = StringHash.Create(ds, md5, StringHash.SmsHash, timespan);
if (sh == null)
{
throw new Exception();
}
SmsTemplate temp = SmsTemplate.GetByName(ds, SmsTemplate.Register);
if (temp.Type == SmsTemplateType.Template)
{
SendTemplateImpl(name, mobile, temp.Content, ds, hash.Hash);
}
else
{
SendImpl(name, mobile, temp.Content, ds, hash.Hash);
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public async Task GivenIHaveCreatedAndStoredASmsNotificationTemplate(Table table)
{
ITenantedNotificationTemplateStoreFactory storeFactory = this.serviceProvider.GetRequiredService <ITenantedNotificationTemplateStoreFactory>();
SmsTemplate notificationTemplate = BuildSmsNotificationTemplateFrom(table.Rows[0]);
INotificationTemplateStore?store = await storeFactory.GetTemplateStoreForTenantAsync(this.featureContext.GetTransientTenant()).ConfigureAwait(false);
await store.CreateOrUpdate(notificationTemplate.NotificationType !, CommunicationType.Sms, notificationTemplate.ETag, notificationTemplate).ConfigureAwait(false);
(SmsTemplate, string?)smsTemplate = await store.GetAsync <SmsTemplate>(notificationTemplate.NotificationType !, CommunicationType.Sms).ConfigureAwait(false);
smsTemplate.Item1.ETag = smsTemplate.Item2;
this.scenarioContext.Set(smsTemplate.Item1);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (!FileUpload1.HasFile)
{
var smsTemplate = new SmsTemplate();
smsTemplate.IsDelete = false;
smsTemplate.SheetId = Convert.ToInt32(ddlSheet.SelectedValue);
smsTemplate.MessageText = txtSms.Text;
smsTemplate.NoOfTimes = Convert.ToInt32(txtNoOfTimes.Text);
smsTemplate.RepeatAfter = Convert.ToInt32(txtRepeatAfter.Text);
smsTemplate.SendingDate = Convert.ToDateTime(txtSendingDate.Text);
_dbScheduler.SmsTemplates.InsertOnSubmit(smsTemplate);
_dbScheduler.SubmitChanges();
SmsTextBinding();
txtSms.Text = "";
txtSendingDate.Text = "";
txtRepeatAfter.Text = "";
txtNoOfTimes.Text = "";
}
else
{
try
{
string fPath = Server.MapPath("ExcelFolder") + "\\" + Session.SessionID + FileUpload1.FileName;
FileUpload1.SaveAs(fPath);
var ds = new DataSet();
var da = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fPath + "; Extended Properties='Excel 8.0;HDR=YES'");
da.Fill(ds);
var smsTemplates = new List<SmsTemplate>();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
try
{
smsTemplates.Add(new SmsTemplate()
{
SendingDate = Convert.ToDateTime(ds.Tables[0].Rows[i][0]),
IsDelete = false,
MessageText = Convert.ToString(ds.Tables[0].Rows[i][4]),
RepeatAfter = Convert.ToInt32(getdays(ds.Tables[0].Rows[i][1].ToString())),
NoOfTimes = Convert.ToInt32(ds.Tables[0].Rows[i][2]),
SheetId = Convert.ToInt32(ddlSheet.SelectedValue)
});
}
catch (Exception ex)
{
Response.Write("<br>Their is some error in row " + (i + 1));
}
}
_dbScheduler.SmsTemplates.InsertAllOnSubmit(smsTemplates);
_dbScheduler.SubmitChanges();
}
else
{
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
partial void InsertSmsTemplate(SmsTemplate instance);
partial void UpdateSmsTemplate(SmsTemplate instance);
partial void DeleteSmsTemplate(SmsTemplate instance);
