protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (Request.QueryString["ID"] != null) { if (Request.QueryString["ID"] == "True") { //lblMsg.Visible = true; //lblMsg.Text = "Successfully Edited"; } } if (Request.QueryString["companyid"] != null) { int companyid = Convert.ToInt32(Request.QueryString["companyid"]); dtCompany = taCompany.SelectAllCompanyByCompanyId(companyid); if (dtCompany.Rows.Count > 0) { DataRow row = dtCompany.Rows[0]; lblCompany.Text = row["CompanyName"].ToString(); } } BindData(); }
protected void LoadCompanies() { dtCompany = taCompany.SelectAllCompany(); ddlCompany.DataSource = dtCompany; ddlCompany.DataTextField = dtCompany.Columns[1].ToString(); ddlCompany.DataValueField = dtCompany.Columns[0].ToString(); ddlCompany.DataBind(); }
protected void LoadCompanies() { dtCompany = taCompany.SelectAllCompany(); ddlCompany.DataSource = dtCompany; ddlCompany.DataTextField = dtCompany.Columns[1].ToString(); ddlCompany.DataValueField = dtCompany.Columns[0].ToString(); ddlCompany.DataBind(); ddlCompany.Items.Insert(0, new ListItem("Please select one", "")); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (Request.QueryString["ID"] != null) { if (Request.QueryString["ID"] == "True") { lblMsg.Visible = true; lblMsg.Text = "Successfully Edited"; } } if (Request.QueryString["companyid"] != null) { int companyid = Convert.ToInt32(Request.QueryString["companyid"]); dtCompany = taCompany.SelectAllCompanyByCompanyId(companyid); if (dtCompany.Rows.Count > 0) { DataRow row = dtCompany.Rows[0]; lblCompany.Text = row["CompanyName"].ToString(); txtAboutCompany.Text = row["AboutCompany"].ToString(); txtBrand.Text = row["Brand"].ToString(); txtOwner.Text = row["Owner"].ToString(); txtYearEstablished.Text = row["YearEstablished"].ToString(); txtContact.Text = row["Contact"].ToString(); txtEmail.Text = row["Email"].ToString(); txtTel1.Text = row["Tel1"].ToString(); txtFax1.Text = row["Fax1"].ToString(); txtURL.Text = row["URL"].ToString(); txtZipCode.Text = row["ZipCode"].ToString(); txtAddress.Text = row["Address"].ToString(); txtBusinessType.Text = row["BusinessType"].ToString(); txtMainProduct.Text = row["MainProduct"].ToString(); txtMainMarket.Text = row["MainMarket"].ToString(); txtApprovalCertificate.Text = row["ApprovalCertificate"].ToString(); txtMembership.Text = row["Membership"].ToString(); lblLogoName.Text = row["logoName"].ToString(); Image1.ImageUrl = "~/thumbnail.aspx?Image=Images/Logo/" + row["logoName"].ToString() ; } } }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { LinkButton lbtnDelete = (LinkButton)e.Row.FindControl("lbtnDelete"); lbtnDelete.Attributes.Add("OnClick", "return confirm('Are you sure to delete this record?');"); Label lblCompanyId = (Label)e.Row.FindControl("lblCompanyId"); if (lblCompanyId.Text != "") { dtCompany = taCompany.SelectCompanyNameFromCompanyId(Convert.ToInt32(lblCompanyId.Text)); if (dtCompany.Rows.Count > 0) lblCompanyId.Text = dtCompany[0].CompanyName.ToString(); else lblCompanyId.Visible = false; } } }
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 }
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() { dtCompany = taCompany.SelectAllCompany(); if (dtCompany.Rows.Count > 0) { GridView1.DataSourceID = null; GridView1.DataSource = dtCompany; GridView1.DataBind(); } else { lblMsg.Text = "No record found"; return; } }
private void SetProfileDetail() { if (Request.QueryString["companyid"] != null) { int companyid = Convert.ToInt32(Request.QueryString["companyid"]); dtCompany = taCompany.SelectAllCompanyByCompanyId(companyid); if (dtCompany.Rows.Count > 0) { DataRow row = dtCompany.Rows[0]; lblAboutCompany.Text = row["AboutCompany"].ToString(); lblBrand.Text = row["Brand"].ToString(); lblOwner.Text = row["Owner"].ToString(); lblYearEstablished.Text = row["YearEstablished"].ToString(); lblContact.Text = row["Contact"].ToString(); lblEmail.Text = row["Email"].ToString(); lblTel1.Text = row["Tel1"].ToString(); lblFax1.Text = row["Fax1"].ToString(); lblURL.Text = row["URL"].ToString(); lblZipCode.Text = row["ZipCode"].ToString(); lblAddress.Text = row["Address"].ToString(); lblBusinessType.Text = row["BusinessType"].ToString(); lblMainProduct.Text = row["MainProduct"].ToString(); lblMainMarket.Text = row["MainMarket"].ToString(); lblApprovalCertificate.Text = row["ApprovalCertificate"].ToString(); lblMembership.Text = row["Membership"].ToString(); } } }