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