public static DataSet EmpresaUsuarioPerfil(int emp_id)
{
DataSet ds = new DataSet();
IDbConnection objConnection;
IDbCommand objCommand;
IDataAdapter objDataDadapter;
string sql = " select pro.*, img.* " +
"from pro_produto pro " +
"inner join img_imagem img " +
"on pro.pro_id = img.pro_id " +
"where emp_id = ?emp_id;";
objConnection = Mapped.Connection();
objCommand = Mapped.Command(sql, objConnection);
objCommand.Parameters.Add(Mapped.Parameter("?emp_id", emp_id));
objDataDadapter = Mapped.adapter(objCommand);
objDataDadapter.Fill(ds);
objConnection.Close();
objCommand.Dispose();
objConnection.Dispose();
return(ds);
}
public static DataSet SelectPorCidade(string cidade)
{
DataSet ds = new DataSet();
IDbConnection objConnection;
IDbCommand objCommand;
IDataAdapter objDataDadapter;
objConnection = Mapped.Connection();
string sql = " select emp_nome_fantasia " +
"from emp_empresa emp " +
"inner join end_endereco end " +
"on emp.end_id = end.end_id " +
"inner join bai_bairro bai " +
"on bai.bai_id = end.bai_id " +
"inner join cid_cidade cid " +
"on cid.cid_id = bai.cid_id " +
"where cid.cid_nome = ?cid_nome;";
objCommand = Mapped.Command(sql, objConnection);
objCommand.Parameters.Add(Mapped.Parameter("?cid_nome", cidade));
objDataDadapter = Mapped.adapter(objCommand);
objDataDadapter.Fill(ds);
objConnection.Close();
objCommand.Dispose();
objConnection.Dispose();
return(ds);
}
public static DataSet SelectAll()
{
DataSet ds = new DataSet();
IDbConnection objConnection;
IDbCommand objCommand;
IDataAdapter objDataDadapter;
objConnection = Mapped.Connection();
string sql = "select * from bai_bairro";
objCommand = Mapped.Command(sql, objConnection);
objDataDadapter = Mapped.adapter(objCommand);
objDataDadapter.Fill(ds);
objConnection.Close();
objCommand.Dispose();
objConnection.Dispose();
return(ds);
}
public static DataSet SelectBairro(int bai_id)
{
DataSet ds = new DataSet();
IDbConnection objConnection;
IDbCommand objCommand;
IDataAdapter objDataDadapter;
objConnection = Mapped.Connection();
string sql = "select * from bai_bairro where bai_id= ?bai_id";
objCommand = Mapped.Command(sql, objConnection);
objCommand.Parameters.Add(Mapped.Parameter("?bai_id", bai_id));
objDataDadapter = Mapped.adapter(objCommand);
objDataDadapter.Fill(ds);
objConnection.Close();
objCommand.Dispose();
objConnection.Dispose();
return(ds);
}
public static DataSet SelectID(int img_id)
{
DataSet ds = new DataSet();
IDbConnection objConnection;
IDbCommand objCommand;
IDataAdapter objDataDadapter;
objConnection = Mapped.Connection();
string sql = "select * from img_imagem where img_id= ?img_id";
objCommand = Mapped.Command(sql, objConnection);
objCommand.Parameters.Add(Mapped.Parameter("?img_id", img_id));
objDataDadapter = Mapped.adapter(objCommand);
objDataDadapter.Fill(ds);
objConnection.Close();
objCommand.Dispose();
objConnection.Dispose();
return(ds);
}
public static DataSet SelectCid(int cid_id)
{
DataSet ds = new DataSet();
IDbConnection objConnection;
IDbCommand objCommand;
IDataAdapter objDataDadapter;
objConnection = Mapped.Connection();
string sql = "select * from cid_cidade inner join est_estado e using (est_id) where cid_id = ?cid_id";
objCommand = Mapped.Command(sql, objConnection);
objCommand.Parameters.Add(Mapped.Parameter("?cid_id", cid_id));
objDataDadapter = Mapped.adapter(objCommand);
objDataDadapter.Fill(ds);
objConnection.Close();
objCommand.Dispose();
objConnection.Dispose();
return(ds);
}
public static DataSet SelectEndereco(int cli_id)
{
DataSet ds = new DataSet();
IDbConnection objConnection;
IDbCommand objCommand;
IDataAdapter objDataDadapter;
objConnection = Mapped.Connection();
string sql = "select * from cle_cliente_endereco where cli_id = ?cli_id";
objCommand = Mapped.Command(sql, objConnection);
objCommand.Parameters.Add(Mapped.Parameter("?cli_id", cli_id));
objDataDadapter = Mapped.adapter(objCommand);
objDataDadapter.Fill(ds);
objConnection.Close();
objCommand.Dispose();
objConnection.Dispose();
return(ds);
}
public static DataSet SelectLogin(string email, string pwd)
{
DataSet ds = new DataSet();
IDbConnection objConnection;
IDbCommand objCommand;
IDataAdapter objDataDadapter;
objConnection = Mapped.Connection();
string sql = "select * from cli_cliente where cli_email = ?cli_email and cli_senha = ?cli_senha";
objCommand = Mapped.Command(sql, objConnection);
objCommand.Parameters.Add(Mapped.Parameter("?cli_email", email));
objCommand.Parameters.Add(Mapped.Parameter("?cli_senha", pwd));
objDataDadapter = Mapped.adapter(objCommand);
objDataDadapter.Fill(ds);
objConnection.Close();
objCommand.Dispose();
objConnection.Dispose();
return(ds);
}