internal OIAutoAcceptanceEntity GetAutoAcceptanceRuleById(int RuleId) { OIAutoAcceptanceEntity results = new OIAutoAcceptanceEntity(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "OI.GetAutoAcceptanceRuleById"; sproc.StoredProceduresParameter.Add(GetParam("@RuleId", RuleId.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { OIAutoAcceptanceAdapter ta = new OIAutoAcceptanceAdapter(); foreach (DataRow rw in dt.Rows) { results = ta.AdaptItem(rw); } } } catch (Exception) { throw; } return(results); }
internal List <OIAutoAcceptanceEntity> GetAutoAcceptanceRulesPaging(int PageSize, int PageNumber, out int TotalRecords) { TotalRecords = 0; List <OIAutoAcceptanceEntity> results = new List <OIAutoAcceptanceEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "OI.GetAutoAcceptanceRulesPaging"; sproc.StoredProceduresParameter.Add(GetParam("@PageSize", PageSize.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@PageNumber", PageNumber.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@TotalRecords", TotalRecords.ToString(), SQLServerDatatype.IntDataType, ParameterDirection.Output)); string outParam = ""; DataTable dt; dt = sql.ExecuteDataTableWithOutputParam(CommandType.StoredProcedure, sproc, out outParam, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { results = new OIAutoAcceptanceAdapter().Adapt(dt); } TotalRecords = Convert.ToInt32(outParam); } catch (Exception) { throw; } return(results); }