private void AddButton(object sender, RoutedEventArgs e)
{
if(CategoryName.Text == "")
{
MessageBox.Show("Please Enter A Category Name");
}
else // two cases if it already exit , else add it to database
{
sql_queries sql = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
bool found = sql.check_catagory(CategoryName.Text);
if (found)
{
MessageBox.Show("This Category is Already Exist");
}
else
{
// e3mel query y insert Category *note that how we can make the combbobox change when insertion , delete
sql.Add_catagory(CategoryName.Text);
MessageBox.Show("Category Inserted Successfully");
}
}
}
private void log_in_btn(object sender, EventArgs e)
{
sql_queries query = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
if (!query.check_username_and_password(username_login_textbox.Text, password_login_passwordbox.Password))
{
MessageBox.Show("Invalid username or password");
}
else if (username_login_textbox.Text.ToLower() == "admin")
{
Admin_Home admin_Home = new Admin_Home();
admin_Home.Show();
this.Close();
}
else
{
DataTable dt = new DataTable();
dt = query.profilename(username_login_textbox.Text);
User.profilename = dt.Rows[0]["profile_name"].ToString();
User.username = dt.Rows[0]["username"].ToString();
User.password = dt.Rows[0]["password"].ToString();
// MessageBox.Show("The username is " + User.username + " and the profilename is " + User.profilename);
Home home = new Home();
home.Show();
this.Close();
}
}
private void join(object sender, RoutedEventArgs e)
{
var btn = (Button)sender;
var x = (product)btn.Tag;
sql_queries query = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
query.delete_product(x.Id);
MessageBox.Show("Deleted Successfully");
}
private void join(object sender, RoutedEventArgs e)
{
sql_queries query = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
var btn = (Button)sender;
var x = (product)btn.Tag;
DateTime Start = Convert.ToDateTime(x.start_date);
DateTime End = Convert.ToDateTime(x.end_date);
int t1 = DateTime.Compare(Start, DateTime.Now);
int t2 = DateTime.Compare(DateTime.Now, End);
if (t1 > 0)
{
MessageBox.Show("The session didn't start yet");
}
else if (t2 < 0)
{
if (User.username == x.seller)
{
MessageBox.Show("The seller can't bid for his product ! ");
}
else
{
Session session = new Session(x.Id, x.photo, x.Title, x.Winner, x.price);
session.Show();
this.Close();
}
}
else if (t2 > 0)
{
if (x.Winner == "")
{
MessageBox.Show("No Participants !");
}
else if (x.Winner == User.username)
{
SoundPlayer soundPlayer = new SoundPlayer("app-30.wav");
soundPlayer.LoadAsync();
soundPlayer.Play();
Result res = new Result(x.photo, x.Title, x.price, x.Winner);
res.Show();
}
else
{
Result res = new Result(x.photo, x.Title, x.price, x.Winner);
res.Show();
}
}
}
public void validate_user(string new_name, string old_name, string type)
{
bool valid = true;
sql_queries query = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
for (int i = 0; i < new_name.Length; i++)
{
if (!char.IsDigit(new_name[i]) && !char.IsLetter(new_name[i]))
{
valid = false;
}
}
if (!valid)
{
MessageBox.Show("The username must contain only letters and digits !");
}
else if (new_name.Length == 0)
{
MessageBox.Show("Please enter the " + type);
}
else if (new_name.Length > 10 || new_name.Length < 5)
{
MessageBox.Show("The " + type + " must be between 5 and 10 characters");
}
else if (type == "username" && query.check_username(new_name))
{
MessageBox.Show("This username is already taken !");
}
else
{
query.update_user(new_name, old_name, type);
if (type == "username")
{
User.username = new_name;
}
else if (type == "profile_name")
{
User.profilename = new_name;
}
else
{
User.password = new_name;
}
MessageBox.Show("The " + type + " is updated successfully");
}
}
public Admin_Home()
{
InitializeComponent();
var products = GetProducts();
if (products.Count > 0)
{
Listproduct.ItemsSource = products;
}
sql_queries query = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
DataTable dt = new DataTable();
dt = query.Get_categories();
foreach (DataRow dr in dt.Rows)
{
Category_Combobox.Items.Add(dr["category_name"]);
}
}
private void Bid_Click(object sender, RoutedEventArgs e)
{
if (current_price_textbox.Text.Length == 0)
{
MessageBox.Show("Please Enter a value");
}
else if (Convert.ToDouble(current_price_textbox.Text) <= current_price)
{
MessageBox.Show("The entered price should be higher than the current price");
}
else
{
current_price = Convert.ToDouble(current_price_textbox.Text);
sql_queries query = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
query.update_top_price(current_price, Id, User.username);
}
current_price_textbox.Text = "";
}
private List <product> GetProducts()
{
DataTable dt = new DataTable();
sql_queries query = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
dt = query.Retrieve_products();
List <product> list = new List <product>();
BitmapImage bmp = new BitmapImage();
foreach (DataRow dr in dt.Rows)
{
byte[] img = null;
img = (byte[])(dr["photo"]);
BitmapImage b = new BitmapImage();
b = bytes_to_image(img);
product p = new product(Convert.ToInt32(dr["ID"]), dr["Winner"].ToString(), dr["seller"].ToString(), dr["Title"].ToString(), Convert.ToDouble(dr["price"]), b, dr["category"].ToString(), dr["start_date"].ToString(), dr["end_date"].ToString(), dr["Descriptions"].ToString());
list.Add(p);
}
return(list);
}
private void RemoveButton(object sender, RoutedEventArgs e)
{
if (UserName.Text == "")
{
MessageBox.Show("Please Enter UserName");
}
else // two cases if it not found , else remove it from database
{
sql_queries sql = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
bool found = sql.check_username(UserName.Text);
if (found) // e3mel delete query ll username
{
sql.Delete_user(UserName.Text);
MessageBox.Show("User Removed Successfully");
}
else
{
MessageBox.Show("This UserName isn't Exist");
}
}
}
private void RemoveButton(object sender, RoutedEventArgs e)
{
if (DeleteCategoryName.Text == "")
{
MessageBox.Show("Please Enter A Category Name");
}
else // two cases if exist delete else print not exist
{
sql_queries sql = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
bool found = sql.check_catagory(DeleteCategoryName.Text);
if (found) // delete
{
// e3mal query y delete el category
sql.Delete_catagory(DeleteCategoryName.Text);
sql.update_catagories(DeleteCategoryName.Text);
MessageBox.Show("Category Removed Successfully");
}
else
{
MessageBox.Show("This Category isn't Exist");
}
}
}
public void validate_signup(string username, string password, string repassword, string profilenme)
{
bool valid = true; string notvalid = "";
sql_queries query = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True");
for (int i = 0; i < username.Length; i++)
{
if (!char.IsDigit(username[i]) && !char.IsLetter(username[i]))
{
notvalid = "username";
valid = false;
}
}
for (int i = 0; i < password.Length; i++)
{
if (!char.IsDigit(password[i]) && !char.IsLetter(password[i]))
{
notvalid = "password";
valid = false;
}
}
for (int i = 0; i < profilenme.Length; i++)
{
if (!char.IsDigit(profilenme[i]) && !char.IsLetter(profilenme[i]))
{
notvalid = "profile_name";
valid = false;
}
}
if (!valid)
{
MessageBox.Show("The " + notvalid + " must contain only letters and digits !");
}
else if (username == "" || password == "" || profilenme == "")
{
MessageBox.Show("Fill the username , password and profile name first");
}
else if (password.Length > 10 || password.Length < 5)
{
MessageBox.Show("The password should be between 5 and 10 characters ");
}
else if (username.Length > 10 || username.Length < 5)
{
MessageBox.Show("The username should be between 5 and 10 characters ");
}
else if (profilenme.Length > 10 || profilenme.Length < 5)
{
MessageBox.Show("The profile name should be between 5 and 10 characters ");
}
else if (repassword.Length == 0)
{
MessageBox.Show("Confirm the password");
}
else if (repassword != password)
{
MessageBox.Show("The two password don't match !");
}
else
{
if (query.check_username(username))
{
MessageBox.Show("This username is already taken!");
}
else
{
query.insert_user_information(profilenme, username, password);
MessageBox.Show("Registrated successifly!");
Sign_in signin = new Sign_in();
MainWindow mainWindow = new MainWindow();
mainWindow.Close();
signin.Show();
}
}
}