//READ public static List <INavigationDO> GetNavigationItemsByRoleID(int roleID) { var menu = new List <INavigationDO>(); try { using (SqlConnection con = new SqlConnection(_conString)) { using (SqlCommand com = new SqlCommand("sp_GetNavigationItemsByRoleID", con)) { try { com.CommandType = CommandType.StoredProcedure; com.CommandTimeout = 35; com.Parameters.Add(new SqlParameter("@RoleID", roleID)); con.Open(); using (SqlDataReader reader = com.ExecuteReader()) { while (reader.Read()) { INavigationDO newMenuItem = new NavigationDO(); newMenuItem.NavigationID = reader.GetInt32(reader.GetOrdinal("NavigationMenuID")); newMenuItem.MenuItem = reader["MenuItem"].ToString(); newMenuItem.URL = reader["Url"].ToString(); newMenuItem.RoleID = reader.GetInt32(reader.GetOrdinal("RoleID")); newMenuItem.ParentNavigationID = reader.GetInt32(reader.GetOrdinal("ParentNavigationID")); newMenuItem.Order = reader.GetInt32(reader.GetOrdinal("Order")); menu.Add(newMenuItem); } } } catch (Exception ex) { ErrorLogger.LogError(ex, "GetNavigationItemsByRoleID", "nothing"); } finally { con.Close(); con.Dispose(); con.Dispose(); } } } } catch (Exception e) { ErrorLogger.LogError(e, "GetNavigationItemsByRoleID", "nothing"); } return(menu); }
public static INavigationDO MapMenuPOtoDO(NavigationPO menuPO) { INavigationDO oMenu = new NavigationDO(); oMenu.NavigationID = menuPO.NavigationID; oMenu.MenuItem = menuPO.MenuItem; oMenu.URL = menuPO.URL; oMenu.RoleID = menuPO.RoleID; oMenu.ParentNavigationID = menuPO.ParentNavigationID; oMenu.Order = menuPO.Order; return(oMenu); }