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