public bool LoginUser(String userName, String userPassword)
{
bool ret = false;
string sql = @"SELECT
UserGUID
,FirstName
,LastName
,UserName
,UserPassword
FROM User
WHERE UserName = @UserName AND UserPassword = @UserPassword";
List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>();
paramList.Add(new SQLiteParameter("@UserName", userName));
paramList.Add(new SQLiteParameter("@UserPassword", GlobalVariables.GetMD5(userPassword)));
NGSConnector connector = new NGSConnector();
SQLiteDataReader reader = connector.execSQLWithResult(sql, paramList);
if (reader.HasRows)
{
ret = true;
FillData(reader);
}
return(ret);
}
public void SavePassword(string userGUID, string userPassword)
{
string sql = @"UPDATE User
SET UserPassword = @UserPassword
WHERE UserGUID = @UserGUID";
List <System.Data.SQLite.SQLiteParameter> paramList = new List <System.Data.SQLite.SQLiteParameter>();
paramList.Add(new SQLiteParameter("@UserGUID", userGUID));
paramList.Add(new SQLiteParameter("@UserPassword", GlobalVariables.GetMD5(userPassword)));
NGSConnector connector = new NGSConnector();
connector.execSQL(sql, paramList);
}