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";
}
}
}
