public bool Update(IDailyReg entity)
{
return(mapperHelper.Update(entity,
(cmd, dailyReg) => UpdateParameters(cmd, dailyReg),
"update DailyReg set minval=@minval, openingval=@openingval, maxval=@maxval, closingval=@closingval where isin=@id and dailydate=@datetime"
));
}
public bool Delete(IDailyReg entity)
{
return(mapperHelper.Delete(entity,
(cmd, dailyreg) => DeleteParameters(cmd, dailyreg),
"delete from DailyReg where isin=@id and dailydate=@datetime"
));
}
protected void DeleteParameters(IDbCommand cmd, IDailyReg dr)
{
SqlParameter id = new SqlParameter("@id", dr.isin);
SqlParameter dt = new SqlParameter("@datetime", dr.dailydate);
cmd.Parameters.Add(id);
cmd.Parameters.Add(dt);
}
public IDailyReg Create(IDailyReg entity)
{
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required))
{
mapperHelper.Create(entity,
(cmd, dailyReg) => InsertParameters(cmd, dailyReg),
"INSERT INTO DailyReg (isin, minval, openingval, maxval, closingval, dailydate) VALUES(@id, @minval, @openingval, @maxval, @closingval, @datetime); select @id=isin, @datetime=dailydate"
);
ts.Complete();
return(entity);
}
}
public void p_actualizavalordiarioTest()
{
DateTime d = new DateTime(2019, 11, 1, 13, 13, 13);
ctx().p_actualizaValorDiario("11111111111", d);
IDailyReg dr = ctx().DailyRegs.Find("111111111111", d.Date);
Assert.AreEqual(dr.minval, 11);
Assert.AreEqual(dr.maxval, 1111);
Assert.AreEqual(dr.openingval, 11111);
Assert.AreEqual(dr.closingval, 111);
}
public bool Update(IDailyReg value)
{
if (value == null)
{
return(false);
}
ctx.Entry((DailyReg)value).State = EntityState.Modified;
IDailyReg newDailyReg = Find(value.dailydate, value.isin);
newDailyReg.minval = value.minval;
newDailyReg.maxval = value.maxval;
newDailyReg.openingval = value.openingval;
newDailyReg.instrument = value.instrument;
newDailyReg.closingval = value.closingval;
return(true);
}
protected void InsertParameters(IDbCommand cmd, IDailyReg dr)
{
SqlParameter dt = new SqlParameter("@datetime", dr.dailydate);
SqlParameter id = new SqlParameter("@id", dr.isin);
SqlParameter miv = new SqlParameter("@minval", dr.minval);
SqlParameter mav = new SqlParameter("@maxval", dr.maxval);
SqlParameter ov = new SqlParameter("@openingval", dr.openingval);
SqlParameter cv = new SqlParameter("@closingval", dr.closingval);
dt.Direction = ParameterDirection.InputOutput;
id.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(dt);
cmd.Parameters.Add(id);
cmd.Parameters.Add(miv);
cmd.Parameters.Add(mav);
cmd.Parameters.Add(ov);
cmd.Parameters.Add(cv);
}
protected void UpdateParameters(IDbCommand cmd, IDailyReg dr)
{
InsertParameters(cmd, dr);
}
public IDailyReg Insert(IDailyReg value)
{
return(db.Add((DailyReg)value));
}
public bool Delete(IDailyReg value)
{
return(db.Remove((DailyReg)value).Equals(value));
}
public bool Update(IDailyReg value)
{
return(mapper.Update(value));
}
public IDailyReg Insert(IDailyReg value)
{
return(mapper.Create(value));
}
public bool Delete(IDailyReg value)
{
return(mapper.Delete(value));
}
