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;
}
}
protected void Page_Load(object sender, EventArgs e)
{
UrunID = Convert.ToInt32(Request.QueryString["ProductID"]);
Urun Product = new Urun();
Product.Id = UrunID;
UrunDb dbProduct = new UrunDb();
dbProduct.Connect();
SqlCommand command = new SqlCommand("sp_ProductDetails", dbProduct.connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@productID", Product.Id);
SqlParameter productName = new SqlParameter("@productName", SqlDbType.NVarChar, int.MaxValue);
productName.Direction = ParameterDirection.Output;
command.Parameters.Add(productName);
SqlParameter productPrice = new SqlParameter("@productPrice", SqlDbType.Decimal, 0);
productPrice.Precision = 18;
productPrice.Scale = 2;
productPrice.Direction = ParameterDirection.Output;
command.Parameters.Add(productPrice);
SqlParameter productStock = new SqlParameter("@productStock", SqlDbType.Int);
productStock.Direction = ParameterDirection.Output;
command.Parameters.Add(productStock);
SqlParameter productSpecial = new SqlParameter("@productSpecial", SqlDbType.NVarChar, int.MaxValue);
productSpecial.Direction = ParameterDirection.Output;
command.Parameters.Add(productSpecial);
SqlParameter productImageURL = new SqlParameter("@productImageURL", SqlDbType.NVarChar, int.MaxValue);
productImageURL.Direction = ParameterDirection.Output;
command.Parameters.Add(productImageURL);
SqlParameter shelfID = new SqlParameter("@rafID", SqlDbType.Int);
shelfID.Direction = ParameterDirection.Output;
command.Parameters.Add(shelfID);
try
{
command.ExecuteNonQuery();
string pName = productName.Value.ToString();
string pPrice = Convert.ToString(productPrice.Value);
string pStock = Convert.ToString(productStock.Value);
string pSpecial = productSpecial.Value.ToString();
string pImageURL = productImageURL.Value.ToString();
rafID = Convert.ToInt16(shelfID.Value);
labelOzellikler.Text = pSpecial;
labelStokBilgi.Text = pStock + " adet";
labelUrunAd.Text = pName;
labelUrunFiyat.Text = pPrice + " ₺";
productImage.ImageUrl = pImageURL;
dbProduct.command = new SqlCommand("SELECT * FROM tbl_Harita", dbProduct.connection);
dbProduct.command.ExecuteNonQuery();
dbProduct.reader = dbProduct.command.ExecuteReader();
while (dbProduct.reader.Read())
{
harita = dbProduct.reader["Harita_Tasarim"].ToString();
}
dbProduct.reader.Close();
dbProduct.reader.Dispose();
}
catch (SqlException hata)
{
throw new Exception(hata.Message);
}
dbProduct.connection.Close();
dbProduct.connection.Dispose();
}