private void Show_Table()
{
button_EditSinger.Visible = false;
button_DeleteSinger.Visible = false;
listView1_Disc.Items.Clear();
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var disc = db.Disc.Select(z => z).ToList();
list = disc;
string[] row = new string[10];
foreach (var VARIABLE in list)
{
row[0] = VARIABLE.Id.ToString();
row[1] = VARIABLE.Cover;
row[2] = VARIABLE.DiskTitle;
row[3] = VARIABLE.Singer;
row[4] = VARIABLE.Publisher;
row[5] = VARIABLE.Tracks.ToString();
row[6] = VARIABLE.Genre;
row[7] = VARIABLE.YearPublishing.ToString("d");
row[8] = VARIABLE.CostPrice.ToString();
row[9] = VARIABLE.SellPrice.ToString();
ListViewItem itm = new ListViewItem(row);
listView1_Disc.Items.Add(itm);
}
}
}
private void Show_Home()
{
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var discs = db.Checkk.Select(z => z).ToList();
Show(discs);
}
}
private void Button_SellingYear_Click(object sender, EventArgs e)
{
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var disc = db.Checkk.Where(z => z.DataSale.Year == data.Year).ToList();
Show(disc);
}
}
private void Show_Log()
{
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var log = db.LoginPassword.FirstOrDefault(z => z.Id == 1);
textBox_Login.Text = log.Login;
textBox_Password.Text = log.Password;
}
}
private void Search_DiscTitle()
{
if (textBox_Search.Text != "")
{
start = textBox_Search.Text;
textBox_Search.Text = "";
}
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var disc = db.Disc.Where(z => z.DiskTitle.StartsWith(start)).OrderBy(z => z.Id).Skip((pagesSearch - 1) * panel_col).Take(panel_col).ToList();
Show_Search(disc);
}
}
private void Button_DeleteSinger_Click(object sender, EventArgs e)
{
int index = listView1_Disc.FocusedItem.Index;
Disc disc = list[index];
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var find = db.Disc.FirstOrDefault(z => z.Id == disc.Id);
db.Disc.Remove(find);
db.SaveChanges();
}
Show_Table();
}
private void List_Cart(object sender, EventArgs e)
{
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
Button button = sender as Button;
if (button.Name == button_AddToCart.Name)
{
int id = Convert.ToInt32(label_Id1.Text);
var disc = db.Disc.FirstOrDefault(z => z.Id == id);
if (disc != null)
{
cart.Add(disc);
}
}
else if (button.Name == button_AddToCart1.Name)
{
int id = Convert.ToInt32(label_Id2.Text);
var disc = db.Disc.FirstOrDefault(z => z.Id == id);
if (disc != null)
{
cart.Add(disc);
}
}
else if (button.Name == button_AddToCart2.Name)
{
int id = Convert.ToInt32(label_Id3.Text);
var disc = db.Disc.FirstOrDefault(z => z.Id == id);
if (disc != null)
{
cart.Add(disc);
}
}
else if (button.Name == button_AddToCart3.Name)
{
int id = Convert.ToInt32(label_Id4.Text);
var disc = db.Disc.FirstOrDefault(z => z.Id == id);
if (disc != null)
{
cart.Add(disc);
}
}
}
label_CartCounter.Text = cart.Count.ToString();
}
private void Button_AdminEnter_Click(object sender, EventArgs e)
{
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var Log_Pas = db.LoginPassword.Where(z =>
z.Login == textBox_AdminLogin.Text && z.Password == textBox_AdminPassword.Text).ToList();
if (Log_Pas.Count == 0)
{
textBox_AdminLogin.Text = null;
textBox_AdminPassword.Text = null;
label_WrongLoginPass.Visible = true;
}
else
{
panel_Shield.Visible = false;
}
}
}
private void Show_Table()
{
listView1_Buyers.Items.Clear();
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var disc = db.Buyer.Select(z => z).ToList();
string[] row = new string[4];
foreach (var VARIABLE in disc)
{
row[0] = VARIABLE.Id.ToString();
row[1] = VARIABLE.FirstName;
row[2] = VARIABLE.LastName;
row[3] = VARIABLE.Quantity.ToString();
ListViewItem itm = new ListViewItem(row);
listView1_Buyers.Items.Add(itm);
}
}
}
private void Edit_database()
{
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var disc = db.Disc.FirstOrDefault(z => z.Id == disc_disc.Id);
disc.Singer = textBox_SingerEdit.Text;
disc.Tracks = col;
disc.CostPrice = seb_pr;
disc.DiskTitle = textBox_AlbumEdit.Text;
disc.Genre = textBox_GenreEdit.Text;
disc.Publisher = textBox_PublisherEdit.Text;
disc.Cover = textBox1_imgEdit.Text;
disc.SellPrice = pr;
disc.YearPublishing = date;
db.Disc.AddOrUpdate(disc);
db.SaveChanges();
}
DialogResult = DialogResult.OK;
}
private void Button_LoginEnter_Click(object sender, EventArgs e)
{
if (textBox_Login.Text == "" || textBox_Password.Text == "")
{
MessageBox.Show("Fill all fields", "Attention", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var log = db.LoginPassword.FirstOrDefault(z => z.Id == 1);
log.Login = textBox_Login.Text;
log.Password = textBox_Password.Text;
db.LoginPassword.AddOrUpdate(log);
db.SaveChanges();
}
MessageBox.Show("Admin data has changed!", "Message", MessageBoxButtons.OK,
MessageBoxIcon.Information);
DialogResult = DialogResult.OK;
}
private void Add_database()
{
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
Disc disc = new Disc
{
Singer = textBox_SingerAdd.Text,
Tracks = col,
CostPrice = seb_pr,
DiskTitle = textBox_AlbumAdd.Text,
Genre = textBox_GenreAdd.Text,
Publisher = textBox_PublisherAdd.Text,
Cover = textBox1_img.Text,
SellPrice = pr,
YearPublishing = date
};
db.Disc.Add(disc);
db.SaveChanges();
}
DialogResult = DialogResult.OK;
}
private void Show_Search(List <Disc> disc)
{
panel1.Visible = false;
panel2.Visible = false;
panel3.Visible = false;
panel4.Visible = false;
label_Hot1.Visible = false;
label_Hot2.Visible = false;
label_Hot3.Visible = false;
label_Hot4.Visible = false;
panel6_first.Visible = true;
int col_poz = 0;
if (disc.Count < 4)
{
button_S2_2.Visible = false;
button_S2Right.Visible = false;
}
else
{
button_S2_2.Visible = true;
button_S2Right.Visible = true;
}
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
foreach (var disc1 in disc)
{
if (col_poz == 0)
{
var hit = db.Checkk.Where(z => z.IdDisc == disc1.Id).ToList();
if (hit.Count > 10)
{
label_Hot1.Visible = true;
}
panel1.Visible = true;
try
{
Bitmap bitmap = new Bitmap(disc1.Cover);
pictureBox1.Image = bitmap;
}
catch (Exception e)
{
Bitmap bitmap = new Bitmap(@"..\..\Covers\default.png");
pictureBox1.Image = bitmap;
}
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
label_Singer.Text = disc1.Singer;
label_Disc.Text = disc1.DiskTitle;
label_Publisher.Text = disc1.Publisher;
label_Tracks.Text = disc1.Tracks.ToString();
label_Genre.Text = disc1.Genre;
label_Year.Text = disc1.YearPublishing.ToString("d");
label_Price1.Text = disc1.CostPrice.ToString();
label_Id1.Text = disc1.Id.ToString();
}
else if (col_poz == 1)
{
var hit = db.Checkk.Where(z => z.IdDisc == disc1.Id).ToList();
if (hit.Count > 10)
{
label_Hot2.Visible = true;
}
panel2.Visible = true;
try
{
Bitmap bitmap = new Bitmap(disc1.Cover);
pictureBox2.Image = bitmap;
}
catch (Exception e)
{
Bitmap bitmap = new Bitmap(@"..\..\Covers\default.png");
pictureBox2.Image = bitmap;
}
pictureBox2.SizeMode = PictureBoxSizeMode.StretchImage;
label_Singer2.Text = disc1.Singer;
label_Disk2.Text = disc1.DiskTitle;
label_Publisher2.Text = disc1.Publisher;
label_Tracks2.Text = disc1.Tracks.ToString();
label_Genre2.Text = disc1.Genre;
label_Year2.Text = disc1.YearPublishing.ToString("d");
label_Price2.Text = disc1.CostPrice.ToString();
label_Id2.Text = disc1.Id.ToString();
}
else if (col_poz == 2)
{
var hit = db.Checkk.Where(z => z.IdDisc == disc1.Id).ToList();
if (hit.Count > 10)
{
label_Hot3.Visible = true;
}
panel3.Visible = true;
try
{
Bitmap bitmap = new Bitmap(disc1.Cover);
pictureBox3.Image = bitmap;
}
catch (Exception e)
{
Bitmap bitmap = new Bitmap(@"..\..\Covers\default.png");
pictureBox3.Image = bitmap;
}
pictureBox3.SizeMode = PictureBoxSizeMode.StretchImage;
label_Singer3.Text = disc1.Singer;
label_Disk3.Text = disc1.DiskTitle;
label_Publisher3.Text = disc1.Publisher;
label_Tracks3.Text = disc1.Tracks.ToString();
label_Genre3.Text = disc1.Genre;
label_Year3.Text = disc1.YearPublishing.ToString("d");
label_Price3.Text = disc1.CostPrice.ToString();
label_Id3.Text = disc1.Id.ToString();
}
else if (col_poz == 3)
{
var hit = db.Checkk.Where(z => z.IdDisc == disc1.Id).ToList();
if (hit.Count > 10)
{
label_Hot4.Visible = true;
}
panel4.Visible = true;
try
{
Bitmap bitmap = new Bitmap(disc1.Cover);
pictureBox4.Image = bitmap;
}
catch (Exception e)
{
Bitmap bitmap = new Bitmap(@"..\..\Covers\default.png");
pictureBox4.Image = bitmap;
}
pictureBox4.SizeMode = PictureBoxSizeMode.StretchImage;
label_Singer4.Text = disc1.Singer;
label_Disk4.Text = disc1.DiskTitle;
label_Publisher4.Text = disc1.Publisher;
label_Tracks4.Text = disc1.Tracks.ToString();
label_Genre4.Text = disc1.Genre;
label_Year4.Text = disc1.YearPublishing.ToString("d");
label_Price4.Text = disc1.CostPrice.ToString();
label_Id4.Text = disc1.Id.ToString();
}
col_poz++;
}
}
}
private void Checkout(List <Disc> discs, string lastName, string firstName)
{
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var user = db.Buyer.Where(z => z.LastName == lastName && z.FirstName == firstName).ToList();
if (user.Count != 0)
{
foreach (Buyer VARIABLE in user)
{
int col = VARIABLE.Quantity;
col += discs.Count;
VARIABLE.Quantity = col;
db.Buyer.AddOrUpdate(VARIABLE);
db.SaveChanges();
}
}
else
{
Buyer buyer = new Buyer {
Quantity = discs.Count, LastName = lastName, FirstName = firstName
};
db.Buyer.Add(buyer);
db.SaveChanges();
}
}
using (MusicStoreEntities1 db = new MusicStoreEntities1())
{
var user = db.Buyer.Where(z => z.LastName == lastName && z.FirstName == firstName).ToList();
foreach (var VARIABLE in user)
{
var sumPrise = db.Checkk.Where(z => z.IdBuyer == VARIABLE.Id).Select(z => z.Summ).ToList();
decimal sum = 0;
foreach (decimal VAR in sumPrise)
{
sum += VAR;
}
if (sum > 1000)
{
decimal s = 0;
decimal nous = 0;
panel_OrderDiscount.Visible = true;
foreach (var V in discs)
{
decimal pr = 0;
s += V.SellPrice;
pr = (V.SellPrice - 15);
nous = nous + (V.SellPrice - 15);
Checkk checkk = new Checkk
{
DataSale = DateTime.Now.Date,
IdDisc = V.Id,
IdBuyer = VARIABLE.Id,
Summ = pr
};
db.Checkk.Add(checkk);
}
db.SaveChanges();
label_TotalDiscount.Text = s.ToString();
label_ToPayDiscount.Text = nous.ToString();
}
else
{
decimal s = 0;
panel_OrderDefault.Visible = true;
foreach (var V in discs)
{
s += V.SellPrice;
Checkk checkk = new Checkk
{
DataSale = DateTime.Now.Date,
IdDisc = V.Id,
IdBuyer = VARIABLE.Id,
Summ = V.SellPrice
};
db.Checkk.Add(checkk);
}
db.SaveChanges();
label_TotalDefault.Text = s.ToString();
}
}
}
}