//private void BtnMML_Clicked(object sender, EventArgs e)
//{
// Detail = new NavigationPage((Page)Activator.CreateInstance(typeof(Tabbed)));
// IsPresented = false;
//}
private void Lsvmenu_ItemSelected(object sender, SelectedItemChangedEventArgs e)
{
PaginaMenu pagina = e.SelectedItem as PaginaMenu;
Detail = new NavigationPage((Page)Activator.CreateInstance(pagina.Pagina));
IsPresented = false;
if (pagina.Titulo == "Logout")
{
session.Token = null;
session.Usuario = null;
session.ListaPeliculas = null;
this.Paginas();
}
}
public void Paginas()
{
this.MiMenu = new List <PaginaMenu>();
session = App.Locator.SessionService;
var home = new PaginaMenu()
{
Titulo = "Home",
Icono = "Home.png",
Pagina = typeof(Tabbed)
};
this.MiMenu.Add(home);
if (session.Token == null || session.Token == "")
{
var page1 = new PaginaMenu()
{
Titulo = "Login",
Icono = "Login.png",
Pagina = typeof(LoginView)
};
this.MiMenu.Add(page1);
}
else if (session.Usuario.NombreUsuario == "admin")
{
var perfil = new PaginaMenu()
{
Titulo = "Perfil",
Icono = "Perfil.png",
Pagina = typeof(PerfilView)
};
this.MiMenu.Add(perfil);
var lista = new PaginaMenu()
{
Titulo = "Mi lista",
Icono = "Lista.png",
Pagina = typeof(ListaPeliculasUsuario)
};
this.MiMenu.Add(lista);
var listausuarios = new PaginaMenu()
{
Titulo = "Administración",
Icono = "Usuarios.png",
Pagina = typeof(ListaUsuario)
};
this.MiMenu.Add(listausuarios);
var logout = new PaginaMenu()
{
Titulo = "Logout",
Icono = "Logout.png",
Pagina = typeof(Tabbed)
};
this.MiMenu.Add(logout);
}
else
{
var perfil = new PaginaMenu()
{
Titulo = "Perfil",
Icono = "Perfil.png",
Pagina = typeof(PerfilView)
};
this.MiMenu.Add(perfil);
var lista = new PaginaMenu()
{
Titulo = "Mi lista",
Icono = "Lista.png",
Pagina = typeof(ListaPeliculasUsuario)
};
this.MiMenu.Add(lista);
var logout = new PaginaMenu()
{
Titulo = "Logout",
Icono = "Logout.png",
Pagina = typeof(Tabbed)
};
this.MiMenu.Add(logout);
}
this.lsvmenu.ItemsSource = this.MiMenu;
Detail = new NavigationPage((Page)Activator.CreateInstance(typeof(Tabbed)));
IsPresented = false;
}
public List <PaginaMenu> Pesquisa(PaginaMenu obj)
{
List <PaginaMenu> lista = new List <PaginaMenu>();
using (SqlConnection oConnection = new SqlConnection(Conexao.DefaultConnection))
{
oConnection.Open();
using (SqlCommand oCommand = oConnection.CreateCommand())
{
oCommand.CommandText = Conexao.Owner + "usp_Pagina_Menu_Pesquisa";
oCommand.CommandType = CommandType.StoredProcedure;
#region --- Parâmetros ---
oCommand.Parameters.Clear();
oCommand.Parameters.Add(new SqlParameter()
{
ParameterName = "@acs_Id",
Direction = ParameterDirection.Input,
IsNullable = true,
SqlValue = obj.AcessoId ?? (object)DBNull.Value
});
#endregion
try
{
SqlDataReader oDr = oCommand.ExecuteReader();
while (oDr.Read())
{
PaginaMenu item = new PaginaMenu
{
MenuId = Convert.ToInt64(oDr["mnu_Id"]),
PaginaIdPai = oDr.IsDBNull(oDr.GetOrdinal("pag_IdPai")) ? null : (Int64?)Convert.ToInt64(oDr["pag_IdPai"]),
PaginaId = Convert.ToInt64(oDr["pag_Id"]),
Pagina = oDr["pag_Nome"].ToString(),
PaginaPai = oDr["pag_NomePai"].ToString(),
Menu = oDr["mnu_Nome"].ToString(),
AcessoId = oDr.IsDBNull(oDr.GetOrdinal("acs_Id")) ? null : (Int64?)Convert.ToInt64(oDr["acs_Id"]),
Action = oDr["pag_Action"].ToString(),
Controller = oDr["pag_Controller"].ToString(),
Tipo = oDr["mnu_Tipo"].ToString(),
};
lista.Add(item);
}
}
catch (SqlException ex) when(ex.Server == ".\\SQLEXPRESS")
{
Console.WriteLine("SQL Provider Error: " + ex.Message);
}
catch (Exception ex) when(ex.InnerException.ToString() == "Parameter Error")
{
Console.WriteLine("SQL Provider Error: " + ex.Message);
}
}
oConnection.Close();
}
return(lista);
}
public long?Insert(PaginaMenu obj)
{
throw new NotImplementedException();
}
public List <PaginaMenuDisponivel> ListarDisponivel(PaginaMenu obj)
{
throw new NotImplementedException();
}
public PaginaMenu Find(PaginaMenu obj)
{
throw new NotImplementedException();
}
public bool Delete(PaginaMenu obj)
{
throw new NotImplementedException();
}
public List <PaginaMenu> Search(PaginaMenu obj)
{
List <PaginaMenu> lista = new List <PaginaMenu>();
using (SqlConnection oConnection = new SqlConnection(Conexao.DefaultConnection))
{
oConnection.Open();
using (SqlCommand oCommand = oConnection.CreateCommand())
{
oCommand.CommandText = Conexao.Owner + "usp_Pagina_Menu_Search";
oCommand.CommandType = CommandType.StoredProcedure;
#region --- Parâmetros ---
oCommand.Parameters.Clear();
oCommand.Parameters.Add(new SqlParameter()
{
ParameterName = "@mnu_Id",
Direction = ParameterDirection.Input,
IsNullable = true,
SqlValue = obj.MenuId ?? (object)DBNull.Value
});
oCommand.Parameters.Add(new SqlParameter()
{
ParameterName = "@pag_Id",
Direction = ParameterDirection.Input,
IsNullable = true,
SqlValue = obj.MenuId ?? (object)DBNull.Value
});
#endregion
try
{
SqlDataReader oDr = oCommand.ExecuteReader();
while (oDr.Read())
{
PaginaMenu item = new PaginaMenu
{
MenuId = Convert.ToInt64(oDr["mnu_Id"]),
PaginaId = Convert.ToInt64(oDr["pag_Id"]),
};
lista.Add(item);
}
}
catch (SqlException ex) when(ex.Server == ".\\SQLEXPRESS")
{
Console.WriteLine("SQL Provider Error: " + ex.Message);
}
catch (Exception ex) when(ex.InnerException.ToString() == "Parameter Error")
{
Console.WriteLine("SQL Provider Error: " + ex.Message);
}
}
oConnection.Close();
}
return(lista);
}
public List <PaginaMenu> Search(PaginaMenu obj)
{
throw new NotImplementedException();
}
public List <PaginaMenu> Pesquisa(PaginaMenu obj)
{
return(_paginaMenuRepository.Pesquisa(obj));
}
