protected void Imagefilter_Click(object sender, ImageClickEventArgs e)
{
//Defect = this.Session["DefectID11"].ToString();
string trteradataconnection = "Data Source='204.99.34.21';User ID='coebatch';Password='******';";
Teradata.Client.Provider.TdConnection tereconnection = new Teradata.Client.Provider.TdConnection(trteradataconnection);
string defectid = TxtDefectSearch.Text;
// int defect = Convert.ToInt32(defectid);
try
{
tereconnection.Open();
TdDataAdapter AdvancedDefectSearch =
new TdDataAdapter(@"select Defectid,Defectname,sdate as OpenDate,Status,Scycle as Cycles,Project,Tester,Module,Assignedto,Closedate as LastUpdatedDate from coebatch.tbl_Defect where CAST(defectid AS VARCHAR(8)) LIKE '%" + defectid + "%' order by Defectid asc ", tereconnection);
// IDataSource dt1 = new IDataSource ;
DataSet ds = new DataSet();
AdvancedDefectSearch.Fill(ds);
this.GridView1.DataSource = ds.Tables[0];
GridView1.DataKeyNames = new string[] { "Defectid" };
this.GridView1.DataBind();
}
catch (Teradata.Client.Provider.TdException ex)
{
//Throw the exception to calling environment
throw ex;
}
finally
{
//Close the Connection from the Database
tereconnection.Close();;
}
}
private void button1_Click(object sender, EventArgs e)
{
Stopwatch sw = new Stopwatch();
sw.Start();
Teradata.Client.Provider.TdConnection mainConn = new Teradata.Client.Provider.TdConnection();
TdConnectionStringBuilder stringBuilder = new TdConnectionStringBuilder();
stringBuilder.CommandTimeout = 300;
stringBuilder.ConnectionTimeout = 100;
stringBuilder.DataSource = host;
stringBuilder.UserId = uid;
stringBuilder.Password = pwd;
mainConn.ConnectionString = stringBuilder.ConnectionString;
this.Text = host;
mainConn.Open();
StreamReader gperead = new StreamReader(@txtFile.Text);
string szLine = "";
string[] szFields;
string[] szHeader;
szLine = gperead.ReadLine();
szLine = szLine.Replace("\"", "");
szHeader = szLine.Split(SEPARATOR);
Teradata.Client.Provider.TdCommand gpeCmd = new Teradata.Client.Provider.TdCommand("SELECT * FROM " + cboDatabaseList.Text + "." + cboTables.Text, mainConn);
gpeCmd.CommandTimeout = 10000;
int counter = 0;
Teradata.Client.Provider.TdDataAdapter gpeAdapter = new Teradata.Client.Provider.TdDataAdapter(gpeCmd);
gpeAdapter.UpdateBatchSize = 100000;
gpeAdapter.KeepCommandBatchSequence = false;
Teradata.Client.Provider.TdCommandBuilder cb = new Teradata.Client.Provider.TdCommandBuilder(gpeAdapter);
DataTable dt = new DataTable();
gpeAdapter.Fill(dt);
while ((szLine = gperead.ReadLine()) != null)
{
szLine = szLine.Replace("\"", "");
szFields = szLine.Split(SEPARATOR);
DataRow dr = dt.NewRow();
if (szFields.GetUpperBound(0) == szHeader.GetUpperBound(0))
{
for (int i = 0; i < szHeader.GetLength(0); i++)
{
if (szFields[i] == "?")
{
dr[szHeader[i]] = DBNull.Value;
}
else if (dr.Table.Columns[szHeader[i]].DataType == typeof(DateTime))
{
try {
dr[szHeader[i]] = Convert.ToDateTime(szFields[i].Trim('\"'));
}
catch (Exception ex) {
dr[szHeader[i]] = DBNull.Value;
}
}
else if (dr.Table.Columns[szHeader[i]].DataType == typeof(double))
{
dr[szHeader[i]] = Convert.ToDecimal(szFields[i].Trim('\"').Replace('.', ','));
}
else
{
try {
dr[szHeader[i]] = szFields[i].Trim('\"');
}
catch (Exception ex) {
dr[szHeader[i]] = DBNull.Value;
}
}
}
dt.Rows.Add(dr);
}
if ((counter++ % 100000) == 0)
{
try {
gpeAdapter.Update(dt);
}
catch (Exception ex) {
MessageBox.Show(this, ex.Message);
}
textBox1.Text = (counter - 1).ToString();
}
Application.DoEvents();
}
gpeAdapter.Update(dt);
textBox1.Text = counter.ToString();
dt.Dispose();
gpeCmd.Dispose();
mainConn.Close();
mainConn.Dispose();
gperead.Close();
sw.Stop();
MessageBox.Show("Done!\n" + sw.Elapsed);
}
protected void ImageExport_Click(object sender, ImageClickEventArgs e)
{
string trteradataconnection = "Data Source='204.99.34.21';User ID='coebatch';Password='******';";
Teradata.Client.Provider.TdConnection tereconnection = new Teradata.Client.Provider.TdConnection(trteradataconnection);
//TdDataAdapter ID;
// string defectid = TxtHistorySearch0.Text;
// ID = dbObj.DefectHome();
try
{
// 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);
tereconnection.Open();
TdDataAdapter AdvancedDefectSearch =
new TdDataAdapter(@"select Defectid,Defectname,sdate as OpenDate,Status,Scycle as Cycles,Project,Tester,Module,Assignedto,Closedate as LastUpdatedDate from coebatch.tbl_Defect order by Defectid asc ", tereconnection);
// IDataSource dt1 = new IDataSource ;
DataSet ds = new DataSet();
AdvancedDefectSearch.Fill(ds);
this.GridView1.DataSource = ds.Tables[0];
GridView1.DataKeyNames = new string[] { "Defectid" };
this.GridView1.DataBind();
}
catch (Teradata.Client.Provider.TdException ex)
{
//Throw the exception to calling environment
throw ex;
}
finally
{
//Close the Connection from the Database
tereconnection.Close();;
}
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 GridView1.HeaderRow.Cells)
{
cell.BackColor = GridView1.HeaderStyle.BackColor;
cell.Height = 25;
}
foreach (GridViewRow row in GridView1.Rows)
{
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 1 == 0)
{
//cell.BackColor = GridView1.AlternatingRowStyle.BackColor;
cell.Height = 25;
}
else
{
cell.BackColor = GridView1.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
//int columns = this.GridView1.Columns.Count;
// //GridView1.AllowPaging = false;
// // GridView1.DataBind();
// int Count = dbObj.GetDefectcount();
// Microsoft.Office.Interop.Excel.Application ExcelApp =
// new Microsoft.Office.Interop.Excel.Application();
// Microsoft.Office.Interop.Excel._Workbook ExcelBook;
// Microsoft.Office.Interop.Excel._Worksheet ExcelSheet;
// int i = 0;
// int j = 0;
// //create object of excel
// ExcelBook = (Microsoft.Office.Interop.Excel._Workbook)ExcelApp.Workbooks.Add(1);
// ExcelSheet = (Microsoft.Office.Interop.Excel._Worksheet)ExcelBook.ActiveSheet;
// //export header
// for (i = 1; i <= this.GridView1.Columns.Count; i++)
// {
// ExcelSheet.Cells[1, i] = this.GridView1.Columns[i - 1].HeaderText;
// }
// //export data
// for (i = 1; i <= Count; i++)
// {
// for (j = 1; j <= GridView1.Columns.Count; j++)
// {
// ExcelSheet.Cells[i + 1, j] = GridView1.Rows[i - 1].Cells[j - 1].Text;
// }
// }
// ExcelApp.Visible = true;
// //GridView1.AllowPaging = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["New"] == null)
{
Server.Transfer("Login2.aspx", true);
// Response.Redirect("Login.aspx");
}
Page.Response.Cache.SetCacheability(HttpCacheability.NoCache);
if (!this.IsPostBack)
{
if (Session["New"] == null)
{
Server.Transfer("Login2.aspx", true);
// Response.Redirect("Login.aspx");
}
else
{
Session["MySessionVar"] = 0;
int DefectID1 = (int)Session["MySessionVar"];
this.Master.Label = Session["New"].ToString();
LbMessage.Visible = false;
LbMessage.Text = "";
//this.Session["DefectID11"] = DefectID1;
//Defect = this.Session["DefectID11"].ToString();
string trteradataconnection = "Data Source='204.99.34.21';User ID='coebatch';Password='******';";
Teradata.Client.Provider.TdConnection tereconnection = new Teradata.Client.Provider.TdConnection(trteradataconnection);
//TdDataAdapter ID;
// string defectid = TxtHistorySearch0.Text;
// ID = dbObj.DefectHome();
try
{
// 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);
tereconnection.Open();
TdDataAdapter AdvancedDefectSearch =
new TdDataAdapter(@"select Defectid,Defectname,sdate as OpenDate,Status,Scycle as Cycles,Project,Tester,Module,Assignedto,Closedate as LastUpdatedDate from coebatch.tbl_Defect order by Defectid asc ", tereconnection);
// IDataSource dt1 = new IDataSource ;
DataSet ds = new DataSet();
AdvancedDefectSearch.Fill(ds);
this.GridView1.DataSource = ds.Tables[0];
GridView1.DataKeyNames = new string[] { "Defectid" };
this.GridView1.DataBind();
}
catch (Teradata.Client.Provider.TdException ex)
{
//Throw the exception to calling environment
throw ex;
}
finally
{
//Close the Connection from the Database
tereconnection.Close();;
}
}
}
else
{
}
}
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);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.Cache.SetCacheability(HttpCacheability.NoCache);
if (Session["New"] == null)
{
Server.Transfer("Login2.aspx", true);
// Response.Redirect("Login.aspx");
}
else
{
int Defectiid = 0;
this.Master.WelLogIn = "";
this.Master.Label = Session["New"].ToString();
lbmessage.Visible = false;
lbmessage.Text = "";
Defectiid = (int)Session["MySessionVar"];
string trteradataconnection = "Data Source='204.99.34.21';User ID='coebatch';Password='******';";
Teradata.Client.Provider.TdConnection tereconnection = new Teradata.Client.Provider.TdConnection(trteradataconnection);
int ID;
// string defectid = TxtHistorySearch0.Text;
ID = dbObj.DefectIDSearch(Defectiid);
try
{
if (ID == 0)
{
lbmessage.Visible = true;
lbmessage.Text = "Please enter a valid DefectID and Search";
}
else
{
// 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);
tereconnection.Open();
TdDataAdapter AdvancedDefectSearch =
new TdDataAdapter(@"select Defectid,Defectname,sdate as CreatedDate,Status,Scycle as Cycles,Project as Releases,Tester,Module,Assignedto,Closedate as LastUpdateddate,Defecthistid,Severity,Environment,Releases as Project,Rootcause, Loginuser from coebatch.tbl_Defect_history where defectid = " + Defectiid + " order by defecthistid asc ", tereconnection);
// IDataSource dt1 = new IDataSource ;
DataSet ds = new DataSet();
AdvancedDefectSearch.Fill(ds);
this.GridHistory.DataSource = ds.Tables[0];
GridHistory.DataKeyNames = new string[] { "Defecthistid" };
this.GridHistory.DataBind();
}
}
catch (Teradata.Client.Provider.TdException ex)
{
//Throw the exception to calling environment
throw ex;
}
finally
{
//Close the Connection from the Database
tereconnection.Close();;
}
}
}
