public Boolean ResetPassword(String account, String password)
{
string sql = @"UPDATE [user] SET [password] = '" + password + "' WHERE [account]='" + account + "'";
ContentProvider provider = ContentProvider.getInstance();
int rowAffected = provider.update(sql);
return(rowAffected > 0);
}
public static int resolve(WarnningDataSource.ErrorInfo info)
{
ContentProvider provider = ContentProvider.getInstance();
String sqlQuery = String.Format(@"SELECT [_id],[whenresolved]FROM [warnning] where level={0} ORDER BY [whenhappened] desc", info.level);
DataTable dt = provider.query(sqlQuery);
int rowAffected = 0;
foreach (DataRow row in dt.Rows)
{
string whenresolved = row["whenresolved"].ToString();
if (String.IsNullOrEmpty(whenresolved))
{
string id = row["_id"].ToString();
string sql = String.Format(@"UPDATE [warnning] SET [whenresolved]='{0}' where [_id]={1} ", DateTime.Now.ToString(), id);
rowAffected = provider.update(sql);
break;
}
}
return(rowAffected);
}
