public string ReturnID(string email)
{
string sql = string.Format($@"SELECT id FROM provider WHERE email = '{email}';");
DataTable dt = connection.QueryExecution(sql);
if (dt.Rows.Count == 1)
{
Console.WriteLine(dt.Rows[0]["id"].ToString());
return(dt.Rows[0]["id"].ToString());
}
else
{
return("NOT_FOUND");
}
}
public string ReturnID(string cep)
{
string sql = string.Format($@"SELECT id FROM address WHERE cep = '{cep}';");
DataTable dt = connection.QueryExecution(sql);
if (dt.Rows.Count == 1)
{
Console.WriteLine(dt.Rows[0]["id"].ToString());
return(dt.Rows[0]["id"].ToString());
}
else
{
return("NOT_FOUND");
}
}
public Boolean Authenticator(string email, string pass)
{
string sql = string.Format($@"SELECT * FROM client WHERE email = '{email}' AND password = '******';");
DataTable dt = connection.QueryExecution(sql);
if (dt.Rows.Count == 1)
{
return(true);
}
else
{
return(false);
}
}
public DataTable ConsultId(int Id)
{
string sql = string.Format($@"SELECT * FROM product WHERE id = '{Id}';");
return(connection.QueryExecution(sql));
}
public DataTable ConsultID(int id)
{
string sql = string.Format($@"SELECT * FROM category WHERE id = '{id}';");
return(connection.QueryExecution(sql));
}