private void lviAltKategori_DoubleClick(object sender, EventArgs e)
{
altKatID = Convert.ToInt32(lviAltKategori.SelectedItems[0].SubItems[0].Text);
EAltKategori ak = BLLAltKategori.AltKategoriBul(altKatID);
txtAltKategoriAdi.Text = ak.SubCategoryName;
}
private void btnSil_Click(object sender, EventArgs e)
{
EAltKategori ak = BLLAltKategori.AltKategoriBul(altKatID);
string cevap = BLLAltKategori.Sil(ak);
MessageBox.Show(cevap);
Doldur();
}
public static void Sil(EAltKategori ak)
{
SqlCommand cmd = new SqlCommand("sp_AltKategoriSil", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", ak.ID);
baglanti.conn.Open();
cmd.ExecuteNonQuery();
baglanti.conn.Close();
}
private void btnGuncelle_Click(object sender, EventArgs e)
{
EAltKategori ak = BLLAltKategori.AltKategoriBul(altKatID);
ak.SubCategoryName = txtAltKategoriAdi.Text;
string cevap = BLLAltKategori.Duzenle(ak);
MessageBox.Show(cevap);
Doldur();
}
public static void Duzenle(EAltKategori ak)
{
SqlCommand cmd = new SqlCommand("sp_AltKategoriDuzenle", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("altKatAdi", ak.SubCategoryName);
cmd.Parameters.AddWithValue("id", ak.ID);
baglanti.conn.Open();
cmd.ExecuteNonQuery();
baglanti.conn.Close();
}
private void btnEkle_Click(object sender, EventArgs e)
{
EKategori k = BLLKategori.KategoriBul(frmKategoriler.katID);
EAltKategori ak = new EAltKategori();
ak.SubCategoryName = txtAltKategoriAdi.Text;
ak.CaregoryID = k.ID;
string cevap = BLLAltKategori.Ekle(ak);
MessageBox.Show(cevap);
Doldur();
}
public static string Duzenle(EAltKategori ak)
{
if (ak.ID <= 0 || ak.SubCategoryName == "")
{
return("Hatalı işlem...");
}
else
{
DALAltKategori.Duzenle(ak);
return("Düzenlendi...");
}
}
public static string Sil(EAltKategori ak)
{
if (ak.ID > 0)
{
DALAltKategori.Sil(ak);
return("Silindi");
}
else
{
return("Hatalı işlem...");
}
}
public static int Ekle(EAltKategori ak)
{
SqlCommand cmd = new SqlCommand("sp_AltKategoriEkle", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@katAdi", ak.SubCategoryName);
cmd.Parameters.AddWithValue("@katID", ak.CaregoryID);
baglanti.conn.Open();
int sayi = cmd.ExecuteNonQuery();
baglanti.conn.Close();
return(sayi);
}
public static string Ekle(EAltKategori ak)
{
if (ak.SubCategoryName != "")
{
if (DALAltKategori.Ekle(ak) > 0)
{
return("Eklendi...");
}
else
{
return("Aynı alt kategoriden var, farklı bir isim giriniz...");
}
}
return("Hatalı işlem...");
}
public static EAltKategori AltKategoriBul(int altKatID)
{
SqlCommand cmd = new SqlCommand("sp_AltKategoriBul", baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
baglanti.conn.Open();
cmd.Parameters.AddWithValue("@altKatID", altKatID);
SqlDataReader dr = cmd.ExecuteReader();
EAltKategori ak = new EAltKategori();
while (dr.Read())
{
ak.ID = Convert.ToInt32(dr["ID"].ToString());
ak.CaregoryID = Convert.ToInt32(dr["CategoryID"].ToString());
ak.SubCategoryName = dr["SubCategoryName"].ToString();
}
dr.Close();
baglanti.conn.Close();
return(ak);
}
public static List <EAltKategori> ALtKategoriListele(int p)
{
SqlCommand cmd = new SqlCommand("select * from SubCategories where CategoryID = @katID", baglanti.conn);
baglanti.conn.Open();
cmd.Parameters.AddWithValue("@katID", p);
SqlDataReader dr = cmd.ExecuteReader();
List <EAltKategori> akListe = new List <EAltKategori>();
while (dr.Read())
{
EAltKategori ak = new EAltKategori();
ak.ID = Convert.ToInt32(dr["ID"].ToString());
ak.CaregoryID = Convert.ToInt32(dr["CategoryID"].ToString());
ak.SubCategoryName = dr["SubCategoryName"].ToString();
akListe.Add(ak);
}
dr.Close();
baglanti.conn.Close();
return(akListe);
}
