public static GlobalMenuItem LoadFromDB(GeneralSessionInfo gsi)
{
using (SqlConnection con = new SqlConnection(DBUtil.GetSqlConnectionString()))
{
con.Open();
SqlDataAdapter sqlDataAdapter;
DataSet dataSet = new DataSet();
SqlCommand sql = new SqlCommand("GetGlobalMenu", con);
sql.CommandType = CommandType.StoredProcedure;
sql.Parameters.Add(new SqlParameter("RetailerID", gsi.retailerID));
sql.Parameters.Add(new SqlParameter("UserID", gsi.userID));
sql.Parameters.Add(new SqlParameter("LanguageID", gsi.languageID));
try
{
sqlDataAdapter = new SqlDataAdapter(sql);
sqlDataAdapter.Fill(dataSet);
if (dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
{
return(ProcessMenu(dataSet.Tables[0]));
}
else
{
Console.WriteLine("No matching records found.");
}
}
catch { }
}
return(null);
}
public bool LoadNavigation(GeneralSessionInfo gsi)
{
int RootNavigationItemID = 6;
NavID = RootNavigationItemID;
using (SqlConnection con = new SqlConnection(DBUtil.GetSqlConnectionString()))
{
con.Open();
SqlDataAdapter sqlDataAdapter;
DataSet dataSet = new DataSet();
List <Field> ret = new List <Field>();
SqlCommand sql = new SqlCommand("GetNavigation", con);
sql.CommandType = CommandType.StoredProcedure;
sql.Parameters.Add(new SqlParameter("NavID", RootNavigationItemID));
sql.Parameters.Add(new SqlParameter("LanguageID", gsi.languageID));
sql.Parameters.Add(new SqlParameter("UserID", gsi.userID));
try
{
sqlDataAdapter = new SqlDataAdapter(sql);
sqlDataAdapter.Fill(dataSet);
if (dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
{
ProcessNavigation(dataSet.Tables[0]);
}
else
{
//Page.GenerateUnknownPageInfo();
Console.WriteLine("No matching records found.");
}
}
catch (Exception eee)
{
ret.Add(new LabelTextAreaField("1", "Exception in LoadNavigation(..)", eee.ToString()));
}
return(false);
}
}
