protected void btnExport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename = QC_Schedule.xls");
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite =
new HtmlTextWriter(stringWrite);
GrdScheduleList.AllowPaging = false;
GetData();
GrdScheduleList.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
protected void GetData()
{
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@OPR", "33"),
};
DataTable Dt = new DataTable();
Dt = DBClass.GetDatatable_WithParam(param, "DM_SP_GET_DATA");
GrdScheduleList.DataSource = Dt;
GrdScheduleList.DataBind();
}
catch (Exception ex)
{
_logger.Error(string.Concat("GetData::", ex.Message), ex);
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename = QC_Schedule.xls");
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite =
new HtmlTextWriter(stringWrite);
GrdScheduleList.AllowPaging = false;
GetData();
foreach (GridViewRow row in GrdScheduleList.Rows)
{
GrdScheduleList.Columns[0].Visible = false;
(GrdScheduleList.Rows[row.RowIndex].Cells[1].FindControl("lnkScheduleNumber") as LinkButton).Font.Underline = false;
(GrdScheduleList.Rows[row.RowIndex].Cells[1].FindControl("lnkScheduleNumber") as LinkButton).Enabled = false;
}
GrdScheduleList.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
protected void BtnShow_Click(object sender, EventArgs e)
{
bool plantIsNull = false;
bool scheduleTypeIsNull = false;
try
{
if (drpPlant.SelectedIndex == 0 && drpScheduleTypeId.SelectedIndex == 0 && string.IsNullOrEmpty(txtCreatedBy.Text))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('Please select/Enter atleast one field')", true);
}
else
{
if (drpPlant.SelectedIndex == 0)
{
plantIsNull = true;
drpPlant.Items.RemoveAt(0);
drpPlant.Items.Insert(0, new ListItem("0"));
drpPlant.SelectedValue = "0";
}
if (drpScheduleTypeId.SelectedIndex == 0)
{
scheduleTypeIsNull = true;
drpScheduleTypeId.Items.RemoveAt(0);
drpScheduleTypeId.Items.Insert(0, new ListItem("0"));
drpScheduleTypeId.SelectedValue = "0";
}
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@OPR", "55"),
new SqlParameter("@PlantCode", drpPlant.SelectedValue),
new SqlParameter("@ScheduleTypeId", drpScheduleTypeId.SelectedValue),
new SqlParameter("@CreatedBy", txtCreatedBy.Text)
};
DataTable Dt = new DataTable();
Dt = DBClass.GetDatatable_WithParam(param, "DM_SP_GET_DATA");
GrdScheduleList.DataSource = Dt;
GrdScheduleList.DataBind();
if (Dt.Rows.Count > 0)
{
if (plantIsNull)
{
drpPlant.Items.RemoveAt(0);
drpPlant.Items.Insert(0, new ListItem("Select Plant"));
}
if (scheduleTypeIsNull)
{
drpScheduleTypeId.Items.RemoveAt(0);
drpScheduleTypeId.Items.Insert(0, new ListItem("Select Schedule Type"));
}
//drpScheduleTypeId.SelectedIndex = 0;
//drpPlant.SelectedIndex = 0;
//txtCreatedBy.Text = "";
}
else if (Dt.Rows.Count == 0)
{
if (plantIsNull)
{
drpPlant.Items.RemoveAt(0);
drpPlant.Items.Insert(0, new ListItem("Select Plant"));
}
if (scheduleTypeIsNull)
{
drpScheduleTypeId.Items.RemoveAt(0);
drpScheduleTypeId.Items.Insert(0, new ListItem("Select Schedule Type"));
}
///drpScheduleTypeId.SelectedIndex = 0;
//drpPlant.SelectedIndex = 0;
//txtCreatedBy.Text = "";
}
}
}
catch (Exception ex)
{
_logger.Error(string.Concat("BindCompletedScheduleStatusGrid::", ex.Message), ex);
}
}
