public object GetDetail(Guid id)
{
Sample result;
using (var db = new ProjectSampleDatabase())
{
result = db.Samples.Where(i => i.Id == id)
.SingleOrDefault();
}
result = result ?? new Sample();
Sample innerSample = new Sample();
if (!string.IsNullOrEmpty(result.JsonData))
{
innerSample = JsonConvert.DeserializeObject <Sample>(result.JsonData);
}
return(new
{
Id = result.Id,
Version = result.Version,
InnerData = innerSample
});
}
public List <object> GetPaging(int?skip = 0, int?take = 10)
{
int xskip = 0;
if (skip != null)
{
xskip = skip.Value;
}
int xtake = 0;
if (take != null)
{
xtake = take.Value;
}
List <Sample> result;
using (var db = new ProjectSampleDatabase())
{
result = db.Samples.Skip(xskip).Take(xtake)
.ToList();
}
result = result ?? new List <Sample>();
List <object> temp = new List <object>();
foreach (var r in result)
{
if (!string.IsNullOrEmpty(r.JsonData))
{
temp.Add(new
{
Id = r.Id,
Version = r.Version
});
}
else
{
temp.Add(new
{
Id = r.Id,
Version = r.Version
});
}
}
return(temp);
}
public void Handle(SampleCreated e)
{
using (var db = new ProjectSampleDatabase())
{
db.Samples.Add(new Sample()
{
Id = e.SampleId,
JsonData = e.SampleJsonData,
Version = e.SampleVersion
});
db.SaveChanges();
}
Console.WriteLine($"Save to DbRead for CreateSample.Id{e.SampleId}");
}
public void Handle(SampleVersionChanged e)
{
using (var db = new ProjectSampleDatabase())
{
var existed = db.Samples.FirstOrDefault(i => i.Id == e.SampleId);
if (existed == null)
{
return;
}
existed.Version = e.SampleVersion;
db.SaveChanges();
}
Console.WriteLine($"Save to DbRead for SampleVersionChanged.Id{e.SampleId}");
}
