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