private void Load_Attachments(int VESSEL_ID, int WORKLIST_ID, int WL_OFFICE_ID, int UserID)
{
DataTable dt = objInsp.Get_Worklist_Attachments(VESSEL_ID, WORKLIST_ID, WL_OFFICE_ID, UserID);
DataView dvImage = dt.DefaultView;
// dvImage.RowFilter = "Is_Image='1' ";
gvWLJobAttachment.DataSource = dt.DefaultView;
gvWLJobAttachment.DataBind();
//Bind Popup
}
public string CreateHtmlTableFromDataTable(DataTable dtTable, string[] HeaderCaptions, string[] DataColumnsName, string[] ColumnsWidth, string PageHeader)
{
StringBuilder strTable = new StringBuilder();
try
{
if (dtTable.Rows.Count > 0)
{
strTable.Append("<table id='__tbl_remark' class='CreateHtmlTableFromDataTable-table' CELLPADDING='2' CELLSPACING='0' style='border-collapse:collapse' >");
if (PageHeader.Length > 1)
{
strTable.Append("<tr> <td class='CreateHtmlTableFromDataTable-PageHeader' colspan='" + dtTable.Columns.Count + "' > <b>" + PageHeader + "</b> </td></tr>");
}
if (HeaderCaptions.Length > 0)
{
strTable.Append("<tr >");
for (int i = 0; i < HeaderCaptions.Length; i++)
{
strTable.Append("<td class='CreateHtmlTableFromDataTable-DataHedaer' width='" + ColumnsWidth[i] + "'>");
strTable.Append("<b>" + HeaderCaptions[i] + "</b>");
strTable.Append("</td>");
}
strTable.Append("</tr>");
}
foreach (DataRow dr in dtTable.Rows)
{
strTable.Append("<tr>");
for (int i = 0; i < DataColumnsName.Length; i++)
{
if (i == 0 || i == 4 || i == 6 || i == 5)
{
strTable.Append("<td class='CreateHtmlTableFromDataTable-Data' style='White-space:normal;width:" + ColumnsWidth[i] + ";text-align:center;'>");
strTable.Append(dr[DataColumnsName[i]].ToString().Replace("\n", "<br>"));
strTable.Append("</td>");
}
else
{
strTable.Append("<td class='CreateHtmlTableFromDataTable-Data' style='White-space:normal;width:" + ColumnsWidth[i] + "'>");
strTable.Append(dr[DataColumnsName[i]].ToString().Replace("\n", "<br>"));
strTable.Append("</td>");
}
}
strTable.Append("</tr>");
// Attachment//
BLL_Tec_Inspection objBLL = new BLL_Tec_Inspection();
DataTable dt = objBLL.Get_Worklist_Attachments(Convert.ToInt32(dr["Vessel_ID"]), Convert.ToInt32(dr["Worklist_id"]), Convert.ToInt32(dr["OFFICE_ID"]), 0);
DataView dvImage = dt.DefaultView;
dvImage.RowFilter = "Is_Image='1' ";
strTable.Append("<tr>");
strTable.Append("<td colspan='" + DataColumnsName.Length.ToString() + "' class='CreateHtmlTableFromDataTable-Data' style='background-color:#F0F0F0; '>");
int imgRun = 1;
foreach (DataRow drimg in dvImage.ToTable().Rows)
{
strTable.Append("<a href='" + Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/" + "uploads/technical/" + drimg["Image_Path"].ToString() + "'><img src='" + Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/" + "uploads/technical/" + drimg["Image_Path"].ToString() + "' alt='' height='250' width='250px' style='margin:5px;' ></a>");
if (imgRun == 3)
{
strTable.Append("</td>");
strTable.Append("</tr>");
strTable.Append("<tr>");
strTable.Append("<td colspan='" + DataColumnsName.Length.ToString() + "' class='CreateHtmlTableFromDataTable-Data'>");
imgRun = 1;
}
imgRun++;
}
strTable.Append("</td>");
strTable.Append("</tr>");
//attachment/
}
strTable.Append("</table>");
}
else
{
strTable.Append("<span style='color:maroon;padding:2px'> No record found !</span>");
}
return(strTable.ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}