public static ViewMesaModel VerificaMesa(string mesa) { ViewMesaModel ret = null; using (var conexao = new SqlConnection()) { conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString; conexao.Open(); using (var comando = new SqlCommand()) { comando.Connection = conexao; comando.CommandText = "select mes_descricao from mesa where (mes_descricao = @mesa)"; comando.Parameters.Add("@mesa", SqlDbType.Int).Value = mesa; var reader = comando.ExecuteReader(); if (reader.Read()) { return(ret); //aqui você colocaria a pagina na qual vai redirecionar caso o usuário exista... } //SENÃO NÃO ENTRA else { return(null); } } } }
public static ViewMesaModel RecuperarPeloId(int id) { ViewMesaModel ret = null; using (var conexao = new SqlConnection()) { conexao.ConnectionString = ConfigurationManager.ConnectionStrings["principal"].ConnectionString; conexao.Open(); using (var comando = new SqlCommand()) { comando.Connection = conexao; comando.CommandText = "select * from mesa where (mes_id = @id)"; comando.Parameters.Add("@id", SqlDbType.Int).Value = id; var reader = comando.ExecuteReader(); if (reader.Read()) { ret = new ViewMesaModel { MesaId = (int)reader["mes_id"], MesaNome = (string)reader["mes_descricao"], MesaAtivo = (bool)reader["mes_ativo"] }; } } } return(ret); }