public bool UpdateTimeRestriction(TimeRestrictionEntity timeRestrictionEntity)
{
bool result;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_TimeRestrictionUpdate");
db.AddInParameter(dbCommand, "@TimeRestrictionId", DbType.Guid, timeRestrictionEntity.TimeRestrictionId);
db.AddInParameter(dbCommand, "@MaximumRecordingPerDay", DbType.Decimal, timeRestrictionEntity.MaximumRecordingPerDay);
db.AddInParameter(dbCommand, "@WarningAfterLimitExceed", DbType.String, timeRestrictionEntity.WarningAfterLimitExceed);
db.AddInParameter(dbCommand, "@UpdatedBy", DbType.Guid, timeRestrictionEntity.UpdatedBy);
db.ExecuteNonQuery(dbCommand);
result = true;
return result;
}
public Guid InsertTimeRestriction(TimeRestrictionEntity timeRestrictionEntity)
{
Guid result;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_TimeRestrictionInsert");
db.AddInParameter(dbCommand, "@MaximumRecordingPerDay", DbType.Decimal, timeRestrictionEntity.MaximumRecordingPerDay);
db.AddInParameter(dbCommand, "@WarningAfterLimitExceed", DbType.String, timeRestrictionEntity.WarningAfterLimitExceed);
db.AddInParameter(dbCommand, "@CreatedBy", DbType.Guid, timeRestrictionEntity.CreatedBy);
db.AddOutParameter(dbCommand, "@TimeRestrictionId", DbType.Guid, 30);
db.ExecuteNonQuery(dbCommand);
result = new Guid(db.GetParameterValue(dbCommand, "@TimeRestrictionId").ToString());
return result;
}
public bool UpdateTimeRestriction(TimeRestrictionEntity timeRestrictionEntity)
{
return timeRestrictionDao.UpdateTimeRestriction(timeRestrictionEntity);
}
public Guid InsertTimeRestriction(TimeRestrictionEntity timeRestrictionEntity)
{
return timeRestrictionDao.InsertTimeRestriction(timeRestrictionEntity);
}
