protected void BtnExport_Click(object sender, EventArgs e)
{
// GridAdvancedSearch.AllowPaging = false;
// GridAdvancedSearch.DataBind();
string attachment = "attachment; filename=Export.xls";
Response.ClearContent(); Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
// GridView1.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in GridAdvancedSearch.HeaderRow.Cells)
{
cell.BackColor = GridAdvancedSearch.HeaderStyle.BackColor;
cell.Height = 25;
}
foreach (GridViewRow row in GridAdvancedSearch.Rows)
{
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 1 == 0)
{
//cell.BackColor = GridView1.AlternatingRowStyle.BackColor;
cell.Height = 25;
}
else
{
cell.BackColor = GridAdvancedSearch.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GridAdvancedSearch.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
protected void BtnSearch_Click(object sender, EventArgs e)
{
DateTime Sysdate = DateTime.Now;
fromdate = Calendarfrom.SelectedDate;
todate = CalendartoDate.SelectedDate;
int defect = 0;
if (fromdate > todate || fromdate > Sysdate || todate > Sysdate)
{
LbMessage.Visible = true;
LbMessage.Text = "Please enter the valid date range";
}
else
{
if
(DDLAssignedto.SelectedValue == "" && DDLEnvironment.SelectedValue == "" &&
DDLModule.SelectedValue == "" && DDLProject.SelectedValue == "" && DDLProjectname.SelectedValue == "" &&
DDlStatus.SelectedValue == "" &&
DDLTester.SelectedValue == "" && txtfromdate.Text == "" && txtTodate.Text == "" && TxtDefectname.Text == "" && DDLCycle.SelectedValue == "")
{
LbMessage.Visible = true;
LbMessage.Text = "Please select any of the search items";
}
else
{
try
{
string trteradataconnection = "Data Source='204.99.34.21';User ID='coebatch';Password='******';";
if (txtfromdate.Text != "" && txtTodate.Text != "")
{
Datefrom = Convert.ToDateTime(txtfromdate.Text);
DateTo = Convert.ToDateTime(txtTodate.Text);
Datefrom1 = new TdTimestamp(Datefrom);
DateTo1 = new TdTimestamp(DateTo);
}
else
{
DateTime timetora = DateTime.Now;
string text = timetora.ToString("MM/dd/yyyy HH:mm:ss");
DateTime Test1 = Convert.ToDateTime(text);
DateTo1 = new TdTimestamp(Test1);
}
Teradata.Client.Provider.TdConnection tereconnection = new Teradata.Client.Provider.TdConnection(trteradataconnection);
//TdCommand Teracomd = new TdCommand("select * from coebatch.tbl_Defect", tereconnection);
//TdDataAdapter AdvancedDefectSearch =
// new TdDataAdapter(@"Select DefectID,DefectName,Status,sDate,sCycle,Description,Project,Tester,TestcasesAssociated,Module,AssignedTo,Filenames,Filesize from coebatch.tbl_Defect where sDate between '" + fromdate + "' and '" + todate + "'", tereconnection);
TdCommand cmd = new TdCommand("COEBATCH.ADVANCEDDEFECTSEARCH1", tereconnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("VDefectname", TdType.VarChar).Value = TxtDefectname.Text;
cmd.Parameters.Add("VStatus", TdType.VarChar).Value = DDlStatus.SelectedValue;
cmd.Parameters.Add("VAssignedto", TdType.VarChar).Value = DDLAssignedto.SelectedValue;
cmd.Parameters.Add("VTester", TdType.VarChar).Value = DDLTester.SelectedValue;
cmd.Parameters.Add("VOpendate", TdType.Timestamp).Value = Datefrom1;
cmd.Parameters.Add("VOpendate1", TdType.Timestamp).Value = DateTo1;
cmd.Parameters.Add("VProject", TdType.VarChar).Value = DDLProject.SelectedValue;
cmd.Parameters.Add("VModule", TdType.VarChar).Value = DDLModule.SelectedValue;
cmd.Parameters.Add("VEnvironment", TdType.VarChar).Value = DDLEnvironment.SelectedValue;
cmd.Parameters.Add("VRelease", TdType.VarChar).Value = DDLProjectname.SelectedValue;
cmd.Parameters.Add("VCycle", TdType.VarChar).Value = DDLCycle.SelectedValue;
//cmd.Parameters.Add("cur1", TdType.AnyType).Direction = ParameterDirection.Output;
tereconnection.Open();
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
// defect = cmd.ExecuteNonQuery();
// TdDataAdapter AdvancedDefectSearch =
// new TdDataAdapter();
//AdvancedDefectSearch= new TdDataAdapter(cmd);
//// IDataSource dt1 = new IDataSource ;
//tereconnection.Open();
//DataSet ds = new DataSet();
//AdvancedDefectSearch.Fill(ds);
GridAdvancedSearch.DataSource = dt;
GridAdvancedSearch.DataBind();
//this.GridAdvancedSearch.DataSource = ds.Tables[0].DataSet;
//GridAdvancedSearch.DataKeyNames = new string[] { "Defectid" };
//this.GridAdvancedSearch.DataBind();
//this.GridAdvancedSearch.Visible = true;
if (GridAdvancedSearch.Rows.Count > 0)
{
rowcount = GridAdvancedSearch.Rows.Count;
BtnExport.Enabled = true;
}
else
{
BtnExport.Enabled = false;
}
}
catch (Teradata.Client.Provider.TdException ex)
{
//Throw the exception to calling environment
throw ex;
}
finally
{
//Close the Connection from the Database
}
//GridAdvancedSearch.DataSource = dt;
// AdvancedDefectSearch.Fill(dt);
}
}
}
