public JsonResult ExecuteSql([FromBody] JObject args)
{
CallDb callDb = new CallDb();
string sql = JObject.Parse(args["body"].ToString())["sql"].ToString();
string arg = Json(JObject.Parse(args["body"].ToString())["args"].ToString()).Value.ToString();
string saveBy = JObject.Parse(args["body"].ToString())["saveBy"].ToString();
arg = arg.Replace("\r\n", "").Replace(" ", "");
JObject json = new JObject();
if (arg != "[]" && arg != "{}")
{
json = JObject.Parse(arg);
}
Dictionary <string, object> paramsDic = SettingParams(json);
paramsDic.Add("@P_SAVEBY", saveBy);
string sqlResult = callDb.ExecuteSql(sql, paramsDic);
return(Json(sqlResult));
}
public async Task TestDbValue_RealDB()
{
var obj1 = new CallDb();
string emailResult = obj1.GetEmployeeEmail("Amy");
Assert.AreEqual("Amy.kmail.com", emailResult);
}
public JsonResult CodeDynamic(string args)
{
CallDb callDb = new CallDb();
JObject json = JObject.Parse(args);
Dictionary <string, object> paramsDic = SettingParams(json);
JObject sqlResult = callDb.LoadSqlSingle("pk_atm_sp_code", paramsDic);
return(Json(sqlResult));
}
internal static Call ToDTO(this CallDb callDb)
{
return(new Call
{
Id = callDb.Id,
DestinationNumber = callDb.DestinationNumber,
Duration = callDb.Duration,
ExternalPrice = callDb.ExternalPrice,
LineId = callDb.LineId,
Line = callDb.Line.ToDTO()
});
}
// public JsonResult CodeDynamic(string args)
public JsonResult CodeDynamic([FromBody] JObject args)
{
CallDb callDb = new CallDb();
string arg = Json(JObject.Parse(args["body"].ToString())["args"].ToString()).Value.ToString();
JObject json = JObject.Parse(arg);
Dictionary <string, object> paramsDic = SettingParams(json);
JObject sqlResult = callDb.LoadSqlSingle("pk_atm_sp_code", paramsDic);
return(Json(sqlResult));
}
private async Task <Result <CallDto> > CreateCall(CallDb model, CancellationToken cancellationToken)
{
await using (_context)
{
_context.Calls.Add(model);
try
{
await _context.SaveChangesAsync(cancellationToken);
return(Result.Success(_mapper.Map <CallDto>(model)));
}
catch (Exception ex) when(ex is DbUpdateException)
{
return(Result.Failure <CallDto>($"Cannot create call. {ex.Message}"));
}
}
}
public JsonResult LoadSqlSingle([FromBody] JObject args)
{
CallDb callDb = new CallDb();
string sql = JObject.Parse(args["body"].ToString())["sql"].ToString();
string arg = Json(JObject.Parse(args["body"].ToString())["args"].ToString()).Value.ToString();
arg = arg.Replace("\r\n", "").Replace(" ", "");
JObject json = new JObject();
if (arg != "[]" && arg != "{}")
{
json = JObject.Parse(arg);
}
Dictionary <string, object> paramsDic = SettingParams(json);
JObject sqlResult = callDb.LoadSqlSingle(sql, paramsDic);
return(Json(sqlResult));
}
