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)); }