/// <summary>
/// butona tiklandiginda DR'den veri ekleyen fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDergiEkleDR_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnDergiEkleDR.Name, adminUserNesnesi.userName);
Bitmap bitti = new Bitmap("D:\\dergiadi" + dgwsirasi + ".jpg");
SaveFileDialog dosyaKaydet = new SaveFileDialog();
SQLdergi cek = new SQLdergi();
cek.dergileriSQLdenCek();
magazineNesnesi.Name = dgwDr.Rows[dgwsirasi].Cells[0].Value.ToString();
dosyaKaydet.FileName = @"DergiFotograf\dergi" + (SQLdergi.sonid + 1) + ".png";
bitti.Save(dosyaKaydet.FileName);
magazineNesnesi.Price = double.Parse(dgwDr.Rows[dgwsirasi].Cells[1].Value.ToString());
magazineNesnesi.Issue = txtSayi1.Text;
magazineNesnesi.ImageLocation = "DergiFotograf\\dergi" + (SQLdergi.sonid + 1) + ".png";
magazineNesnesi.Type = (Magazine.typeOfMagazine)cmbDergiTur.SelectedIndex;
SQLdergi.sonid++;
adminUserNesnesi.addNewItem(magazineNesnesi);
//dergi.dergileriSQLeEkle(magazineNesnesi);
tabloGoster();
}
/// <summary>
/// butona tiklandiginda DR'den veri ekleyen fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCdEkleDR_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnCdEkleDR.Name, adminUserNesnesi.userName);
Bitmap bitti = new Bitmap("D:\\cdadi" + dgwsirasi + ".jpg");
SaveFileDialog dosyaKaydet = new SaveFileDialog();
SQLmusicCd cek = new SQLmusicCd();
cek.muzikCDleriSQLdenCek();
musicCDnesnesi.Name = dgwDr.Rows[dgwsirasi].Cells[0].Value.ToString();
dosyaKaydet.FileName = @"MuzikCDFotograf\muzikCd" + (SQLmusicCd.sonid + 1) + ".png";
bitti.Save(dosyaKaydet.FileName);
musicCDnesnesi.Price = double.Parse(dgwDr.Rows[dgwsirasi].Cells[1].Value.ToString());
musicCDnesnesi.Singer = dgwDr.Rows[dgwsirasi].Cells[2].Value.ToString();
musicCDnesnesi.Type = (MusicCD.typeOfMusicCD)cmbTur1.SelectedIndex;
musicCDnesnesi.ImageLocation = @"MuzikCDFotograf\muzikCd" + (SQLmusicCd.sonid + 1) + ".png";
SQLmusicCd.sonid++;
adminUserNesnesi.addNewItem(musicCDnesnesi);
//muzikCd.MusicCdSQLeEkle(musicCDnesnesi);
tabloGoster();
}
/// <summary>
/// butona tiklandiginda DR'den kitap ekleyen fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnKitapEkleDR_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnKitapEkleDR.Name, adminUserNesnesi.userName);
Bitmap bitti = new Bitmap("D:\\Resimadi" + dgwsirasi + ".jpg");
SaveFileDialog dosyaKaydet = new SaveFileDialog();
SQLkitap cek = new SQLkitap();
cek.kitaplariSQLdenCek();
bookNesnesi.Name = dgwDr.Rows[dgwsirasi].Cells[0].Value.ToString();
bookNesnesi.IsbnNumber = txtIsbnDR.Text;
dosyaKaydet.FileName = @"KitapFotograf\kitap" + (SQLkitap.sonid + 1) + ".png";
bitti.Save(dosyaKaydet.FileName);
bookNesnesi.Price = double.Parse(dgwDr.Rows[dgwsirasi].Cells[1].Value.ToString());
bookNesnesi.IsbnNumber = txtIsbnDR.Text;
bookNesnesi.Author = dgwDr.Rows[dgwsirasi].Cells[2].Value.ToString();
bookNesnesi.Publisher = dgwDr.Rows[dgwsirasi].Cells[3].Value.ToString();
bookNesnesi.Page = int.Parse(dgwDr.Rows[dgwsirasi].Cells[4].Value.ToString());
bookNesnesi.Cover_page_picture = "KitapFotograf\\kitap" + (SQLkitap.sonid + 1) + ".png";
bookNesnesi.ImageLocation = "KitapFotograf\\kitap" + (SQLkitap.sonid + 1) + ".png";
bookNesnesi.TypeOfBook = cmbKitapDR.Text;
SQLkitap.sonid++;
adminUserNesnesi.addNewItem(bookNesnesi);
//kitap.kitaplariSQLeEkle(bookNesnesi);
tabloGoster();
}
/// <summary>
/// butona tiklandiginda eklenen adminin bilgileri girildikten sonra kayit eden fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnKayitOlOnay_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnKayitOlOnay.Name, adminUserNesnesi.userName);
kayitOlAdmin();
}
/// <summary>
/// admin tarafindan muzik cd ekleyen fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnMuzikCdEkle_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnMuzikCdEkle.Name, adminUserNesnesi.userName);
FormEkleMuzikCd formEkleMuzikCd_obj = new FormEkleMuzikCd();
formEkleMuzikCd_obj.gbxEkle.Enabled = true;
formEkleMuzikCd_obj.gbxSil.Visible = false;
formEkleMuzikCd_obj.Show();
}
/// <summary>
/// admin tarafindan dergi silen fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDergiSil_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnDergiSil.Name, adminUserNesnesi.userName);
FormEkleDergi formEkleDergi_obj = new FormEkleDergi();
formEkleDergi_obj.gbxSil.Visible = true;
formEkleDergi_obj.gbxEkle.Enabled = false;
formEkleDergi_obj.Show();
}
/// <summary>
/// admin tarafindan butona tiklandiginda dergi ekleyen fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDergiEkle_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnDergiEkle.Name, adminUserNesnesi.userName);
DergiFotoAl();
nesneDoldur();
adminUserNesnesi.addNewItem(magazineNesnesi);
//dergi.dergileriSQLeEkle(magazineNesnesi);
tabloGoster();
}
/// <summary>
/// admin tarafindan butona tiklandiginda kitap ekleyen fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnKitapEkle_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnKitapEkle.Name, adminUserNesnesi.userName);
KitapFotoAl();
nesneDoldur();
adminUserNesnesi.addNewItem(bookNesnesi);
//kitap.kitaplariSQLeEkle(bookNesnesi);
tabloGoster();
}
/// <summary>
/// admin tarafindan butona tiklandiginda muzik cd ekleyen fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnMuzikCdEkle_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnMuzikCdEkle.Name, adminUserNesnesi.userName);
MuzikCdFotoAl();
nesneDoldur();
adminUserNesnesi.addNewItem(musicCDnesnesi);
//muzikCd.MusicCdSQLeEkle(musicCDnesnesi);
tabloGoster();
MessageBox.Show("eklendi");
}
/// <summary>
/// admin tarafindan yeni admin ekleyen fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnYeniAdminEkle_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnYeniAdminEkle.Name, adminUserNesnesi.userName);
AdminUser admin = AdminUser.adminUser;
FormEkleAdmin formEkleAdmin_obj = new FormEkleAdmin();
formEkleAdmin_obj.gbxEkle.Enabled = true;
formEkleAdmin_obj.gbxSil.Visible = false;
formEkleAdmin_obj.Show();
}
/// <summary>
/// admin tarafindan muzik cd silen fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void linkLblAdminCikis_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, linkLblAdminCikis.Name, adminUserNesnesi.userName);
FormAnaEkran anaEkran = FormAnaEkran.formAnaEkran;
anaEkran.linklblCikisYap.Visible = false;
anaEkran.linklblKayitOl.Visible = true;
anaEkran.linklblUyeGirisi.Visible = true;
adminUserNesnesi = null;
this.Close();
}
/// <summary>
/// butona tiklandiginda DR'den muzik cd ceken fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnVeriCekMusicCdDr_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnVeriCekMusicCdDr.Name, adminUserNesnesi.userName);
WebClient client = new WebClient();
Uri url = new Uri("https://www.dr.com.tr/Sectiklerimiz/Muzik");
client.Encoding = Encoding.UTF8;
var html1 = client.DownloadData(url);
string html = Encoding.UTF8.GetString(html1);
HtmlAgilityPack.HtmlDocument dokuman = new HtmlAgilityPack.HtmlDocument();
dokuman.LoadHtml(html);
HtmlNodeCollection resim = dokuman.DocumentNode.SelectNodes("//img[@class='lazyload']");
HtmlNodeCollection ad = dokuman.DocumentNode.SelectNodes("//h3");
HtmlNodeCollection fiyat = dokuman.DocumentNode.SelectNodes("//span[@class='old-price']");
HtmlNodeCollection sarkici = dokuman.DocumentNode.SelectNodes("//a[@class='who']");
string duzeltme, gecicifiyat;
DataGridViewImageColumn resim11 = new DataGridViewImageColumn();
dgwDr.Columns.Add(resim11);
resim11.ImageLayout = DataGridViewImageCellLayout.Stretch;
for (int i = 0; i < fiyat.Count; i++)
{
gecicifiyat = "";
var adi = ad[i];
duzeltme = yerineKoy(adi.InnerText);
dgwDr.Rows.Add(duzeltme.ToString());
var fiyati = fiyat[i];
for (int t = 0; t < fiyati.InnerLength - 3; t++)
{
gecicifiyat += fiyati.InnerText[t];
}
dgwDr.Rows[i].Cells[1].Value = gecicifiyat;
var kim = sarkici[i];
duzeltme = yerineKoy(kim.InnerText);
dgwDr.Rows[i].Cells[2].Value = duzeltme.ToString();
var imge = resim[i].Attributes["data-src"].Value;
dgwDr.Rows[i].Cells[3].Value = imge.ToString();
imageİndirNet dmage = new imageİndirNet(imge);
dmage.Download();
try
{ dmage.SaveImage("D:\\cdadi" + i + ".jpg", ImageFormat.Jpeg); }
catch (Exception)
{
dmage.SaveImage("D:\\cdadi" + i + ".png", ImageFormat.Png);
}
try
{
dgwDr.Rows[i].Cells[4].Value = Image.FromFile("D:\\cdadi" + i + ".jpg");
dgwDr.Rows[i].Cells[3].Value = "D:\\cdadi" + i + ".jpg";
}
catch (Exception)
{
dgwDr.Rows[i].Cells[5].Value = Image.FromFile("D:\\cdadi" + i + ".png");
}
}
}
/// <summary>
/// butona tiklandiginda DR'den veri ceken fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnVeriCekDergiDr_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnVeriCekDergiDr.Name, adminUserNesnesi.userName);
WebClient client = new WebClient();
Uri url = new Uri("https://www.dr.com.tr/Search?q=dergi#/page=1/sort=relevance,desc/categoryid=0/parentId=0/lg=undefined/price=-1,-1/ldir=h");
client.Encoding = Encoding.UTF8;
var html1 = client.DownloadData(url);
string html = Encoding.UTF8.GetString(html1);
HtmlAgilityPack.HtmlDocument dokuman = new HtmlAgilityPack.HtmlDocument();
dokuman.LoadHtml(html);
//HtmlNodeCollection basliklar = dokuman.DocumentNode.SelectNodes("//a[@href]");
HtmlNodeCollection resim = dokuman.DocumentNode.SelectNodes("//img");
HtmlNodeCollection ad = dokuman.DocumentNode.SelectNodes("//img[@src]");
HtmlNodeCollection fiyat = dokuman.DocumentNode.SelectNodes("//span[@class='old-price']");
DataGridViewImageColumn resim11 = new DataGridViewImageColumn();
dgwDr.Columns.Add(resim11);
resim11.ImageLayout = DataGridViewImageCellLayout.Stretch;
for (int i = 0; i < fiyat.Count; i++)
{
gecicifiyat = "";
var adi = ad[i + 1].Attributes["alt"].Value;
adi = yerineKoy(adi);
dgwDr.Rows.Add(adi.ToString());
var fiyati = fiyat[i];
for (int t = 0; t < fiyati.InnerLength - 3; t++)
{
gecicifiyat += fiyati.InnerText[t];
}
dgwDr.Rows[i].Cells[1].Value = gecicifiyat;
var imge = resim[i + 1].Attributes["src"].Value;
imageİndirNet dmage = new imageİndirNet(imge);
dmage.Download();
try
{ dmage.SaveImage("D:\\dergiadi" + i + ".jpg", ImageFormat.Jpeg); }
catch (Exception)
{
dmage.SaveImage("D:\\dergiadi" + i + ".png", ImageFormat.Png);
}
try
{
dgwDr.Rows[i].Cells[3].Value = Image.FromFile("D:\\dergiadi" + i + ".jpg");
dgwDr.Rows[i].Cells[2].Value = "D:\\dergiadi" + i + ".jpg";
}
catch (Exception)
{
dgwDr.Rows[i].Cells[3].Value = Image.FromFile("D:\\dergiadi" + i + ".png");
}
}
}
/// <summary>
/// butona tiklandiginda DR'den veri ceken fonksiyon
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnVeriCekKitapDr_Click(object sender, EventArgs e)
{
AdminUser adminUserNesnesi = FormAnaEkran.AdminUserNesnesi;
adminUserNesnesi.logAdmin(this, btnVeriCekKitapDr.Name, adminUserNesnesi.userName);
Random rastgele = new Random();
WebClient client = new WebClient();
client.Encoding = System.Text.Encoding.GetEncoding(1254);
Uri url = new Uri("https://www.dr.com.tr/CokSatanlar/Kitap#/page=2/sort=groups.group.displayorder,asc/categoryid=0/clog=4020/parentId=0/price=-1,-1");
client.Encoding = Encoding.UTF8;
Encoding.GetEncoding("iso-8859-9");
var html1 = client.DownloadData(url);
string html = Encoding.UTF8.GetString(html1);
HtmlAgilityPack.HtmlDocument dokuman = new HtmlAgilityPack.HtmlDocument();
dokuman.LoadHtml(html);
HtmlNodeCollection basliklar = dokuman.DocumentNode.SelectNodes("//a[@href]");
HtmlNodeCollection sayfa = dokuman.DocumentNode.SelectNodes("//a[@title]");
HtmlNodeCollection resim = dokuman.DocumentNode.SelectNodes("//img[@class='lazyload']");
HtmlNodeCollection ad = dokuman.DocumentNode.SelectNodes("//div[@class='cell']");
HtmlNodeCollection fiyat = dokuman.DocumentNode.SelectNodes("//span[@class='old-price']");
HtmlNodeCollection yazar = dokuman.DocumentNode.SelectNodes("//a[@class='who']");
HtmlNodeCollection yayinci = dokuman.DocumentNode.SelectNodes("//a[@class='who mb10']");
HtmlNodeCollection tipi = dokuman.DocumentNode.SelectNodes("//div[@class='cell']");
//HtmlNodeCollection sayfa=dokuman.DocumentNode.SelectNodes("//div[@style]");
string adi, duzeltme, tpi;
for (int i = 0; i < ad.Count; i++)
{
gecicifiyat = "";
adi = ad[i].Attributes["data-name"].Value;
adi = yerineKoy(adi);
dgwDr.Rows.Add(adi.ToString());
var fiyati = fiyat[i];
for (int t = 0; t < fiyati.InnerLength - 3; t++)
{
gecicifiyat += fiyati.InnerText[t];
}
dgwDr.Rows[i].Cells[1].Value = gecicifiyat;
var yazari = yazar[i];
duzeltme = yerineKoy(yazari.InnerText);
dgwDr.Rows[i].Cells[2].Value = duzeltme;
var yayincisi = yayinci[i];
duzeltme = yerineKoy(yayincisi.InnerText);
dgwDr.Rows[i].Cells[3].Value = duzeltme;
dgwDr.Rows[i].Cells[4].Value = rastgele.Next(31, 738);
var imge = resim[i].Attributes["data-src"].Value;
tpi = tipi[i].Attributes["data-category"].Value;
tpi = yerineKoy(tpi);
dgwDr.Rows[i].Cells[6].Value = tpi.ToString();
imageİndirNet dmage = new imageİndirNet(imge);
dmage.Download();
try
{ dmage.SaveImage("D:\\Resimadi" + i + ".jpg", ImageFormat.Jpeg); }
catch (Exception)
{
dmage.SaveImage("D:\\Resimadi" + i + ".png", ImageFormat.Png);
}
try
{
dgwDr.Rows[i].Cells[7].Value = Image.FromFile("D:\\Resimadi" + i + ".jpg");
dgwDr.Rows[i].Cells[5].Value = "D:\\Resimadi" + i + ".jpg";
}
catch (Exception)
{
dgwDr.Rows[i].Cells[7].Value = Image.FromFile("D:\\Resimadi" + i + ".png");
}
}
var img = resim[8].Attributes["data-src"].Value;
}