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));
}
