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)); }