/// <summary> /// Check the User Account /// </summary> /// <param name="username"></param> /// <returns></returns> public static Boolean UserAccountIsExist(string username) { using (DbAction db = new DbAction("connStr1")) { string sql = string.Format("select * from GoogleApp_Users_t where username='******'", username); SqlCommand cmd = new SqlCommand(sql); if (db.ExecuteScalar(cmd) != null) return true; else return false; } }
/// <summary> /// distinguish capital /// </summary> /// <param name="username"></param> /// <param name="error"></param> public static String GetUserNameInGoogleUser(string username) { using (DbAction db = new DbAction("connStr1")) { string sql = string.Format("select username from GoogleApp_Users_t where username = '******'", username); SqlCommand cmd = new SqlCommand(sql); return db.ExecuteScalar(cmd).ToString(); } }