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;
}
}
