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