private void DeleteToolStripMenuItem1_Click(object sender, EventArgs e)
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
database.deleteData("customerID=" + Id, "MusteriBilgileriTablosu");
dataRefresh();
}
private void DeleteToolStripMenuItem_Click(object sender, EventArgs e)
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
database.dataUpdate("userAuthorization", "0", "MusteriBilgileriTablosu", "customerID=" + Id);
dataRefresh();
}
private void AdminForm_Activated(object sender, EventArgs e)
{
VeritabaniIslemleri dosya = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
kaynakTablo = dosya.veriCek("*", "UrunlerTablosu");
dgvUrunler.DataSource = kaynakTablo;
}
/// <summary>
/// the constructor to create invoice from database
/// </summary>
/// <param name="dataTable"> products </param>
/// <param name="dataRow"> shopingcard </param>
public PaymentDatailControl(DataTable dataTable, DataRow dataRow)
{
InitializeComponent();
lbDate.Text = "Date : " + (dataRow[3]).ToString();
lbInvoiceID.Text = "Invoice Id : " + dataRow[1].ToString();
lbOrderName.Text = "To : " + MainForm.user.Name.ToString() + " " + MainForm.user.Surname;
foreach (DataRow row in dataTable.Rows)
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string query = "select * from UrunlerTablosu where productId = " + row[1];
DataTable table = database.veriCek(query);
ListViewItem lvi = new ListViewItem();
string s = (table.Rows[0])[1].ToString();
lvi.SubItems.Add(s);
s = row[3].ToString();
lvi.SubItems.Add(s);
s = row[4].ToString();
lvi.SubItems.Add(s);
lwproductlist.Items.Add(lvi);
lbShip.Text = "Shipment : " + (Convert.ToDouble(dataRow[5])).ToString("0.##");
lbtotal.Text = "Total : " + (Convert.ToDouble(dataRow[2])).ToString("0.##");
}
txtbxAdress.Text = dataRow[6].ToString();
}
private void TbAra_TextChanged(object sender, EventArgs e)
{
pnlSearch.Controls.Clear();
DataTable dt = new DataTable();
pnlSearch.Visible = true;
string aranan = tbAra.Text;
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
dt = database.veriCek("SELECT * FROM UrunlerTablosu WHERE productName LIKE '%" + tbAra.Text + "%' AND visibility = 1");
Point p = new Point();
p.Y = 0;
p.X = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
LinkLabel lbl = new LinkLabel();
lbl.Text = dt.Rows[i]["productName"].ToString(); // + " " + dt.Rows[i]["productPrice"].ToString() + " " + dt.Rows[i]["productSale"].ToString();
lbl.Location = p;
p.Y += lbl.Height;
pnlSearch.Controls.Add(lbl);
lbl.Name = dt.Rows[i][0].ToString();
lbl.AutoSize = true;
lbl.Visible = true;
lbl.Click += new System.EventHandler(this.LinkLabel_Click);
}
}
/// <summary>
/// it updates the customer information.
/// </summary>
public void saveCustomer()
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string query = "update MusteriBilgileriTablosu set customerName = '" + Name + "', customerSurname = '" + Surname + "', customerAdress='" + Adress + "', customerEmail='" + Email + "', userName = '******', userPassword = '******' where customerID=" + UserID;
database.veriKaydet(query);
}
/// <summary>
/// dergi için resim seçen metot
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void LblSelectImage_Click(object sender, EventArgs e)
{
OpenFileDialog file = new OpenFileDialog();
file.Filter = "resim dosyası | *.png|resim dosyası | *.jpeg";
file.FilterIndex = 1;
//file.Multiselect = true;
if (file.ShowDialog() == DialogResult.OK)
{
filePath = file.FileName;
Bitmap bitmap = new Bitmap(filePath);
SaveFileDialog saveFile = new SaveFileDialog();
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string maxId = null;
try
{
DataTable maxIdtTable = database.veriCek("SELECT Max(productId) FROM UrunlerTablosu");
maxId = (Convert.ToInt32(maxIdtTable.Rows[0][0]) + 1).ToString();
}
catch (Exception)
{
if (maxId == null)
{
maxId = 1.ToString();
}
}
saveFile.FileName = @"ProductPhotos\magazine_" + maxId + ".png";
bitmap.Save(saveFile.FileName);
pbProductImage.ImageLocation = saveFile.FileName;
pbProductImage.Visible = true;
filePath = saveFile.FileName;
}
}
private void dataRefresh()
{
VeritabaniIslemleri dosya = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
kaynakTablo = dosya.veriCek("*", "MusteriBilgileriTablosu");
dgvUserInformation.DataSource = kaynakTablo;
}
public static VeritabaniIslemleri bagOlustur(string veritabaniAdi)
{
baglanti = new SqlConnection("Data Source=.; Initial Catalog=" + veritabaniAdi + "; Integrated Security=true");
if (nesne == null)
{
nesne = new VeritabaniIslemleri();
}
return(nesne);
}
public void upload()
{
flytbBook.Controls.Clear();
flytbMusic.Controls.Clear();
flytbMagazine.Controls.Clear();
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
int i = 0;
string query = "select * from UrunlerTablosu where productType = 1 and visibility= 1";
DataTable table = database.veriCek(query);
foreach (DataRow item in table.Rows)
{
Product book = addNewProductFromDatabase.CreateNewItem(item);
BookControl cont = new BookControl((Book)book, mainform.shoppingCard);
flytbBook.Controls.Add(cont);
i++;
if (i == 6)
{
break;
}
}
pctrbxsitephoto.Image = new Bitmap("kitap" + (pictureindex % 3 + 1).ToString() + ".jpg");
query = "select * from UrunlerTablosu where productType = 2 and visibility= 1";
table = database.veriCek(query);
i = 0;
foreach (DataRow item in table.Rows)
{
Product music = addNewProductFromDatabase.CreateNewItem(item);
MusicCdControl cont = new MusicCdControl((MusicCD)music, mainform.shoppingCard);
flytbMusic.Controls.Add(cont);
i++;
if (i == 6)
{
break;
}
}
query = "select * from UrunlerTablosu where productType = 3 and visibility= 1";
table = database.veriCek(query);
i = 0;
foreach (DataRow item in table.Rows)
{
Product magazine = addNewProductFromDatabase.CreateNewItem(item);
MagazineControl cont = new MagazineControl((Magazine)magazine, mainform.shoppingCard);
flytbMagazine.Controls.Add(cont);
i++;
if (i == 6)
{
break;
}
}
}
private void LinkLabel_Click(object sender, EventArgs e)
{
LinkLabel lLbl = ((LinkLabel)sender);
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
DataTable table = database.veriCek("select * from UrunlerTablosu WHERE productId = " + lLbl.Name);
try
{
Product product = addNewProductFromDatabase.CreateNewItem(table.Rows[0]);
product.printProperties();
}
catch { }
}
/// <summary>
/// it shows the details of the given id
/// </summary>
/// <param name="PruchaseID"> to find purchase from database </param>
public PurchasesForm(string PruchaseID)
{
InitializeComponent();
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string query = "select * from ShoppingCartTable where siparisId = '" + PruchaseID + "'";
DataTable table = database.veriCek(query);
DataRow row = table.Rows[0];
query = "select * from SepetTablosu where siparisId = '" + row[1] + "'";
DataTable tabledetails = database.veriCek(query);
PaymentDatailControl control = new PaymentDatailControl(tabledetails, row);
flpdetails.Controls.Add(control);
}
/// <summary>
/// it refresh the main form after a form opened
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void MainForm_Activated(object sender, EventArgs e)
{
if (user != null)
{
bttnUserName.Text = user.Name;
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
DataTable authorizationTable = database.veriCek("SELECT userAuthorization FROM MusteriBilgileriTablosu WHERE customerID =" + user.UserID);
authorizationDegre = authorizationTable.Rows[0][0].ToString();
}
this.updateShoppingCart();
if (authorizationDegre == "1")
{
btnAdminPaneli.Visible = true;
}
}
/// <summary>
/// it records the log info
/// </summary>
/// <param name="formname"> form name to record </param>
/// <param name="bttnname"> button name to record </param>
public override void record(string formname, string bttnname)
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string query = "";
if (MainForm.user != null)
{
query = "INSERT INTO logtablosu (formName,buttonName,UserID,Date) VALUES('" + formname + "','" + bttnname + "', " + MainForm.user.UserID + " ,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')";
}
else
{
query = "INSERT INTO logtablosu (formName,buttonName,UserID,Date) VALUES('" + formname + "','" + bttnname + "', " + 0 + " ,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')";
}
database.veriKaydet(query);
}
/// <summary>
/// güncellenecek olan verinin bilgilerini forma yükleyen metot
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void MagazineUpdateForm_Load(object sender, EventArgs e)
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
dgvMagazineUpdate.DataSource = database.veriCek("SELECT * FROM UrunlerTablosu WHERE productId=" + productId);
tbId.Text = dgvMagazineUpdate.Rows[0].Cells["productId"].Value.ToString();
tbName.Text = dgvMagazineUpdate.Rows[0].Cells["productName"].Value.ToString();
tbPrice.Text = dgvMagazineUpdate.Rows[0].Cells["productPrice"].Value.ToString();
tbDescription.Text = dgvMagazineUpdate.Rows[0].Cells["productDescription"].Value.ToString();
tbSale.Text = dgvMagazineUpdate.Rows[0].Cells["productSale"].Value.ToString();
filePath = dgvMagazineUpdate.Rows[0].Cells["productImage"].Value.ToString();
pbProductImage.ImageLocation = dgvMagazineUpdate.Rows[0].Cells["productImage"].Value.ToString();
pbProductImage.Visible = true;
dgvMagazineUpdate.DataSource = database.veriCek("SELECT * FROM MagazineBilgileriTablosu WHERE productId=" + productId);
tbIssue.Text = dgvMagazineUpdate.Rows[0].Cells["productIssue"].Value.ToString();
cmbCdType.SelectedIndex = Convert.ToInt32(dgvMagazineUpdate.Rows[0].Cells["productType"].Value);
}
/// <summary>
/// it lists previous purchases
/// </summary>
public PurchasesForm()
{
InitializeComponent();
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string query = "select * from ShoppingCartTable where CustomerId = " + MainForm.user.UserID.ToString();
DataTable table = database.veriCek(query);
foreach (DataRow row in table.Rows)
{
if (row[1].ToString() != "none")
{
query = "select * from SepetTablosu where siparisId = '" + row[1] + "'";
DataTable tabledetails = database.veriCek(query);
PaymentDatailControl control = new PaymentDatailControl(tabledetails, row);
flpdetails.Controls.Add(control);
}
}
}
/// <summary>
/// when filter is activated it works.
/// </summary>
/// <param name="type"> the product type </param>
public void pnlShowClear(string type)
{
pnlShow.Controls.Clear();
FlowLayoutPanel panel = new FlowLayoutPanel();
//p.Controls.Add(panel);
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
if (type == "Book") //it list the products which are books
{
string query = "select * from UrunlerTablosu where productType = 1 AND visibility = 1 ";
DataTable table = database.veriCek(query);
foreach (DataRow item in table.Rows)
{
Product book = addNewProductFromDatabase.CreateNewItem(item); //factory pattern
BookControl cont = new BookControl((Book)book, shoppingCard);
pnlShow.Controls.Add(cont);
}
}
else if (type == "Music") //it list the products which are music
{
string query = "select * from UrunlerTablosu where productType = 2 AND visibility = 1 ";
DataTable table = database.veriCek(query);
foreach (DataRow item in table.Rows)
{
Product music = addNewProductFromDatabase.CreateNewItem(item); //factory pattern
MusicCdControl cont = new MusicCdControl((MusicCD)music, shoppingCard);
pnlShow.Controls.Add(cont);
}
}
else if (type == "Magazine") //it list the products which are books
{
string query = "select * from UrunlerTablosu where productType = 3 AND visibility = 1 ";
DataTable table = database.veriCek(query);
foreach (DataRow item in table.Rows)
{
Product magazine = addNewProductFromDatabase.CreateNewItem(item); //factory pattern
MagazineControl cont = new MagazineControl((Magazine)magazine, shoppingCard);
pnlShow.Controls.Add(cont);
}
}
}
/// <summary>
/// when the user wants to log out
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bttnlogout_Click(object sender, EventArgs e)
{
Program.NotifyObserver(this.Name, ((Button)sender).Name);
try
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string query = "";
for (int i = 0; i < shoppingCard.items.Count; i++)
{
query = "insert into SepetTablosu (customerId,urunId,siparisId,urunAdedi ) values(" + user.UserID + "," + shoppingCard.items.ElementAt(i).Value.product.Id + " ,'none' ," + shoppingCard.items.ElementAt(i).Value.quantity + " )";
database.veriKaydet(query);
}
}
catch
{ }
user = null;
pnlUserNameClicked.Visible = false;
bttnUserName.Text = "Sign In";
shoppingCard.cancelOrder();
btnAdminPaneli.Visible = false;
this.MainForm_Activated(this, new EventArgs());
}
/// <summary>
/// kitap güncelleme ekranını açan ve açarken de ilgili ürünün bilgilerini yazan metot
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BookUpdateForm_Load(object sender, EventArgs e)
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
dgvBookUpdate.DataSource = database.veriCek("SELECT * FROM UrunlerTablosu WHERE productId=" + productId);
tbId.Text = dgvBookUpdate.Rows[0].Cells["productId"].Value.ToString();
tbName.Text = dgvBookUpdate.Rows[0].Cells["productName"].Value.ToString();
tbPrice.Text = dgvBookUpdate.Rows[0].Cells["productPrice"].Value.ToString();
tbDescription.Text = dgvBookUpdate.Rows[0].Cells["productDescription"].Value.ToString();
tbSale.Text = dgvBookUpdate.Rows[0].Cells["productSale"].Value.ToString();
pbProductImage.ImageLocation = dgvBookUpdate.Rows[0].Cells["productImage"].Value.ToString();
filePath = dgvBookUpdate.Rows[0].Cells["productImage"].Value.ToString();
pbProductImage.Visible = true;
dgvBookUpdate.DataSource = database.veriCek("SELECT * FROM KitapBilgileriTablosu WHERE productId=" + productId);
tbAuthor.Text = dgvBookUpdate.Rows[0].Cells["productAuthor"].Value.ToString();
tbIsbn.Text = dgvBookUpdate.Rows[0].Cells["isbn"].Value.ToString();
tbPublisher.Text = dgvBookUpdate.Rows[0].Cells["publisher"].Value.ToString();
tbPage.Text = dgvBookUpdate.Rows[0].Cells["page"].Value.ToString();
tbSize.Text = dgvBookUpdate.Rows[0].Cells["size"].Value.ToString();
cmbBookType.SelectedIndex = Convert.ToInt32(dgvBookUpdate.Rows[0].Cells["type"].Value);
cmbBoxLanguage.SelectedIndex = Convert.ToInt32(dgvBookUpdate.Rows[0].Cells["language"].Value);
}
/// <summary>
/// when this button clicked,
/// if user == null the login page appear
/// else the pnlUserNameClicked appear or vice versa
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bttnUserName_Click(object sender, EventArgs e)
{
Program.NotifyObserver(this.Name, ((Button)sender).Name);
if (user == null)
{
LoginForm login = new LoginForm();
DialogResult result = login.ShowDialog();
if (result == DialogResult.Yes)
{
bttnUserName.Text = user.Name;
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string query = "select * from SepetTablosu where customerId = " + user.UserID + " and siparisId = 'none'";
DataTable table = database.veriCek(query);
foreach (DataRow item in table.Rows)
{
query = "select * from UrunlerTablosu where productId = '" + item[1].ToString() + "'";
DataTable tablee = database.veriCek(query);
shoppingCard.addProduct(new ItemToPurchase(addNewProductFromDatabase.CreateNewItem(tablee.Rows[0]), Convert.ToInt32(item[3])));
}
query = "delete from SepetTablosu where customerId = " + user.UserID + " and siparisId = 'none'";
database.veriKaydet(query);
query = "delete from ShoppingCartTable where CustomerId = " + user.UserID + " and siparisId = 'none'";
database.veriKaydet(query);
}
}
else
{
if (pnlUserNameClicked.Visible == false)
{
pnlUserNameClicked.Visible = true;
}
else
{
pnlUserNameClicked.Visible = false;
}
}
this.MainForm_Activated(this, new EventArgs());
}
public DataTable deleteData(string productType, string productId)
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
if (productType == "1")
{
database.deleteData("productId=" + productId, "kitapBilgileriTablosu");
}
else if (productType == "2")
{
database.deleteData("productId=" + productId, "CdBilgileriTablosu");
}
else if (productType == "3")
{
database.deleteData("productId=" + productId, "MagazineBilgileriTablosu");
}
else
{
System.Windows.Forms.MessageBox.Show("invalid product type");
}
database.deleteData("productId=" + productId, "UrunlerTablosu");
return(database.veriCek("SELECT * FROM UrunlerTablosu"));
}
/// <summary>
/// it works when form closing.
/// if user != null it records the items in the shoping card in database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void MainForm_FormClosing(object sender, FormClosingEventArgs e)
{
//try
//{
// VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
// for (int i = 0; i <= shoppingCard.items.Count; i++)
// {
// string query = "insert into ShoppingCartTable (CustomerId,siparisId) values(" + user.UserID + ",'none')";
// database.veriKaydet(query);
// query = "insert into SepetTablosu (customerId,urunId,siparisId,urunAdedi ) values(" + user.UserID + "," + shoppingCard.items.ElementAt(i).Value.product.Id + " ,'none' ," + shoppingCard.items.ElementAt(i).Value.quantity + " )";
// database.veriKaydet(query);
// }
//}
//catch
//{
//}
Program.NotifyObserver(this.Name, "formclosing");
try
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string query = "";
for (int i = 0; i < shoppingCard.items.Count; i++)
{
query = "insert into SepetTablosu (customerId,urunId,siparisId,urunAdedi ) values(" + user.UserID + "," + shoppingCard.items.ElementAt(i).Value.product.Id + " ,'none' ," + shoppingCard.items.ElementAt(i).Value.quantity + " )";
database.veriKaydet(query);
}
}
catch
{ }
user = null;
pnlUserNameClicked.Visible = false;
bttnUserName.Text = "Sign In";
shoppingCard.cancelOrder();
btnAdminPaneli.Visible = false;
}
/// <summary>
/// it is using to change users information
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bttnSignUp_Click(object sender, EventArgs e)
{
Program.NotifyObserver(this.Name, ((Button)sender).Name);
if (bttnSignUp.Text == "Changes")
{
txtbxName.Text = user.Name;
txtbxSurname.Text = user.Surname;
txtbxUserName.Text = user.Username;
txtbxAdress.Text = user.Adress;
txtbxMail.Text = user.Email;
txtbxPassWord.Text = user.Password;
txtbxName.Enabled = true;
txtbxName.BackColor = Color.White;
txtbxName.ForeColor = Color.Black;
txtbxSurname.Enabled = true;
txtbxSurname.BackColor = Color.White;
txtbxSurname.ForeColor = Color.Black;
txtbxUserName.Enabled = true;
txtbxUserName.BackColor = Color.White;
txtbxUserName.ForeColor = Color.Black;
txtbxAdress.Enabled = true;
txtbxAdress.BackColor = Color.White;
txtbxAdress.ForeColor = Color.Black;
txtbxMail.Enabled = true;
txtbxMail.BackColor = Color.White;
txtbxMail.ForeColor = Color.Black;
lbPassWord.Visible = true;
txtbxPassWord.Visible = true;
lbCheckedPassword.Visible = true;
txtbxCheckedPassword.Visible = true;
bttnSignUp.Text = "Save";
txtbxCheckedPassword.Text = user.Password;
}
else if (bttnSignUp.Text == "Save")
{
if (txtbxSurname.Text != "" && txtbxUserName.Text != "" && Text != "" && txtbxName.Text != "" && txtbxMail.Text != "" && txtbxAdress.Text != "" && txtbxPassWord.Text != "" && txtbxCheckedPassword.Text != "")
{
if (txtbxPassWord.Text == txtbxCheckedPassword.Text)
{
int countindatabase = 0;
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string query = "select * from MusteriBilgileriTablosu where userName = '******'";
if (txtbxUserName.Text == user.Username)
{
countindatabase++;
}
if (database.veriCek(query).Rows.Count == countindatabase)
{
user.Adress = txtbxAdress.Text;
user.Email = txtbxMail.Text;
user.Name = txtbxName.Text;
user.Password = txtbxPassWord.Text;
user.Surname = txtbxSurname.Text;
user.Username = txtbxUserName.Text;
((Customer)user).saveCustomer();
MessageBox.Show("Your Information saved succesfully");
this.Close();
return;
}
MessageBox.Show("Your password dont match");
return;
}
MessageBox.Show("This username is using from another user");
return;
}
else
{
MessageBox.Show("there are empty areas");
return;
}
}
}
/// <summary>
/// this event for filter panel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tvFilter_AfterSelect(object sender, TreeViewEventArgs e)
{
Program.NotifyObserver(this.Name, ((TreeView)sender).Name);
int index = e.Node.Index;
int level = e.Node.Level;
if (level == 0)
{
switch (index)
{
case 0:
pnlShow.Controls.Clear();
this.pnlShowClear("Book");
break;
case 1:
pnlShow.Controls.Clear();
this.pnlShowClear("Music");
break;
case 2:
pnlShow.Controls.Clear();
this.pnlShowClear("Magazine");
break;
default:
break;
}
}
if (level == 1)
{
int parentindex = e.Node.Parent.Index;
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string query;
//DataTable dataTable = database.veriCek(query);
switch (parentindex)
{
case 0:
pnlShow.Controls.Clear();
query = "select * from kitapBilgileriTablosu where type = " + index + " and visibility = 1";
DataTable dataTable = database.veriCek(query);
foreach (DataRow row in dataTable.Rows)
{
Product book = addNewProductFromDatabase.CreateNewItemfilter(row, 1);
BookControl cont = new BookControl((Book)book, shoppingCard);
pnlShow.Controls.Add(cont);
}
break;
case 1:
pnlShow.Controls.Clear();
query = "select * from CdBilgileriTablosu where productType = " + index + " and visibility = 1";
DataTable dataTabl = database.veriCek(query);
foreach (DataRow row in dataTabl.Rows)
{
Product book = addNewProductFromDatabase.CreateNewItemfilter(row, 2);
MusicCdControl cont = new MusicCdControl((MusicCD)book, shoppingCard);
pnlShow.Controls.Add(cont);
}
break;
case 2:
pnlShow.Controls.Clear();
query = "select * from MagazineBilgileriTablosu where productType = " + index + " and visibility = 1";
DataTable dataTabe = database.veriCek(query);
foreach (DataRow row in dataTabe.Rows)
{
Product book = addNewProductFromDatabase.CreateNewItemfilter(row, 3);
MagazineControl cont = new MagazineControl((Magazine)book, shoppingCard);
pnlShow.Controls.Add(cont);
}
break;
default:
break;
}
}
}
/// <summary>
/// it saves the user
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bttnSignUp_Click(object sender, EventArgs e)
{
if (txtbxName.Text == "")
{
lbName.ForeColor = Color.Maroon;
}
else if (txtbxAdress.Text == "")
{
lbAdress.ForeColor = Color.Maroon;
}
else if (txtbxMail.Text == "")
{
lbMail.ForeColor = Color.Maroon;
}
else if (txtbxcheck.Text == "")
{
lbcheck.ForeColor = Color.Maroon;
}
else if (txtbxPassWord.Text == "")
{
lbPassWord.ForeColor = Color.Maroon;
}
else if (txtbxSurname.Text == "")
{
lbSurname.ForeColor = Color.Maroon;
}
else if (txtbxUserName.Text == "")
{
lbUserName.ForeColor = Color.Maroon;
}
else if (txtbxcheck.Text == txtbxPassWord.Text)
{
if (IsValidEmail(txtbxMail.Text))
{
try
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string checkQuery = "select * from MusteriBilgileriTablosu where userName ='******'";
DataTable check = database.veriCek(checkQuery);
if (check.Rows.Count == 0)
{
string query = "INSERT INTO MusteriBilgileriTablosu(customerName,customerSurname,customerAdress,customerEmail,userName,userPassword,userAuthorization) VALUES('" + txtbxName.Text + "','" + txtbxSurname.Text + "','" + txtbxAdress.Text + "','" + txtbxMail.Text + "','" + txtbxUserName.Text + "','" + txtbxPassWord.Text + "'," + 0 + ")";
database.veriKaydet(query);
Task.Delay(5000).Wait();
query = "SELECT * FROM MusteriBilgileriTablosu WHERE userName='******'and userPassword='******'";
DataTable table = database.veriCek(query);
DataRow row = table.Rows[0];
MainForm.user = new Customer();
MainForm.user.UserID = Convert.ToInt32(row[0]);
MainForm.user.Name = row[1].ToString();
MainForm.user.Surname = row[2].ToString();
MainForm.user.Adress = row[3].ToString();
MainForm.user.Email = row[4].ToString();
MainForm.user.Username = row[5].ToString();
MainForm.user.Password = row[6].ToString();
this.Close();
}
else
{
MessageBox.Show("This user name using by another user");
lbUserName.ForeColor = Color.Maroon;
}
}
catch { }
}
else
{
MessageBox.Show("This mail was not found");
}
}
}
/// <summary>
/// it create specific product from database
/// </summary>
/// <param name="datatableRow">the row from urunlertablosu</param>
/// <param name="productType">product type</param>
/// <returns>product</returns>
public Product CreateNewItemfilter(DataRow datatableRow, int productType) //it thakes the rows of product table
{
try
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
Product product;
if (productType == 1)
{
product = new Book();
DataTable ProductTable = database.veriCek("SELECT * FROM UrunlerTablosu WHERE productId = " + datatableRow[0] + " and visibility = 1");
DataRow producttablrow = ProductTable.Rows[0];
//product is filled with database
product.Id = Convert.ToInt32(producttablrow[0]);
product.Name = producttablrow[1].ToString();
product.Price = Convert.ToInt32(producttablrow[2]);
product.Photo1 = new Bitmap(producttablrow[3].ToString());
product.Description = producttablrow[4].ToString();
product.Sale = Convert.ToInt32(producttablrow[5]);
((Book)product).Author = datatableRow[1].ToString();
((Book)product).Isbn = Convert.ToInt64(datatableRow[2]);
((Book)product).Publisher = datatableRow[3].ToString();
((Book)product).Page = Convert.ToInt32(datatableRow[4]);
((Book)product).size = datatableRow[5].ToString();
((Book)product).type = (Book.BookType)datatableRow[6];
((Book)product).l_anguage = (Book.Language)datatableRow[7];
return(product);
}
else if (productType == 2)
{
product = new MusicCD();
DataTable MusicTable = database.veriCek("SELECT * FROM UrunlerTablosu WHERE productId = " + datatableRow[0] + " and visibility = 1");
DataRow producttablrow = MusicTable.Rows[0];
//product is filled with database
product.Id = Convert.ToInt32(producttablrow[0]);
product.Name = producttablrow[1].ToString();
product.Price = Convert.ToInt32(producttablrow[2]);
product.Photo1 = new Bitmap(producttablrow[3].ToString());
product.Description = producttablrow[4].ToString();
product.Sale = Convert.ToInt32(producttablrow[5]);
((MusicCD)product).Mcdtype = (MusicCD.MusicCDType)datatableRow[1];
((MusicCD)product).Singer = datatableRow[2].ToString();
return(product);
}
else //(Convert.ToInt32(dataRow[6]) == 3)
{
product = new Magazine();
DataTable magazineTable = database.veriCek("SELECT * FROM UrunlerTablosu WHERE productId = " + datatableRow[0] + " and visibility = 1");
DataRow producttablrow = magazineTable.Rows[0];
//product is filled with database
product.Id = Convert.ToInt32(producttablrow[0]);
product.Name = producttablrow[1].ToString();
product.Price = Convert.ToInt32(producttablrow[2]);
product.Photo1 = new Bitmap(producttablrow[3].ToString());
product.Description = producttablrow[4].ToString();
product.Sale = Convert.ToInt32(producttablrow[5]);
//product.Name = producttablrow[1].ToString();
((Magazine)product).Issue = datatableRow[1].ToString();
((Magazine)product).Mtype = (Magazine.MagazineType)datatableRow[2];
return(product);
}
}
catch
{
return(null);
}
}
/// <summary>
/// it create a product from database
/// </summary>
/// <param name="dataRow">the row from urunlertablosu </param>
/// <returns>product</returns>
public Product CreateNewItem(DataRow dataRow)
{
try
{
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
Product product = new Book();
if (Convert.ToInt32(dataRow[6]) == 1)
{
product = new Book();
DataTable BookTable = database.veriCek("SELECT * FROM kitapBilgileriTablosu WHERE productId = " + dataRow[0] + " and " + " visibility = 1 ");
DataRow BookTableRow = BookTable.Rows[0];
//product is filled with database
product.Id = Convert.ToInt32(dataRow[0]);
product.Name = dataRow[1].ToString();
product.Price = Convert.ToInt32(dataRow[2]);
product.Photo1 = new Bitmap(dataRow[3].ToString());
product.Description = dataRow[4].ToString();
product.Sale = Convert.ToInt32(dataRow[5]);
((Book)product).Author = BookTableRow[1].ToString();
((Book)product).Isbn = Convert.ToInt64(BookTableRow[2]);
((Book)product).Publisher = BookTableRow[3].ToString();
((Book)product).Page = Convert.ToInt32(BookTableRow[4]);
((Book)product).size = BookTableRow[5].ToString();
((Book)product).type = (Book.BookType)BookTableRow[6];
((Book)product).l_anguage = (Book.Language)BookTableRow[7];
return(product);
}
else if (Convert.ToInt32(dataRow[6]) == 2)
{
product = new MusicCD();
DataTable MusicTable = database.veriCek("SELECT * FROM CdBilgileriTablosu WHERE productId = " + dataRow[0] + " and " + " visibility = 1");
DataRow MusicTableRow = MusicTable.Rows[0];
//product is filled with database
product.Id = Convert.ToInt32(dataRow[0]);
product.Name = dataRow[1].ToString();
product.Price = Convert.ToInt32(dataRow[2]);
product.Photo1 = new Bitmap(dataRow[3].ToString());
product.Description = dataRow[4].ToString();
product.Sale = Convert.ToInt32(dataRow[5]);
((MusicCD)product).Mcdtype = (MusicCD.MusicCDType)MusicTableRow[1];
((MusicCD)product).Singer = MusicTableRow[2].ToString();
return(product);
}
else//(Convert.ToInt32(dataRow[6]) == 3)
{
product = new Magazine();
DataTable magazineTable = database.veriCek("SELECT * FROM MagazineBilgileriTablosu WHERE productId = " + dataRow[0] + " and " + " visibility = 1 ");
DataRow magazineTableRow = magazineTable.Rows[0];
//product is filled with database
product.Id = Convert.ToInt32(dataRow[0]);
product.Name = dataRow[1].ToString();
product.Price = Convert.ToInt32(dataRow[2]);
product.Photo1 = new Bitmap(dataRow[3].ToString());
product.Description = dataRow[4].ToString();
product.Sale = Convert.ToInt32(dataRow[5]);
product.Name = dataRow[1].ToString();
((Magazine)product).Issue = magazineTableRow[1].ToString();
((Magazine)product).Mtype = (Magazine.MagazineType)magazineTableRow[2];
return(product);
}
}
catch (Exception)
{
return(null);
}
}
