test

' runat = "server" />

&name=<%# DataBinder.Eval(Container.DataItem,"CatName")%>'>
'>

// page load
intPageSize.Text = "6";
lblIntCurrentIndex.Text = "0";
///
intRoundCount.Text = Convert.ToString(ds.Tables[0].Rows.Count);

if (ds.Tables[0].Rows.Count > 0)
{
lblFirst.Visible = true;
lblPervious.Visible = true;
lblNext.Visible = true;
lblLast.Visible = true;
}
}
public void ShowFirst(object sender, EventArgs e)
{
lblIntCurrentIndex.Text = "0";
DataBind();
}
public void ShowPerivous(object sender, EventArgs e)
{
lblIntCurrentIndex.Text = Convert.ToString(Convert.ToInt32(lblIntCurrentIndex.Text) - Convert.ToInt32(intPageSize.Text));
if (Convert.ToInt32(lblIntCurrentIndex.Text) < text = "0" text =" Convert.ToString(Convert.ToInt32(lblIntCurrentIndex.Text)" i =" Convert.ToInt32(intRoundCount.Text)"> 0)
{
lblIntCurrentIndex.Text = Convert.ToString(Convert.ToInt32(intRoundCount.Text) - i);
}
else
{
lblIntCurrentIndex.Text = Convert.ToString(Convert.ToInt32(intPageSize.Text) - i);
}
DataBind();
}

protected void Page_Load(object sender, EventArgs e)
{
if (Session["userLoginID"] != null)
{
try
{
uid = dt.CInt(Session["userLoginID"]);
utype = dt.CInt(Session["userTypeID"]);
ulocid = dt.CInt(Session["userLocationID"]);
}
catch { }
}
else
{
Response.Redirect("Default.aspx");
}
if (!Page.IsPostBack)
{
binddl();
if (Request["id"] != null)
{
getproduct(Convert.ToInt32(Request["id"].ToString()));
Button1.Text = "Update";
Session.Add("PID", Request["id"].ToString());
}
else
{
lblmsg.Text = "";
trreason.Visible = false;
Button1.Text = "Create";
}
}
}
public void binddl()
{
DataSet ds = new DataSet();
DataView dvloc;
string strloc = "";
ds = aobj.getddls();
ddlscat.DataSource = ds.Tables[11];
ddlscat.DataTextField = "prodSubCatName";
ddlscat.DataValueField = "prodSubCatID";
ddlscat.DataBind();
ddlscat2.DataSource = ds.Tables[8];
ddlscat2.DataTextField = "prodSubCatName";
ddlscat2.DataValueField = "prodSubCatID";
ddlscat2.DataBind();
//dvloc = new DataView(ds.Tables[10]);
dvloc = new DataView(ds.Tables[3]);
if (utype == 3 utype == 4)
{
strloc = " retLocID = -1 OR retLocID = 0 OR retLocID = " + ulocid ;
dvloc.RowFilter = strloc ;
}
ddlloc.DataSource = dvloc;
ddlloc.DataTextField = "retLocLocationName";
ddlloc.DataValueField = "retLocID";
ddlloc.DataBind();
ddlloc.Items.Insert(0, new ListItem("All Location", "0"));
ddlloc.SelectedValue = "0";
if (Session["searchPName"] != null)
txtsearch.Text = Session["searchPName"].ToString();
if (Session["searchPLocation"] != null)
ddlloc.SelectedValue = Session["searchPLocation"].ToString();
if (Session["searchPSubCategory"] != null)
ddlscat2.SelectedValue = Session["searchPSubCategory"].ToString();
fillGrid();
}
public void insertproduct()
{
pobj.prodCodeType = dt.CInt(rbl1.SelectedItem.Value);
pobj.prodAltCodeType = dt.CInt(rbl2.SelectedItem.Value);
pobj.prodCreatedByID = uid;
//pobj.prodDescription = txtdesc.Text;
pobj.prodModifyByID = uid;
pobj.prodName = txtname.Text;
if (pobj.prodAltCodeType == 1)
pobj.prodCode = txtcode.Text;
else
pobj.prodCode = "";
if(ddlstatus.SelectedValue == "1")
{
pobj.prodStatus = true;
}
else
{
pobj.prodStatus = false;
}
pobj.prodUPC = txtpcode.Text;
pobj.prodSubCatID =dt.CInt( ddlscat.SelectedValue);
if (utype == 3 utype == 4)
{
pobj.prodLocId = ulocid ;
}
if (utype == 1)
{
pobj.prodLocId = -1;
}
if (utype == 2)
{
pobj.prodLocId = 0 ;
}
int result = 0;
result = prodobj.InsertProduct(pobj);
if (result > 0)
{
lblmsg.Text = "Product added successfully";
}
else
{
lblmsg.Text = "Product could not be added";
}
fillGrid();
ResetControls();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Session["PID"] != null)
{
//trreason.Visible = true;
Button1.Text = "Update";
Editproduct();
}
else
{
//trreason.Visible = false;
Button1.Text = "Create";
insertproduct();
}
}
public void Editproduct()
{
pobj.prodID = dt.CInt(Session["PID"]);
pobj.prodCodeType = dt.CInt(rbl1.SelectedItem.Value);
pobj.prodAltCodeType = dt.CInt(rbl2.SelectedItem.Value);
pobj.prodCreatedByID = 1;
//pobj.prodDescription = txtdesc.Text;
pobj.prodModifyByID = uid;
pobj.prodName = txtname.Text;
if (pobj.prodAltCodeType == 1)
pobj.prodCode = txtcode.Text;
else
pobj.prodCode = "";
pobj.prodUpdateReason = txtreason.Text;
if(ddlstatus.SelectedValue == "1")
{
pobj.prodStatus = true;
}
else
{
pobj.prodStatus = false;
}
pobj.prodUPC = txtpcode.Text;
pobj.prodSubCatID =dt.CInt( ddlscat.SelectedValue);
pobj.prodLocId = Convert.ToInt32(txtProductLocID.Text.ToString());
int result = 0;
result = prodobj.ReturnUPdateProduct(pobj);
if (result > 0)
{
lblmsg.Text = "Product updated successfully";
}
else
{
lblmsg.Text = "Product could not be updated";
}
fillGrid();
}
public void getproduct(int pid)
{
DataSet dsprod = new DataSet();
dsprod = ppobj.GetProdByID(pid);
if (utype == 3 utype == 4)
{
if (ulocid == dt.CInt(dsprod.Tables[0].Rows[0]["prodLocId"].ToString()))
{
Button1.Visible = true;
}
else
{
Button1.Visible = false;
}
}
for (int j = 0; j < rbl1.Items.Count; j++)
{
if (rbl1.Items[j].Value == dsprod.Tables[0].Rows[0]["prodCodeType"].ToString())
{
rbl1.Items[j].Selected = true;
}
}
txtpcode.Text =dsprod.Tables[0].Rows[0]["prodUPC"].ToString();
txtcode.Text = dsprod.Tables[0].Rows[0]["prodCode"].ToString();
//txtdesc.Text = dsprod.Tables[0].Rows[0]["prodDescription"].ToString();
txtname.Text = dsprod.Tables[0].Rows[0]["prodName"].ToString();
ddlscat.SelectedValue = dsprod.Tables[0].Rows[0]["prodSubCatID"].ToString();
txtreason.Text = dsprod.Tables[0].Rows[0]["prodUpdateReason"].ToString();
if (dsprod.Tables[0].Rows[0]["prodAltCodeType"].ToString() == "2")
rbl2.SelectedValue = "2";
else
rbl2.SelectedValue = "1";
if (dsprod.Tables[0].Rows[0]["prodStatus"].ToString() == "True")
{
ddlstatus.SelectedValue = "1";
}
else
{
ddlstatus.SelectedValue = "0";
}
txtProductLocID.Text = dsprod.Tables[0].Rows[0]["prodLocID"].ToString();
}
public void ResetControls()
{
//lblmsg.Text = "";
txtcode.Text = "";
//txtdesc.Text = "";
txtname.Text = "";
ddlscat.SelectedValue = "-1";
ddlstatus.SelectedValue = "1";
txtreason.Text = "";
txtpcode.Text = "";
//ddlloc.SelectedValue = "-1";
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
trreason.Visible = false;
ResetControls();
Session["PID"] = null;
Button1.Text = "Create";
}
protected void btnsearch_Click(object sender, EventArgs e)
{
//ResetControls();
lblsearch.Visible = true;
lblsearch.Text = "";
Session["searchPCurrentPageIndex"] = "0";
Session["searchPName"] = txtsearch.Text.ToString();
Session["searchPLocation"] = ddlloc.SelectedValue.ToString();
Session["searchPSubCategory"] = ddlscat2.SelectedValue.ToString();
fillGrid();
}
protected void ddlscat2_SelectedIndexChanged(object sender, EventArgs e)
{
Session["searchPCurrentPageIndex"] = "0";
Session["searchPName"] = txtsearch.Text.ToString();
Session["searchPLocation"] = ddlloc.SelectedValue.ToString();
Session["searchPSubCategory"] = ddlscat2.SelectedValue.ToString();
fillGrid();
}
protected void ddlloc_SelectedIndexChanged(object sender, EventArgs e)
{
Session["searchPCurrentPageIndex"] = "0";
Session["searchPName"] = txtsearch.Text.ToString();
Session["searchPLocation"] = ddlloc.SelectedValue.ToString();
Session["searchPSubCategory"] = ddlscat2.SelectedValue.ToString();
fillGrid();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
Session["searchPCurrentPageIndex"] = e.NewPageIndex.ToString();
fillGrid();
}
public void fillGrid()
{
DataSet dsloc = new DataSet();
DataView dv;
string str = "";
dsloc = aobj.getddls();
dv = new DataView(dsloc.Tables[9]);
// Location Filter
if (ddlloc.SelectedValue.ToString() == "0")
str = " (prodLocId = -1 or prodLocId = 0 or prodLocId = " + ulocid + ")" ;
else
str = " (prodLocId = " + ddlloc.SelectedValue.ToString() + ")" ;
//Sub Category Filter
if (ddlscat2.SelectedValue.ToString() != "-1")
{
if (str == "")
str = " (prodSubCatID = " + dt.CInt(ddlscat2.SelectedValue) + ")" ;
else
str = str + " AND (prodSubCatID = " + dt.CInt(ddlscat2.SelectedValue) + ")";
}
// Search Text Filter
if (txtsearch.Text.ToString() != "")
{
if (str == "")
str = " (prodName LIKE '" + txtsearch.Text + "%' or prodUPC LIKE '%" + txtsearch.Text + "%')";
else
str = str + " AND (prodName LIKE '" + txtsearch.Text + "%' or prodUPC LIKE '%" + txtsearch.Text + "%')";
}
dv.RowFilter = str;
GridView1.DataSource = dv;
if (Session["searchPCurrentPageIndex"] != null)
GridView1.PageIndex = Convert.ToInt32(Session["searchPCurrentPageIndex"].ToString());
GridView1.DataBind();
Session["searchPName"] = txtsearch.Text.ToString();
Session["searchPLocation"] = ddlloc.SelectedValue.ToString();
Session["searchPSubCategory"] = ddlscat2.SelectedValue.ToString();
Int32 iPageSize = 0, iPageRows = 0, iTotalPages = 0, iCurrentPage = 0, iTotalRows = 0;
iPageSize = Convert.ToInt32(GridView1.PageSize.ToString());
iTotalRows = Convert.ToInt32(dv.Count.ToString());
iCurrentPage = Convert.ToInt32(GridView1.PageIndex.ToString()) + 1;
if ((iTotalRows % iPageSize) > 0)
iTotalPages = Convert.ToInt32((iTotalRows / iPageSize)) + 1;
else
iTotalPages = Convert.ToInt32((iTotalRows / iPageSize));
if (iCurrentPage < iTotalPages)
iPageRows = iPageSize;
else
iPageRows = (iTotalRows % iPageSize);
lblNoOfProducts.Text = dv.Count.ToString();
lblcurrentPage.Text = iCurrentPage.ToString();
lblTotalPage.Text = iTotalPages.ToString();
}
}