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