/// <summary> /// Saves the canvas snapshot. /// </summary> /// <param name="cdto">The cdto.</param> public string SaveCanvasSnapshot(CanvasDto cdto) { return(em.SaveCanvasSnapshot(cdto)); // TODO: Implement this method //throw new NotImplementedException(); }
public void SaveCanvas(CanvasDto canvasDto, Action <int, Exception> completed) { _completed = completed; canvasCtx = new CanvasDomainContext(); InvokeOperation <int> canvasResults = canvasCtx.SaveCanvas(canvasDto); canvasResults.Completed += new EventHandler(canvasResults_Completed); }
/// <summary> /// Saves the canvas snapshot. /// </summary> /// <param name="canvasSnapshotAsBase64">The canvas snapshot as base64.</param> /// <param name="completed">The completed.</param> public void SaveCanvasSnapshot(CanvasDto cdto, Action <string, Exception> completed) { _completed2 = completed; canvasCtx = new CanvasDomainContext(); InvokeOperation <string> canvasSnapshotResults = canvasCtx.SaveCanvasSnapshot(cdto); canvasSnapshotResults.Completed += new EventHandler(canvasSnapshotResults_Completed); }
protected void Button1_Click(object sender, EventArgs e) { EntityManager em = new EntityManager(); CanvasDto dto = em.LoadCanvas(Convert.ToInt32(TextBox1.Text)); TextArea1.InnerText = ""; TextArea1.InnerText = dto.XmlData.ToString(); // Response.Write( dto.XmlData.ToString() ) ; }
void loadResults_Completed(object sender, EventArgs e) { InvokeOperation <CanvasDto> result = (InvokeOperation <CanvasDto>)sender; Exception ex = null; if (result.HasError) { result.MarkErrorAsHandled(); ex = result.Error; } CanvasDto returnedData = ((InvokeOperation <CanvasDto>)sender).Value; _loadCompleted(returnedData, ex); }
/// <summary> /// Saves the snapshot. /// </summary> /// <param name="cdto">The cdto.</param> /// <returns></returns> public string SaveSnapshot(CanvasDto cdto) { SqlDatabase db = new SqlDatabase(ConnectionString); string query = string.Empty; CanvasDto canvasDtoToReturn = cdto; string snapshotGuid = ""; try { snapshotGuid = Convert.ToString(db.ExecuteScalar("usp_save_canvas_snapshot", cdto.CanvasId, cdto.CanvasSnapshotAsBase64)); } catch (Exception ex) { throw new Exception(ex.Message); } return(snapshotGuid); }
public string SaveCanvasSnapshot(CanvasDto cdto) { return(cm.SaveCanvasSnapshot(cdto)); }
/// <summary> /// Saves Canvas /// </summary> /// <param name="canvasDto"></param> /// <returns></returns> public int SaveCanvas(CanvasDto canvasDto) { return(cm.SaveCanvas(canvasDto)); // return false; }
public HttpResponseMessage Get(string id) { XmlDocument doc = new XmlDocument(); CanvasDomainService CanvasDS = new CanvasDomainService(); CanvasDto cDto = CanvasDS.LoadCanvasGUID(new Guid(id)); doc.LoadXml(cDto.XmlData.ToString()); int jsonId = 0; XmlNode dashboardCanvas = doc.GetElementsByTagName("DashboardCanvas")[0]; XmlAttribute xAttDatasourceName1 = doc.CreateAttribute("DatasourceName"); XmlAttribute xAttCanvasName = doc.CreateAttribute("CanvasName"); xAttCanvasName.Value = cDto.CanvasName.ToString(); xAttDatasourceName1.Value = cDto.Datasource.ToString(); dashboardCanvas.Attributes.Append(xAttCanvasName); dashboardCanvas.Attributes.Append(xAttDatasourceName1); foreach (XmlNode item in doc.GetElementsByTagName("Gadgets")[0].ChildNodes) { // XmlDocument xDoc = item as XmlDocument; XmlAttribute xAttJsonId = doc.CreateAttribute("jsonId"); XmlAttribute xAttDatasourceName = doc.CreateAttribute("DatasourceName"); XmlAttribute xAttDatasourceId = doc.CreateAttribute("DatasourceId"); xAttDatasourceId.Value = cDto.DatasourceID.ToString(); xAttDatasourceName.Value = cDto.Datasource.ToString(); xAttJsonId.Value = jsonId.ToString(); jsonId++; item.Attributes.Append(xAttJsonId); item.Attributes.Append(xAttDatasourceId); item.Attributes.Append(xAttDatasourceName); if (item.Name == "chart" && item["gadgetDescription"] != null && item["gadgetDescription"].InnerText != null) { string gadgetDescription = item["gadgetDescription"].InnerText.ToString(); if (gadgetDescription.Length > 0) { if (!string.IsNullOrEmpty(gadgetDescription)) { byte[] encodedDataAsBytes = System.Convert.FromBase64String(gadgetDescription); item["gadgetDescription"].InnerText = System.Text.ASCIIEncoding.Unicode.GetString(encodedDataAsBytes); } } } } var resp = new HttpResponseMessage() { Content = new StringContent(JsonConvert.SerializeXmlNode(doc)) //("[{\"Name\":\"ABC\"},[{\"A\":\"1\"},{\"B\":\"2\"},{\"C\":\"3\"}]]") }; resp.Content.Headers.ContentType = new MediaTypeHeaderValue("application/jsonp"); return(resp); }
public void SaveCanvas(CanvasDto canvasDto) { throw new NotImplementedException(); }
public void Update(CanvasDto canvasDto) { throw new NotImplementedException(); }
/// <summary> /// Saves the specified canvas dto. /// </summary> /// <param name="canvasDto">The canvas dto.</param> /// <returns></returns> /// <exception cref="System.Exception"></exception> public int Save(CanvasDto canvasDto) { PostgreSQLDB db = new PostgreSQLDB(ConnectionString); string query = string.Empty; CanvasDto canvasDtoToReturn = canvasDto; int canvasId = -1; NpgsqlCommand Command = new NpgsqlCommand(); Command.CommandType = CommandType.StoredProcedure; Command.CommandText = "save_canvas"; NpgsqlParameter parameter = new NpgsqlParameter("cname", NpgsqlTypes.NpgsqlDbType.Text); parameter.Value = canvasDto.CanvasName; parameter.Direction = ParameterDirection.Input; Command.Parameters.Add(parameter); parameter = new NpgsqlParameter("uid", NpgsqlTypes.NpgsqlDbType.Integer); parameter.Value = canvasDto.UserId; parameter.Direction = ParameterDirection.Input; Command.Parameters.Add(parameter); parameter = new NpgsqlParameter("cdesc", NpgsqlTypes.NpgsqlDbType.Text); parameter.Value = canvasDto.CanvasDescription; parameter.Direction = ParameterDirection.Input; Command.Parameters.Add(parameter); parameter = new NpgsqlParameter("cdate", NpgsqlTypes.NpgsqlDbType.Date); parameter.Value = canvasDto.CreatedDate; parameter.Direction = ParameterDirection.Input; Command.Parameters.Add(parameter); parameter = new NpgsqlParameter("mdate", NpgsqlTypes.NpgsqlDbType.Date); parameter.Value = canvasDto.ModifiedDate; parameter.Direction = ParameterDirection.Input; Command.Parameters.Add(parameter); parameter = new NpgsqlParameter("did", NpgsqlTypes.NpgsqlDbType.Integer); parameter.Value = canvasDto.DatasourceID; parameter.Direction = ParameterDirection.Input; Command.Parameters.Add(parameter); parameter = new NpgsqlParameter("isnewcanvas", NpgsqlTypes.NpgsqlDbType.Boolean); parameter.Value = canvasDto.IsNewCanvas; parameter.Direction = ParameterDirection.Input; Command.Parameters.Add(parameter); parameter = new NpgsqlParameter("cid", NpgsqlTypes.NpgsqlDbType.Integer); parameter.Value = canvasDto.CanvasId; parameter.Direction = ParameterDirection.Input; Command.Parameters.Add(parameter); parameter = new NpgsqlParameter("xmlcontent", NpgsqlTypes.NpgsqlDbType.Text); parameter.Value = canvasDto.XmlData.ToString(); parameter.Direction = ParameterDirection.Input; Command.Parameters.Add(parameter); try { canvasId = Convert.ToInt32(db.ExecuteScalar(Command)); } catch (Exception ex) { throw new Exception(ex.Message); } canvasDtoToReturn.CanvasId = canvasId; return(canvasId); }
/// <summary> /// Saves the snapshot. /// </summary> /// <param name="cdto">The cdto.</param> /// <returns></returns> public string SaveSnapshot(CanvasDto cdto) { // TODO: Implement this method throw new NotImplementedException(); }
/// <summary> /// Saves the canvas. /// </summary> /// <param name="canvasDto">The canvas dto.</param> public int SaveCanvas(CanvasDto canvasDto) { return(em.SaveCanvas(canvasDto)); }
public int Save(CanvasDto canvasDto) { if (canvasDto.IsNewCanvas) { try { MySqlConnection conn = new MySqlConnection(ConnectionString); conn.Open(); MySqlCommand myCommand = new MySqlCommand(); myCommand.Connection = conn; myCommand.CommandText = "usp_save_canvas"; myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add(new MySqlParameter("CanvasName", canvasDto.CanvasName)); myCommand.Parameters.Add(new MySqlParameter("CanvasContent", canvasDto.XmlData)); myCommand.Parameters.Add(new MySqlParameter("CanvasDescription", canvasDto.CanvasDescription)); myCommand.Parameters.Add(new MySqlParameter("CreatedDate", canvasDto.CreatedDate)); myCommand.Parameters.Add(new MySqlParameter("DatasourceID", canvasDto.DatasourceID)); myCommand.Parameters.Add(new MySqlParameter("ModifiedDate", canvasDto.ModifiedDate)); myCommand.Parameters.Add(new MySqlParameter("UserID", canvasDto.UserId)); MySqlParameter p1 = new MySqlParameter(); p1.ParameterName = "CanvasID"; p1.Direction = ParameterDirection.Output; myCommand.Parameters.Add(p1); myCommand.ExecuteNonQuery(); int retval = Int32.Parse(p1.Value.ToString()); if (retval == -1) { throw new Exception("MySQL Exception - canvas already exists"); } return(Int32.Parse(p1.Value.ToString())); } catch (MySqlException mex) { // throw new Exception("MySQL Exception - {0}", mex.Message); throw new Exception(string.Format("MySQL Exception - {0}", mex.Message)); } catch (Exception ex) { throw new Exception(string.Format("{0}Stack trace -- {1}", ex.Message, ex.StackTrace)); } } else { try { MySqlConnection conn = new MySqlConnection(ConnectionString); conn.Open(); MySqlCommand myCommand = new MySqlCommand(); myCommand.Connection = conn; myCommand.CommandText = "usp_update_canvas"; myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add(new MySqlParameter("CanvasContent", canvasDto.XmlData)); // myCommand.Parameters.Add(new MySqlParameter("CanvasID", canvasDto.CanvasId)); myCommand.Parameters.Add(new MySqlParameter("ModifiedDate", canvasDto.ModifiedDate)); myCommand.ExecuteNonQuery(); return(canvasDto.CanvasId); } catch (MySqlException mex) { throw new Exception(string.Format("MySQL Exception - {0}", mex.Message)); } catch (Exception ex) { throw new Exception(string.Format("{0}Stack trace -- {1}", ex.Message, ex.StackTrace)); } } }
/// <summary> /// Saves the specified canvas dto. /// </summary> /// <param name="canvasDto">The canvas dto.</param> public int Save(CanvasDto canvasDto) { SqlDatabase db = new SqlDatabase(ConnectionString); string query = string.Empty; CanvasDto canvasDtoToReturn = canvasDto; int canvasId = -1; // // SqlConnection sqlConn = new SqlConnection(this.ConnectionString); // sqlConn.Open(); // // SqlCommand addCanvasCommand = sqlConn.CreateCommand(); // [CanvasID] // INT IDENTITY(1, 1) NOT NULL, //[CanvasGUID] UNIQUEIDENTIFIER CONSTRAINT[DF_Canvas_CanvasGUID] DEFAULT(newid()) NOT NULL, //[CanvasName] VARCHAR(50) NOT NULL, //[UserID] INT NOT NULL, // [CanvasDescription] VARCHAR(MAX) NULL, // [CreatedDate] // DATETIME NOT NULL, // [ModifiedDate] // DATETIME NOT NULL, // [DatasourceID] // INT NOT NULL, // [CanvasContent] NVARCHAR(MAX) NOT NULL, // SqlParameter param = new SqlParameter("CanvasName", SqlDbType.NVarChar); // addCanvasCommand.Connection = new SqlConnection(ConnectionString); ////addCanvasCommand.CommandType = CommandType.StoredProcedure; ////addCanvasCommand.CommandText = "usp_save_canvas"; ////addCanvasCommand.Parameters.Add("CanvasName", SqlDbType.NVarChar).Value = canvasDto.CanvasName; ////addCanvasCommand.Parameters.Add("UserID", SqlDbType.Int ).Value = canvasDto.UserId; ////addCanvasCommand.Parameters.Add("CANVASDESC", SqlDbType.NVarChar ).Value = canvasDto.CanvasDescription; ////addCanvasCommand.Parameters.Add("CreatedDate", SqlDbType.Date ).Value = canvasDto.CreatedDate; ////addCanvasCommand.Parameters.Add("ModifiedDate", SqlDbType.Date).Value = canvasDto.ModifiedDate; ////addCanvasCommand.Parameters.Add("DatasourceID", SqlDbType.Int ).Value = canvasDto.DatasourceID; ////addCanvasCommand.Parameters.Add("IsNewCanvas", SqlDbType.Bit ).Value = canvasDto.IsNewCanvas; ////addCanvasCommand.Parameters.Add("CanvasID", SqlDbType.Int ).Value = canvasDto.CanvasId; ////addCanvasCommand.Parameters.Add("XMLCONTENT", SqlDbType.NVarChar).Value = canvasDto.XmlData.ToString(); try { //sqlConn.Open(); //canvasId = Convert.ToInt32(addCanvasCommand.ExecuteScalar()); // canvasId = Convert.ToInt32(db.ExecuteScalar("usp_save_canvas", addCanvasCommand.Parameters )); canvasId = Convert.ToInt32(db.ExecuteScalar("usp_save_canvas", canvasDto.CanvasName, canvasDto.UserId, canvasDto.CanvasDescription, canvasDto.CreatedDate, canvasDto.ModifiedDate, canvasDto.DatasourceID, canvasDto.IsNewCanvas, canvasDto.CanvasId, canvasDto.XmlData.ToString())); } catch (SqlException sqlEx) { Exception duplicateException = new Exception(string.Format("SQL Exception - {0}", sqlEx.Message)); throw duplicateException; } catch (Exception ex) { throw new Exception(ex.Message); } canvasDtoToReturn.CanvasId = canvasId; return(canvasId); }
/// <summary> /// Updates the specified canvas dto. /// </summary> /// <param name="canvasDto">The canvas dto.</param> public void Update(CanvasDto canvasDto) { // TODO: Implement this method throw new NotImplementedException(); }