protected void Page_Load(object sender, EventArgs e) { /* * if (!IsPostBack) * { * DisplayData() * } */ ProdBLL p = new ProdBLL(); DataTable dt = p.AllProdBLL(); if (dt.Rows.Count > 0) { //products.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { products.Items.Add(dt.Rows[i]["prd_title"].ToString()); } } else { Response.Write("<script>alert('Record Not Found..!')</script>"); } SellBLL s = new SellBLL(); DataTable dtt = s.getSellBLL(); GridView1.DataSource = dtt; GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { ProdProps p = new ProdProps(); p.Prd_id = p_id.Text; p.Prd_title = p_name.Text; p.Prd_price = p_price.Text; p.Prd_stock = p_stock.Text; p.Prd_expiry = expiry.Text; p.Prd_manufact = p_manuf.Text; if (image.HasFile) { String timeStamp = DateTime.Now.ToString("yyyyMMddHHmmss"); String img_name = image.FileName.ToString(); img_name = timeStamp + img_name; p.Prd_image = img_name; image.SaveAs(Server.MapPath("~/upload/") + img_name); } else { p.Prd_image = hdnimg.Text.ToString(); } ProdBLL emp = new ProdBLL(); if (emp.updateProdBLL(p) && emp.updatePImgBLL(p)) { Response.Redirect("viewproducts.aspx?success=Product Updated Successfully"); } else { Response.Redirect("viewproducts.aspx?error=Sorry, Something Went Wrong....!"); } }
protected void Page_Load(object sender, EventArgs e) { ProdBLL p = new ProdBLL(); DataTable dt = p.AllProdBLL(); if (dt.Rows.Count > 0) { //products.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { products.Items.Add(dt.Rows[i]["prd_title"].ToString()); } } else { Response.Write("<script>alert('Products Not Found..!')</script>"); } SupBLL s = new SupBLL(); DataTable dtb = s.AllSupBLL(); if (dtb.Rows.Count > 0) { //supply.Items.Clear(); for (int i = 0; i < dtb.Rows.Count; i++) { supply.Items.Add(dtb.Rows[i]["name"].ToString()); } } else { Response.Write("<script>alert('Supplyers Not Found..!')</script>"); } PurBLL pp = new PurBLL(); DataTable dtt = pp.getPurBLL(); GridView1.DataSource = dtt; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { ProdBLL s = new ProdBLL(); Repeater1.DataSource = s.AllProdBLL(); Repeater1.DataBind(); if (Request.Params.AllKeys.Contains("dltprd")) { ProdProps u = new ProdProps(); u.Prd_id = Request.QueryString["dltprd"]; ProdBLL ub = new ProdBLL(); if (ub.deleteProdBLL(u)) { Response.Redirect("viewproducts.aspx?success=Deleted Successfully"); } else { Response.Redirect("viewproducts.aspx?error=Something Went Wrong....!"); } } }
protected void Page_Load(object sender, EventArgs e) { ProdProps p = new ProdProps(); p.Prd_id = Request.QueryString["edtprd"]; ProdBLL emp = new ProdBLL(); DataTable dt = emp.searchProdBLL(p); if (dt.Rows.Count > 0) { p_id.Text = dt.Rows[0]["prd_id"].ToString(); p_name.Text = dt.Rows[0]["prd_title"].ToString(); p_price.Text = dt.Rows[0]["prd_price"].ToString(); p_stock.Text = dt.Rows[0]["prd_stock"].ToString(); expiry.Text = dt.Rows[0]["prd_expiry"].ToString(); p_manuf.Text = dt.Rows[0]["prd_manufacturer"].ToString(); hdnimg.Text = dt.Rows[0]["img"].ToString(); } else { Response.Redirect("viewproducts.aspx?error=Sorry, Something Went Wrong....!"); } }
protected void Insert_Click(object sender, EventArgs e) { if (image.HasFile) { ProdProps p = new ProdProps(); p.Prd_id = p_id.Text; p.Prd_title = p_name.Text; p.Prd_price = p_price.Text; p.Prd_stock = p_stock.Text; p.Prd_expiry = expiry.Text; p.Prd_manufact = p_manuf.Text; //p.Prd_image = DateTime.Now + files.FileName.ToString(); //files.SaveAs(Server.MapPath("~/upload/") + p.Prd_image); //String imgpath = Request.PhysicalPath + "/upload/" + DateTime.Now + files.FileName.ToString(); //p.Prd_image = imgpath; //files.SaveAs(imgpath); String timeStamp = DateTime.Now.ToString("yyyyMMddHHmmss"); String img_name = timeStamp + image.FileName.ToString(); p.Prd_image = img_name; image.SaveAs(Server.MapPath("~/upload/") + img_name); ProdBLL emp = new ProdBLL(); if (emp.insertProdBLL(p)) { Response.Redirect("products.aspx?success=Product Added Successfully."); } else { Response.Redirect("products.aspx?error=Sorry, Something Went Wrong....!"); } } else { Response.Redirect("products.aspx?error=PLease upload a image."); } }