public static void PerformSQLQuery(string sqlQuery)
{
using (useSQL.useSQL dbCon = new useSQL.useSQL(frm_menu.conStr))
{
dbCon.PerformQuery(sqlQuery);
}
}
public static DataTable GetNDTOnlyData(DataTable dtData)
{
DataTable retData = new DataTable();
for (int i = 1; i < dtData.Rows.Count; i++)
{
DataTable result = new DataTable();
using (useSQL.useSQL dbCon = new useSQL.useSQL(frm_menu.conStr))
{
result = dbCon.PerformQuery("SELECT UNIT,SERVICE, LINE,TRAIN, JOINTNUMBER, RTNUMBER1, RTDATE1, RTNUMBER2, RTDATE2, RTNUMBER3, RTDATE3,"
+ "RESHOOT, RESHOOTDATE, RESHOOT2, RESHOOTDATE2,RTACCEPTED,"
+ "PWHT1, PWHTDATE1, PWHT2, PWHTDATE2, PWHT3, PWHTDATE3, PWHTACCEPTED,"
+ "HT1, HTDATE1, HT2, HTDATE2, HT3, HTDATE3, HTAACCEPTED,"
+ "HTB, HTBDATE, HTB2, HTB2DATE, HTB3, HTB3DATE, HTBACCEPTED,"
+ "PMINUMBER, PMIDATE, PMI,"
+ "PTNUMBER, PTDATE, PT,"
+ "FERRIT, FERRITDATE, FERRIT2, FERRIT2DATE, FERRIT3, FERRIT3DATE, FERRITACCEPTED"
+ " from joints WITH (NOLOCK) where Unit ='" + dtData.Rows[i][1].ToString()
+ "' and [Service] ='" + dtData.Rows[i][0].ToString()
+ "' and Line ='" + dtData.Rows[i][2].ToString()
+ "' and Train='" + dtData.Rows[i][3].ToString()
+ "' and Jointnumber='" + dtData.Rows[i][4].ToString() + "'");
}
if (retData.Columns.Count == 0)
{
retData = result.Clone();
}
retData.ImportRow(result.Rows[0]);
}
return(retData);
}
public static void InitWelders(DataTable dtWelder)
{
using (dbCon = new useSQL.useSQL(conStr))
{
dtWelder = dbCon.PerformQuery("select distinct id,rtrim(stamp) as [stamp],name,subcontractor, issueddate,expdate,remarks,active "
+ "from WelderList where stamp not like 'F%' order by stamp ");
}
}
public static void InitJoints(DataTable dtJoints)
{
string script = File.ReadAllText(@"..\QUERIES\Joints.sql");
using (dbCon = new useSQL.useSQL(conStr))
{
dtJoints = dbCon.PerformQuery(script);
}
}
public static void UploadData(DataGridView dgData)
{
for (int i = 1; i < dgData.Rows.Count; i++)
{
using (useSQL.useSQL dbCon = new useSQL.useSQL(frm_menu.conStr))
{
}
}
}
public static DataTable GetDBData(string sqlQuery)
{
DataTable returnData = new DataTable();
using (useSQL.useSQL dbCon = new useSQL.useSQL(frm_menu.conStr))
{
returnData = dbCon.PerformQuery(sqlQuery);
}
return(returnData);
}
public static DataTable GetNDTJointData(NDT_Control.Data_Classes.NDT rawData)
{
DataTable retData = new DataTable();
using (useSQL.useSQL dbCon = new useSQL.useSQL(frm_uploadData.conStr))
{
retData = dbCon.PerformQuery("select *"
+ " from joints WITH (NOLOCK) where Unit ='" + rawData._unit
+ "' and [Service] ='" + rawData._service
+ "' and Line ='" + rawData._line
+ "' and Train='" + rawData._train
+ "' and Jointnumber='" + rawData._joint + "'");
}
return(retData);
}
private void btnVerify_Click(object sender, EventArgs e)
{
try
{
if (cmbMode.SelectedItem.ToString().Equals("DWR AFTER PRESSURE TEST"))
{
string script = File.ReadAllText(@"..\QUERIES\DWR after TP.sql");
StringBuilder sb = new StringBuilder(script);
sb.Replace("@testpacknum", txt_tp.Text);
sb.Replace("@TPDate", txt_tpDate.Text);
DataTable retData = new DataTable();
lst_joints.Items.Clear();
using (dbCon = new useSQL.useSQL(conStr))
{
retData = dbCon.PerformQuery(sb.ToString());
}
if (retData.Rows.Count > 0)
{
for (int n = 0; n < retData.Rows.Count; n++)
{
string[] row = { retData.Rows[n][0].ToString(), retData.Rows[n][1].ToString(),
retData.Rows[n][2].ToString(), retData.Rows[n][3].ToString(),
retData.Rows[n][4].ToString(), retData.Rows[n][5].ToString(),
retData.Rows[n][6].ToString(), retData.Rows[n][7].ToString() };
var jointData = new ListViewItem(row);
lst_joints.Items.Add(jointData);
}
}
pnl_NDT_Loader.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show("TP number or TP Date is invalid.");
}
}
public void DWRCheck(DataTable dwrData)
{
DataTable dtresult = new DataTable();
dtresult.Columns.Add("S/N");
dtresult.Columns.Add("unit");
dtresult.Columns.Add("service");
dtresult.Columns.Add("line");
dtresult.Columns.Add("train");
dtresult.Columns.Add("joint");
dtresult.Columns.Add("welder1 - SUBCON");
dtresult.Columns.Add("welder2 - SUBCON");
dtresult.Columns.Add("welder1 - PCA");
dtresult.Columns.Add("welder2 - PCA");
dtresult.Columns.Add("WELDER COMMENT");
DataTable dtjoints = new DataTable();
string[] rowData = new string[] { };
for (int i = 0; i < dwrData.Rows.Count; i++)
{
using (dbCon = new useSQL.useSQL(conStr))
{
dtjoints = dbCon.PerformQuery("select Unit, [Service], Line, Train, Spool, JointNumber,"
+ " welder1, welder2 "
+ " from joints WITH (NOLOCK) where Unit ='" + dwrData.Rows[i][1]
+ "' and [Service] ='" + dwrData.Rows[i][2]
+ "' and Line ='" + dwrData.Rows[i][3]
+ "' and Train='" + dwrData.Rows[i][4]
+ "' and Jointnumber='" + dwrData.Rows[i][5] + "'");
}
if (dtjoints.Rows.Count > 0)
{
rowData = new string[] { dwrData.Rows[i][0].ToString(), dwrData.Rows[i][1].ToString(), dwrData.Rows[i][2].ToString()
, dwrData.Rows[i][3].ToString(), dwrData.Rows[i][4].ToString()
, dwrData.Rows[i][5].ToString(), dwrData.Rows[i][6].ToString()
, dwrData.Rows[i][7].ToString()
, dtjoints.Rows[0]["welder1"].ToString()
, dtjoints.Rows[0]["welder2"].ToString()
, (dwrData.Rows[i][6].ToString() == dtjoints.Rows[0]["welder1"].ToString().Trim()) &&
(dwrData.Rows[i][7].ToString() == dtjoints.Rows[0]["welder2"].ToString().Trim()) ? "MATCH" : "NOT MATCH" };
}
else
{
rowData = new string[] { dwrData.Rows[i][0].ToString(), dwrData.Rows[i][1].ToString(), dwrData.Rows[i][2].ToString()
, dwrData.Rows[i][3].ToString(), dwrData.Rows[i][4].ToString()
, dwrData.Rows[i][5].ToString(), dwrData.Rows[i][6].ToString()
, dwrData.Rows[i][7].ToString()
, ""
, ""
, "ISO NOT EXISTING IN PCA" };
}
dtresult.NewRow();
dtresult.Rows.Add(rowData);
}
string filePath = System.IO.Path.GetDirectoryName(txt_filePath.Text) + "\\" + System.IO.Path.GetFileNameWithoutExtension(txt_filePath.Text) + " - DWR WELDER COMMENTS.xlsx";
Utilities.ExportExcel(dtresult, filePath);
}
public static void CheckFiles(string ndtType, frm_menu updateLoading)
{
HashSet <string> dtpdf = new HashSet <string>();
useSQL.useSQL dbCon;
string conStr = File.ReadAllText(@"..\ndtCon.cfg");
DirectoryInfo d = null;
if (ndtType.Equals("RT"))
{
d = new DirectoryInfo(@"Z:\04 - Construction\04-Site Progress Report\ISOMETRICS\ABOVEGROUND\NDT\RT");
}
else if (ndtType.Equals("PWHT"))
{
d = new DirectoryInfo(@"Z:\04 - Construction\04-Site Progress Report\ISOMETRICS\ABOVEGROUND\NDT\PWHT");
}
else if (ndtType.Equals("HTA"))
{
d = new DirectoryInfo(@"Z:\04 - Construction\04-Site Progress Report\ISOMETRICS\ABOVEGROUND\NDT\HTA");
}
else if (ndtType.Equals("HTB"))
{
d = new DirectoryInfo(@"Z:\04 - Construction\04-Site Progress Report\ISOMETRICS\ABOVEGROUND\NDT\HTB");
}
else if (ndtType.Equals("PMI"))
{
d = new DirectoryInfo(@"Z:\04 - Construction\04-Site Progress Report\ISOMETRICS\ABOVEGROUND\NDT\PMI");
}
else if (ndtType.Equals("PT"))
{
d = new DirectoryInfo(@"Z:\04 - Construction\04-Site Progress Report\ISOMETRICS\ABOVEGROUND\NDT\PT");
}
else if (ndtType.Equals("FT") || ndtType.Equals("FERRIT"))
{
d = new DirectoryInfo(@"Z:\04 - Construction\04-Site Progress Report\ISOMETRICS\ABOVEGROUND\NDT\Ferrit");
}
else if (ndtType.Equals("DWR"))
{
d = new DirectoryInfo(@"Z:\04 - Construction\04-Site Progress Report\ISOMETRICS\ABOVEGROUND\WeldReport");
}
FileInfo[] Files = d.GetFiles("*.pdf");
int filectr = 0;
foreach (FileInfo file in Files)
{
filectr++;
dtpdf.Add(Path.GetFileNameWithoutExtension(file.Name));
updateLoading.ChangeUpperLabel("TOTAL PDF FILES:" + filectr);
}
DataTable dtDBReport = new DataTable();
using (dbCon = new useSQL.useSQL(conStr))
{
if (ndtType.Equals("RT"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(rtnumber1) as [reportnum],unit,service,line, train, JointNumber, rtdate1,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] "
+ " from Joints WITH(NOLOCK) WHERE RTNUMBER1 <> '' union select distinct RTRIM(RTnumber2) "
+ ",unit,service,line, train, JointNumber, rtdate2,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE RTNUMBER2 <> '' "
+ " union select distinct RTRIM(RTnumber3),unit,service,line, train, JointNumber,rtdate3,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WHERE RTNUMBER3 <> '' union select distinct RTRIM(reshoot) "
+ ",unit,service,line, train, JointNumber,reshootdate,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE RESHOOT <> '' union "
+ "select distinct RTRIM(reshoot2),unit,service,line, train, JointNumber,reshootdate2,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] "
+ "from Joints WITH(NOLOCK) WHERE RESHOOT2 <> ''");
}
else if (ndtType.Equals("PWHT"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(PWHT1) as [reportnum],unit,service,line, train, JointNumber,pwhtdate1,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE PWHT1 <> '' union select distinct RTRIM(PWHT2)"
+ ",unit,service,line, train, JointNumber,pwhtdate2,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE PWHT2 <> '' union select distinct RTRIM(PWHT3)"
+ ",unit,service,line, train, JointNumber,pwhtdate3,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE PWHT3 <>''");
}
else if (ndtType.Equals("HTA"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(HT1) as [reportnum],unit,service,line, train, JointNumber,htdate1,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE HT1 <> '' union select distinct RTRIM(HT2)"
+ ",unit,service,line, train, JointNumber,htdate2,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE HT2 <> '' union select distinct RTRIM(HT3),unit,service,line, train, JointNumber,htdate3,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] "
+ " from Joints WITH(NOLOCK) WHERE HT3 <>''");
}
else if (ndtType.Equals("HTB"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(HTB) as [reportnum],unit,service,line, train, JointNumber,htbdate,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE HTB <> '' union select distinct RTRIM(HTB2)"
+ ",unit,service,line, train, JointNumber,htb2date,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE HTB2 <> '' union select distinct RTRIM(HTB3),unit,service,line, train, JointNumber,htb3date,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] "
+ " from Joints WITH(NOLOCK) WHERE HTB3 <>''");
}
else if (ndtType.Equals("PMI"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(PMINUMBER) as [reportnum],unit,service,line, train, JointNumber, pmidate,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE PMINUMBER <> ''");
}
else if (ndtType.Equals("PT"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(PTNUMBER) as [reportnum],unit,service,line, train, JointNumber,ptdate,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE PTNUMBER <> ''");
}
else if (ndtType.Equals("FT") || ndtType.Equals("FERRIT"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(FERRIT) as [reportnum],unit,service,line, train, JointNumber,ferritdate,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE FERRIT <> '' union select distinct RTRIM(FERRIT2)"
+ ",unit,service,line, train, JointNumber,ferrit2date,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] from Joints WITH(NOLOCK) WHERE FERRIT2 <> '' union select distinct RTRIM(FERRIT3),unit,service,line, train, JointNumber,ferrit3date,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE]"
+ " from Joints WITH(NOLOCK) WHERE FERRIT3 <> ''");
}
else if (ndtType.Equals("DWR"))
{
dtDBReport = dbCon.PerformQuery("SELECT DISTINCT WeldingReportNumber AS [reportnum],UNIT,SERVICE,LINE,TRAIN, JOINTNUMBER, dateofweld,case when active = 1 then 'ACTIVE' else 'CANCELED' end as [ACTIVE] FROM JOINTS"
+ " WHERE"
+ " WeldingReportNumber <> ''"
+ " AND "
+ " Active =1"
+ " AND JointType NOT IN ('FJ','TH')");
}
}
var hashSet = new HashSet <string[]>(DTtoList(dtDBReport));
var pcaReports = new HashSet <string>(dtDBReport.AsEnumerable().Select(x => x.Field <string>("reportnum")));
DataTable dtresult1 = new DataTable();
dtresult1.Columns.Add("ReportNumber");
dtresult1.Columns.Add("Result");
string[] strResult1 = null;
var hashReports = hashSet.First();
int pdfreportCount = 0;
if (!ndtType.Equals("DWR"))
{
foreach (string c in dtpdf)
{
updateLoading.ChangeLowerLabel(pdfreportCount++, dtpdf.Count(), "PDF FILE CHECKING: ");
if (pcaReports.Contains(c))
{
strResult1 = new string[] { c, "REPORT UPDATED IN PCA" };
}
else
{
strResult1 = new string[] { c, "NOT UPDATED" };
}
dtresult1.NewRow();
dtresult1.Rows.Add(strResult1);
}
}
DataTable dtresult2 = new DataTable();
dtresult2.Columns.Add("UNIT");
dtresult2.Columns.Add("SERVICE");
dtresult2.Columns.Add("LINE");
dtresult2.Columns.Add("TRAIN");
dtresult2.Columns.Add("JOINTNUMBER");
dtresult2.Columns.Add("ReportNumber");
dtresult2.Columns.Add("ReportDate");
dtresult2.Columns.Add("Joint Active");
dtresult2.Columns.Add("Result");
string[] strResult2 = null;
int dbReportCount = 0;
int totalrepcount = hashSet.Count();
foreach (string[] c in hashSet)
{
dbReportCount++;
//updateLoading.ChangeLowerLabel(dbReportCount, totalrepcount, "PCA JOINT REPORTS CHECKING: ");
//updateLoading.ChangeUpperLabel("PAKPAKPAK LABAN LNG BES:" + dbReportCount);
if (Regex.IsMatch(c[0], @"\s"))
{
if (dtpdf.Contains(c[0].Trim()))
{
if (!ndtType.Equals("DWR"))
{
strResult2 = new string[] { c[1], c[2], c[3], c[4], c[5], c[0], c[6], c[7], "REPORT EXISTING IN MAIN FOLDER BUT UPDATED WITH SPACES" };
}
}
else
{
strResult2 = new string[] { c[1], c[2], c[3], c[4], c[5], c[0], c[6], c[7], "REPORT MISSING IN MAIN FOLDER" };
}
}
else
{
if (dtpdf.Contains(c[0]))
{
if (!ndtType.Equals("DWR"))
{
strResult2 = new string[] { c[1], c[2], c[3], c[4], c[5], c[0], c[6], c[7], "REPORT EXISTING IN MAIN FOLDER" };
}
}
else
{
strResult2 = new string[] { c[1], c[2], c[3], c[4], c[5], c[0], c[6], c[7], "REPORT MISSING IN MAIN FOLDER" };
}
}
if (strResult2 != null)
{
dtresult2.NewRow();
dtresult2.Rows.Add(strResult2);
}
}
string fn = null;
if (ndtType.Equals("RT"))
{
fn = " RT CHECK FILE RESULT.xlsx";
}
else if (ndtType.Equals("PWHT"))
{
fn = " PWHT CHECK FILE RESULT.xlsx";
}
else if (ndtType.Equals("HTA"))
{
fn = " HTA CHECK FILE RESULT.xlsx";
}
else if (ndtType.Equals("HTB"))
{
fn = " HTB CHECK FILE RESULT.xlsx";
}
else if (ndtType.Equals("PMI"))
{
fn = " PMI CHECK FILE RESULT.xlsx";
}
else if (ndtType.Equals("PT"))
{
fn = " PT CHECK FILE RESULT.xlsx";
}
else if (ndtType.Equals("FT") || ndtType.Equals("FERRIT"))
{
fn = " FT CHECK FILE RESULT.xlsx";
}
else if (ndtType.Equals("DWR"))
{
fn = " DWR CHECK FILE RESULT.csv";
}
if (!ndtType.Equals("DWR"))
{
try
{
ExportExcel(dtresult1, dtresult2, Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "\\" + DateTime.Now.ToString("dd-MM-yyyy") + fn);
MetroMessageBox.Show(updateLoading, "", "RESULT SUCCESSFULLY IMPORTED! FILE LOCATED IN YOUR DESKTOP.", MessageBoxButtons.OK, MessageBoxIcon.Question, 150);
}
catch (Exception ex)
{
MetroMessageBox.Show(updateLoading, "IMPORT FAILED", "There is something wrong. " + ex.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Hand, 150);
}
}
else
{
ExportExcel(dtresult2, Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "\\" + DateTime.Now.ToString("dd-MM-yyyy") + fn);
}
}
public static DataTable CheckFilesFromLoader(DataTable worksheetCells)
{
useSQL.useSQL dbCon;
string conStr = File.ReadAllText(@"..\ndtCon.cfg");
DataTable dtresult2 = new DataTable();
dtresult2.Columns.Add("UNIT");
dtresult2.Columns.Add("SERVICE");
dtresult2.Columns.Add("LINE");
dtresult2.Columns.Add("TRAIN");
dtresult2.Columns.Add("JOINTNUMBER");
dtresult2.Columns.Add("ReportNumber");
dtresult2.Columns.Add("Result");
foreach (DataRow dr in worksheetCells.Rows)
{
DataTable dtDBReport = new DataTable();
using (dbCon = new useSQL.useSQL(conStr))
{
if (dr[1].Equals("RT"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(rtnumber1) as [reportnum],unit,service,line, train, JointNumber from Joints WITH(NOLOCK) WHERE RTNUMBER1 = '" + dr[0].ToString() + "' or "
+ " RTNumber2 = '" + dr[0].ToString() + "' OR RTNumber3 = '" + dr[0].ToString() + "' or reshoot = '" + dr[0].ToString() + "' or reshoot2 = '" + dr[0].ToString() + "' ");
}
else if (dr[1].Equals("PWHT"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(PWHT1) as [reportnum],unit,service,line, train, JointNumber from Joints WITH(NOLOCK) WHERE PWHT1 = '" + dr[0].ToString() + "' or PWHT2 ='" + dr[0].ToString() + "' OR PWHT3 = '" + dr[0].ToString() + "' ");
}
else if (dr[1].Equals("HTA"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(HT1),unit,service,line, train, JointNumber as [reportnum] from Joints WITH(NOLOCK) WHERE HT1 = '" + dr[0].ToString() + "' or HT2 = '" + dr[0].ToString() + "' OR HT3 = '" + dr[0].ToString() + "'");
}
else if (dr[1].Equals("HTB"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(HTB) as [reportnum],unit,service,line, train, JointNumber from Joints WITH(NOLOCK) WHERE HTB ='" + dr[0].ToString() + "' OR htb2 = '" + dr[0].ToString() + "' OR htb3 = '" + dr[0].ToString() + "'");
}
else if (dr[1].Equals("PMI"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(PMINUMBER) as [reportnum],unit,service,line, train, JointNumber as [reportnum] from Joints WITH(NOLOCK) WHERE PMINUMBER ='" + dr[0].ToString() + "'");
}
else if (dr[1].Equals("PT"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(PTNUMBER) as [reportnum],unit,service,line, train, JointNumber as [reportnum] from Joints WITH(NOLOCK) WHERE PTNUMBER ='" + dr[0].ToString() + "'");
}
else if (dr[1].Equals("FT") || dr[1].Equals("FERRIT"))
{
dtDBReport = dbCon.PerformQuery("select distinct RTRIM(FERRIT) as [reportnum],unit,service,line, train, JointNumber from Joints WITH(NOLOCK) WHERE FERRIT = '" + dr[0].ToString() + "' OR ferrit2 = '" + dr[0].ToString() + "' or ferrit3 = '" + dr[0].ToString() + "'");
}
}
string[] strResult2 = null;
if (dtDBReport.Rows.Count > 0)
{
strResult2 = new string[] { dtDBReport.Rows[0][1].ToString(), dtDBReport.Rows[0][2].ToString(), dtDBReport.Rows[0][3].ToString(), dtDBReport.Rows[0][4].ToString(), dtDBReport.Rows[0][5].ToString(), dtDBReport.Rows[0][0].ToString(), "REPORT UPDATED" };
}
else
{
strResult2 = new string[] { dtDBReport.Rows[0][1].ToString(), dtDBReport.Rows[0][2].ToString(), dtDBReport.Rows[0][3].ToString(), dtDBReport.Rows[0][4].ToString(), dtDBReport.Rows[0][5].ToString(), dtDBReport.Rows[0][0].ToString(), "REPORT NOT FOUND IN DATABASE" };
}
dtresult2.NewRow();
dtresult2.Rows.Add(strResult2);
}
return(dtresult2);
}
