internal bool DbConn() { try { using (SqlConnection dbcon = new SqlConnection(connectionstring)) { dbcon.Open(); using (SqlCommand querry = new SqlCommand("SELECT * FROM sys.Databases where Name = 'Private_Messenger'", dbcon)) { int Exist = querry.ExecuteNonQuery(); if (Exist > 0) { return(false); } else { return(true); } } } } catch (Exception) { Console.WriteLine("Something Went Wrong with DataBase"); Design.ConsoleClear(); return(false); } }
internal void UpdateUsername() { Console.WriteLine("Give me the User You want to Change his/Her Username: "******"Give me a New Username: "******"Give me Another Username"); NewUser = Console.ReadLine(); } IEnumerable <int> ID; DatabaseConnection.UsernameWithID(User, out ID); DatabaseConnection.UpdateUsernameDB(NewUser, ID); Design.ConsoleClear(); }
internal void UpdateUserPass() { Console.WriteLine("Give a Username: "); string Username = Console.ReadLine(); while (DatabaseConnection.CheckUserList(Username)) { Username = Console.ReadLine(); } DatabaseConnection.UpdateUserPassDB(Username, Password.PasswordInsert()); Design.ConsoleClear(); }
internal void DeleteUser() { Console.WriteLine("What User Do you want to Delete"); string DeletedUser = Console.ReadLine(); while (DatabaseConnection.CheckUserList(DeletedUser)) { DeletedUser = Console.ReadLine(); } DatabaseConnection.DeleteUserDB(DeletedUser); Design.ConsoleClear(); }
internal static void ShowAllUsers() { var db = new DatabaseConnection(); var users = db.SelectAllUsers() .Where(x => x.Deleted == false) .OrderBy(x => x.Role) .ToList(); foreach (var user in users) { Console.WriteLine($"{user.Role}: {user.Username}"); } Design.ConsoleClear(); }
internal static void DeleteMessage(string LogedUser) { if (DatabaseConnection.ViewForZeroMessage(LogedUser) == false) { DatabaseConnection.ViewMessageWithIdDB(LogedUser); Console.Write("Select An ID: "); int ID; CheckID(LogedUser, out ID); DatabaseConnection.DeleteMessageDB(ID); } Design.ConsoleClear(); }
internal static void ViewMessage() { Console.Clear(); Console.WriteLine("Select A User: "******"Select Again:"); user = Console.ReadLine(); } DatabaseConnection.ViewMessageWithIdDB(user); Design.ConsoleClear(); }
internal static void SendMessageDB(string UserMessage, string Sender, string Receiver) { using (SqlConnection dbcon = new SqlConnection(connectionstring)) { var NewQuerry = dbcon.Execute("insert into Messages values(@Date,@Sender, @Receiver, @UserMessage, @Deleted)", new { Date = DateTime.Now, Sender = Sender, Receiver = Receiver, UserMessage = UserMessage, Deleted = 0, }); } TxtAccess.FileCreation(Sender, Receiver, UserMessage); Console.WriteLine("\nYour Message Send Successfully"); Design.ConsoleClear(); }
internal static void EditMessage(string LogedUser) { if (DatabaseConnection.ViewForZeroMessage(LogedUser) == false) { DatabaseConnection.ViewMessageWithIdDB(LogedUser); Console.Write("Select An ID: "); int ID; CheckID(LogedUser, out ID); Console.WriteLine("Edit Message: "); string Message = Console.ReadLine(); while (Message.Length > 250) { Console.WriteLine("Your Message must Under 250 Character. Try Again ..."); Message = Console.ReadLine(); } DatabaseConnection.EditMessageDB(ID, Message); } Design.ConsoleClear(); }
internal static void RoleMenu(string logedUser) { if (DatabaseConnection.CheckUserRole(logedUser) == "Admin") { var menu = new Menus(); while (menu.AdminActionsMenu(logedUser)) { } } else if (DatabaseConnection.CheckUserRole(logedUser) == "Mod") { var menu = new Menus(); while (menu.ModActionsMenu(logedUser)) { } } else if (DatabaseConnection.CheckUserRole(logedUser) == "Loyal") { var menu = new Menus(); while (menu.LoyalActionsMenu(logedUser)) { } } else if (DatabaseConnection.CheckUserRole(logedUser) == "Friend") { var menu = new Menus(); while (menu.FriendActionsMenu(logedUser)) { } } else //if (DatabaseConnection.CheckUserRole(logedUser) == "Guest") { Console.WriteLine("Your Role is Guest ... You dont have any Role Action's"); Design.ConsoleClear(); } }
internal void UpdateUserRole() { Console.WriteLine("Which User do you want to Change his/her Role"); String Username = Console.ReadLine(); while (DatabaseConnection.CheckUserList(Username)) { Username = Console.ReadLine(); } Console.WriteLine("Select A Role:"); Console.WriteLine("Admin - Mod - Loyal - Friend - Guest"); String UserRole = Console.ReadLine(); while (UserRole != "Admin" && UserRole != "Mod" && UserRole != "Loyal" && UserRole != "Friend" && UserRole != "Guest") { Console.WriteLine("Wrong Role. Try Again"); UserRole = Console.ReadLine(); } DatabaseConnection.UpdateUserRoleDB(Username, UserRole); Design.ConsoleClear(); }
internal static void EditMessage() { Console.Clear(); string user; ViewMessageWithId(out user); Console.Write("Select An ID: "); int ID; CheckID(user, out ID); Console.WriteLine("Edit Message: "); string Message = Console.ReadLine(); while (Message.Length > 250) { Console.WriteLine("Your Message must Under 250 Character. Try Again ..."); Message = Console.ReadLine(); } DatabaseConnection.EditMessageDB(ID, Message); Design.ConsoleClear(); }
internal static void ViewMessage(string LogedUser) { DatabaseConnection.ViewMessageDB(LogedUser); Design.ConsoleClear(); }