public static List <PredictionEntityModel> FindAllBySynAppsDeviceId(string _synappsDeviceId)
{
var dc = new PredictionExamplesDataContext(SqlConnectionString);
var records =
from n in dc.PredictionEntities
where n.SynAppsDeviceId == _synappsDeviceId
select n;
return(Build(records));
}
public static ApiResult Refresh(string _synappsDeviceId, List <PredictionEntityModel> _list)
{
var apiResult = new ApiResult {
StatusCode = StatusCode.Success
};
var dc = new PredictionExamplesDataContext(SqlConnectionString);
dc.Connection.Open();
using (dc.Transaction = dc.Connection.BeginTransaction())
{
try
{
var forDelete =
from n in dc.PredictionEntities
where n.SynAppsDeviceId == _synappsDeviceId
select n;
dc.PredictionEntities.DeleteAllOnSubmit(forDelete);
var now = DateTime.UtcNow;
var entities = new List <PredictionEntity>();
foreach (var entity in _list)
{
entities.Add(new PredictionEntity
{
SynAppsDeviceId = entity.SynAppsDeviceId,
LuisExampleId = entity.LuisExampleId,
EntityName = entity.EntityName,
EntityValue = entity.EntityValue,
CreatedAt = now,
UpdatedAt = now
});
}
dc.PredictionEntities.InsertAllOnSubmit(entities);
dc.SubmitChanges();
dc.Transaction.Commit();
}
catch (Exception e)
{
dc.Transaction.Rollback();
apiResult.StatusCode = StatusCode.Error;
apiResult.Message = e.Message;
}
}
dc.Connection.Close();
return(apiResult);
}
public static PredictionEntityModel FindBySynAppsDeviceIdAndLuisExampleId(string _synappsDeviceId, long _luisExampleId)
{
var dc = new PredictionExamplesDataContext(SqlConnectionString);
var records =
from n in dc.PredictionEntities
where n.SynAppsDeviceId == _synappsDeviceId
where n.LuisExampleId == _luisExampleId
select n;
var list = Build(records);
if (list.Count > 0)
{
return(list.First());
}
else
{
return(null);
}
}
public static List <PredictionIntentModel> FindAllBySynAppsDeviceIdAndIntentOrderByLuisExampleId(string _synappsDeviceId, string _intent)
{
List <PredictionIntentModel> list = new List <PredictionIntentModel>();
var dc = new PredictionExamplesDataContext(SqlConnectionString);
var records =
from n in dc.PredictionIntents
join b in dc.PredictionEntities on n.LuisExampleId equals b.LuisExampleId
where n.SynAppsDeviceId == _synappsDeviceId
where n.Intent == _intent
where b.SynAppsDeviceId == _synappsDeviceId
orderby n.LuisExampleId
select new
{
Id = n.Id,
SynAppsDeviceId = n.SynAppsDeviceId,
LuisExampleId = n.LuisExampleId,
Intent = n.Intent,
EntityName = b.EntityName,
EntityValue = b.EntityValue,
CreatedAt = n.CreatedAt,
UpdatedAt = n.UpdatedAt
};
foreach (var r in records)
{
var model = PredictionIntentModel.New();
model.Id = r.Id;
model.SynAppsDeviceId = r.SynAppsDeviceId;
model.LuisExampleId = r.LuisExampleId;
model.Intent = r.Intent;
model.EntityName = r.EntityName;
model.EntityValue = r.EntityValue;
model.CreatedAt = r.CreatedAt;
model.UpdatedAt = r.UpdatedAt;
list.Add(model);
}
return(list);
}
public ApiResult Save()
{
var apiResult = new ApiResult()
{
StatusCode = StatusCode.Success
};
var now = DateTime.UtcNow;
var dc = new PredictionExamplesDataContext(SqlConnectionString);
if (this.Id == 0)
{
var r = new PredictionEntity();
r.SynAppsDeviceId = this.SynAppsDeviceId;
r.LuisExampleId = this.LuisExampleId;
r.EntityName = this.EntityName;
r.EntityValue = this.EntityValue;
r.CreatedAt = now;
r.UpdatedAt = now;
try
{
dc.PredictionEntities.InsertOnSubmit(r);
dc.SubmitChanges();
this.Id = r.Id;
this.CreatedAt = r.CreatedAt;
this.UpdatedAt = r.UpdatedAt;
}
catch (Exception e)
{
apiResult.StatusCode = StatusCode.Error;
apiResult.Message = e.Message;
}
}
else
{
var records =
from n in dc.PredictionEntities
where n.Id == this.Id
select n;
foreach (var r in records)
{
r.SynAppsDeviceId = this.SynAppsDeviceId;
r.LuisExampleId = this.LuisExampleId;
r.EntityName = this.EntityName;
r.EntityValue = this.EntityValue;
r.UpdatedAt = now;
}
try
{
dc.SubmitChanges();
}
catch (Exception e)
{
apiResult.StatusCode = StatusCode.Error;
apiResult.Message = e.Message;
}
}
return(apiResult);
}
