public DataTable GetComputationRuleBase(TCoreRiTypeObject tcoreritype)
{
if (tcoreritype.ri_type_id < 1)
{
throw new ArgumentException("Return institution ID and frequency is required");
}
else
{
var comamndText = @"SELECT rule_ID AS 'Rule ID', rule_Name AS 'Rule Name', rule_Desc AS 'Rule Description', type AS 'Rule Type' FROM t_rpt_computation_rulebase a WHERE a.rule_ri = (SELECT ri_type_code FROM t_core_ri_type WHERE ri_type_id = @ritypeid) AND rule_status = 'Active'";
using (SqlCommand command = new SqlCommand(comamndText, DatabaseOps.OpenSqlConnection()))
{
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@ritypeid", tcoreritype.ri_type_id);
_resultTable = _databaseOperations.GetDataTable(command);
return(_resultTable);
}
}
}
/// <summary>
/// Method created for returning the articles
/// </summary>
/// <param name="article"></param>
/// <returns></returns>
public List <TCoreRiTypeObject> GetAllRIType()
{
List <TCoreRiTypeObject> result = new List <TCoreRiTypeObject>();
//Create the SQL Query for returning all the articles
string sqlQuery = String.Format("SELECT * FROM t_core_ri_type");
//Create and open a connection to SQL Server
SqlConnection connection = new SqlConnection(ConnectionString.GetConnectionString());
connection.Open();
SqlCommand command = new SqlCommand(sqlQuery, connection);
//Create DataReader for storing the returning table into server memory
SqlDataReader dataReader = command.ExecuteReader();
TCoreRiTypeObject riResult;
//load into the result object the returned row from the database
if (dataReader.HasRows)
{
while (dataReader.Read())
{
riResult = new TCoreRiTypeObject()
{
ri_type_id = Convert.ToInt32(dataReader.GetString(0)),
ri_type_code = dataReader.GetString(1),
description = dataReader.GetString(2),
start_validity_date = Convert.ToDateTime(dataReader.GetString(3)),
end_validity_date = Convert.ToDateTime(dataReader.GetString(4)),
admin_user_limit = Convert.ToInt32(dataReader.GetString(5)),
created_date = Convert.ToDateTime(dataReader.GetString(6)),
created_by = dataReader.GetString(7),
last_modified = Convert.ToDateTime(dataReader.GetString(8)),
modified_by = dataReader.GetString(9),
};
result.Add(riResult);
}
}
return(result);
}
