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);
}
}
}
//select * from ltc_newsletter.templates_user where IsParadigmNewsletter = 1 and Office_Sequence = -1
public static void SavePreNewsTemplate(gSavePredefinedTemplate model)
{
model.TemplateSourceMarkup = model.TemplateSourceMarkup ?? "empty";
using (var db = new Database(DbConfiguration.LtcNewsletter))
{
gSavePredefinedTemplate found = db.Fetch <gSavePredefinedTemplate>($"select * from templates where TemplateID={model.TemplateID}").FirstOrDefault();
if (found != null)
{
db.Update(model, model.TemplateID);
}
else
{
db.Save(model);
}
}
}
public static void CopySystemTemplate(int TemplateID, string name, int Office_Sequence)
{
using (var db = new Database(DbConfiguration.LtcNewsletter))
{
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.ContentImage = found
//obj.IndustryID = found.IndustryID;
obj.MainBodymarkup = found.TemplateSourceMarkup;
obj.TemplateSourceMarkup = found.TemplateSourceMarkup;
obj.TypeID = 8;
obj.ThumbnailPath = found.ThumbnailPath;
obj.ModificationDate = DateTime.Now.ToUniversalTime();
obj.CategoryID = 1;
db.Save(obj);
}
}
}
