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