public static void AssertFieldsExist(ActiveRecord person)
{
// check person record is OK
if (!person.FieldExists("Email") || !person.FieldExists("PersonID") || !person.FieldExists("DoubleOptInEmailSentDate") || !person.FieldExists("SubscribeDate") || !person.FieldExists("UnsubscribeDate") || !person.FieldExists("HasValidatedEmail"))
{
throw new Exception("NewsletterDoubleOptIn - fields missing from person record. The following fields must exists: Email, PersonID, DoubleOptInEmailSentDate, SubscribeDate, UnsubscribeDate, HasValidatedEmail");
}
}
public ActionResult SEOEditPanel(ActiveRecord record, bool showHeader, string cssTablerowClass)
{
if (!record.FieldExists("PageTitleTag"))
{
return(null);
}
CheckForNoShowHeader(record, ref showHeader);
var data = new SEOViewData();
data.DataRecord = record;
data.ShowHeader = showHeader;
data.CssTablerowClass = cssTablerowClass;
// AF20140926: Invoke GetFullUrl method by reflection to get the overriden method inside each model rather than the ActiveRecord generic one
data.Url = record.GetType().GetMethod("GetFullUrl", new Type[] { }).Invoke(record, new object[] { }).ToString();
return(View(data));
}
public static void CheckAttachmentsForDocOrPDFText(ActiveRecord record)
{
//walk the field list for this record looking for attachments
foreach (var fieldName in record.GetFieldNames())
{
if (fieldName.Contains("Attachment") && fieldName.DoesntContain("RawText"))
{
//if (record.Fields.Attachment.IsDirty) {
if (ActiveFieldBase.IsDirtyObj(record[fieldName].ValueObject, record[fieldName].OriginalValueObject))
{
if (record[fieldName].ToString().Contains(".doc") || record[fieldName].ToString().EndsWith(".pdf") || record[fieldName].ToString().EndsWith(".rtf"))
{
if (!record.FieldExists(fieldName + "RawText"))
{
(new Sql("ALTER TABLE ", record.GetTableName().SqlizeName(), " ADD [" + fieldName + "RawText] nvarchar (MAX);")).Execute();
}
string output = "";
if (record[fieldName].ToString().ToLower().EndsWith(".doc"))
{
OfficeFileReader.OfficeFileReader objOFR = new OfficeFileReader.OfficeFileReader();
if (objOFR.GetText(Web.MapPath(Web.Attachments) + record[fieldName].ToString(), ref output) > 0)
{
//ok
}
}
else if (record[fieldName].ToString().ToLower().EndsWith(".docx"))
{
BewebCore.ThirdParty.ReadWordDocText.DocxToText objOFR = new DocxToText(Web.MapPath(Web.Attachments) + record[fieldName].ToString());
if ((output = objOFR.ExtractText()).Length > 0)
{
//ok
}
}
else if (record[fieldName].ToString().Contains(".pdf"))
{
PdfToText.PDFParser pdf = new PDFParser();
if (pdf.ExtractText(Web.MapPath(Web.Attachments) + record[fieldName].ToString(), ref output))
{
//ok
}
}
else if (record[fieldName].ToString().Contains(".rtf"))
{
#if RTFProcessingAvailable
//Create the RTF tree object
RtfTree tree = new RtfTree();
//Load and parse RTF document
tree.LoadRtfFile(Web.MapPath(Web.Attachments) + record[fieldName].ToString());
output = tree.Text;
#else
throw new Exception("rtf library not included");
#endif
}
if (output.Trim() != "")
{
(new Sql("update ", record.GetTableName().SqlizeName(), "set " + fieldName + "RawText=", output.SqlizeText(), " where ",
record.GetPrimaryKeyName().SqlizeName(), "=", record.ID_Field.Sqlize(), "")).Execute();
}
}
else
{
//no doc any more
if (record.FieldExists(fieldName + "RawText"))
{
(new Sql("update ", record.GetTableName().SqlizeName(), "set " + fieldName + "RawText=null where ",
record.GetPrimaryKeyName().SqlizeName(), "=", record.ID_Field.Sqlize(), "")).Execute();
}
}
}
}
}
}
