/// <summary>
/// checks the username and password exist in the database
/// </summary>
/// <param name="username">The username.</param>
/// <param name="password">The password.</param>
/// <returns></returns>
public int RetrieveUserCountByUsernameAndPassword(string username, string password)
{
SqlParameter[] parameters =
{
_database.MakeParameter("@Username", SqlDbType.NVarChar, 50, username),
_database.MakeParameter("@Password", SqlDbType.NVarChar, 150, password)
};
int count = _database.Scalar <int>("User_RetrieveUserCountByUsernameAndPassword", parameters);
return(count);
}
/// <summary>
/// Gets one image by photo Id
/// </summary>
/// <param name="photoId"></param>
/// <param name="procedure"></param>
/// <returns></returns>
public byte[] GetImage(int photoId, string procedure)
{
SqlParameter[] parameters =
{
_database.MakeParameter("@PhotoID", SqlDbType.Int, 4, photoId)
};
object dbImage = _database.Scalar <object>(procedure, parameters);
byte[] image = new byte[128];
//check for image bits
if (dbImage != DBNull.Value)
{
image = (byte[])dbImage;
}
return(image);
}
