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