protected void fillScrollData()
{
string html = "";
string scmdTxt = string.Format(" SELECT " +
" CASE WHEN SCROLL_DT < (CURDATE()- INTERVAL 8 DAY) THEN " + //(CURDATE() - INTERVAL 1 DAY)
" CONCAT('<h4>','<img style=\"margin-right: 6px; vertical-align: bottom;\" src=\"images/calendar.png\" alt=\"new\" />',DATE_FORMAT( SCROLL_DT,'%a, %D %b, %Y') ,'</h4>' ,'<a href=\"' , WEBURL , '\" target=\"_self\">' , DOC_TITLE , '</a>') " +
" ELSE " +
" CONCAT('<h4>','<img style=\"margin-right: 6px; vertical-align: bottom;\" src=\"images/calendar.png\" alt=\"new\" />',DATE_FORMAT( SCROLL_DT,'%a, %D %b, %Y') ,'</h4>' ,'<a href=\"' , WEBURL , '\" target=\"_blank\"><img style=\"margin-right: 3px;\" src=\"images/new.gif\" alt=\"new\" />' , DOC_TITLE , '</a>') " +
" END DOC_TITLE " +
" FROM FRONTSCROLL " +
" WHERE SCROLL_TILL >= (CURDATE() ) " +
" ORDER BY DOC_ID desc "
);
try
{
DataSet ds = MySqlDBConnection.fillDataSet(scmdTxt);
DataTable dt = new DataTable();
dt = ds.Tables[0];
int colCount = ds.Tables[0].Columns.Count;
html = "<marquee id=\"marq\" height='220' behavior='scroll' direction='up' scrollamount='2' onmouseover='this.stop();' onmouseout='this.start();'>";
//add li
//Remove this block to remove the pic
// html += " <li> ";
// html += "<a href='http://pstcl.org/photogallery.aspx?p=19' target='_blank'>";
// html += "<img class=\"mImagedropshadowGallery\" src=\"pgallery/pimagesrday2019/thumb.JPEG\" alt=\"\" width='150px' height='150px'><br>Republic Day 2019 Celebrations at PSTCL,Patiala</a>";
// html += "</li>";
//Remove this block to remove the pic
for (int i = 0; i < dt.Rows.Count; i++)
{
html += " <li> ";
//for (int j = 0; j < dt.Columns.Count; j++) //1 instead of dt.Columns.Count
html += dt.Rows[i][0].ToString();
html += "</li>";
}
html += " </marquee>";
divScroll.InnerHtml = html;
dt.Clear();
dt.Dispose();
ds.Clear();
ds.Dispose();
}
catch (Exception ex)
{
divScroll.InnerHtml = html;
}
}
private static string InitiateConnectionProcess(string query)
{
try
{
MySqlDBConnection connection = new MySqlDBConnection();
MySqlConnection connect = connection.SQLConnection;
connection.RunInTrx(query, ref connect);
return("Success");
}
catch (Exception ex)
{
return(ex.Message);
}
}
protected void fillHtml()
{
string qry = " SELECT aboutus_final FROM ABOUTUS " +
" WHERE PUBLISH = 'Y' AND UPPER(OFFICE) = UPPER('CEHISD') ";
DataSet ds = MySqlDBConnection.fillDataSet(qry);
DataTable dt = new DataTable();
dt = ds.Tables[0];
if (ds.Tables[0].Rows.Count > 0)
{
string html = dt.Rows[0]["aboutus_final"].ToString();
divTable.InnerHtml = html;
}
ds.Clear();
ds.Dispose();
}
protected void fillHtmlTable()
{
//string scmdTxt = string.Format("SELECT DOC_REF,DOC_TITLE, DATE_FORMAT(NIT_OP_DT,'%d-%m-%Y') NIT_OP_DT,NIT_OP_TM,PUBLISH_DT " +
// " FROM ( " +
// " SELECT DOC_REF , GROUP_CONCAT(CONCAT( '<a href=\"' , WFM.PATH_URL ,DOC_ID, DOC_EXT, '\" target=\"_blank\">' , DOC_TITLE , '</a>') ORDER BY DOC_ID ASC SEPARATOR ' ') DOC_TITLE , " +
// " NIT_OP_DT " +
// ",NIT_OP_TM " +
// ", DATE_FORMAT( PUBLISH_DT,'%d-%m-%Y') PUBLISH_DT " +
// " FROM NIT " +
// " LEFT OUTER JOIN WEB_FOLDER_MAP WFM " +
// " ON NIT.WEB_ID = WFM.WEB_ID " +
// " WHERE PUBLISHED = 'Y' " +
// " GROUP BY PARENT_DOC_ID ORDER BY DOC_ID desc " +
// " ) FIN WHERE NIT_OP_DT >= (CURDATE()) " ) ;
string scmdTxt = " SET SESSION group_concat_max_len = 1000000; ";
scmdTxt += string.Format(" SELECT DOC_REF, " +
" (SELECT " +
" GROUP_CONCAT( " +
" CONCAT( '<a href=\"' , WFM.PATH_URL ,Y.DOC_ID, Y.DOC_EXT, '\" target=\"_blank\">' , Y.DOC_TITLE , '</a>') " +
" ORDER BY DOC_ID ASC SEPARATOR ' ' " +
" )DOC_TITLE " +
" FROM NIT Y " +
" LEFT OUTER JOIN WEB_FOLDER_MAP WFM " +
" ON Y.WEB_ID = WFM.WEB_ID " +
" WHERE Y.PARENT_DOC_ID = a.PARENT_DOC_ID " +
" GROUP BY Y.PARENT_DOC_ID " +
" ) DOC_TITLE " +
" ,DATE_FORMAT(NIT_OP_DT,'%d-%m-%Y') NIT_OP_DT " +
" , NIT_OP_TM " +
" , DATE_FORMAT( PUBLISH_DT,'%d-%m-%Y') PUBLISH_DT " +
" FROM " +
" NIT a " +
" INNER JOIN ( " +
" SELECT PARENT_DOC_ID, MAX(DOC_ID) DOC_ID " +
" FROM NIT " +
" GROUP BY PARENT_DOC_ID " +
" ) b ON a.PARENT_DOC_ID = b.PARENT_DOC_ID AND a.DOC_ID = b.DOC_ID " +
" AND a.PUBLISHED = 'Y' " +
" AND a.NIT_OP_DT >= (CURDATE()) " +
" ORDER BY a.DOC_ID desc ");
DataSet ds = MySqlDBConnection.fillDataSet(scmdTxt);
DataTable dt = new DataTable();
dt = ds.Tables[0];
string html = "<table id='tableTwo1' class='yui' style='margin-left: auto; margin-right: auto; width: 900px;' >";
//add header row
html += "<thead> ";
html += "<tr > " +
" <td colspan='5' class='filter' style='background: #ffffff;'> " +
" <span style='color: Black;'>Search</span> <input id='filterBoxTwo' value='' maxlength='30' size='30' type='text' /> " +
" <img id='filterClearTwo' src='_assets/img/cross.png' title='Click to clear filter.' alt='Clear Filter Image' /> " +
" </td> " +
" </tr> ";
html += "<tr>";
//Add Header
//html += "<th style='width: 100px;'>" + "ID" + "</th> ";
html += "<th style='width: 150px;'>" + "Tender Enquiry No." + "</th> ";
html += "<th style='width: 470px;'>" + "Brief Description " + "</th>";
html += "<th style='width: 125px;'>" + "Bids<br> Opening Date" + "</th>";
html += "<th style='width: 125px;'>" + "Bids<br> Opening Time" + "</th>";
html += "<th style='width: 100px;'>" + "Last Updated on Website" + "</th>";
//for (int i = 0; i < dt.Columns.Count; i++)
// html += "<th>" + dt.Columns[i].ColumnName + "</th>";
html += "</tr></thead>";
//add rows
for (int i = 0; i < dt.Rows.Count; i++)
{
html += "<tr>";
for (int j = 0; j < dt.Columns.Count; j++)
{
html += "<td>" + dt.Rows[i][j].ToString() + "</td>";
}
html += "</tr>";
}
string tfoot = " <tfoot> " +
" <tr id='pagerTwo' align='center'> <td colspan='5'> " +
" <img src='_assets/img/first.png' class='first'/> " +
" <img src='_assets/img/prev.png' class='prev'/> " +
" <input type='text' class='pagedisplay'/> " +
" <img src='_assets/img/next.png' class='next'/> " +
" <img src='_assets/img/last.png' class='last'/> " +
" <select class='pagesize'> " +
" <option selected='selected' value='10'>10</option> " +
" <option value='20'>20</option> " +
" <option value='30'>30</option> " +
" <option value='40'>40</option> " +
" </select> " +
" </td> " +
" </tr> " +
" </tfoot> ";
html += tfoot;
html += "</table>";
divTable.InnerHtml = html;
}
protected void fillHtmlTable()
{
string web_page = this.GetType().Name.Replace("_aspx", "") + ".aspx";
string qry = " SELECT DOC_DT, DOC_REF, CONCAT(DOC_TITLE,LANG) DOC_TITLE, CONCAT(' ',EXT, ' ' ,FSIZE, FUNIT ) FILE_DETAIL, PUBLISH_DT " +
" , (SELECT LNAME FROM COMPILLOGIN WHERE UPPER(USERID) = UPPER(FIN.USERID) ) UPLOADED_BY FROM ( " +
" SELECT DATE_FORMAT(DOC_DT,'%d-%m-%Y') DOC_DT, DOC_REF " +
", GROUP_CONCAT(CONCAT( '<a href=\"' , WFM.PATH_URL ,DOC_ID, DOC_EXT, '\" target=\"_blank\">' , DOC_TITLE ,'</a>' ) ORDER BY DOC_ID ASC SEPARATOR ' ') DOC_TITLE " +
", CASE WHEN LANG <> '' THEN CONCAT( ' (In ',LANG , ')' ) ELSE '' END LANG " +
", CASE WHEN UPPER(DOC_EXT) = '.PDF' THEN '<img src=\"images/pdf_16_3.png\" alt=\"\" />' ELSE '' END EXT " +
", CASE WHEN ISNULL(FILE_SIZE_BYTES) <> 1 THEN (CASE WHEN (FILE_SIZE_BYTES) < 1048576 THEN ROUND((FILE_SIZE_BYTES/1024), 2) ELSE ROUND((FILE_SIZE_BYTES/1048576),2) END) ELSE '' END FSIZE " +
", CASE WHEN ISNULL(FILE_SIZE_BYTES) <> 1 THEN CASE WHEN (FILE_SIZE_BYTES) < 1048576 THEN 'KB' ELSE 'MB' END ELSE '' END FUNIT " +
", DATE_FORMAT( PUBLISH_DT,'%d-%m-%Y') PUBLISH_DT , USERID " +
" FROM UPLOAD UD " +
" LEFT OUTER JOIN WEB_FOLDER_MAP WFM " +
" ON UD.WEB_ID = WFM.WEB_ID " +
" WHERE PUBLISHED = 'Y' AND UPPER(WFM.WEB_PAGE) = UPPER('{0}') " +
" GROUP BY PARENT_DOC_ID ORDER BY DOC_ID desc ) FIN";
string scmdTxt = string.Format(qry, web_page);
DataSet ds = MySqlDBConnection.fillDataSet(scmdTxt);
DataTable dt = new DataTable();
dt = ds.Tables[0];
string html = "<table id='tableTwo1' class='yui' style='margin-left: auto; margin-right: auto; width: 900px;' >";
//add header row
html += "<thead> ";
html += "<tr > " +
" <td colspan='6' class='filter' style='background: #ffffff;'> " +
" <span style='color: Black;'>Search</span> <input id='filterBoxTwo' value='' maxlength='30' size='30' type='text' /> " +
" <img id='filterClearTwo' src='_assets/img/cross.png' title='Click to clear filter.' alt='Clear Filter Image' /> " +
" </td> " +
" </tr> ";
html += "<tr>";
//Add Header
//html += "<th style='width: 100px;'>" + "ID" + "</th> ";
html += "<th style='width: 100px;'>" + "Dated" + "</th> ";
html += "<th style='width: 110px;'>" + "Reference No." + "</th> ";
html += "<th style='width: 460px;'>" + "Brief Description " + "</th>";
html += "<th style='width: 100px;'>" + "File Details " + "</th>";
html += "<th style='width: 100px;'>" + "Last Updated on Website" + "</th>";
html += "<th style='width: 100px;'>" + "Published by O/o " + "</th>";
//for (int i = 0; i < dt.Columns.Count; i++)
// html += "<th>" + dt.Columns[i].ColumnName + "</th>";
html += "</tr></thead>";
//add rows
for (int i = 0; i < dt.Rows.Count; i++)
{
html += "<tr>";
for (int j = 0; j < dt.Columns.Count; j++)
{
html += "<td>" + dt.Rows[i][j].ToString() + "</td>";
}
html += "</tr>";
}
string tfoot = " <tfoot> " +
" <tr id='pagerTwo' align='center'> <td colspan='6'> " +
" <img src='_assets/img/first.png' class='first'/> " +
" <img src='_assets/img/prev.png' class='prev'/> " +
" <input type='text' class='pagedisplay'/> " +
" <img src='_assets/img/next.png' class='next'/> " +
" <img src='_assets/img/last.png' class='last'/> " +
" <select class='pagesize'> " +
" <option selected='selected' value='10'>10</option> " +
" <option value='20'>20</option> " +
" <option value='30'>30</option> " +
" <option value='40'>40</option> " +
" </select> " +
" </td> " +
" </tr> " +
" </tfoot> ";
html += tfoot;
html += "</table> <br />";
divTable.InnerHtml = html;
}
protected void fillHtmlTable()
{
string web_page = this.GetType().Name.Replace("_aspx", "") + ".aspx";
string scmdTxt = string.Format(Utilities.qry_website()
, web_page);
DataSet ds = MySqlDBConnection.fillDataSet(scmdTxt);
DataTable dt = new DataTable();
dt = ds.Tables[0];
string html = "<table id='tableTwo1' class='yui' style='margin-left: auto; margin-right: auto; width: 900px;' >";
//add header row
html += "<thead> ";
html += "<tr > " +
" <td colspan='5' class='filter' style='background: #ffffff;'> " +
" <span style='color: Black;'>Search</span> <input id='filterBoxTwo' value='' maxlength='30' size='30' type='text' /> " +
" <img id='filterClearTwo' src='_assets/img/cross.png' title='Click to clear filter.' alt='Clear Filter Image' /> " +
" </td> " +
" </tr> ";
html += "<tr>";
//Add Header
//html += "<th style='width: 100px;'>" + "ID" + "</th> ";
html += "<th style='width: 100px;'>" + "Dated" + "</th> ";
html += "<th style='width: 110px;'>" + "Reference No." + "</th> ";
html += "<th style='width: 460px;'>" + "Brief Description " + "</th>";
html += "<th style='width: 100px;'>" + "File Details " + "</th>";
html += "<th style='width: 100px;'>" + "Last Updated on Website" + "</th>";
//for (int i = 0; i < dt.Columns.Count; i++)
// html += "<th>" + dt.Columns[i].ColumnName + "</th>";
html += "</tr></thead>";
//add rows
for (int i = 0; i < dt.Rows.Count; i++)
{
html += "<tr>";
for (int j = 0; j < dt.Columns.Count; j++)
{
html += "<td>" + dt.Rows[i][j].ToString() + "</td>";
}
html += "</tr>";
}
string tfoot = " <tfoot> " +
" <tr id='pagerTwo' align='center'> <td colspan='5'> " +
" <img src='_assets/img/first.png' class='first'/> " +
" <img src='_assets/img/prev.png' class='prev'/> " +
" <input type='text' class='pagedisplay'/> " +
" <img src='_assets/img/next.png' class='next'/> " +
" <img src='_assets/img/last.png' class='last'/> " +
" <select class='pagesize'> " +
" <option selected='selected' value='10'>10</option> " +
" <option value='20'>20</option> " +
" <option value='30'>30</option> " +
" <option value='40'>40</option> " +
" </select> " +
" </td> " +
" </tr> " +
" </tfoot> ";
html += tfoot;
html += "</table> <br />";
divTable.InnerHtml = html;
}
