public static int GetUserID(this IIdentity identity) { var user = ManagerViewModel.GetUsers().Where(x => x.Username.Equals(identity.Name)).FirstOrDefault(); if (user == null) { return(0); } return(user.ID); }
public static string GetWarningCount(this IIdentity identity) { var user = ManagerViewModel.GetUsers().Where(x => x.Username.Equals(identity.Name)).FirstOrDefault(); if (user != null) { return(user.WarningCount.ToString()); } return("0"); }
public static string GetVIPStatus(this IIdentity identity) { var user = ManagerViewModel.GetUsers().Where(x => x.Username.Equals(identity.Name)).FirstOrDefault(); if (user != null) { if (user.isVIP == false) { return("false"); } else { return("true"); } } return("false"); }
public static string GetVVIPStatus(this IIdentity identity) { DataTable dt = new DataTable(); var user = ManagerViewModel.GetUsers().Where(x => x.Username.Equals(identity.Name)).FirstOrDefault(); if (user != null) { using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString)) { using (MySqlCommand cmd = new MySqlCommand("GetVVIPStatus", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("user_ID", user.ID); using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { sda.Fill(dt); } } } int flag = int.Parse(dt.Rows[0].ItemArray[0].ToString()); if (user.WarningCount > 0 || !user.isVIP) { return("0"); } else if (flag == 1) { return("1"); } else { return("0"); } } return("0"); }
public ActionResult Users() { return(View(ManagerViewModel.GetUsers())); }