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.");
}
}
