protected void Page_Load(object sender, EventArgs e) { if (Page.Title.ToString() == "DYL Motorcycles - Welcome") breadcrumb.Visible = false; dtCategories = taCategories.SelectAllCategory(); Repeater1.DataSource = dtCategories; Repeater1.DataBind(); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Label lblCategoryId = (Label)e.Row.FindControl("lblCategoryId"); if (lblCategoryId.Text != "") { dtCategory = taCategory.SelectCategorybyCategoryId(Convert.ToInt16(lblCategoryId.Text.ToString())); if (dtCategory.Rows.Count > 0) lblCategoryId.Text = dtCategory[0].CategoryName.ToString(); else lblCategoryId.Visible = false; LinkButton lbtnDelete = (LinkButton)e.Row.FindControl("lbtnDelete"); lbtnDelete.Attributes.Add("OnClick", "return confirm('Are you sure to delete this record?');"); } } }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Label lblCategoryId = (Label)e.Row.FindControl("lblCategoryId"); dtCategory = taCategory.SelectCategorybyCategoryId(Convert.ToInt32(lblCategoryId.Text)); if (dtCategory.Rows.Count > 0) lblCategoryId.Text = dtCategory[0].CategoryName.ToString(); LinkButton lbtnManageSetCode = (LinkButton)e.Row.FindControl("lbtnManageSetCode"); if (lbtnManageSetCode.Text == null || lbtnManageSetCode.Text == "") lbtnManageSetCode.Text = "Include in this Set"; else lbtnManageSetCode.Text = "Remove from this Set"; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; LoadCompanies(); if (Request.QueryString["ID"] != null) { if (Request.QueryString["ID"] == "True") { lblMsg.Visible = true; lblMsg.Text = "Successfully Edited"; } } if (Request.QueryString["CategoryId"] != null) { int CategoryId = Convert.ToInt32(Request.QueryString["CategoryId"]); dtCategory = taCategory.SelectCategorybyCategoryId(CategoryId); if (dtCategory.Rows.Count > 0) { DataRow row = dtCategory.Rows[0]; ddlCompany.Items.FindByValue(row["companyid"].ToString()).Selected = true; txtCategory.Text = row["CategoryName"].ToString(); } else { lblMsg.Text = "No Record Found"; btnEdit.Visible = false; return; } } else { lblMsg.Text = "No Record Found"; btnEdit.Visible = false; return; } }
private void BindData() { DataTable DT; ylib = new ylibWebClass(constr.connect()); FillWebControlClass FCC = new FillWebControlClass(); int CompanyId; int SubCategoryId; int CategoryId; int ProductGroupCode; #region SetListVariables CompanyId = StringOperation.QueryStringInt16Value(Request.QueryString["CompanyId"]); CategoryId = StringOperation.QueryStringInt16Value(Request.QueryString["CategoryId"]); SubCategoryId = StringOperation.QueryStringInt16Value(Request.QueryString["SubCategoryId"]); ProductGroupCode = StringOperation.QueryStringInt16Value(Request.QueryString["ProductGroupCode"]); #endregion #region FillDropDownLists dtCompany = taCompany.GetData(); FCC.FillDropDownList(ref ddlCompany, dtCompany, "CompanyName", "CompanyId", true, true, CompanyId.ToString()); dtCategory = taCategory.SelectCategorybyCompanyId(CompanyId); FCC.FillDropDownList(ref ddlCategory, dtCategory, "CategoryName", "CategoryId", true, true, CategoryId.ToString()); dtSubCategory = taSubCategory.GetDataByCategoryId(CategoryId); FCC.FillDropDownList(ref ddlSubCategory, dtSubCategory, "SubCategoryName", "SubCategoryId", true, true, SubCategoryId.ToString()); dtProductGroup = taProductGroup.GetDataBySubCategoryId(SubCategoryId); FCC.FillDropDownList(ref ddlProductGroupCode, dtProductGroup, "ProductGroupDescription", "ProductGroupCode", true, true, ProductGroupCode.ToString()); #endregion #region SetSelectionLabel if (CompanyId != 0 && CategoryId != 0 && SubCategoryId != 0 && ProductGroupCode != 0) lblGroupLevel.Text = "Product Group"; else if (CompanyId != 0 && CategoryId != 0 && SubCategoryId != 0) lblGroupLevel.Text = "Sub Category"; else if (CompanyId != 0 && CategoryId != 0) lblGroupLevel.Text = "Category"; else if (CompanyId != 0) lblGroupLevel.Text = "Company"; #endregion #region Set Main Repeater Page Parts DT = ylib.GiveDataTable_BySQLStatement("select PagePartName from PageParts "); if (DT.Rows.Count > 0) { if (CompanyId != 0) { Repeater1.DataSource = DT; Repeater1.DataBind(); } } else { lblMsg.Text = "No record found"; return; } #endregion }
protected void SelectCategories() { int CategoryId = Convert.ToInt32(Request.QueryString["CategoryId"]); if ((Request.QueryString["CompanyId"] != null) && (Convert.ToInt16(Request.QueryString["CompanyId"]) != 0)) { int CompanyId = Convert.ToInt32(Request.QueryString["CompanyId"]); dtCategory = taCategory.SelectCategorybyCompanyId(CompanyId); ddlCompany.Items.FindByValue(CompanyId.ToString()).Selected = true; ddlCategory.DataSourceID = null; ddlCategory.DataSource = dtCategory; ddlCategory.DataTextField = dtCategory.Columns[1].ToString(); ddlCategory.DataValueField = dtCategory.Columns[0].ToString(); ddlCategory.DataBind(); if ((Request.QueryString["CategoryId"] != null) && (Convert.ToInt16(Request.QueryString["CategoryId"]) != 0)) { ddlCategory.Items.FindByValue(Request.QueryString["CategoryId"]).Selected = true; } else ddlCategory.Items.Insert(0, new ListItem("Please Select", "")); } else ddlCategory.Items.Insert(0, new ListItem("Please Select", "")); }
private void BindData() { int SectionCode = 0; FillWebControlClass FCC = new FillWebControlClass(); ylib = new ClassP.ylibWebClass(constr.connect()); lblGroupLevel.Text = Request.QueryString["lblGroupLevel"]; int CompanyId ; int SubCategoryId ; int CategoryId; int ProductGroupCode ; #region SetListVariables SectionCode = StringOperation.QueryStringInt16Value(Request.QueryString["SectionCode"]); CompanyId = StringOperation.QueryStringInt16Value(Request.QueryString["CompanyId"]); CategoryId = StringOperation.QueryStringInt16Value(Request.QueryString["CategoryId"]); SubCategoryId = StringOperation.QueryStringInt16Value(Request.QueryString["SubCategoryId"]); ProductGroupCode = StringOperation.QueryStringInt16Value(Request.QueryString["ProductGroupCode"]); #region Write Cookies if (CompanyId != 0 && CategoryId != 0 && SubCategoryId != 0 && ProductGroupCode != 0) { Response.Cookies["ProductGroupCode"].Value=ProductGroupCode.ToString(); Response.Cookies["ProductGroupCode"].Expires=DateTime.Now.AddDays(1); } else if (CompanyId != 0 && CategoryId != 0 && SubCategoryId != 0) { Response.Cookies["SubCategoryId"].Value=SubCategoryId.ToString(); Response.Cookies["SubCategoryId"].Expires=DateTime.Now.AddDays(1); } else if (CompanyId != 0 && CategoryId != 0) { Response.Cookies["CategoryId"].Value = CategoryId.ToString(); Response.Cookies["CategoryId"].Expires = DateTime.Now.AddDays(1); } else if (CompanyId != 0) { Response.Cookies["CompanyId"].Value = CompanyId.ToString(); Response.Cookies["CompanyId"].Expires = DateTime.Now.AddDays(1); } #endregion #endregion lblSectionName.Text = ylib.giveValue("select SectionName from MainPageSection where SectionCode=" + SectionCode); #region FillDropDownLists dtCompany = taCompany.GetData(); FCC.FillDropDownList(ref ddlCompany, dtCompany, "CompanyName", "CompanyId",true,true,CompanyId.ToString()); dtCategory = taCategory.SelectCategorybyCompanyId(CompanyId); FCC.FillDropDownList(ref ddlCategory, dtCategory, "CategoryName", "CategoryId", true, true, CategoryId.ToString()); dtSubCategory = taSubCategory.GetDataByCategoryId(CategoryId); FCC.FillDropDownList(ref ddlSubCategory, dtSubCategory, "SubCategoryName", "SubCategoryId", true, true, SubCategoryId.ToString()); dtProductGroup = taProductGroup.GetDataBySubCategoryId(SubCategoryId); FCC.FillDropDownList(ref ddlProductGroupCode, dtProductGroup, "ProductGroupDescription", "ProductGroupCode", true, true, ProductGroupCode.ToString()); #endregion if (CompanyId != 0 && CategoryId != 0 && SubCategoryId != 0 && ProductGroupCode!=0) dtProduct = taProduct.GetDataByProductGroupCode(ProductGroupCode); else dtProduct = taProduct.GetDataByProductGroupCode(0); if (dtProduct.Rows.Count > 0) { GridView1.DataSourceID = null; GridView1.DataSource = dtProduct; GridView1.DataBind(); } else { GridView1.DataSourceID = null; GridView1.DataSource = dtProduct; GridView1.DataBind(); lblMsg.Text = "No record found"; return; } }
private void BindData() { FillWebControlClass FCC = new FillWebControlClass(); int CompanyId ; int SubCategoryId ; int CategoryId; int ProductGroupCode ; #region SetListVariables CompanyId = StringOperation.QueryStringInt16Value(Request.QueryString["CompanyId"]); CategoryId = StringOperation.QueryStringInt16Value(Request.QueryString["CategoryId"]); SubCategoryId = StringOperation.QueryStringInt16Value(Request.QueryString["SubCategoryId"]); ProductGroupCode = StringOperation.QueryStringInt16Value(Request.QueryString["ProductGroupCode"]); #region Write Cookies if (CompanyId != 0 && CategoryId != 0 && SubCategoryId != 0 && ProductGroupCode != 0) { Response.Cookies["ProductGroupCode"].Value = ProductGroupCode.ToString(); Response.Cookies["ProductGroupCode"].Expires = DateTime.Now.AddDays(1); } else if (CompanyId != 0 && CategoryId != 0 && SubCategoryId != 0) { Response.Cookies["SubCategoryId"].Value = SubCategoryId.ToString(); Response.Cookies["SubCategoryId"].Expires = DateTime.Now.AddDays(1); } else if (CompanyId != 0 && CategoryId != 0) { Response.Cookies["CategoryId"].Value = CategoryId.ToString(); Response.Cookies["CategoryId"].Expires = DateTime.Now.AddDays(1); } else if (CompanyId != 0) { Response.Cookies["CompanyId"].Value = CompanyId.ToString(); Response.Cookies["CompanyId"].Expires = DateTime.Now.AddDays(1); } #region GetCookies if (Request.Cookies["CompanyId"] != null && CompanyId==0) CompanyId = StringOperation.QueryStringInt16Value(Convert.ToString(Request.Cookies["CompanyId"].Value)); if (Request.Cookies["CompanyId"] != null && Request.Cookies["CategoryId"] != null && CategoryId == 0) CategoryId = StringOperation.QueryStringInt16Value(Convert.ToString(Request.Cookies["CategoryId"].Value)); if (Request.Cookies["CompanyId"] != null && Request.Cookies["CategoryId"] != null && Request.Cookies["SubCategoryId"] != null && SubCategoryId == 0) SubCategoryId = StringOperation.QueryStringInt16Value(Convert.ToString(Request.Cookies["SubCategoryId"].Value)); //if (Request.Cookies["ProductGroupCode"] != null && ProductGroupCode == 0) // ProductGroupCode = StringOperation.QueryStringInt16Value(Convert.ToString(Request.Cookies["ProductGroupCode"].Value)); #endregion #endregion #endregion #region FillDropDownLists dtCompany = taCompany.GetData(); FCC.FillDropDownList(ref ddlCompany, dtCompany, "CompanyName", "CompanyId",true,true,CompanyId.ToString()); dtCategory = taCategory.SelectCategorybyCompanyId(CompanyId); FCC.FillDropDownList(ref ddlCategory, dtCategory, "CategoryName", "CategoryId", true, true, CategoryId.ToString()); dtSubCategory = taSubCategory.GetDataByCategoryId(CategoryId); FCC.FillDropDownList(ref ddlSubCategory, dtSubCategory, "SubCategoryName", "SubCategoryId", true, true, SubCategoryId.ToString()); dtProductGroup = taProductGroup.GetDataBySubCategoryId(SubCategoryId); FCC.FillDropDownList(ref ddlProductGroupCode, dtProductGroup, "ProductGroupDescription", "ProductGroupCode", true, true, ProductGroupCode.ToString()); #endregion if (CompanyId != 0 && CategoryId != 0 && SubCategoryId != 0 && ProductGroupCode!=0) dtProduct = taProduct.GetDataByProductGroupCode(ProductGroupCode); else dtProduct = taProduct.GetDataByProductGroupCode(0); if (dtProduct.Rows.Count > 0) { GridView1.DataSourceID = null; GridView1.DataSource = dtProduct; GridView1.DataBind(); } else { GridView1.DataSourceID = null; GridView1.DataSource = dtProduct; GridView1.DataBind(); lblMsg.Text = "No record found"; return; } }
private void BindData() { if (Request.QueryString["CompanyId"] != null) { int CompanyId = Convert.ToInt32(Request.QueryString["CompanyId"]); dtCategory = taCategory.SelectCategorybyCompanyId(CompanyId); ddlCompany.Items.FindByValue(CompanyId.ToString()).Selected = true; if (dtCategory.Rows.Count > 0) { GridView1.DataSourceID = null; GridView1.DataSource = dtCategory; GridView1.DataBind(); } else { lblMsg.Text = "No record found"; return; } } }