public List <MenuBean> getListMainMenu(string user)
{
List <MenuBean> lstRS = new List <MenuBean>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(null, con);
SqlDataReader rd = null;
cmd.CommandText = "SELECT m.id FROM menu m " +
"where ((m.id in (select mr.menu_id from menu_role mr " +
" where role_id in (select uir.RoleId from aspnet_UsersInRoles uir, aspnet_Users u "+
" where u.UserId=uir.UserId and u.LoweredUserName=@userName))) "+
" or (m.secure_level<1)) and m.type = 0 and m.active > 0 order by m.[order]";
Debug.WriteLine("Get list main menu: " + cmd.CommandText);
cmd.Parameters.Add("@userName", System.Data.SqlDbType.NVarChar);
cmd.Parameters["@userName"].Value = user;
//SqlParameter parUserName = new SqlParameter();
//parUserName.DbType = System.Data.DbType.String;
//parUserName.Value = user;
//parUserName.ParameterName = "@userName";
//cmd.Parameters.Add(parUserName);
con.Open();
rd = cmd.ExecuteReader();
while (rd.Read())
{
MenuBean temp = loadMenu((int)rd["id"], user);
if (temp != null)
{
lstRS.Add(temp);
}
}
}
return(lstRS);
}
public static List <MenuBean> subObtenerDatosMenu(Int32 piIdPerfil)
{
List <MenuBean> loLstMenuBean = new List <MenuBean>();
try
{
DataTable loDatatable = MenuModel.fnObtenerDatosMenu(piIdPerfil);
MenuBean loMenuBean;
if (loDatatable != null && loDatatable.Rows.Count > 0)
{
foreach (DataRow row in loDatatable.Rows)
{
loMenuBean = new MenuBean();
loMenuBean.IdMenu = row["idMenu"].ToString();
loMenuBean.IdMenuPadre = row["IdMenuPadre"].ToString();
loMenuBean.Descripcion = row["Descripcion"].ToString();
loMenuBean.UrlImagen = row["UrlImagen"].ToString();
loMenuBean.Url = row["Url"].ToString();
loMenuBean.Codigo = row["Codigo"].ToString();
loLstMenuBean.Add(loMenuBean);
}
}
}
catch (Exception)
{
// GUARDAR EN LOG
}
return(loLstMenuBean);
}
private MenuBean loadMenu(int menuId, string user)
{
MenuBean rs = null;
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(null, con);
SqlDataReader rd = null;
cmd.CommandText = "SELECT * FROM menu M WHERE M.id=@menuId";
SqlParameter parMenuId = new SqlParameter();
parMenuId.DbType = System.Data.DbType.Int32;
parMenuId.Value = menuId;
parMenuId.ParameterName = "menuId";
cmd.Parameters.Add(parMenuId);
con.Open();
rd = cmd.ExecuteReader();
if (rd.Read())
{
rs = new MenuBean();
object objId = rd["id"];
rs.Id = (int)objId;
object objOrder = rd["order"];
rs.Order = (int)objOrder;
object objSecureLevel = rd["secure_level"];
rs.SecureLevel = (int)objSecureLevel;
object objSelectable = rd["selectable"];
int selectable = (int)objSelectable;
rs.Selectable = selectable > 0;
object objText = rd["text"];
rs.Text = objText != null ? (string)objText : "";
object objType = rd["type"];
rs.Type = (int)objType;
object objUrl = rd["url"];
rs.Url = !DBNull.Value.Equals(objUrl) ? (string)objUrl : "";
}
}
if (rs != null)
{
rs.LstSub = loadChildrens(rs.Id, user);
return(rs);
}
else
{
return(null);
}
}
private List<MenuItem> generateMenuChild(MenuBean bean)
{
List<MenuItem> lstRS = new List<MenuItem>();
if (bean != null && bean.LstSub != null && bean.LstSub.Count > 0)
{
foreach (MenuBean it in bean.LstSub)
{
MenuItem mt = new MenuItem();
mt.Text = it.Text;
mt.NavigateUrl = it.Url != null && it.Url.Trim().Length > 0 ? "~" + it.Url.Trim() : "#";
List<MenuItem> lstChild = generateMenuChild(it);
foreach (MenuItem c in lstChild)
{
mt.ChildItems.Add(c);
}
lstRS.Add(mt);
}
}
return lstRS;
}
public void ShouldThrowExceptionForNullOptionElements()
{
IMenuBean bean = new MenuBean();
bean.OptionElements = null;
}
public void ShouldNotBeEqual()
{
Mock<IWebElement> mockElementOne = new Mock<IWebElement>();
Mock<IWebElement> mockElementTwo = new Mock<IWebElement>();
IMenuBean beanOne = new MenuBean();
IMenuBean beanTwo = new MenuBean();
beanOne.ContentContainer = mockElementOne.Object;
beanTwo.ContentContainer = mockElementTwo.Object;
Assert.AreNotEqual(beanOne, beanTwo, "Beans with different container element references should not be " +
"equal");
beanTwo.ContentContainer = mockElementOne.Object;
IList<IWebElement> optionsListOne = new List<IWebElement>();
IList<IWebElement> optionsListTwo = new List<IWebElement>();
Mock<IWebElement> mockOptionElementOne = new Mock<IWebElement>();
Mock<IWebElement> mockOptionElementTwo = new Mock<IWebElement>();
optionsListOne.Add(mockOptionElementOne.Object);
optionsListTwo.Add(mockOptionElementTwo.Object);
beanOne.OptionElements = optionsListOne;
beanTwo.OptionElements = optionsListTwo;
Assert.AreNotEqual(beanOne, beanTwo, "Beans with different lists of option elements should not be equal");
beanTwo.OptionElements = optionsListOne;
beanOne.ClickOptionWithJavascript = true;
Assert.AreNotEqual(beanOne, beanTwo, "Beans with different Javascript click workaround values should not " +
"be equal");
}
public void ShouldCallBaseForToString()
{
Mock<IWebElement> mockElement = new Mock<IWebElement>();
IMenuBean bean = new MenuBean();
bean.ContentContainer = mockElement.Object;
Assert.AreEqual("MenuBean(ContentContainerBean(LoadableBean(Driver: null, LoadTimeout: 30), " +
"ContentContainer: " + mockElement.Object.ToString() + "), ClickOptionWithJavascript: False, " +
"OptionElements: System.Collections.Generic.List`1[OpenQA.Selenium.IWebElement])", bean.ToString());
}
public void ShouldCallBaseForHashCode()
{
IMenuBean bean = new MenuBean();
IMenuBean beanToCompare = new MenuBean();
Assert.AreEqual(bean.GetHashCode(), beanToCompare.GetHashCode(), "Hash codes for bean which have not had " +
"setters called should be equal, but are not: " + bean.ToString() + ", " + beanToCompare.ToString());
Mock<IWebElement> mockElement = new Mock<IWebElement>();
bean.ContentContainer = mockElement.Object;
Assert.AreNotEqual(bean.GetHashCode(), beanToCompare.GetHashCode(), "Hash codes for bean which have " +
"different values for their container element fields should not be equal, but are: " +
bean.ToString() + ", " + beanToCompare.ToString());
beanToCompare.ContentContainer = mockElement.Object;
Assert.AreEqual(bean.GetHashCode(), beanToCompare.GetHashCode(), "Hash codes for bean which have the " +
"same container element should be equal, but are not: " + bean.ToString() + ", " +
beanToCompare.ToString());
}
public void HashCodesShouldBeEqual()
{
IMenuBean beanOne = new MenuBean();
IMenuBean beanTwo = new MenuBean();
Mock<IWebElement> mockElement = new Mock<IWebElement>();
beanOne.ContentContainer = mockElement.Object;
beanTwo.ContentContainer = mockElement.Object;
Assert.AreEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "The hash codes for two beans should be " +
"equal if they have the same container element reference and same default JavaScript click " +
"workaround value");
beanOne.ClickOptionWithJavascript = true;
beanTwo.ClickOptionWithJavascript = true;
Assert.AreEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "The hash codes for two beans should be " +
"equal if they have the same container element reference and same non-default JavaScript click " +
"workaround value");
beanOne = new MenuBean();
beanTwo = new MenuBean();
beanOne.ClickOptionWithJavascript = true;
beanTwo.ClickOptionWithJavascript = true;
Assert.AreEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "The hash codes for two beans should be " +
"equal if they have null container element references and same non-default JavaScript click " +
"workaround value");
beanOne.ContentContainer = mockElement.Object;
beanTwo.ContentContainer = mockElement.Object;
List<IWebElement> optionsListOne = new List<IWebElement>();
List<IWebElement> optionsListTwo = new List<IWebElement>();
Mock<IWebElement> mockOptionElement = new Mock<IWebElement>();
beanOne.OptionElements = optionsListOne;
beanTwo.OptionElements = optionsListOne;
Assert.AreEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "The hash codes for two beans should be " +
"equal if they have the same contrainer element references and the same empty option elements list " +
"reference");
optionsListOne.Add(mockOptionElement.Object);
Assert.AreEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "The hash codes for two beans should be " +
"equal if they have the same contrainer element references and the same non-empty option elements " +
"list reference");
optionsListTwo.Add(mockOptionElement.Object);
beanTwo.OptionElements = optionsListTwo;
Assert.AreEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "The hash codes for two beans should be " +
"equal if they have the same contrainer element references and two non-empty option elements list " +
"references containing the same object");
optionsListOne = new List<IWebElement>();
optionsListTwo = new List<IWebElement>();
beanOne.OptionElements = optionsListOne;
beanTwo.OptionElements = optionsListTwo;
Assert.AreEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "The hash codes for two beans should be " +
"equal if they have the same container element and two different empty option element list references");
beanOne = new MenuBean();
beanTwo = new MenuBean();
beanOne.OptionElements = optionsListOne;
beanTwo.OptionElements = optionsListTwo;
Assert.AreEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "The hash codes for two beans should be " +
"equal if they both have null container element references and two different empty option element " +
"list references");
beanTwo.OptionElements = optionsListOne;
Assert.AreEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "The hash codes for two beans should be " +
"equal if they both have null container element references and the same empty option elements list " +
"reference");
beanTwo.OptionElements = optionsListTwo;
optionsListOne.Add(mockOptionElement.Object);
optionsListTwo.Add(mockOptionElement.Object);
Assert.AreEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "The hash codes for two beans should be " +
"equal if they both have null container element references and two non-empty option elements list " +
"references containing the same object");
}
public void ShouldBeEqual()
{
IMenuBean beanOne = new MenuBean();
IMenuBean beanTwo = new MenuBean();
Assert.AreEqual(beanOne, beanTwo, "Two newly constructed beans should be equal before any setters are " +
"invoked");
Mock<IWebElement> mockElement = new Mock<IWebElement>();
beanOne.ContentContainer = mockElement.Object;
beanTwo.ContentContainer = mockElement.Object;
Assert.AreEqual(beanOne, beanTwo, "Two beans should be equal if they have the same container element " +
"reference and same default JavaScript click workaround value");
beanOne.ClickOptionWithJavascript = true;
beanTwo.ClickOptionWithJavascript = true;
Assert.AreEqual(beanOne, beanTwo, "Two beans should be equal if they have the same container element " +
"reference and same non-default JavaScript click workaround value");
beanOne = new MenuBean();
beanTwo = new MenuBean();
beanOne.ClickOptionWithJavascript = true;
beanTwo.ClickOptionWithJavascript = true;
Assert.AreEqual(beanOne, beanTwo, "Two beans should be equal if they have null container element " +
"references and same non-default JavaScript click workaround value");
beanOne.ContentContainer = mockElement.Object;
beanTwo.ContentContainer = mockElement.Object;
List<IWebElement> optionsListOne = new List<IWebElement>();
List<IWebElement> optionsListTwo = new List<IWebElement>();
Mock<IWebElement> mockOptionElement = new Mock<IWebElement>();
beanOne.OptionElements = optionsListOne;
beanTwo.OptionElements = optionsListOne;
Assert.AreEqual(beanOne, beanTwo, "Two beans should be equal if they have the same container element " +
"references and the same empty option elements list reference");
optionsListOne.Add(mockOptionElement.Object);
Assert.AreEqual(beanOne, beanTwo, "Two beans should be equal if they have the same container element " +
"references and the same non-empty option elements list reference");
optionsListTwo.Add(mockOptionElement.Object);
beanTwo.OptionElements = optionsListTwo;
Assert.AreEqual(beanOne, beanTwo, "Two beans should be equal if they have the same container element " +
"references and two non-empty option elements list references containing the same object");
optionsListOne = new List<IWebElement>();
optionsListTwo = new List<IWebElement>();
beanOne.OptionElements = optionsListOne;
beanTwo.OptionElements = optionsListTwo;
Assert.AreEqual(beanOne, beanTwo, "Two beans should be equal if they have the same container element " +
"two different empty option element list references");
beanOne = new MenuBean();
beanTwo = new MenuBean();
beanOne.OptionElements = optionsListOne;
beanTwo.OptionElements = optionsListTwo;
Assert.AreEqual(beanOne, beanTwo, "Two beans should be equal if they both have null container element " +
"references and two different empty option element list references");
beanTwo.OptionElements = optionsListOne;
Assert.AreEqual(beanOne, beanTwo, "Two beans should be equal if they both have null container element " +
"references and the same empty option elements list reference");
beanTwo.OptionElements = optionsListTwo;
optionsListOne.Add(mockOptionElement.Object);
optionsListTwo.Add(mockOptionElement.Object);
Assert.AreEqual(beanOne, beanTwo, "Two beans should be equal if they both have null container element " +
"references and two non-empty option elements list references containing the same object");
}
public void HashCodesShouldNotBeEqual()
{
Mock<IWebElement> mockElementOne = new Mock<IWebElement>();
Mock<IWebElement> mockElementTwo = new Mock<IWebElement>();
IMenuBean beanOne = new MenuBean();
IMenuBean beanTwo = new MenuBean();
beanOne.ContentContainer = mockElementOne.Object;
beanTwo.ContentContainer = mockElementTwo.Object;
Assert.AreNotEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "Beans with different container element " +
"references should have different hash codes");
beanTwo.ContentContainer = mockElementOne.Object;
IList<IWebElement> optionsListOne = new List<IWebElement>();
IList<IWebElement> optionsListTwo = new List<IWebElement>();
Mock<IWebElement> mockOptionElementOne = new Mock<IWebElement>();
Mock<IWebElement> mockOptionElementTwo = new Mock<IWebElement>();
optionsListOne.Add(mockOptionElementOne.Object);
optionsListTwo.Add(mockOptionElementTwo.Object);
beanOne.OptionElements = optionsListOne;
beanTwo.OptionElements = optionsListTwo;
Assert.AreNotEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "Beans with different lists of option " +
"elements should have different hash codes");
beanTwo.OptionElements = optionsListOne;
beanOne.ClickOptionWithJavascript = true;
Assert.AreNotEqual(beanOne.GetHashCode(), beanTwo.GetHashCode(), "Beans with different Javascript click " +
"workaround values should have different hash codes");
}
