public static EUrun UrunBul(int urunID)
{
SqlCommand cmd = new SqlCommand("sp_UrunBul", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
baglanti.conn.Open();
cmd.Parameters.AddWithValue("@uID", urunID);
SqlDataReader dr = cmd.ExecuteReader();
EUrun u = new EUrun();
while (dr.Read())
{
u.ID = Convert.ToInt32(dr["ID"].ToString());
u.SubCategoryID = Convert.ToInt32(dr["SubCategoryID"].ToString());
u.BrandID = Convert.ToInt32(dr["BrandID"].ToString());
u.ProductName = dr["ProductName"].ToString();
u.Price = Convert.ToDecimal(dr["Price"].ToString());
u.Stock = Convert.ToInt32(dr["Stock"].ToString());
u.Description = dr["Description"].ToString();
u.MasterPhotoPath = dr["MasterPhotoPath"].ToString();
}
dr.Close();
baglanti.conn.Close();
return(u);
}
private void lviUrunler_MouseDoubleClick(object sender, MouseEventArgs e)
{
urunID = Convert.ToInt32(lviUrunler.SelectedItems[0].SubItems[0].Text);
EUrun u = BLLUrun.UrunBul(urunID);
lblUrunAdi.Text = u.ProductName;
}
private void frmUrunDuzenle_Load(object sender, EventArgs e)
{
u = BLLUrun.UrunBul(frmUrunler.urunID);
cmbKategori.DataSource = BLLKategori.Listele();
cmbKategori.DisplayMember = "CategoryName";
cmbKategori.ValueMember = "ID";
cmbKategori.SelectedValue = BLLKategori.UrunKategoriBul(u.SubCategoryID).ID;
cmbMarka.DataSource = BLLMarka.Listele();
cmbMarka.DisplayMember = "BrandName";
cmbMarka.ValueMember = "ID";
cmbMarka.SelectedValue = BLLMarka.MarkaBul(u.BrandID).ID;
int id = BLLKategori.UrunKategoriBul(u.SubCategoryID).ID;
cmbAltKategori.DataSource = BLLAltKategori.AltKategoriListele(id);
cmbAltKategori.DisplayMember = "SubCategoryName";
cmbAltKategori.ValueMember = "ID";
cmbAltKategori.SelectedValue = BLLAltKategori.AltKategoriBul(u.SubCategoryID).ID;
txtUrunAdi.Text = u.ProductName;
numFiyat.Value = u.Price;
numStok.Value = u.Stock;
txtAciklama.Text = u.Description;
pictureBox1.ImageLocation = u.MasterPhotoPath;
btnGozat.Visible = false;
}
public static List <EUrun> Listele()
{
SqlCommand cmd = new SqlCommand("sp_UrunListele", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
baglanti.conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
List <EUrun> uListe = new List <EUrun>();
while (dr.Read())
{
EUrun u = new EUrun();
u.ID = Convert.ToInt32(dr["ID"].ToString());
u.SubCategoryID = Convert.ToInt32(dr["SubCategoryID"].ToString());
u.BrandID = Convert.ToInt32(dr["BrandID"].ToString());
u.ProductName = dr["ProductName"].ToString();
u.Price = Convert.ToDecimal(dr["Price"].ToString());
u.Stock = Convert.ToInt32(dr["Stock"].ToString());
u.Description = dr["Description"].ToString();
u.MasterPhotoPath = dr["MasterPhotoPath"].ToString();
uListe.Add(u);
}
dr.Close();
baglanti.conn.Close();
return(uListe);
}
private void btnSil_Click(object sender, EventArgs e)
{
EUrun u = BLLUrun.UrunBul(urunid);
string cevap = BLLUrun.Sil(u);
MessageBox.Show(cevap);
Doldur();
}
private void lvUrunListe_DoubleClick(object sender, EventArgs e)
{
urunid = Convert.ToInt32(lvUrunListe.SelectedItems[0].SubItems[0].Text);
EUrun u = BLLUrun.UrunBul(urunid);
cmbKategori.SelectedValue = u.CategoryID;
txtUrunAdi.Text = u.ProductName;
numFiyat.Value = u.Price;
}
public static void Sil(EUrun u)
{
SqlCommand cmd = new SqlCommand("sp_UrunSil", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", u.ID);
baglanti.conn.Open();
cmd.ExecuteNonQuery();
baglanti.conn.Close();
}
public static string Duzenle(EUrun u)
{
if (u.ID <= 0 || u.ProductName == "" || u.CategoryID == 0 || u.Price < 0)
{
return("Hatalı işlem...");
}
else
{
DALUrun.Duzenle(u);
return("Düzenlendi...");
}
}
private void btnGuncelle_Click(object sender, EventArgs e)
{
EUrun u = BLLUrun.UrunBul(urunid);
u.CategoryID = Convert.ToInt32(cmbKategori.SelectedValue);
u.ProductName = txtUrunAdi.Text;
u.Price = Convert.ToDecimal(numFiyat.Value);
string cevap = BLLUrun.Duzenle(u);
MessageBox.Show(cevap);
Doldur();
}
public static string Sil(EUrun u)
{
if (u.ID > 0)
{
DALUrun.Sil(u);
return("Silindi...");
}
else
{
return("Hatalı işlem...");
}
}
public static string Duzenle(EUrun u)
{
if (u.SubCategoryID <= 0 || u.BrandID <= 0 || u.ProductName == "" || u.Price <= 0 || u.Stock < 0 || u.MasterPhotoPath == "")
{
return("Hatalı işlem");
}
else
{
DALUrun.Duzenle(u);
return("Düzenlendi...");
}
}
private void btnSil_Click(object sender, EventArgs e)
{
EUrun u = BLLUrun.UrunBul(urunID);
string cevap = BLLUrun.Sil(u);
if (File.Exists(u.MasterPhotoPath))
{
File.Delete(u.MasterPhotoPath);
}
MessageBox.Show(cevap);
Doldur();
}
public static void Duzenle(EUrun u)
{
SqlCommand cmd = new SqlCommand("sp_UrunDuzenle", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", u.ID);
cmd.Parameters.AddWithValue("@katID", u.CategoryID);
cmd.Parameters.AddWithValue("@urunAdi", u.ProductName);
cmd.Parameters.AddWithValue("@fiyat", u.Price);
baglanti.conn.Open();
cmd.ExecuteNonQuery();
baglanti.conn.Close();
}
public static string Ekle(EUrun u)
{
if (u.ProductName != "" && u.SubCategoryID > 0 && u.BrandID > 0 && u.Price > 0 && u.Stock > 0 && u.MasterPhotoPath != "")
{
if (DALUrun.Ekle(u) > 0)
{
return("Eklendi...");
}
else
{
return("Aynı ürün var, farklı bir isim giriniz...");
}
}
return("Hatalı işlem...");
}
public static void Duzenle(EUrun u)
{
SqlCommand cmd = new SqlCommand("sp_UrunDuzenle", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", u.ID);
cmd.Parameters.AddWithValue("@urunAdi", u.ProductName);
cmd.Parameters.AddWithValue("@altKatID", u.SubCategoryID);
cmd.Parameters.AddWithValue("@markaID", u.BrandID);
cmd.Parameters.AddWithValue("@fiyat", u.Price);
cmd.Parameters.AddWithValue("@stok", u.Stock);
cmd.Parameters.AddWithValue("aciklama", u.Description);
cmd.Parameters.AddWithValue("@fotoYolu", u.MasterPhotoPath);
baglanti.conn.Open();
cmd.ExecuteNonQuery();
baglanti.conn.Close();
}
public static string Ekle(EUrun urun)
{
if (urun.ProductName == "" || urun.CategoryID == 0 || urun.Price < 0)
{
return("Hatalı işlem...");
}
else
{
if (DALUrun.Ekle(urun) > 0)
{
return("Eklendi...");
}
else
{
return("Aynı kategoriden var, farklı bir isim giriniz...");
}
}
}
public static string KategoriBul(EUrun u)
{
SqlCommand cmd = new SqlCommand("sp_KategoriBul", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
baglanti.conn.Open();
cmd.Parameters.AddWithValue("@katID", u.CategoryID);
SqlDataReader dr = cmd.ExecuteReader();
string kategoriAdi = "";
while (dr.Read())
{
kategoriAdi = dr["CategoryName"].ToString();
}
dr.Close();
baglanti.conn.Close();
return(kategoriAdi);
}
public static EUrun UrunBul(int id)
{
SqlCommand cmd = new SqlCommand("sp_UrunBul", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
baglanti.conn.Open();
cmd.Parameters.AddWithValue("proID", id);
SqlDataReader dr = cmd.ExecuteReader();
EUrun u = new EUrun();
while (dr.Read())
{
u.ID = Convert.ToInt32(dr["ID"]);
u.CategoryID = Convert.ToInt32(dr["CategoryID"]);
u.ProductName = dr["ProductName"].ToString();
u.Price = Convert.ToDecimal(dr["Price"]);
}
dr.Close();
baglanti.conn.Close();
return(u);
}
public static List <EUrun> Listele()
{
SqlCommand cmd = new SqlCommand("sp_UrunListele", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
baglanti.conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
List <EUrun> liste = new List <EUrun>();
while (dr.Read())
{
EUrun u = new EUrun();
u.ID = Convert.ToInt32(dr["ID"]);
u.CategoryID = Convert.ToInt32(dr["CategoryID"]);
u.ProductName = dr["ProductName"].ToString();
u.Price = Convert.ToDecimal(dr["Price"]);
liste.Add(u);
}
dr.Close();
baglanti.conn.Close();
return(liste);
}
private void btnEkle_Click(object sender, EventArgs e)
{
if (!Directory.Exists(@"C:\Users\Public\ONRMuhendislik"))
{
Directory.CreateDirectory(@"C:\Users\Public\ONRMuhendislik");
}
if (!Directory.Exists(@"C:\Users\Public\ONRMuhendislik\Ürün Resimleri"))
{
Directory.CreateDirectory(@"C:\Users\Public\ONRMuhendislik\Ürün Resimleri");
}
EUrun u = new EUrun();
u.SubCategoryID = Convert.ToInt32(cmbAltKategori.SelectedValue);
u.BrandID = Convert.ToInt32(cmbMarka.SelectedValue);
u.ProductName = txtUrunAdi.Text;
u.Price = Convert.ToDecimal(numFiyat.Value);
u.Stock = Convert.ToInt32(numStok.Value);
u.Description = txtAciklama.Text;
Guid resimAdi = Guid.NewGuid();
if (BLLUrun.ResimKontrol(pictureBox1.ImageLocation) == "Hata")
{
MessageBox.Show("Resim seçiniz...");
return;
}
u.MasterPhotoPath = @"C:\Users\Public\ONRMuhendislik\Ürün Resimleri\" + resimAdi + ".jpg";
string cevap = BLLUrun.Ekle(u);
if (cevap == "Eklendi...")
{
File.Copy(BLLMarka.ResimKontrol(pictureBox1.ImageLocation), @"C:\Users\Public\ONRMuhendislik\Ürün Resimleri\" + resimAdi + ".jpg");
}
MessageBox.Show(cevap);
frmUrunler f = Application.OpenForms["frmUrunler"] as frmUrunler;
f.Doldur();
}
public static string KategoriBul(EUrun item)
{
return(DALUrun.KategoriBul(item));
}
