public static bool checkUsername(String username)
{
String sql = "Select * from [User] where UserName = '******'";
DataTable dt = DAO.GetDataTable(sql);
return(dt.Rows.Count == 0 ? true : false);
}
public static int getIDMax()
{
String sql = "SELECT max(orderid) from Orders";
try
{
DataTable dt = DAO.GetDataTable(sql);
foreach (DataRow rd in dt.Rows)
{
return(int.Parse(rd[0].ToString()));
}
}catch (Exception ex)
{
return(-1);
}
return(-1);
}
public static DataTable GetAlbum(int genreid, int artistid)
{
String sql = "SELECT albumid, title, price, albumurl FROM Albums";
if (genreid != -1 && artistid != -1)
{
sql += " WHERE genreid = " + genreid + " and artistid = " + artistid;
}
else if (genreid == -1 && artistid == -1)
{
}
else if (artistid == -1)
{
sql += " WHERE genreid = " + genreid;
}
else
{
sql += " WHERE artistid = " + artistid;
}
return(DAO.GetDataTable(sql));
}
public static DataTable getAllGenres()
{
String sql = "SELECT * FROM Genres";
return(DAO.GetDataTable(sql));
}
public static DataTable getLogUser(String usn, String ps)
{
String sql = "Select * from [User] where UserName = '******' and Password = '******'";
return(DAO.GetDataTable(sql));
}
public static DataTable getAllArtist()
{
String sql = "SELECT * FROM Artists";
return(DAO.GetDataTable(sql));
}
