public async Task <List <SampleToJson> > getSamplesList()
{
SampleDate lastSampleDate = db.SampleDates.LastOrDefault();
IQueryable <Sample> samples = db.Samples
.Include(d => d.User)
.ThenInclude(x => x.Role)
.Include(d => d.User)
.ThenInclude(x => x.Department);
if (lastSampleDate != null)
{
samples = samples.Where(a => a.Date == lastSampleDate.Date);
}
// IQueryable<SampleToJson> sampleToJsons= samples.Select(p => new SampleToJson
// {
// Id = p.Id,
// StressFactor = p.StressFactor,
// Pulse = p.Pulse,
// Temperature = p.Temperature,
// User = p.User,
// Date = p.Date.ToString("dd/MM/yyyy")
// }).OrderBy(x=>x.StressFactor);
List <Sample> lSamples = await samples.AsNoTracking().ToListAsync();
return(SampleToJson(lSamples));
}
public override int GetHashCode()
{
return(key.GetHashCode() ^ CoordComp.GetHashCode() ^ OverallComp.GetHashCode() ^ CommunicationComp.GetHashCode() ^ CourtesyComp.GetHashCode() ^ ResponsivenessComp.GetHashCode() ^ InterviewDate.GetHashCode() ^ SampleDate.GetHashCode() ^ LoadDate.GetHashCode() ^ SurveyRound.GetHashCode() ^ RegionCode.GetHashCode() ^ WesId.GetHashCode() ^ SurveyOutcome.GetHashCode() ^ q1.GetHashCode() ^ q2.GetHashCode() ^ q3.GetHashCode() ^ q4.GetHashCode() ^ q5.GetHashCode() ^ q6.GetHashCode() ^ q7.GetHashCode() ^ q8.GetHashCode() ^ q9.GetHashCode() ^ q10.GetHashCode() ^ q11.GetHashCode() ^ q12.GetHashCode() ^ q13.GetHashCode() ^ q14.GetHashCode() ^ q15.GetHashCode() ^ q16.GetHashCode() ^ q17.GetHashCode() ^ q18.GetHashCode() ^ q19.GetHashCode() ^ q20.GetHashCode() ^ SurveyQuarter.GetHashCode() ^ SurveyType.GetHashCode());
}
public void TestDate()
{
var js = new JsonSerializer();
js.JsonOptions.Indent = "";
js.JsonOptions.FieldSeparator = " ";
var jd = new JsonDeserializer();
var n = DateTime.Now;
Assert.AreEqual("\"" + n.ToString("O") + "\"", js.ToString(n));
var t = DateTime.Now - DateTime.MinValue;
Assert.AreEqual("\"" + t.ToString("c") + "\"", js.ToString(t));
var v1 = new SampleDate { D = new DateTime(2011, 3, 25), T = TimeSpan.FromMinutes(5) };
var result1 = js.ToString(v1);
Assert.AreEqual("{ \"D\":\"2011-03-25T00:00:00.0000000\", \"T\":\"00:05:00\" }", result1);
js.JsonOptions.DateFormat = @"yyyy";
js.JsonOptions.TimeSpanFormat = @"hh\#mm\#ss";
Assert.AreEqual("{ \"D\":\"2011\", \"T\":\"00#05#00\" }", js.ToString(v1));
var w1 = new SampleDate();
(new JsonDeserializer()).FromString(w1, result1);
Assert.AreEqual(v1.D, w1.D);
Assert.AreEqual(v1.T, w1.T);
w1 = (SampleDate)SampleDate_JsonDeserializer.Instance.FromString(result1);
Assert.AreEqual(v1.D, w1.D);
Assert.AreEqual(v1.T, w1.T);
js.JsonOptions.DateFormat = "O";
var v2 = new DateTime(2011, 3, 25, 1, 2, 3, DateTimeKind.Utc);
var result2 = js.ToString(v2);
Assert.AreEqual("\"2011-03-25T01:02:03.0000000Z\"", result2);
var w2 = jd.FromString<DateTime>(result2);
Assert.AreEqual(v2, w2);
Assert.AreEqual(v2.Kind, w2.Kind);
var v3 = new DateTime(2011, 3, 25, 1, 2, 3, DateTimeKind.Local);
var result3 = js.ToString(v3);
var w3 = jd.FromString<DateTime>(result3);
Assert.AreEqual(v3, w3);
Assert.AreEqual(v3.Kind, w3.Kind);
}
public void TestDate()
{
var bs = new BinarySerializer();
var bd = new BinaryDeserializer();
var v1 = new SampleDate { D = new DateTime(2011, 3, 25), T = TimeSpan.FromMinutes(5) };
var result1 = bs.ToBytes(v1);
Assert.AreEqual(
"20 01 00 " + XS(typeof(SampleDate)) + " 02 00 " +
XS("D", RoughType.DateTime, "T", RoughType.TimeSpan) +
" 01 00 00 00 F5 B7 96 B8 CD 08 02 00 00 5E D0 B2 00 00 00 00 00 00",
XS(result1));
var w1 = new SampleDate();
bd.FromBytes(w1, result1);
Assert.AreEqual(v1.D, w1.D);
Assert.AreEqual(v1.T, w1.T);
var v2 = new DateTime(2011, 3, 25, 1, 2, 3, DateTimeKind.Utc);
var result2 = bs.ToBytes(v2);
var w2 = bd.FromBytes<DateTime>(result2);
Assert.AreEqual(v2, w2);
Assert.AreEqual(v2.Kind, w2.Kind);
var v3 = new DateTime(2011, 3, 25, 1, 2, 3, DateTimeKind.Local);
var result3 = bs.ToBytes(v3);
var w3 = bd.FromBytes<DateTime>(result3);
Assert.AreEqual(v3, w3);
Assert.AreEqual(v3.Kind, w3.Kind);
}
public override string ToString()
{
return(SampleDate.ToShortDateString() + ": " + Amount + " " + CompoundName);
}
