protected void btQuery_Click(object sender, EventArgs e) { KwGridView.Visible = false; ButtonExcel_Click.Visible = false; Label8.Visible = false; /****EAC BAD CODE int Singlequote=0;*/ Message.Visible = false; string[] split = null; string iProdId = null; string delimStr = ","; char[] delimiter = delimStr.ToCharArray(); Boolean valid = false; Boolean validnum = false; Boolean validlen = false; iProdId = TxtPubid.Text; if (iProdId.Length != 0) { valid = PubEntAdminManager.OtherVal(iProdId); validnum = PubEntAdminManager.SpecialVal2(iProdId); validlen = PubEntAdminManager.LenVal(iProdId, 50); /****EAC BAD CODE Singlequote = iProdId.IndexOf(",");*/ } if ((valid == false) && (validnum == false) && (validlen == true) /****EAC BAD CODE & Singlequote==0*/) { split = iProdId.Split(delimiter); ArrayList list = strQuery(split); if (iProdId == "") { Message.Visible = true; } else if (list.Count == 0) { ButtonExcel_Click.Visible = false; Label8.Visible = false; Message.Text = "Invalid Publication ID(s)"; Message.Visible = true; } else { KwGridView.DataSource = list; KwGridView.DataBind(); KwGridView.Visible = true; Label8.Visible = true; ButtonExcel_Click.Visible = true; } } else { Response.Redirect("InvalidInput.aspx"); } }
protected void btAll_Click(object sender, EventArgs e) { Message.Visible = false; TxtPubid.Text = ""; ArrayList list = strAllQuery(); KwGridView.DataSource = list; KwGridView.DataBind(); KwGridView.Visible = true; Label8.Visible = true; ButtonExcel_Click.Visible = true; }
protected void btQuery_Click(object sender, EventArgs e) { string strsDate = this.txtStartDate.Text; string streDate = this.txtEndDate.Text; ArrayList list = null; Label9.ToolTip = ""; Label8.Visible = false; ButtonExcel_Click.Visible = false; KwGridView.DataSource = list; KwGridView.AllowSorting = false; KwGridView.DataBind(); Message.Text = ""; if (strsDate.Length == 0 || streDate.Length == 0) { Message.Visible = true; Message.Text = "Please Enter required values"; } else if (strsDate.Length != 0 && streDate.Length != 0) { DateTime sDate = Convert.ToDateTime(strsDate); DateTime eDate = Convert.ToDateTime(streDate); if (sDate > eDate) { Message.Visible = true; Message.Text = "Start Date cannot be greater than End Date"; } } if (strsDate.Length != 0 && streDate.Length != 0 && (Convert.ToDateTime(strsDate) <= Convert.ToDateTime(streDate))) { Label9.Visible = true; lbtextDates.Text = " dates between " + strsDate + " and " + streDate; list = strQuery(Convert.ToDateTime(strsDate), Convert.ToDateTime(streDate)); if (list.Count != 0) { KwGridView.DataSource = list; KwGridView.AllowSorting = false; KwGridView.DataBind(); Label8.Visible = true; ButtonExcel_Click.Visible = true; } else if (list.Count == 0) { Message.Text = "No Data available for selected Dates"; } } }