/// <summary>
/// Butang 'Save' telah ditekan.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SaveButton_OnClick(object sender, EventArgs e)
{
// Declare template untuk disimpan ke DB
var template = new Models.PagesTemplate()
{
Name = TemplateName.Text,
Language = Language.SelectedValue,
AppStatusListId = int.Parse(AppStatusListId.SelectedValue),
ProgrammeId = int.Parse(ProgrammeIdHidden.Value),
ContentText = OfferLetterText.Text,
FileUrl = FileUrl.Text,
SortOrder = int.Parse(SortOrder.Text)
};
string sql;
// Kemaskini template sedia ada
if (TemplateIdHidden.Value != "")
{
sql = @"
UPDATE PagesTemplate
SET Name = @Name,
Language = @Language,
AppStatusListId = @AppStatusListId,
ProgrammeId = @ProgrammeId,
ContentText = @ContentText,
FileUrl = @FileUrl,
SortOrder = @SortOrder
WHERE Id = @Id";
template.Id = int.Parse(TemplateIdHidden.Value);
}
else
{
// Template baru
sql = @"
INSERT INTO PagesTemplate (Name, Language, AppStatusListId, ProgrammeId, ContentText, SortOrder, FileUrl)
VALUES (@Name, @Language, @AppStatusListId, @ProgrammeId, @ContentText, @SortOrder, @FileUrl)";
}
using (var c = ConnectionFactory.GetConnection())
{
c.Execute(sql, template);
}
Response.Redirect("~/Pages/Programme/View.aspx?Id=" + template.ProgrammeId);
}
/// <summary>
/// Paparkan maklumat template page page.
/// </summary>
/// <param name="template"></param>
protected void BindTemplate(Models.PagesTemplate template)
{
TemplateName.Text = template.Name;
OfferLetterText.Text = template.ContentText;
Language.Text = template.Language;
AppStatusListId.SelectedValue = template.AppStatusListId.ToString();
SortOrder.Text = template.SortOrder.ToString();
FileUrl.Text = template.FileUrl;
ProgrammeIdHidden.Value = template.ProgrammeId.ToString();
TemplateIdHidden.Value = template.Id.ToString();
// Jika file PDF dimuat naik
if (template.FileLocation == null && template.FileUrl == null)
{
return;
}
var url = template.FileUrl ?? GetGoogleDocsEmbeddedUrl(template.FileLocation);
PdfLiteral.Text =
$"<iframe src=\"http://docs.google.com/gview?url={url}&embedded=true\" style=\"width:100%; height:700px;\" frameborder=\"0\"></iframe>";
}
