private void BindDataProvince()
{
log4net.Config.XmlConfigurator.Configure();
log.Info("BindDataProvince() Started..");
try
{
lbxProvince.Items.Clear();
SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA();
DataTable dt = ws.GetProvince();
lbxProvince.DataSource = dt;
lbxProvince.DataTextField = "Nama";
lbxProvince.DataValueField = "Id";
lbxProvince.DataBind();
}
catch (Exception ex)
{
log.Info("BindDataProvince() Error. " + ex.Message);
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "err_msg", "bootbox.alert({message:'<strong>There is an error:</strong> " + ex.Message.Replace("'", "\\'") + "', title:'Oops!'});", true);
}
log.Info("BindDataProvince() Finished..");
}
protected void btnView_Click(object sender, EventArgs e)
{
SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA();
string id = ws.InsertReportParameter(GetListBoxItem(lbxCompany), GetListBoxItem(lbxProvince), "", Constants.sessionUsername);
Response.Redirect(Page.ResolveUrl("~/Lookup/Preview/ViewAssetSummaryByComp.aspx?id=" + id + "&usr=" + Constants.sessionUsername));
}
protected void btnView_Click(object sender, EventArgs e)
{
SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA();
string id = ws.InsertReportParameter(GetListBoxItem(lbxStatus), "", "", Constants.sessionUsername);
Response.Redirect(Page.ResolveUrl("~/Lookup/Preview/ViewAssetDocumentChecklist.aspx?id=" + id + "&usr="******"&ty=v"));
}
protected void btnDownload_Click(object sender, EventArgs e)
{
try
{
//after publish need to change it
string rooturl = Constants.rootURL;
SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA();
string id = ws.InsertReportParameter(GetListBoxItem(lbxCompany), GetListBoxItem(lbxProvince), "", Constants.sessionUsername);
string url = rooturl + "Lookup/Preview/ViewAssetSummaryByComp.aspx?id=" + id + "&usr="******"AssetSummaryByCompany_" + DateTime.Now.ToString("yyyyMMdd") + ".pdf";
string filename = "\"" + Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig) + "\"";
if (File.Exists(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig)))
{
File.Delete(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig));
}
Process proc = new Process();
proc.StartInfo.FileName = Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "exe\\") + "wkhtmltopdf.exe";
proc.StartInfo.Arguments = "--print-media-type --page-width 250mm --page-height 323mm --margin-top 0 --margin-right 0 --margin-bottom 0 --margin-left 0 --dpi 200 --header-spacing 0 --footer-spacing 0 --disable-smart-shrinking --zoom 1.33 " + url + " " + filename;
proc.StartInfo.UseShellExecute = false;
proc.StartInfo.CreateNoWindow = true;
proc.Start();
proc.WaitForExit();
byte[] bytes = System.IO.File.ReadAllBytes(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig));
Page.Response.ContentType = "application/pdf";
Page.Response.AddHeader("content-disposition", "attachment;filename=" + fileConfig);
Page.Response.Cache.SetCacheability(HttpCacheability.NoCache);
Page.Response.BinaryWrite(bytes);
if (File.Exists(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig)))
{
File.Delete(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig));
}
log.Info("Download " + fileConfig + " finished.");
Page.Response.End();
}
catch (Exception ex)
{
log.Info("Download error. " + ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
log.Info("ViewSertipikatSudahJatuhTempo Page_Load.");
string username = Request.QueryString["usr"];
SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA();
DataTable dtSertipikat = new DataTable();
log.DebugFormat("Call GetSertipikatSudahJatuhTempo() Started.");
dtSertipikat = ws.GetSertipikatSudahJatuhTempo();
log.DebugFormat("Call GetSertipikatSudahJatuhTempo() Finished. Result {0} rows.", dtSertipikat.Rows.Count);
string html = System.IO.File.ReadAllText(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Template/HTML/SertipikatSudahJatuhTempo.html"));
if (dtSertipikat.Rows.Count > 0)
{
string HTMLContentReport = "";
for (int i = 0; i < dtSertipikat.Rows.Count; i++)
{
HTMLContentReport += string.Format(@"<tr>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{2}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{3}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{4}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{5}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{6}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{7}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{8}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{9}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{10}</td>
</tr>", dtSertipikat.Rows[i]["Kode"].ToString(),
dtSertipikat.Rows[i]["Nama Aset"].ToString(),
dtSertipikat.Rows[i]["Nomor Sertipikat"].ToString(),
dtSertipikat.Rows[i]["Tanggal Penerbitan"].ToString(),
dtSertipikat.Rows[i]["Tanggal Berakhir Hak"].ToString(),
string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Lewat Hari"].ToString())),
dtSertipikat.Rows[i]["Alamat Sertipikat"].ToString(),
string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Luas Tanah Fisik"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Luas Tanah Sertipikat"].ToString())),
dtSertipikat.Rows[i]["Jenis Hak Atas Tanah"].ToString(),
dtSertipikat.Rows[i]["Nama Pemegang Hak"].ToString());
}
html = html.Replace("@ContentReport", HTMLContentReport);
}
else
{
html = html.Replace("@ContentReport", "");
}
html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"))
.Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy"));
ltView.Text = html;
}
catch (Exception ex)
{
log.Error(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
log.Info("ViewAkuisisiSummaryByComp Page_Load.");
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
string username = Request.QueryString["usr"];
string company = "";
decimal totalPerencanaan = 0;
decimal totalAreaPerencanaan = 0;
decimal totalPemeriksaan = 0;
decimal totalAreaPemeriksaan = 0;
decimal totalProses = 0;
decimal totalAreaProses = 0;
decimal totalSudahBayarProses = 0;
decimal totalJatuhTempoProses = 0;
decimal totalBelumJatuhTempoProses = 0;
decimal totalNilaiProses = 0;
decimal totalSelesai = 0;
decimal totalAreaSelesai = 0;
decimal totalSudahBayarSelesai = 0;
decimal totalJatuhTempoSelesai = 0;
decimal totalBelumJatuhTempoSelesai = 0;
decimal totalNilaiSelesai = 0;
decimal totalSeluruhAkuisisi = 0;
decimal totalSeluruhArea = 0;
decimal totalSeluruhNilai = 0;
SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA();
DataTable dtParameter = new DataTable();
log.DebugFormat("Call GetReportParameter() Started. Parameters : id = {0}", id);
dtParameter = ws.GetReportParameter(id);
if (dtParameter.Rows.Count > 0)
{
company = dtParameter.Rows[0]["Parameter1"].ToString();
}
log.DebugFormat("Call GetReportParameter() Finished. Result {0} rows.", dtParameter.Rows.Count);
DataTable dtAkuisisi = new DataTable();
log.DebugFormat("Call GetAkuisisiSummaryByComp() Started. Parameters : Company = {0}", company);
dtAkuisisi = ws.GetAkuisisiSummaryByComp(company);
log.DebugFormat("Call GetAkuisisiSummaryByComp() Finished. Result {0} rows.", dtAkuisisi.Rows.Count);
string html = System.IO.File.ReadAllText(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Template/HTML/AkuisisiSummaryByComp.html"));
if (dtAkuisisi.Rows.Count > 0)
{
string HTMLContentReport = "";
int no = 1;
for (int i = 0; i < dtAkuisisi.Rows.Count; i++)
{
HTMLContentReport += string.Format(@"<tr>
<td style='text-align: center; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{0}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{1}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{2}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{3}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{4}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{5}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{6}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{7}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{8}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{9}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{10}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{11}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{12}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{13}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{14}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{15}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{16}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{17}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{18}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{19}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{20}</td>
</tr>", string.Format("{0:n0}", Convert.ToDecimal(no.ToString())),
dtAkuisisi.Rows[i]["CompanyName"].ToString(),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalPerencanaan"].ToString())),
string.Format("{0:n2}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaPerencanaan"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalPemeriksaan"].ToString())),
string.Format("{0:n2}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaPemeriksaan"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalProses"].ToString())),
string.Format("{0:n2}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaProses"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBayarProses"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalJatuhTempoProses"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBelumJatuhTempoProses"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilaiProses"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalSelesai"].ToString())),
string.Format("{0:n2}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaSelesai"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBayarSelesai"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalJatuhTempoSelesai"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBelumJatuhTempoSelesai"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilaiSelesai"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAkuisisi"].ToString())),
string.Format("{0:n2}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalArea"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilai"].ToString())));
totalPerencanaan += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalPerencanaan"].ToString());
totalAreaPerencanaan += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaPerencanaan"].ToString());
totalPemeriksaan += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalPemeriksaan"].ToString());
totalAreaPemeriksaan += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaPemeriksaan"].ToString());
totalProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalProses"].ToString());
totalAreaProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaProses"].ToString());
totalSudahBayarProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBayarProses"].ToString());
totalJatuhTempoProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalJatuhTempoProses"].ToString());
totalBelumJatuhTempoProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBelumJatuhTempoProses"].ToString());
totalNilaiProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilaiProses"].ToString());
totalSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalSelesai"].ToString());
totalAreaSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaSelesai"].ToString());
totalSudahBayarSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBayarSelesai"].ToString());
totalJatuhTempoSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalJatuhTempoSelesai"].ToString());
totalBelumJatuhTempoSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBelumJatuhTempoSelesai"].ToString());
totalNilaiSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilaiSelesai"].ToString());
totalSeluruhAkuisisi += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAkuisisi"].ToString());
totalSeluruhArea += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalArea"].ToString());
totalSeluruhNilai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilai"].ToString());
no += 1;
}
//Total
HTMLContentReport += string.Format(@"<tr>
<td colspan='2' style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{0}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{1}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{2}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{3}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{4}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{5}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{6}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{7}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{8}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{9}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{10}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{11}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{12}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{13}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{14}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{15}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{16}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{17}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{18}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{19}</b></td>
</tr>", "Total",
string.Format("{0:n0}", totalPerencanaan),
string.Format("{0:n2}", totalAreaPerencanaan),
string.Format("{0:n0}", totalPemeriksaan),
string.Format("{0:n2}", totalAreaPemeriksaan),
string.Format("{0:n0}", totalProses),
string.Format("{0:n2}", totalAreaProses),
string.Format("{0:n0}", totalSudahBayarProses),
string.Format("{0:n0}", totalJatuhTempoProses),
string.Format("{0:n0}", totalBelumJatuhTempoProses),
string.Format("{0:n0}", totalNilaiProses),
string.Format("{0:n0}", totalSelesai),
string.Format("{0:n2}", totalAreaSelesai),
string.Format("{0:n0}", totalSudahBayarSelesai),
string.Format("{0:n0}", totalJatuhTempoSelesai),
string.Format("{0:n0}", totalBelumJatuhTempoSelesai),
string.Format("{0:n0}", totalNilaiSelesai),
string.Format("{0:n0}", totalSeluruhAkuisisi),
string.Format("{0:n2}", totalSeluruhArea),
string.Format("{0:n0}", totalSeluruhNilai));
html = html.Replace("@ContentReport", HTMLContentReport);
}
else
{
html = html.Replace("@ContentReport", "");
}
html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"))
.Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy"));
ltView.Text = html;
}
catch (Exception ex)
{
log.Error(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
log.Info("ViewAssetSummaryByComp Page_Load.");
string company = "";
string province = "";
string username = Request.QueryString["usr"];
int id = Convert.ToInt32(Request.QueryString["id"]);
decimal totalAsset = 0;
decimal totalSertipikat = 0;
decimal totalGirik = 0;
decimal totalLainnya = 0;
decimal totalArea = 0;
SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA();
DataTable dtParameter = new DataTable();
log.DebugFormat("Call GetReportParameter() Started. Parameters : id = {0}", id);
dtParameter = ws.GetReportParameter(id);
if (dtParameter.Rows.Count > 0)
{
company = dtParameter.Rows[0]["Parameter1"].ToString();
province = dtParameter.Rows[0]["Parameter2"].ToString();
}
log.DebugFormat("Call GetReportParameter() Finished. Result {0} rows.", dtParameter.Rows.Count);
DataTable dtAsset = new DataTable();
log.DebugFormat("Call GetAssetSummaryByComp() Started. Parameters : Company = {0}, Province = {0}", company, province);
dtAsset = ws.GetAssetSummaryByComp(company, province);
log.DebugFormat("Call GetAssetSummaryByComp() Finished. Result {0} rows.", dtAsset.Rows.Count);
string html = System.IO.File.ReadAllText(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Template/HTML/AssetSummaryByComp.html"));
if (dtAsset.Rows.Count > 0)
{
string HTMLContentReport = "";
for (int i = 0; i < dtAsset.Rows.Count; i++)
{
HTMLContentReport += string.Format(@"<tr>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{2}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{3}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{4}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{5}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{6}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{7}</td>
</tr>", dtAsset.Rows[i]["CompanyName"].ToString(),
dtAsset.Rows[i]["ProvinsiName"].ToString(),
dtAsset.Rows[i]["AsetTypeName"].ToString(),
string.Format("{0:n0}", Convert.ToDecimal(dtAsset.Rows[i]["hasAsset"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAsset.Rows[i]["hasSertipikat"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAsset.Rows[i]["hasGirik"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAsset.Rows[i]["Lainnya"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtAsset.Rows[i]["LuasTanah"].ToString())));
totalAsset += Convert.ToDecimal(dtAsset.Rows[i]["hasAsset"].ToString());
totalSertipikat += Convert.ToDecimal(dtAsset.Rows[i]["hasSertipikat"].ToString());
totalGirik += Convert.ToDecimal(dtAsset.Rows[i]["hasGirik"].ToString());
totalLainnya += Convert.ToDecimal(dtAsset.Rows[i]["Lainnya"].ToString());
totalArea += Convert.ToDecimal(dtAsset.Rows[i]["LuasTanah"].ToString());
}
//Total
HTMLContentReport += string.Format(@"<tr>
<td colspan='3' style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{0}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{1}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{2}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{3}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{4}</b></td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{5}</b></td>
</tr>", "Total",
string.Format("{0:n0}", totalAsset),
string.Format("{0:n0}", totalSertipikat),
string.Format("{0:n0}", totalGirik),
string.Format("{0:n0}", totalLainnya),
string.Format("{0:n0}", totalArea));
html = html.Replace("@ContentReport", HTMLContentReport);
}
else
{
html = html.Replace("@ContentReport", "");
}
html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"))
.Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy"));
ltView.Text = html;
}
catch (Exception ex)
{
log.Error(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
log.Info("ViewAssetDocumentChecklist Page_Load.");
int id = Convert.ToInt32(Request.QueryString["id"]);
string username = Request.QueryString["usr"];
string type = Request.QueryString["ty"];
string namaAset = "";
string kodeAset = "";
string status = "";
SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA();
DataTable dtParameter = new DataTable();
log.DebugFormat("Call GetReportParameter() Started. Parameters : id = {0}", id);
dtParameter = ws.GetReportParameter(id);
if (dtParameter.Rows.Count > 0)
{
status = dtParameter.Rows[0]["Parameter1"].ToString();
}
log.DebugFormat("Call GetReportParameter() Finished. Result {0} rows.", dtParameter.Rows.Count);
DataTable dtAsset = new DataTable();
log.DebugFormat("Call GetAssetDocumentChecklist() Started.");
dtAsset = ws.GetAssetDocumentChecklist(status);
log.DebugFormat("Call GetAssetDocumentChecklist() Finished. Result {0} rows.", dtAsset.Rows.Count);
string html = System.IO.File.ReadAllText(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Template/HTML/AssetDocumentChecklist.html"));
string HTMLDokumen = "";
if (dtAsset.Rows.Count > 0)
{
if (type == "d")
{
string HTMLContent = "";
HTMLContent += @"<div style='page-break-after: always;'>
<table style='width:100%; font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'>
<tr style='font-family: Calibri; font-size: 16px; color: black; text-align: center'>
<td colspan='2'><b>Asset Document Checklist</b></td>
</tr>
<tr style='font-family: Calibri; font-size: 12px; color: black; text-align: center'>
<td colspan='2'><b>@AsOf</b></td>
</tr>
<tr style='height:20px'>
<td colspan='2'></td>
</tr>
<tr>
<td style='width:500px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Aset</td>
<td style='width:900px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Kekurangan</td>
</tr>";
var DTAkuisisi = (from DataRow dRow in dtAsset.Rows
select new
{
akuisisiID = dRow["AkuisisiID"],
kodeAkuisisi = dRow["KodeAkuisisi"],
statusAkuisisi = dRow["StatusAkuisisi"]
}).Distinct().ToList();
int idx = 1;
int idxOri = 1;
bool pageBreak = false;
foreach (var akuisisi in DTAkuisisi)
{
var DTAssetID = (from DataRow dRow in dtAsset.Rows
where dRow["AkuisisiID"].ToString() == akuisisi.akuisisiID.ToString()
select new
{
asetID = dRow["AsetID"],
akuisisiID = dRow["AkuisisiID"]
}).Distinct().ToList();
foreach (var asetid in DTAssetID)
{
var DTAsset = (from DataRow dRow in dtAsset.Rows
where dRow["AsetID"].ToString() == asetid.asetID.ToString() &&
dRow["AkuisisiID"].ToString() == asetid.akuisisiID.ToString()
select new
{
akuisisiID = dRow["AkuisisiID"],
kodeAkuisisi = dRow["KodeAkuisisi"],
kodeAset = dRow["KodeAset"],
namaAset = dRow["NamaAset"],
jenisDokumen = dRow["JenisDokumen"],
keterangan = dRow["Keterangan"]
}).ToList();
idx++;
if (idx > 115 || (idxOri + DTAsset.Count()) > 115)
{
pageBreak = true;
idx = 1;
idxOri = 1;
}
foreach (var asset in DTAsset)
{
if (idx > 115)
{
pageBreak = true;
}
namaAset = asset.namaAset.ToString();
kodeAset = asset.kodeAset.ToString();
if (asset.keterangan.ToString() == "")
{
HTMLDokumen += asset.jenisDokumen.ToString().Trim() + "<br/>";
}
else
{
HTMLDokumen += asset.jenisDokumen.ToString().Trim() + " - <i>" + asset.keterangan.ToString().Trim() + "</i><br/>";
}
idx++;
}
idxOri = idx;
if (pageBreak)
{
HTMLContent += @" </table>
</div>
<div style='page-break-after: always;'>
<table style='width:100%; font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'>
<tr style='font-family: Calibri; font-size: 16px; color: black; text-align: center'>
<td colspan='11'><b>Asset Document Checklist</b></td>
</tr>
<tr style='font-family: Calibri; font-size: 12px; color: black; text-align: center'>
<td colspan='21'><b>@AsOf</b></td>
</tr>
<tr style='height:20px'>
<td colspan='11'></td>
</tr>
<tr>
<td style='width:500px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Aset</td>
<td style='width:900px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Kekurangan</td>
</tr>";
pageBreak = false;
}
HTMLContent += @"<tr bgcolor=#F7F7F7><td colspan=2 style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>Kode Akuisisi : " + akuisisi.kodeAkuisisi.ToString() + " - " + akuisisi.statusAkuisisi.ToString() + "</b></td></tr>";
HTMLContent += string.Format(@"<tr>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td>
</tr>", namaAset, HTMLDokumen);
HTMLDokumen = "";
}
}
HTMLContent += @"<table style='width:100%; font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'>
<tr style='height:20px'>
<td></td>
</tr>
<tr style='font-family: Calibri; font-size: 10px; color: black; text-align: center'>
<td>-- End of Report --</td>
</tr>
<tr style='font-family: Calibri; font-size: 10px; color: black; text-align: left'>
<td>Printed by : @PrintedBy</td>
</tr>
</table>";
html = html.Replace("@ContentReport", HTMLContent);
}
else if (type == "v")
{
string HTMLContent = "";
HTMLContent += @"<div style='page-break-after: always;'>
<table style='width:100%; font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'>
<tr style='font-family: Calibri; font-size: 16px; color: black; text-align: center'>
<td colspan='2'><b>Asset Document Checklist</b></td>
</tr>
<tr style='font-family: Calibri; font-size: 12px; color: black; text-align: center'>
<td colspan='2'><b>@AsOf</b></td>
</tr>
<tr style='height:20px'>
<td colspan='2'></td>
</tr>
<tr>
<td style='width:500px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Aset</td>
<td style='width:900px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Kekurangan</td>
</tr>";
var DTAkuisisi = (from DataRow dRow in dtAsset.Rows
select new
{
akuisisiID = dRow["AkuisisiID"],
kodeAkuisisi = dRow["KodeAkuisisi"],
statusAkuisisi = dRow["StatusAkuisisi"]
}).Distinct().ToList();
foreach (var akuisisi in DTAkuisisi)
{
var DTAssetID = (from DataRow dRow in dtAsset.Rows
where dRow["AkuisisiID"].ToString() == akuisisi.akuisisiID.ToString()
select new
{
asetID = dRow["AsetID"],
akuisisiID = dRow["AkuisisiID"]
}).Distinct().ToList();
foreach (var asetid in DTAssetID)
{
var DTAsset = (from DataRow dRow in dtAsset.Rows
where dRow["AsetID"].ToString() == asetid.asetID.ToString() &&
dRow["AkuisisiID"].ToString() == asetid.akuisisiID.ToString()
select new
{
akuisisiID = dRow["AkuisisiID"],
kodeAkuisisi = dRow["KodeAkuisisi"],
kodeAset = dRow["KodeAset"],
namaAset = dRow["NamaAset"],
jenisDokumen = dRow["JenisDokumen"],
keterangan = dRow["Keterangan"]
}).ToList();
foreach (var asset in DTAsset)
{
namaAset = asset.namaAset.ToString();
kodeAset = asset.kodeAset.ToString();
if (asset.keterangan.ToString() == "")
{
HTMLDokumen += asset.jenisDokumen.ToString().Trim() + "<br/>";
}
else
{
HTMLDokumen += asset.jenisDokumen.ToString().Trim() + " - <i>" + asset.keterangan.ToString().Trim() + "</i><br/>";
}
}
HTMLContent += @"<tr bgcolor=#F7F7F7><td colspan=2 style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>Kode Akuisisi : " + akuisisi.kodeAkuisisi.ToString() + " - " + akuisisi.statusAkuisisi.ToString() + "</b></td></tr>";
HTMLContent += string.Format(@"<tr>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td>
</tr>", namaAset, HTMLDokumen);
HTMLDokumen = "";
}
}
HTMLContent += @"</table>
</div>
<table style='width:100%; font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'>
<tr style='height:20px'>
<td></td>
</tr>
<tr style='font-family: Calibri; font-size: 10px; color: black; text-align: center'>
<td>-- End of Report --</td>
</tr>
<tr style='font-family: Calibri; font-size: 10px; color: black; text-align: left'>
<td>Printed by : @PrintedBy</td>
</tr>
</table>";
html = html.Replace("@ContentReport", HTMLContent);
}
}
else
{
html = html.Replace("@ContentReport", "");
}
html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"))
.Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy"));
ltView.Text = html;
}
catch (Exception ex)
{
log.Error(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
log.Info("ViewSertipikatAkanJatuhTempo Page_Load.");
string username = Request.QueryString["usr"];
SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA();
DataTable dtSertipikat = new DataTable();
log.DebugFormat("Call GetSertipikatAkanJatuhTempo() Started.");
dtSertipikat = ws.GetSertipikatAkanJatuhTempo();
log.DebugFormat("Call GetSertipikatAkanJatuhTempo() Finished. Result {0} rows.", dtSertipikat.Rows.Count);
string html = System.IO.File.ReadAllText(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Template/HTML/SertipikatAkanJatuhTempo.html"));
if (dtSertipikat.Rows.Count > 0)
{
string HTMLContent = "";
HTMLContent += @"<div style='page-break-after: always;'>
<table style='font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'>
<tr style='font-family: Calibri; font-size: 16px; color: black; text-align: center'>
<td colspan='11'><b>Sertipikat Akan Jatuh Tempo</b></td>
</tr>
<tr style='font-family: Calibri; font-size: 12px; color: black; text-align: center'>
<td colspan='21'><b>@AsOf</b></td>
</tr>
<tr style='height:20px'>
<td colspan='11'></td>
</tr>
<tr>
<td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Kode</td>
<td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Aset</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nomor Sertipikat</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Tanggal Penerbitan</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Tanggal Berakhir Hak</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Sisa Hari Berlaku</td>
<td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Alamat Sertipikat</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Luas Tanah Fisik</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Luas Tanah Sertipikat</td>
<td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Jenis Hak Atas Tanah</td>
<td style='width:200px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Pemegang Hak</td>
</tr>";
for (int i = 1; i < dtSertipikat.Rows.Count; i++)
{
HTMLContent += string.Format(@"<tr>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{2}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{3}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{4}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{5}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{6}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{7}</td>
<td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{8}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{9}</td>
<td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{10}</td>
</tr>", dtSertipikat.Rows[i - 1]["Kode"].ToString(),
dtSertipikat.Rows[i - 1]["Nama Aset"].ToString(),
dtSertipikat.Rows[i - 1]["Nomor Sertipikat"].ToString(),
dtSertipikat.Rows[i - 1]["Tanggal Penerbitan"].ToString(),
dtSertipikat.Rows[i - 1]["Tanggal Berakhir Hak"].ToString(),
string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i - 1]["Sisa Hari Berlaku"].ToString())),
dtSertipikat.Rows[i - 1]["Alamat Sertipikat"].ToString(),
string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i - 1]["Luas Tanah Fisik"].ToString())),
string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i - 1]["Luas Tanah Sertipikat"].ToString())),
dtSertipikat.Rows[i - 1]["Jenis Hak Atas Tanah"].ToString(),
dtSertipikat.Rows[i - 1]["Nama Pemegang Hak"].ToString());
if (i % 50 == 0)
{
HTMLContent += @" </table>
</div>
<div style='page-break-after: always;'>
<table style='font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'>
<tr style='font-family: Calibri; font-size: 16px; color: black; text-align: center'>
<td colspan='11'><b>Sertipikat Akan Jatuh Tempo</b></td>
</tr>
<tr style='font-family: Calibri; font-size: 12px; color: black; text-align: center'>
<td colspan='21'><b>@AsOf</b></td>
</tr>
<tr style='height:20px'>
<td colspan='11'></td>
</tr>
<tr>
<td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Kode</td>
<td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Aset</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nomor Sertipikat</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Tanggal Penerbitan</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Tanggal Berakhir Hak</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Sisa Hari Berlaku</td>
<td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Alamat Sertipikat</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Luas Tanah Fisik</td>
<td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Luas Tanah Sertipikat</td>
<td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Jenis Hak Atas Tanah</td>
<td style='width:200px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Pemegang Hak</td>
</tr>";
}
}
HTMLContent += @"<table style='font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'>
<tr style='height:20px'>
<td colspan='11'></td>
</tr>
<tr style='font-family: Calibri; font-size: 10px; color: black; text-align: center'>
<td colspan='11'>-- End of Report --</td>
</tr>
<tr style='font-family: Calibri; font-size: 10px; color: black; text-align: left'>
<td colspan='11'>Printed by : @PrintedBy</td>
</tr>
</table>";
html = html.Replace("@ContentReport", HTMLContent);
}
else
{
html = html.Replace("@ContentReport", "");
}
html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"))
.Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy"));
// if (dtSertipikat.Rows.Count > 0)
// {
// string HTMLContentReport = "";
// for (int i = 0; i < dtSertipikat.Rows.Count; i++)
// {
// HTMLContentReport += string.Format(@"<tr>
// <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td>
// <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td>
// <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{2}</td>
// <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{3}</td>
// <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{4}</td>
// <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{5}</td>
// <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{6}</td>
// <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{7}</td>
// <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{8}</td>
// <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{9}</td>
// <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{10}</td>
//
// </tr>", dtSertipikat.Rows[i]["Kode"].ToString(),
// dtSertipikat.Rows[i]["Nama Aset"].ToString(),
// dtSertipikat.Rows[i]["Nomor Sertipikat"].ToString(),
// dtSertipikat.Rows[i]["Tanggal Penerbitan"].ToString(),
// dtSertipikat.Rows[i]["Tanggal Berakhir Hak"].ToString(),
// string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Sisa Hari Berlaku"].ToString())),
// dtSertipikat.Rows[i]["Alamat Sertipikat"].ToString(),
// string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Luas Tanah Fisik"].ToString())),
// string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Luas Tanah Sertipikat"].ToString())),
// dtSertipikat.Rows[i]["Jenis Hak Atas Tanah"].ToString(),
// dtSertipikat.Rows[i]["Nama Pemegang Hak"].ToString());
// }
// html = html.Replace("@ContentReport", HTMLContentReport);
// }
// else
// {
// html = html.Replace("@ContentReport", "");
// }
// html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"))
// .Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy"));
ltView.Text = html;
}
catch (Exception ex)
{
log.Error(ex.Message);
}
}
