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