public async Task <WFChart> Get(string ChartName)
{
WFChart result = null;
result = await _WFContext.WFChart.FromSql("select ChartName, ChartId, ChartDescription from owf.wfChart " + ChartNameSelectTail(ChartName)
).SingleOrDefaultAsync <WFChart>();
return(result);
}
public async Task Delete(WFChart chart)
{
var ChartName = new SqlParameter("ChartName", chart.ChartName);
var ret = await _WFContext.Database.ExecuteSqlCommandAsync("delete from owf.WFChart where chartName = @ChartName", ChartName);
//var ret = await _WFContext.WFChart.FromSql("delete from owf.WFChart where chartName = @ChartName; select ChartName, ChartId, ChartDescription from owf.WFChart where chartName = @ChartName").FirstOrDefaultAsync<WFChart>();
if (ret != 1)
{
throw new SQLWFException(string.Format("Failure to delete \"{0}\" chart - returned value {1} from Delete routine", chart.ChartName, ret));
}
}
public async Task <WFChart> Save(WFChart Chart)
{
var id = Chart.ChartId;
var ChartName = new SqlParameter("ChartName", Chart.ChartName);
string chartDesc = "";
if (Chart.ChartDescription != null)
{
chartDesc = Chart.ChartDescription;
}
var ChartDescription = new SqlParameter("ChartDescription", chartDesc); // cannot pass null parameter as Text value to SQL
string selectCommandScript = " declare @id int;" +
" exec owf.ChartSet @ChartName, @ChartDescription, @id out;" +
" select ChartId, ChartName, ChartDescription from owf.WFChart where ChartId=@id";
SqlParameter[] arrParam = { ChartName, ChartDescription };
/*
* var connection = new SqlConnection(_WFContext.Database.GetDbConnection().ConnectionString);
* var command = new SqlCommand(selectCommandScript, arrParam, connection);
*
* using (var reader = command.ExecuteReader())
* {
* while (reader.Read())
* {
* Console.WriteLine($"{reader[0]}:{reader[1]} ${reader[2]}");
* }
* }
*/
var ret = await _WFContext.WFChart.FromSql(selectCommandScript, arrParam).FirstOrDefaultAsync <WFChart>();
return(ret);
}