public bool RuleResultSave(OXORuleResult obj) { bool retVal = true; string procName = (obj.Id == 0 ? "dbo.OXO_Programme_Rule_Result_New" : "dbo.OXO_Programme_Rule_Result_Edit"); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { obj.Save(this.CurrentCDSID); var para = new DynamicParameters(); para.Add("@p_OXODocId", obj.OXODocId, dbType: DbType.Int32); para.Add("@p_ProgrammeId", obj.ProgrammeId, dbType: DbType.Int32); para.Add("@p_Level", obj.ObjectLevel, dbType: DbType.String, size: 3); para.Add("@p_ObjectId", obj.ObjectId, dbType: DbType.Int32); para.Add("@p_RuleId", obj.RuleId, dbType: DbType.Int32); para.Add("@p_ModelId", obj.ModelId, dbType: DbType.Int32); para.Add("@p_RuleResult", obj.RuleResult, dbType: DbType.Boolean); para.Add("@p_CreatedBy", obj.CreatedBy, dbType: DbType.String, size: 8); para.Add("@p_CreatedOn", obj.CreatedOn, dbType: DbType.DateTime); if (obj.Id == 0) { para.Add("@p_Id", dbType: DbType.Int32, direction: ParameterDirection.Output); } else { para.Add("@p_Id", obj.Id, dbType: DbType.Int32); } conn.Execute(procName, para, commandType: CommandType.StoredProcedure); if (obj.Id == 0) { obj.Id = para.Get <int>("@p_Id"); } } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }
public OXORuleResult RuleResultGet(int id) { OXORuleResult retVal = null; using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@p_Id", id, dbType: DbType.Int32); retVal = conn.Query <OXORuleResult>("dbo.OXO_Programme_Rule_Result_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { Log.Error(ex); throw; } } return(retVal); }