public bool Update(IDailyMarket idm) { return(mapperHelper.Update(idm, (cmd, idailymarket) => UpdateParameters(cmd, idailymarket), "update DailyMarket set idxmrkt=@idxmrkt, dailyvar=@dailyvar, idxopeningval=@idxopv where code=@id and date=@datetime" )); }
public bool Delete(IDailyMarket idm) { return(mapperHelper.Delete(idm, (cmd, idailymarket) => DeleteParameters(cmd, idailymarket), "delete from DailyMarket where code=@id and date = @datetime" )); }
protected void DeleteParameters(IDbCommand cmd, IDailyMarket dm) { SqlParameter id = new SqlParameter("@id", dm.code); SqlParameter datetime = new SqlParameter("@datetime", dm.date); cmd.Parameters.Add(id); cmd.Parameters.Add(datetime); }
public IDailyMarket Create(IDailyMarket idm) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { mapperHelper.Create(idm, (cmd, idailymarket) => InsertParameters(cmd, idailymarket), "INSERT INTO DailyMarket (idxmrkt,dailyvar,idxopeningval, code, date) VALUES(@idxmrkt, @dailyvar, @idxopv, @id, @datetime); select @id=code, @datetime=date" ); ts.Complete(); return(idm); } }
protected void InsertParameters(IDbCommand cmd, IDailyMarket dm) { SqlParameter idm = new SqlParameter("@IdxMrkt", dm.idxmrkt); SqlParameter id = new SqlParameter("@id", dm.code); SqlParameter dt = new SqlParameter("@datetime", dm.date); SqlParameter dv = new SqlParameter("@dailyVar", dm.dailyvar); SqlParameter iov = new SqlParameter("@IdxOpeningVal", dm.idxopeningval); id.Direction = ParameterDirection.InputOutput; dt.Direction = ParameterDirection.InputOutput; cmd.Parameters.Add(idm); cmd.Parameters.Add(id); cmd.Parameters.Add(dt); cmd.Parameters.Add(dv); cmd.Parameters.Add(iov); }
public bool Update(IDailyMarket value) { if (value == null) { return(false); } ctx.Entry((DailyMarket)value).State = EntityState.Modified; IDailyMarket newDailyMarket = Find(value.code, value.date); newDailyMarket.market = value.market; newDailyMarket.idxmrkt = value.idxmrkt; newDailyMarket.dailyvar = value.dailyvar; newDailyMarket.idxopeningval = value.idxopeningval; newDailyMarket.market = value.market; return(true); }
public bool Update(IDailyMarket value) { return(mapper.Update(value)); }
public IDailyMarket Insert(IDailyMarket value) { return(mapper.Create(value)); }
public bool Delete(IDailyMarket value) { return(mapper.Delete(value)); }
protected void UpdateParameters(IDbCommand cmd, IDailyMarket dm) { InsertParameters(cmd, dm); }
public IDailyMarket Insert(IDailyMarket value) { return(db.Add((DailyMarket)value)); }
public bool Delete(IDailyMarket value) { return(db.Remove((DailyMarket)value).Equals(value)); }