public static string ClearArticleTemplate(gOfficeInfo office, gArticleModel template, gPatientOfficeInfo patient, string familyList)
{
StringBuilder sb = new StringBuilder(template.ContentWithDefaultStyle);
sb.Replace("&OfficeName&", office?.ClinicName);
sb.Replace("&Subscriber&", patient.Email);
sb.Replace("&PatientName&", patient.FirstName);
sb.Replace("&PatientSalutation&", patient.Salutation);
sb.Replace("&PatientFirstName&", patient.FirstName);
sb.Replace("&PatientLastName&", patient.LastName);
sb.Replace("&AppointDate&", patient.AppointmentDate);
sb.Replace("&AppointTime&", patient.AppointmentTime);
sb.Replace("&ProviderName&", patient.Provider);
sb.Replace("&Date&", DateTime.Now.Date.ToString());
sb.Replace("&subjecttext&", template.Title);
sb.Replace("&OfficeEmail&", office?.OfficeEmailAddress);
sb.Replace("&OfficeStreet&", office?.AddressLine1);
sb.Replace("&OfficeStreet2&", office?.AddressLine2);
sb.Replace("&OfficeStreet3&", office?.AddressLine3);
sb.Replace("&OfficeProvince&", office?.Province);
sb.Replace("&City&", office?.City);
sb.Replace("&Country&", office?.Country);
sb.Replace("&PostalCode&", office?.PostalCode);
sb.Replace("&OfficePhone&", office?.Phone);
sb.Replace("&OfficeWebAddress&", office?.WebSite);
sb.Replace("&Fax&", office?.Fax);
sb.Replace("&FamilyList&", familyList);
return(sb.ToString());
}
public static void CopyArticle(int TemplateID, int ArticleId, string name, int Office_Sequence, string Content, byte[] ContentImage)
{
using (var db = new Database(DbConfiguration.LtcNewsletter))
{
var categoryId = 1;
gArticleModel art = db.Fetch <gArticleModel>($"select * from system_articles where ArticleID={ArticleId}").FirstOrDefault();
if (art != null)
{
categoryId = art.CategoryID;
}
gSavePredefinedTemplate found = db.Fetch <gSavePredefinedTemplate>($"select * from templates where TemplateID={TemplateID}").FirstOrDefault();
if (found != null)
{
gSaveUserTemplate obj = new gSaveUserTemplate();
obj.TemplateTitle = name;
obj.Office_Sequence = Office_Sequence;
obj.EmbeddedNewsletter = string.Empty;
obj.MainBodymarkup = Content;
obj.TemplateSourceMarkup = found.TemplateSourceMarkup;
obj.TypeID = 8;
obj.ThumbnailPath = found.ThumbnailPath;
obj.ContentImage = ContentImage;
obj.ModificationDate = DateTime.Now.ToUniversalTime();
obj.CategoryID = categoryId;
db.Save(obj);
}
}
}
public static void SaveArticle(gArticleModel model)
{
using (var db = new Database(DbConfiguration.LtcNewsletter))
{
gArticleModel found = db
.Fetch <gArticleModel>($"select * from system_articles where ArticleID={model.ArticleID}")
.FirstOrDefault();
if (found != null)
{
db.Update(model, model.ArticleID);
}
//else
// db.Save(model);
}
}
public static void UpdateArticle(gArticleModelTest model)
{
using (var db = new Database(DbConfiguration.LtcNewsletter))
{
gArticleModel found = db
.Fetch <gArticleModel>($"select * from system_articles where ArticleID={model.ArticleID}")
.FirstOrDefault();
byte[] byteArray = Convert.FromBase64String(model.ContentImage);
found.ContentImage = byteArray;
if (found != null)
{
db.Update(found, model.ArticleID);
}
//else
// db.Save(model);
}
}