public void Edit(SummaryChart objectToEdit)
{
_summaryChartPresenter.Edit(objectToEdit);
UpdateCaption();
updateChartVisibility();
_view.Display();
}
public static string GetSummary(string listid, string type)
{
SummaryChart sc = new SummaryChart();
List <SummaryItem> rawitems = new List <SummaryItem>();
List <SummaryItem> rtnitems = new List <SummaryItem>();
Framework.Utilities.DataIO dataio = new Framework.Utilities.DataIO();
try
{
string connstr = dataio.GetConnectionString();
SqlConnection dbconnection = new SqlConnection(connstr);
dbconnection.Open();
SqlCommand dbcommand = new SqlCommand();
dbcommand.CommandType = CommandType.Text;
dbcommand.CommandText = string.Format("exec [Profile.Data].[List.GetSummary] @UserID = {0}", listid);
dbcommand.CommandTimeout = dataio.GetCommandTimeout();
dbcommand.Connection = dbconnection;
using (SqlDataReader dbreader = dbcommand.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dbreader.Read())
{
rawitems.Add(new SummaryItem {
Variable = dbreader["Variable"].ToString(), Value = dbreader["Value"].ToString().Replace("'", "\\'"), n = Convert.ToInt32(dbreader["n"]), color = ""
});
}
if (!dbreader.IsClosed)
{
dbreader.Close();
}
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
rtnitems = rawitems.FindAll(o => o.Variable.ToLower() == type.ToLower()).ToList();
sc.cols = "{\"cols\": [{\"id\":\"\",\"label\": \"" + type + "\",\"pattern\":\"\",\"type\":\"string\"},{\"id\":\"\",\"label\":\"Count\",\"pattern\":\"\",\"type\":\"number\"}],";
sc.rows = "\"rows\":[";
foreach (SummaryItem si in rtnitems)
{
sc.rows += "{ \"c\":[{\"v\":\"" + si.Value + "\"},{\"v\":" + si.n.ToString() + "}]},";
}
sc.rows = sc.rows.Substring(0, sc.rows.Length - 1);
sc.colors = "],\"colors\":\"[#4E79A7,#F28E2B,#E15759,#76B7B2,#59A14F,#EDC948,#B07AA1,#FF9DA7,#9C755F,#BAB0AC]\"}";
return(sc.cols + sc.rows + sc.colors);
}
public static List <SummaryItem> GetSummaryRaw(string listid, string type)
{
SummaryChart sc = new SummaryChart();
List <SummaryItem> rawitems = new List <SummaryItem>();
List <SummaryItem> rtnitems = new List <SummaryItem>();
Framework.Utilities.DataIO dataio = new Framework.Utilities.DataIO();
try
{
string connstr = dataio.GetConnectionString();
SqlConnection dbconnection = new SqlConnection(connstr);
dbconnection.Open();
SqlCommand dbcommand = new SqlCommand();
dbcommand.CommandType = CommandType.Text;
dbcommand.CommandText = string.Format("exec [Profile.Data].[List.GetSummary] @UserID = {0}", listid);
dbcommand.CommandTimeout = dataio.GetCommandTimeout();
dbcommand.Connection = dbconnection;
using (SqlDataReader dbreader = dbcommand.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dbreader.Read())
{
rawitems.Add(new SummaryItem {
Variable = dbreader["Variable"].ToString(), Value = dbreader["Value"].ToString().Replace("'", "\\'"), n = Convert.ToInt32(dbreader["n"]), color = ""
});
}
if (!dbreader.IsClosed)
{
dbreader.Close();
}
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
rtnitems = rawitems.FindAll(o => o.Variable.ToLower() == type.ToLower()).ToList();
return(rtnitems);
}
