public async Task TestAppendMeasure()
{
ITorqueWrenchMeasureRepository rp = new TorqueWrenchMeasureRepository();
// Environment ev = new Environment {Time=DateTime.Now , Address = "bnmb", Humidity = 12, Temperature = 56 };
var ev = await EnvironmentRepository.Find(2);
var wrench = await new TorqueWrenchRepository().Find(1);
var measure = new TorqueWrenchMeasure {
TestCode = DateTime.Now.ToShortDateString() + DateTime.Now.Millisecond.ToString(), Tester = "fedf", Environment = ev, Measurand = wrench
};
measure.Standard = new TorqueStandard {
Name = "sname", CertificateName = "certname"
};
measure.Data.ZeroPoint = 0.03;
measure.Data.GagingPoints.Add(new TorqueMeasurePoint {
Nominal = 10, Values = new List <double>(new double[] { 12, 13, 14 })
});
measure.Data.GagingPoints.Add(new TorqueMeasurePoint {
Nominal = 20, Values = new List <double>(new double[] { 22, 23, 24 })
});
measure.Data.GagingPoints.Add(new TorqueMeasurePoint {
Nominal = 30, Values = new List <double>(new double[] { 32, 33, 34 })
});
measure.Dump();
var result = await rp.Add(measure);
measure.Dump();
Assert.IsTrue(result);
}
public static TorqueWrenchMeasureDao ToDao(this TorqueWrenchMeasure entity)
{
//Mapper.Initialize(x => x.CreateMap<TorqueWrenchMeasure, TorqueWrenchMeasureDao>().AfterMap((a, b) =>
//{
// b.Data = JsonConvert.SerializeObject(a.Data);
//}));
return(Mapper.Map <TorqueWrenchMeasureDao>(entity));
}
public async Task <bool> Add(TorqueWrenchMeasure measure)
{
var sql = string.Format("insert into {0} values(@a,@b,@c,@d)", this.TableName);
var result = await this.CreateConnection().ExecuteAsync(sql, new { a = measure.Id, b = measure.TestCode, c = measure.Tester.Id, d = measure.TestDate }) == 1;
if (result)
{
measure.Id = this.GetInsertedId();
}
return(result);
}
public async Task <bool> Update(TorqueWrenchMeasure measure)
{
string sql = string.Format("UPDATE {0} SET {2} = @a, {3}=@b WHERE {1} = @{1}", TableName, ID, Col_tstcode, Col_tstDate);
return(await this.CreateConnection().ExecuteAsync(sql, new { a = measure.TestCode, b = measure.TestDate }) > 0);
}
public static TorqueWrenchMeasureDao ToDao(this TorqueWrenchMeasure entity)
{
return(Mapper.Map <TorqueWrenchMeasureDao>(entity));
}
