public static TeleUser GetTeleUser(string user_login, string tag_caption) { TeleUser res = null; //если у пользователя нет такого тега, то вернуть null var RegisteredTags = GetUserTags(user_login); if (!RegisteredTags.Any(x => x.TAG_CAPTION.Equals(tag_caption, StringComparison.InvariantCultureIgnoreCase))) { return(res); } using (var con = new SqlConnection(AppConst.ConnStr)) { using (var cmd = new SqlCommand("SELECT * FROM APPUSER WHERE LOWER(USER_LOGIN)=@user_login", con)) { cmd.Parameters.AddWithValue("@user_login", user_login.ToLower()); try { con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); res = new TeleUser() { USER_ID = Convert.ToInt32(rdr["USER_ID"]), TagCaption = tag_caption, USER_LASTNAME = Convert.ToString(rdr["USER_LASTNAME"]), USER_FIRSTNAME = Convert.ToString(rdr["USER_FIRSTNAME"]), USER_PATR = Convert.ToString(rdr["USER_PATR"]), USER_EMAIL = Convert.ToString(rdr["USER_EMAIL"]), USER_LOGIN = Convert.ToString(rdr["USER_LOGIN"]), USER_PHONE = Convert.ToString(rdr["USER_PHONE"]) }; } rdr.Close(); con.Close(); } catch { } } } return(res); }
/// <summary> /// Получить информацию о пользователе и хэштеге по запросу с Telegram /// </summary> public JsonResult GetTeleUser(string user_login, string tag_caption) { TeleUser user = UserManager.GetTeleUser(user_login, tag_caption); return(Json(user, JsonRequestBehavior.AllowGet)); }