public RootForm()
{
InitializeComponent();
dh = DataBaseHandler.getInstance();
dataset = new DataSet();
cmd = new SqlCommand("SELECT * FROM [Book]; SELECT * FROM [Customer];SELECT * FROM [MusicCD];SELECT * FROM [Magazine];", connection);
adapter = new SqlDataAdapter(cmd);
adapter.Fill(dataset);
dtgBook.DataSource = dataset.Tables[0];
dtgCustomer.DataSource = dataset.Tables[1];
dtgMusicCd.DataSource = dataset.Tables[2];
dtgMagazine.DataSource = dataset.Tables[3];
dtgCustomer.SelectAll();
customerTextArray = new TextBox[] { txtCustomerName, txtAddress, txtEmail, txtUserName, txtPassword };
bookTextArray = new TextBox[] { txtBookName, txtAuthor, txtPublisher, txtPage, txtBookPrice, txtBookSale, txtBookCategory, txtBookDescription, txtImageName };
magazineTextArray = new TextBox[] { txtMagazineName, txtMagazineCategory, txtMagazinePrice, txtMagazineSale, txtIssue, txtMagazineImage, txtMagazineDescription };
musicCDTextArray = new TextBox[] { txtMusicName, txtSinger, txtMusicDescription, txtMusicPrice, txtMusicSale, txtMusicCategory, txtMusicImage, txtDemo };
btnAddBook.Enabled = false;
btnAddMagazine.Enabled = false;
btnAddMusicCD.Enabled = false;
btnBookUpdate.Enabled = false;
btnBookDelete.Enabled = false;
btnMagazineDelete.Enabled = false;
btnUpdateMagazine.Enabled = false;
btnMusicDelete.Enabled = false;
btnMusicUpdate.Enabled = false;
btnCustomerDelete.Enabled = false;
btnCustUpdate.Enabled = false;
btnBookImageChange.Enabled = false;
btnMagazinemageChange.Enabled = false;
btnMusicCDChangeImage.Enabled = false;
btnAddDemo.Enabled = false;
}
public void Refresh()
{
dataset.Clear();
dh = DataBaseHandler.getInstance();
cmd = new SqlCommand("SELECT * FROM [Book]; SELECT * FROM [Customer];SELECT * FROM [MusicCD];SELECT * FROM [Magazine];", connection);
adapter = new SqlDataAdapter(cmd);
adapter.Fill(dataset);
}
private void InvoiceForm_Load(object sender, EventArgs e)
{
using (var bitmap = new Bitmap(this.ClientSize.Width, this.ClientSize.Height))
{
Customer cust = Customer.getInstance();
this.pnlInvoice.DrawToBitmap(bitmap, new Rectangle(0, 0, bitmap.Width, bitmap.Height));
System.IO.Directory.CreateDirectory(Application.StartupPath + @"\Resources\Invoices\");
bitmap.Save(Application.StartupPath + @"\Resources\Invoices\" + cust.Username + cust.PurchCount + ".png");
cust.PurchCount++;
DataBaseHandler dh = DataBaseHandler.getInstance();
dh.CustomerUpdate(cust);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
Logger.logger("Profile Form Update");
DataBaseHandler dh = DataBaseHandler.getInstance();
cstmr.Name = txtName.Text;
cstmr.Adress = txtAddress.Text;
cstmr.Email = txtEmail.Text;
cstmr.Password = txtPassword.Text;
dh.CustomerUpdate(cstmr);
MessageBox.Show("Your profile has been updated successfully.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
private void MainForm_Load(object sender, EventArgs e)
{
panelCreator = new FactoryPanelCreator();
DataBaseHandler dh = DataBaseHandler.getInstance();
productList = new ArrayList();
booklist = dh.BookLoader();
CurrentProductList.AddRange(booklist);
musiclist = dh.MusicCDLoader();
magazinelist = dh.MagazineLoader();
productList.Add(booklist);
productList.Add(magazinelist);
productList.Add(musiclist);
cbProduct.SelectedIndex = 0;
worker.DoWork += new DoWorkEventHandler(Worker_DoWork);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(Worker_RunWorkerCompleted);
worker.ProgressChanged += Worker_ProgressChanged;
}
private void btnRoot_Click(object sender, EventArgs e)
{
Logger.logger(" Main Form Root");
DataBaseHandler dh = DataBaseHandler.getInstance();
RootForm root = new RootForm();
root.ShowDialog();
booklist.Clear();
musiclist.Clear();
magazinelist.Clear();
CurrentProductList.Clear();
booklist = dh.BookLoader();
CurrentProductList.AddRange(booklist);
musiclist = dh.MusicCDLoader();
magazinelist = dh.MagazineLoader();
productList.Clear();
productList.Add(booklist);
productList.Add(magazinelist);
productList.Add(musiclist);
btnRoot.Visible = Isroot;
cbProduct_SelectedIndexChanged(cbProduct, null);
}
private void pbLogin_Click(object sender, EventArgs e)
{
DataBaseHandler dh = DataBaseHandler.getInstance();
Customer logined = Customer.getInstance();
Customer customer = dh.CustomerHandler(txtUsername.Text, txtPassword.Text);
if (customer != null)
{
this.Hide();
logined = customer;
Logger.logger("Login");
MainForm mainform = new MainForm();
mainform.ShowDialog();
mainform = null;
GC.Collect();
txtUsername.Clear();
txtPassword.Clear();
this.Show();
}
else
{
MessageBox.Show("Wrong Username or Password.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}