public List <BlockData> GetBlocks()
{
List <BlockData> list = null;
BlockData l_user = null;
try
{
string strquery = @"SELECT ID_RLS,[DOCUMENT_RLS],[TYPE_RLS] FROM [dbo].[RULES_RLS] RLS where RLS.TYPE_RLS IN ('pricer', 'FORMLOGIC', 'ErrorMessages', 'CommonRating', 'StatReporting', 'PolicyIndicator', 'PremiumCalculation', 'PremiumRollups','others')";
using (DbCommand command = l_database.GetSqlStringCommand(strquery))
{
//l_database.AddInParameter(command, "@EMAIL", DbType.String, userName);
//l_database.AddInParameter(command, "@PASSWORD", DbType.String, password);
DataSet l_dataset = l_database.ExecuteDataSet(command);
if (l_dataset != null && l_dataset.Tables.Count > 0 && l_dataset.Tables[0].Rows.Count > 0)
{
list = new List <BlockData>();
foreach (DataRow row in l_dataset.Tables[0].Rows)
{
l_user = new BlockData();
l_user.blockType = Convert.ToString(row["TYPE_RLS"]);
if (l_user.blockType.ToLower() == "pricer")
{
l_user.pricer = XMLExtensions.DeSerialize <PricerInfo>(Convert.ToString(row["DOCUMENT_RLS"]));
}
else if (l_user.blockType.ToLower() == "formlogic")
{
l_user.formRules = XMLExtensions.DeSerialize <FormRules>(Convert.ToString(row["DOCUMENT_RLS"]));
}
l_user.algoName = "";
l_user.displayName = "";
l_user.ruleId = Convert.ToInt32(row["ID_RLS"]);
list.Add(l_user);
}
}
}
}
catch (SqlException ex)
{
string exceptionMessage = ex.Errors[0].Message;
throw new Exception(exceptionMessage);
}
catch (Exception ex)
{
throw;
}
return(list);
}
