public List <Dictionary <string, object> > GetSubPageRecords(int subPageId, int recordId, String token) { SelectQueryResult result = Call <SelectQueryResult>(token, platformClient => platformClient.GetSubpageRecords(subPageId, recordId, string.Empty, string.Empty, 0)); return(MPFormatConversion.MPFormatToList(result)); }
private static Dictionary <string, object> MpFormatToDictionary(SelectQueryResult mpObject) { var ret = new Dictionary <string, object>(); foreach (var dataitem in mpObject.Data) { foreach (var mpField in mpObject.Fields) { ret.Add(mpField.Name, dataitem[mpField.Index]); } } return(ret); }
private static List <Dictionary <string, object> > MpFormatToList(SelectQueryResult mpObject) { var list = new List <Dictionary <string, object> >(); foreach (var dataitem in mpObject.Data) { var ret = new Dictionary <string, object>(); foreach (var mpField in mpObject.Fields) { ret.Add(mpField.Name, dataitem[mpField.Index]); } list.Add(ret); } return(list); }
public ICommandResult Select([FromBody] SelectCommand cmd) { try { connectionString = GetConexao(Request.Host.Host); using (SqlConnection db = new SqlConnection(connectionString)) { db.Open(); var retorno = new SelectQueryResult(); if (cmd.Total) { string queryTotal = ""; int z = cmd.Query.ToUpper().IndexOf("ORDER") - cmd.Query.ToUpper().IndexOf("FROM"); if (cmd.Query.ToUpper().Contains("ORDER")) { queryTotal = "SELECT COUNT(*)" + cmd.Query.Substring(cmd.Query.ToUpper().IndexOf(" FROM "), z); } else { queryTotal = "SELECT COUNT(*)" + cmd.Query.Substring(cmd.Query.ToUpper().IndexOf(" FROM ")); } retorno.Total = db.Query <int>(queryTotal).FirstOrDefault(); } retorno.Itens = db.Query(cmd.Query).ToList(); db.Close(); return(new CommandResult(true, "Consulta realizada com sucesso.", new { retorno })); } } catch (System.Exception) { return(new CommandResult(false, "Dados inválidos", new Notification("DataBase", "Erro ao pesquisar na base"))); } }