protected void Page_Load(object sender, EventArgs e) { EmployeeLogic el = new EmployeeLogic(); Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"])); if (!IsPostBack) { if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE") || e2.Designation.Equals("MARKETING MANAGER") || e2.Designation.Equals("MARKETING EMPLOYEE") || e2.Designation.Equals("PRODUCTION MANAGER") || e2.Designation.Equals("PRODUCTION EMPLOYEE")) { QuotationLogic QL = new QuotationLogic(); DataTable dt = QL.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } CustomerLogic cl = new CustomerLogic(); DataTable dt1 = cl.SelectAll(); dt1.Rows.Add(0, "All Customer", null, null, null, null, null, null, null, null, null); dt1.DefaultView.Sort = "CustomerID"; DropDownList1.DataSource = dt1; DropDownList1.DataTextField = "Name"; DropDownList1.DataValueField = "CustomerID"; DropDownList1.DataBind(); DropDownList1.SelectedItem.Text = "All Customer"; ProductLogic pl = new ProductLogic(); DataTable dt2 = pl.SelectAll(); dt2.Rows.Add(0, "All Product", null, null, null, null, null, null, null, null); dt2.DefaultView.Sort = "ProductID"; DropDownList2.DataSource = dt2; DropDownList2.DataTextField = "Name"; DropDownList2.DataValueField = "ProductID"; DropDownList2.DataBind(); DropDownList2.SelectedItem.Text = "All Product"; } else { Response.Redirect("Access.aspx"); } } }