public static SignupUser GetSignupUser(SignupUser user) { using (SqlConnection sqlCon = con) { sqlCon.Open(); SqlCommand cmd = new SqlCommand("GetSignupUser", sqlCon); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Username", user.Username); cmd.Parameters.AddWithValue("@Password", SharedSupport.MD5Encrypt(user.Password)); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); return(new SignupUser { Id = Convert.ToInt32(dr[1]), Username = dr[2].ToString(), Gender = dr[4].ToString(), Age = Convert.ToInt32(dr[5]), }); } } return(null); }
public static bool AddNewMod(Mod mod) { using (SqlConnection sqlCon = con) { sqlCon.Open(); SqlCommand cmd = new SqlCommand("AddNewMod", sqlCon); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Username", mod.Username); cmd.Parameters.AddWithValue("@Password", SharedSupport.MD5Encrypt(mod.Password)); return(Convert.ToInt32(cmd.ExecuteScalar()) == 1 ? true : false); } }
public static bool SignupNewUser(SignupUser user) { using (SqlConnection sqlCon = con) { sqlCon.Open(); SqlCommand cmd = new SqlCommand("SignupNewUser", sqlCon); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", user.Id); cmd.Parameters.AddWithValue("@Username", user.Username); cmd.Parameters.AddWithValue("@Password", SharedSupport.MD5Encrypt(user.Password)); cmd.Parameters.AddWithValue("@Gender", user.Gender); cmd.Parameters.AddWithValue("@Age", user.Age); return(Convert.ToInt32(cmd.ExecuteScalar()) == 1 ? true : false); } }
public static bool ValidateMod(Mod mod) { using (SqlConnection sqlCon = con) { sqlCon.Open(); SqlCommand cmd = new SqlCommand("ValidateMod", sqlCon); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Username", mod.Username); cmd.Parameters.AddWithValue("@Password", SharedSupport.MD5Encrypt(mod.Password)); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { return(true); } } return(false); }
public static void DeleteSignedOffUsers(Object source, System.Timers.ElapsedEventArgs e) { IEnumerable <ChatUser> users = GetUsers(); List <string> bots = new List <string>() { "AaShQii", "Aliza", "AmirJoya", "Ayaan", "Baazigarr", "BholaBacha", "Blood_Seeker", "Diyyaa", "Eman", "FireCracker", "GreeN-Eyes", "Hamza26", "Iffi", "James", "Jazib", "JDee", "JohnSnow", "Khanaa", "Khoobsoorat", "King_of_Hrtzz", "LalaGujjar", "MamooJaan", "Manal", "Mubeen", "Mystic", "Namaloom", "Neha", "Peshawar_Man", "RaffatKhan", "Sara", "SarfarazJutt", "StevePapp", "Zain", "Uzair", "GaNdA_BaChA", "Dewana", "Bilal25", "Sehrish", "SpiderBoy", "Shahzad_akram" }; if (users != null) { foreach (var item in users) { if (bots.Where(x => x == item.Username).Count() == 0 && item.ConnectTime < DateTime.UtcNow.AddHours(5).AddMinutes(-20)) { if (DeleteUser(item.Username)) { if (!string.IsNullOrEmpty(item.Photo)) { string image = SharedSupport.GetImageFolderPath() + item.Username + item.Photo.Substring(item.Photo.LastIndexOf(".")); if (System.IO.File.Exists(image)) { System.IO.File.Delete(image); } } IHubContext hubContext = GlobalHost.ConnectionManager.GetHubContext <Chat>(); hubContext.Clients.AllExcept(item.ConnectionId).userLeft(item.Username); hubContext.Clients.All.totalUsers(DBSupport.GetUsersCount()); hubContext.Clients.Client(item.ConnectionId).forceDisconnect(); hubContext.Clients.All.dcUserSessions(item.Username); } } } } }