public static bool Autenticar2(string usuario, string password)
{
#region CONEXION BASE DE DATOS
string conn1 = System.Configuration.ConfigurationManager.ConnectionStrings["bddComprobantesConnectionString"].ConnectionString;
Data_bddComprobantesDataContext dc = new Data_bddComprobantesDataContext();
#endregion
bool pasa = false;
DateTime fecha = Convert.ToDateTime("09/09/2017");
string contrasena = Helper.EncodePassword(string.Concat(usuario, password));
var cAutentico = dc.sp_abmUsuario("AUTENTICAR", 0, 0, "", "", "", "", "", usuario, contrasena, "", fecha, 0, false, "", false);
if (cAutentico.Count() <= 0)
{
pasa = false;
}
else
{
pasa = true;
}
return(pasa);
}
public static bool calificarOpcion(string accion, string grupo, string menu, string submenu, string boton)
{
#region CONEXION BASE DE DATOS
string conn1 = System.Configuration.ConfigurationManager.ConnectionStrings["bddComprobantesConnectionString"].ConnectionString;
Data_bddComprobantesDataContext dc = new Data_bddComprobantesDataContext();
#endregion
bool califica = false;
using (SqlConnection conexion = new SqlConnection(conn1))
{
SqlCommand cmd = new SqlCommand("sp_CalificarOpcion", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@accion", accion);
cmd.Parameters.AddWithValue("@grupo", grupo);
cmd.Parameters.AddWithValue("@menu", menu);
cmd.Parameters.AddWithValue("@submenu", submenu);
cmd.Parameters.AddWithValue("@boton", boton);
try
{
conexion.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//while(rdr.Read()) // En caso de que exista varios valores de retorno sin usar DataTable
// {
//califica = rdr.GetInt32(rdr.GetOrdinal("sp_CalificaOpcion"));
if (rdr.HasRows)
{
rdr.Read();
califica = rdr.GetBoolean(0);
}
conexion.Close();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
return(califica);
}
}
