private async Task <ResponseModel> SmsLog(EmailSmsModel sms)
{
List <SqlParameter> sp = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@UserId", ToDBNull(sms.UserId));
sp.Add(param);
param = new SqlParameter("@PriorityTypeId", ToDBNull(sms.PriorityTypeId));
sp.Add(param);
param = new SqlParameter("@GatewayId", ToDBNull(sms.GatewayId));
sp.Add(param);
param = new SqlParameter("@smsFrom", ToDBNull(sms.SmsFrom));
sp.Add(param);
param = new SqlParameter("@PhoneNumber", ToDBNull(sms.PhoneNumber));
sp.Add(param);
param = new SqlParameter("@MessageText", ToDBNull(sms.MessageText));
sp.Add(param);
param = new SqlParameter("@ErrorText", ToDBNull(sms.ErrorText));
sp.Add(param);
param = new SqlParameter("@Status", ToDBNull(sms.Status));
sp.Add(param);
var sql = "SMSSave @UserId,@PriorityTypeId,@GatewayId, @smsFrom,@PhoneNumber,@MessageText,@ErrorText,@Status";
try
{
var res = await _context.Database.SqlQuery <ResponseModel>(sql, sp.ToArray()).SingleOrDefaultAsync();
if (res.ResponseCode == 0)
{
res.IsSuccess = true;
}
else
{
res.IsSuccess = false;
}
return(res);
}
catch (Exception ex)
{
return(new ResponseModel());
}
}
private async Task <ResponseModel> EmailLog(EmailSmsModel email)
{
List <SqlParameter> sp = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@UserId", ToDBNull(email.UserId));
sp.Add(param);
param = new SqlParameter("@PriorityTypeId", ToDBNull(email.PriorityTypeId));
sp.Add(param);
param = new SqlParameter("@GatewayId", ToDBNull(email.GatewayId));
sp.Add(param);
param = new SqlParameter("@EmailFrom", ToDBNull(email.EmailFrom));
sp.Add(param);
param = new SqlParameter("@EmailTo", ToDBNull(email.EmailTo));
sp.Add(param);
param = new SqlParameter("@EmailBCC", ToDBNull(email.EmailBCC));
sp.Add(param);
param = new SqlParameter("@Subject", ToDBNull(email.Subject));
sp.Add(param);
param = new SqlParameter("@Content", ToDBNull(email.Content));
sp.Add(param);
param = new SqlParameter("@errorText", ToDBNull(email.ErrorText));
sp.Add(param);
param = new SqlParameter("@Status", ToDBNull(email.Status));
sp.Add(param);
var sql = "EmailSave @UserId,@PriorityTypeId, @GatewayId,@EmailFrom,@EmailTo,@EmailBCC,@Subject,@Content,@errorText,@Status";
var res = await _context.Database.SqlQuery <ResponseModel>(sql, sp.ToArray()).SingleOrDefaultAsync();
if (res.ResponseCode == 0)
{
res.IsSuccess = true;
}
else
{
res.IsSuccess = false;
}
return(res);
}
