private string GenerateDetailLoiDoc(GeneratorController gc, int reqid, string loicode, string DirectoryResultPath)
{
string resulturl = "";
DataTable dt = gc.generate_loi_detail_getdata(reqid);
string LoiDocPath = Path.Combine(Environment.CurrentDirectory, "Template");
string Templatedetailfile = ConfigurationManager.AppSettings["Templatedetailfile"];
string FullTemplateDetail = Path.Combine(LoiDocPath, Templatedetailfile);
string filenameSavedOri = string.Concat("LOIDoc_Detail_", loicode);
string resultfile = Path.Combine(DirectoryResultPath, filenameSavedOri, ".pdf");
string resultfilehtml = Path.Combine(DirectoryResultPath, filenameSavedOri + ".htm");
string TextTemplateDetail = ReadApprovalTemplate(FullTemplateDetail);
int no = 0;
StringBuilder sb = new StringBuilder();
sb.Append(TextTemplateDetail);
foreach (DataRow dr in dt.Rows)
{
no += 1;
sb.Append("<tr style='text-align:center'>");
sb.Append("<td>" + no + "</td>");
sb.Append("<td>" + dr["workpackageid"].ToString() + "</td>");
sb.Append("<td>" + dr["Customer_PO"].ToString() + "</td>");
sb.Append("<td>" + Convert.ToDateTime(dr["Customer_PO_Date"]).ToString("dd/MM/yyyy") + "</td>");
sb.Append("<td>" + dr["Region"].ToString() + "</td>");
sb.Append("<td>" + dr["Site_ID"].ToString() + "</td>");
sb.Append("<td>" + dr["Site_ID"].ToString() + "</td>");
sb.Append("<td>" + dr["ScopeOfWork"].ToString() + "</td>");
sb.Append("<td>" + dr["Subcone_Name"].ToString() + "</td>");
sb.Append("<td>" + dr["Site_Model"].ToString() + "</td>");
sb.Append("<td>" + String.Format("{0:n0}", dr["Unit_Price"]) + "</td>");
sb.Append("<td>" + dr["Qty"].ToString() + "</td>");
sb.Append("<td>" + String.Format("{0:n0}", dr["Total_Price"]) + "</td>");
sb.Append("</tr>");
}
sb.Append("</table>");
sb.Append("</body>");
try
{
HtmlTextWriter sw = new HtmlTextWriter(new StreamWriter(resultfilehtml, false, UnicodeEncoding.UTF8));
sw.BeginRender();
sw.WriteLine(sb.ToString());
sw.Close();
sw.Dispose();
resulturl = GeneralConfig.ConvertAnyFormatToPDFHtmlNew(resultfilehtml, DirectoryResultPath, filenameSavedOri);
}
catch (Exception ex)
{
EBOQ_Lib_New.DAL.DAL_AppLog.ErrLogInsert("Program.cs:GenerateDetailLoiDoc", ex.Message, "NON-SP");
}
return(resulturl);
}
