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