/*==================================================================================================================================
* Private Methods
*=================================================================================================================================*/
private questStatus initialize()
{
// Initialize
questStatus status = null;
try
{
_dbTypeListsMgr = new DbTypeListsMgr(this.UserSession);
}
catch (System.Exception ex)
{
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().ToString(), MethodInfo.GetCurrentMethod().Name, ex.Message));
throw new System.Exception(status.Message, ex);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Properties
*=================================================================================================================================*/
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus GetTypeListOptions(TypeListId typeListId, List <TypeListArgument> typeListArgumentList, out List <OptionValuePair> typeListOptionList)
{
// Initialize
questStatus status = null;
typeListOptionList = null;
// Get the typeList.
TypeList typeList = null;
DbTypeListsMgr dbTypeListsMgr = new DbTypeListsMgr(this.UserSession);
status = dbTypeListsMgr.Read(typeListId, out typeList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get the database.
DatabaseId databaseId = new DatabaseId(typeList.DatabaseId);
Quest.Functional.MasterPricing.Database database = null;
DbDatabasesMgr dbDatabasesMgr = new DbDatabasesMgr(this.UserSession);
status = dbDatabasesMgr.Read(databaseId, out database);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Apply typeList arguments.
if (typeListArgumentList == null)
{
typeListArgumentList = new List <TypeListArgument>();
}
string sql = typeList.SQL;
foreach (TypeListArgument typeListArgument in typeListArgumentList)
{
sql = sql.Replace(typeListArgument.Name, typeListArgument.Value);
}
try
{
using (SqlConnection conn = new SqlConnection(database.ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(null, conn))
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
using (SqlDataReader rdr = cmd.ExecuteReader())
{
typeListOptionList = new List <OptionValuePair>();
while (rdr.Read())
{
OptionValuePair optionValuePair = new OptionValuePair();
optionValuePair.Id = rdr[0].ToString();
optionValuePair.Label = rdr[0].ToString();
typeListOptionList.Add(optionValuePair);
}
}
}
}
}
catch (System.Exception ex)
{
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().ToString(), MethodInfo.GetCurrentMethod().Name, ex.Message));
return(status);
}
return(new questStatus(Severity.Success));
}
