private void SubCategoryListShow()
{
AltKategoriDb db = new AltKategoriDb();
DropDownList_SubCategorySelect.DataSource = db.GetAllSubCategory();
DropDownList_SubCategorySelect.DataTextField = "AltKategori_Ad";
DropDownList_SubCategorySelect.DataValueField = "AltKategori_ID";
DropDownList_SubCategorySelect.DataBind();
}
protected void DropDownListCategorySelect_SelectedIndexChanged(object sender, EventArgs e)
{
AltKategori a = new AltKategori();
a.KategoriId.Id = Convert.ToInt16(DropDownListCategorySelect.SelectedItem.Value);
AltKategoriDb db = new AltKategoriDb();
DropDownListSubCategoryDelete.DataSource = db.GetSubCategory(a);
DropDownListSubCategoryDelete.DataTextField = "AltKategori_Ad";
DropDownListSubCategoryDelete.DataValueField = "AltKategori_ID";
DropDownListSubCategoryDelete.DataBind();
}
protected void btnSubCategoryDelete_Click(object sender, EventArgs e)
{
Label_SubCategoriesDeleteError.Text = "";
AltKategori a = new AltKategori();
a.Id = Convert.ToInt16(DropDownListSubCategoryDelete.SelectedItem.Value);
AltKategoriDb db = new AltKategoriDb();
try
{
db.Delete(a);
}
catch (Exception hata)
{
Label_SubCategoriesDeleteError.Visible = true;
Label_SubCategoriesDeleteError.Text = hata.Message;
}
Response.Redirect(HttpContext.Current.Request.Url.ToString(), true);
}
protected void btnSubCategoryAdd_Click(object sender, EventArgs e)
{
Label_SubCategoryError.Text = "";
AltKategori a = new AltKategori();
a.Ad = txtAltKategori.Text;
a.KategoriId.Id = Convert.ToInt16(DropDownListCategoryforSubCategory.SelectedItem.Value);
AltKategoriDb db = new AltKategoriDb();
try
{
db.Insert(a);
}
catch (Exception hata)
{
Label_SubCategoryError.Visible = true;
Label_SubCategoryError.Text = hata.Message.ToString();
}
txtAltKategori.Text = "";
Response.Redirect(HttpContext.Current.Request.Url.ToString(), true);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Label_SearchNotFound.Text = "";
Urun u = new Urun();
u.Barkod = search = Request.Params["search"] != null ? Request.Params["search"].ToString() : String.Empty;
UrunDb db = new UrunDb();
int subCategory = 0,
category = 0,
personelID = 0,
counter = 0;
db.Connect();
db.command = new SqlCommand("SELECT * FROM tbl_Urun WHERE Urun_Barkod LIKE @barcode", db.connection);
db.command.Parameters.AddWithValue("@barcode", u.Barkod);
db.command.ExecuteNonQuery();
db.reader = db.command.ExecuteReader();
while (db.reader.Read())
{
txtCost.Text = Convert.ToSingle(db.reader["Urun_Fiyat"]).ToString();
txtStock.Text = db.reader["Urun_Stok"].ToString();
txtUrunAd.Text = db.reader["Urun_Ad"].ToString();
txtBarkod.Text = search;
txtFeatures.Text = db.reader["Urun_Ozellikleri"].ToString();
subCategory = Convert.ToInt16(db.reader["AltKategori_id"]);
personelID = Convert.ToInt16(db.reader["Personel_id"]);
counter++;
}
db.reader.Close();
if (counter == 0)
{
Label_SearchNotFound.Visible = true;
Label_SearchNotFound.Text = "Aradığınız ürün bulunamadı!";
}
else
{
db.command = new SqlCommand("SELECT * FROM tbl_AltKategori WHERE AltKategori_ID=@subCategory", db.connection);
db.command.Parameters.AddWithValue("@subCategory", subCategory);
db.command.ExecuteNonQuery();
db.reader = db.command.ExecuteReader();
while (db.reader.Read())
{
category = Convert.ToInt16(db.reader["Kategori_id"]);
}
db.reader.Close();
db.connection.Close();
db.connection.Dispose();
Kategori k = new Kategori();
k.Id = category;
KategoriDb kdb = new KategoriDb();
Label_CurrentCategory.Text = "";
Label_CurrentCategory.Visible = true;
Label_CurrentCategory.Text = kdb.GetCategoryName(k);
AltKategori ak = new AltKategori();
ak.Id = subCategory;
AltKategoriDb akdb = new AltKategoriDb();
Label_CurrentSubCategory.Text = "";
Label_CurrentSubCategory.Visible = true;
Label_CurrentSubCategory.Text = akdb.GetSubCategoryName(ak);
ShowCategory();
txtBarkod.Enabled = false;
}
}