static public DataTable recieveUserDataByUserName(string username)
{
Classes.DataBase db = new Classes.DataBase();
string strSQL = "SELECT * FROM users WHERE username=@username";
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@username",
SqlDbType = SqlDbType.VarChar,
Value = username
},
};
DataTable data = db.recieveSQL(strSQL, parameters);
return(data);
}
static public DataTable recieveUserDataByEmail(string email)
{
Classes.DataBase db = new Classes.DataBase();
string strSQL = "SELECT * FROM users WHERE email=@email";
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@email",
SqlDbType = SqlDbType.VarChar,
Value = email
},
};
DataTable data = db.recieveSQL(strSQL, parameters);
return(data);
}
static public DataTable recieveUserDataByID(int id)
{
Classes.DataBase db = new Classes.DataBase();
string strSQL = "SELECT * FROM users WHERE iduser=@iduser";
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@iduser",
SqlDbType = SqlDbType.Int,
Value = id
},
};
DataTable data = db.recieveSQL(strSQL, parameters);
return(data);
}
static public DataTable recieveCategoryByName(string name)
{
Classes.DataBase db = new Classes.DataBase();
string strSQL = "SELECT * FROM categoriesfsa WHERE name=@name";
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@name",
SqlDbType = SqlDbType.VarChar,
Value = name
},
};
DataTable data = db.recieveSQL(strSQL, parameters);
return(data);
}