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