private void btnUpdate_Click(object sender, EventArgs e)
{
foreach (ListViewItem item in lstwProducts.SelectedItems)
{
pro = item.Tag as Entity.Products;
}
pro.ProductName = txtProductName.Text;
pro.UnitPrice = nudUnitPrice.Value;
pro.UnitsInStock = int.Parse(nudUnitsInStock.Value.ToString());
pro.id = pro.id;
Entity.Categories seciliCat = cbCategori.SelectedItem as Entity.Categories;
pro.CategoryID = seciliCat.id;
Entity.Suppliers seciliSup = cbSupplier.SelectedItem as Entity.Suppliers;
pro.SupplierID = seciliSup.id;
int result = proDAL.Update(pro);
MessageBox.Show(result.ToString() + " satır etkilendi.");
pro.ListViewDoldur(lstwProducts);
Entity.Entity en = new Entity.Entity();
en.Temizle(groupBox1);
en.Temizle(groupBox2);
}
public Products SingleProduct(int selectedID)
{
SqlCommand cmd = new SqlCommand("pr_SelectedProduct_List", Tools.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ProductID", selectedID);
cmd.Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
Products singleProduct = new Products();
if (reader.HasRows)
{
while (reader.Read())
{
singleProduct = new Entity.Products
{
ProductID = Convert.ToInt32(reader["ProductID"]),
ProductName = reader["ProductName"].ToString(),
Description = reader["Description"].ToString(),
CategoryID = Convert.ToInt32(reader["CategoryID"]),
LargePhotoPath = reader["LargePhotoPath"].ToString(),
UnitPrice = Convert.ToDecimal(reader["UnitPrice"]),
UnitsInStock = Convert.ToInt32(reader["UnitsInStock"]),
SmallPhotoPath = reader["SmallPhotoPath"].ToString()
};
}
}
cmd.Connection.Close();
return(singleProduct);
}
protected void btnProductInsert_Click(object sender, EventArgs e)
{
try
{
bool result = false;
if (btnProductInsert.Text == "Güncelle")
{
Entity.Products prod = new Entity.Products
{
ProductID = Convert.ToInt32(Session["ProductID"]),
ProductName = txtProductName.Value,
Description = txtProductAciklama.Value,
UnitPrice = Convert.ToDecimal(txtProductPrice.Value),
UnitsInStock = int.Parse(txtProductUnitsInStock.Value),
CategoryID = int.Parse(drpCategory.SelectedItem.Value),
SmallPhotoPath = "Content/User/images/small/" + photoUpload.FileName,
LargePhotoPath = "Content/User/images/large/" + photoUpload.FileName
};
ProductORM prodORM = new ProductORM();
result = prodORM.Update(prod);
photoUpload.SaveAs(Server.MapPath("~/Content/User/images/large/" + photoUpload.FileName));
}
else
{
Entity.Products prod = new Entity.Products
{
ProductName = txtProductName.Value,
Description = txtProductAciklama.Value,
UnitPrice = Convert.ToDecimal(txtProductPrice.Value),
UnitsInStock = int.Parse(txtProductUnitsInStock.Value),
CategoryID = int.Parse(drpCategory.SelectedItem.Value),
SmallPhotoPath = "Content/User/images/small/" + photoUpload.FileName,
LargePhotoPath = "Content/User/images/large/" + photoUpload.FileName
};
ProductORM prodORM = new ProductORM();
result = prodORM.Insert(prod);
photoUpload.SaveAs(Server.MapPath("~/Content/User/images/large/" + photoUpload.FileName));
}
if (result)
{
eklemeBilgi.Visible = true;
eklemeBilgi.InnerText = "İşleminiz Başarıyla Gerçekleştirildi.";
}
else
{
eklemeBilgi.Visible = true;
eklemeBilgi.InnerText = "İşleminiz Gerçekleştirilemedi.";
}
}
catch
{
}
}
private void silToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult answer = MessageBox.Show("Silmek istediğinize emin misiniz", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Stop);
if (answer == DialogResult.Yes)
{
foreach (ListViewItem li in lstwProducts.SelectedItems)
{
pro = li.Tag as Entity.Products;
pro.id = pro.id;
}
proDAL.Delete(pro.id);
pro.ListViewDoldur(lstwProducts);
}
}
private void SelectedProductGet()
{
try
{
if (string.IsNullOrEmpty(Request.QueryString["pID"]))
{
Response.Redirect("Products.aspx");
return;
}
ProductORM prodORM = new ProductORM();
selectedProduct = prodORM.SingleProduct(int.Parse(Request.QueryString["pID"]));
}
catch
{
Response.Redirect("Products.aspx");
}
}
private void ProductUpdateItem()
{
if (Session["ProductID"] != null)
{
ProductORM prodORM = new ProductORM();
Entity.Products prod = prodORM.SingleProduct(Convert.ToInt32(Session["ProductID"]));
txtProductName.Value = prod.ProductName;
txtProductAciklama.Value = prod.Description;
txtProductPrice.Value = prod.UnitPrice.ToString();
txtProductUnitsInStock.Value = prod.UnitsInStock.ToString();
for (int i = 0; i < drpCategory.Items.Count; i++)
{
if (drpCategory.Items[i].Value == prod.CategoryID.ToString())
{
drpCategory.Items[i].Selected = true;
}
}
btnProductInsert.Text = "Güncelle";
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Entity.Products pro = new Entity.Products();
pro.ProductName = txtProductName.Text;
pro.UnitPrice = nudUnitPrice.Value;
pro.UnitsInStock = int.Parse(nudUnitsInStock.Value.ToString());
Entity.Categories seciliCat = cbCategori.SelectedItem as Entity.Categories;
pro.CategoryID = seciliCat.id;
Entity.Suppliers seciliSup = cbSupplier.SelectedItem as Entity.Suppliers;
pro.SupplierID = seciliSup.id;
DAL.ProductsDal proDAL = new DAL.ProductsDal();
int result = proDAL.Save(pro);
MessageBox.Show(result.ToString() + " satır etkilendi.");
Entity.Entity en = new Entity.Entity();
en.Temizle(groupBox1);
en.Temizle(groupBox2);
}
private void lstwProducts_SelectedIndexChanged(object sender, EventArgs e)
{
foreach (ListViewItem li in lstwProducts.SelectedItems)
{
pro = li.Tag as Entity.Products;
txtProductName.Text = pro.ProductName;
nudUnitPrice.Value = pro.UnitPrice;
nudUnitsInStock.Value = pro.UnitsInStock;
foreach (Entity.Categories item in cbCategori.Items)
{
if (item.id == int.Parse(li.SubItems[2].Text))
{
cbCategori.SelectedItem = item;
}
}
foreach (Entity.Suppliers item in cbSupplier.Items)
{
if (item.id == int.Parse(li.SubItems[1].Text))
{
cbSupplier.SelectedItem = item;
}
}
}
}
private void RelatedProducts(int categoryID)
{
ProductORM prodORM = new ProductORM();
DataTable dt = prodORM.ProductInCategory(categoryID);
foreach (DataRow item in dt.Rows)
{
Entity.Products prod = new Entity.Products
{
ProductID = Convert.ToInt32(item["ProductID"]),
ProductName = item["ProductName"].ToString(),
Description = item["Description"].ToString(),
CategoryID = Convert.ToInt32(item["CategoryID"]),
LargePhotoPath = item["LargePhotoPath"].ToString(),
UnitPrice = Convert.ToDecimal(item["UnitPrice"]),
UnitsInStock = Convert.ToInt32(item["UnitPrice"]),
SmallPhotoPath = item["SmallPhotoPath"].ToString()
};
RelatedProductsList.Add(prod);
}
dtListSinglePopup.DataSource = prodORM.ProductInCategory(categoryID);
dtListSinglePopup.DataBind();
}
private void frmListProducts_Load(object sender, EventArgs e)
{
Entity.Products pro = new Entity.Products();
pro.ListViewDoldur(lstwProducts);
}
