|
public GetDataTable ( string sql ) : |
||
| sql | string | |
| 리턴 | ||
public static char GetProgress(String UserName)
{
//gets a useres training progress from the database
SQLiteDatabase db = new SQLiteDatabase();
DataTable rawUserData = new DataTable();
String cmd = String.Format("SELECT * from User WHERE UserName = '******'", UserName);
rawUserData = db.GetDataTable(cmd);
char retVal = char.Parse(rawUserData.Rows[0]["TrainingProgress"].ToString());
return retVal;
}
public static String GetName(String UserName)
{
//gets a users first and last name from the database
SQLiteDatabase db = new SQLiteDatabase();
DataTable rawUserData = new DataTable();
String cmd = String.Format("SELECT * from User WHERE UserName = '******'", UserName);
rawUserData = db.GetDataTable(cmd);
String retVal = rawUserData.Rows[0]["FirstName"].ToString() + " " + rawUserData.Rows[0]["LastName"].ToString();
return retVal;
}
public static List<String> GetUserNames()
{
//function that returns all user names in the database
List<String> retVal = new List<String>();
SQLiteDatabase db = new SQLiteDatabase();
DataTable rawUserData = new DataTable();
String cmd = String.Format("SELECT * from User");
rawUserData = db.GetDataTable(cmd);
foreach (DataRow r in rawUserData.Rows)
{
retVal.Add(r["UserName"].ToString());
}
return retVal;
}
public static IList<SignInfo> GetSignInfo(String UserName, char Letter)
{
//gets all of the calibrated and uncalibrated info to match a sign
IList<SignInfo> signs = new List<SignInfo>();
SQLiteDatabase db = new SQLiteDatabase();
DataTable rawSigns = new DataTable();
String cmd = String.Format("SELECT AreaPercentage, NumFingers, ClosestPoint, Area from Sign where UserName = '******' and Sign.Letter = '{1}'", UserName, Letter);
rawSigns = db.GetDataTable(cmd);
foreach (DataRow r in rawSigns.Rows)
{
double Percentage = Double.Parse(r["AreaPercentage"].ToString());
int NumFingers = Int32.Parse(r["NumFingers"].ToString());
double ClosestPoint = Double.Parse(r["ClosestPoint"].ToString());
double Area = Double.Parse(r["Area"].ToString());
signs.Add(new SignInfo(Letter, UserName, Percentage, NumFingers, ClosestPoint, Area));
}
return signs;
}
