public void DeleteAllLatexForItem(int itemId, ELatexItemType itemType)
{
using (IDataContext context = DataContext.Instance())
{
var rec = context.ExecuteQuery <PHText>(CommandType.Text,
"DELETE FROM PHLatex WHERE ItemId=@0 AND ItemType=@1", itemId, (int)itemType);
}
}
/// <summary>
/// Will get the latest version of LatexText in language cultureCode for itemType/itemId
/// If the text does not exist, it creates a LatexText where LatexId=0
/// </summary>
/// <param name="cultureCode"></param>
/// <param name="itemId"></param>
/// <param name="itemType"></param>
/// <returns></returns>
public PHLatex GetCurrentVersionLatexText(string cultureCode, int itemId, ELatexItemType itemType)
{
PHLatex txt = rep.GetCurrentVersionLatexText(cultureCode, itemId, itemType);
if (txt == null)
{
txt = new PHLatex();
txt.Text = "(No text)";
txt.HtmlText = "(No text)";
txt.CultureCode = cultureCode;
txt.ItemId = itemId;
txt.ItemType = itemType;
}
return(txt);
}
public PHLatex GetCurrentVersionLatexText(string cultureCode, int itemId, ELatexItemType itemType)
{
IEnumerable <PHLatex> txt;
PHLatex theText = null;
using (IDataContext ctx = DataContext.Instance())
{
var rep = ctx.GetRepository <PHLatex>();
txt = rep.Find("WHERE CultureCode = @0 AND ItemId = @1 AND ItemType = @2 AND CurrentVersion = 'True'", cultureCode, itemId, (int)itemType);
}
if (txt.Any())
{
theText = txt.First(); //Can only be at most one. PetaPoco does not handle composite key
}
return(theText);
}
public void DeleteAllLatexForItem(int itemId, ELatexItemType itemType)
{
using (IDataContext context = DataContext.Instance())
{
var rec = context.ExecuteQuery<PHText>(CommandType.Text,
"DELETE FROM PHLatex WHERE ItemId=@0 AND ItemType=@1", itemId, (int)itemType);
}
}
public PHLatex GetCurrentVersionLatexText(string cultureCode, int itemId, ELatexItemType itemType)
{
IEnumerable<PHLatex> txt;
PHLatex theText = null;
using (IDataContext ctx = DataContext.Instance())
{
var rep = ctx.GetRepository<PHLatex>();
txt = rep.Find("WHERE CultureCode = @0 AND ItemId = @1 AND ItemType = @2 AND CurrentVersion = 'True'", cultureCode, itemId, (int)itemType);
}
if (txt.Any())
theText = txt.First(); //Can only be at most one. PetaPoco does not handle composite key
return theText;
}
public IEnumerable<PHLatex> GetAllVersionsLatexText(string cultureCode, int itemId, ELatexItemType itemType)
{
IEnumerable<PHLatex> txt;
using (IDataContext ctx = DataContext.Instance())
{
var rep = ctx.GetRepository<PHLatex>();
txt = rep.Find("WHERE CultureCode = @0 AND ItemId = @1 AND ItemType = @2 ORDER BY Version", cultureCode, itemId, (int)itemType);
}
return txt;
}
/// <summary>
/// Will get the latest version of LatexText in language cultureCode for itemType/itemId
/// If the text does not exist, it creates a LatexText where LatexId=0
/// </summary>
/// <param name="cultureCode"></param>
/// <param name="itemId"></param>
/// <param name="itemType"></param>
/// <returns></returns>
public PHLatex GetCurrentVersionLatexText(string cultureCode, int itemId, ELatexItemType itemType)
{
PHLatex txt = rep.GetCurrentVersionLatexText(cultureCode, itemId, itemType);
if (txt == null)
{
txt = new PHLatex();
txt.Text = "(No text)";
txt.HtmlText = "(No text)";
txt.CultureCode = cultureCode;
txt.ItemId = itemId;
txt.ItemType = itemType;
}
return txt;
}
/// <summary>
/// Will return all versions of LatexText in language cultureCode for itemType/itemId
/// May be null if no versions exist
/// </summary>
/// <param name="cultureCode"></param>
/// <param name="itemId"></param>
/// <param name="itemType"></param>
/// <returns></returns>
public IEnumerable<PHLatex> GetAllVersionsLatexText(string cultureCode, int itemId, ELatexItemType itemType)
{
return rep.GetAllVersionsLatexText(cultureCode, itemId, itemType);
}
public IEnumerable <PHLatex> GetAllVersionsLatexText(string cultureCode, int itemId, ELatexItemType itemType)
{
IEnumerable <PHLatex> txt;
using (IDataContext ctx = DataContext.Instance())
{
var rep = ctx.GetRepository <PHLatex>();
txt = rep.Find("WHERE CultureCode = @0 AND ItemId = @1 AND ItemType = @2 ORDER BY Version", cultureCode, itemId, (int)itemType);
}
return(txt);
}
/// <summary>
/// Constructs a PHLatex
/// </summary>
/// <param name="text"></param>
/// <param name="cultureCode"></param>
/// <param name="itemType"></param>
public PHLatex(string text, string cultureCode, ELatexItemType itemType)
{
Text = text;
CultureCode = cultureCode;
ItemType = itemType;
}
/// <summary>
/// Constructs a PHLatex
/// </summary>
/// <param name="text"></param>
/// <param name="cultureCode"></param>
/// <param name="itemType"></param>
public PHLatex(string text, string cultureCode, ELatexItemType itemType)
{
Text = text;
CultureCode = cultureCode;
ItemType = itemType;
}
/// <summary>
/// Will return all versions of LatexText in language cultureCode for itemType/itemId
/// May be null if no versions exist
/// </summary>
/// <param name="cultureCode"></param>
/// <param name="itemId"></param>
/// <param name="itemType"></param>
/// <returns></returns>
public IEnumerable <PHLatex> GetAllVersionsLatexText(string cultureCode, int itemId, ELatexItemType itemType)
{
return(rep.GetAllVersionsLatexText(cultureCode, itemId, itemType));
}
/// <summary>
/// Will get the latest version of LatexText in language cultureCode for itemType/itemId
/// If the text does not exist, it creates a LatexText where LatexId=0
/// htmltext will be decoded (actual html)
/// </summary>
/// <param name="cultureCode"></param>
/// <param name="itemId"></param>
/// <param name="itemType"></param>
/// <returns></returns>
public PHLatex GetCurrentVersionLatexText(string cultureCode, int itemId, ELatexItemType itemType)
{
PHLatex txt = rep.GetCurrentVersionLatexText(cultureCode, itemId, itemType);
if (txt != null && txt.CultureCodeStatus == ECultureCodeStatus.NotTranslated)
{
string CreatedInCultureCode = GetCreatedInCultureCode(txt);
if (CreatedInCultureCode != null)
{
PHLatex originalText = rep.GetCurrentVersionLatexText(CreatedInCultureCode, itemId, itemType);
string translatedText = TranslateText(CreatedInCultureCode.Substring(0, 2), cultureCode.Substring(0, 2), originalText.HtmlText);
if (translatedText != null)
{
txt.HtmlText = translatedText;
txt.CultureCodeStatus = ECultureCodeStatus.GoogleTranslated;
rep.UpdateLatexText(txt);
}
else
txt.HtmlText = "- no translation is available at the moment, please try again later -";
}
}
return txt;
}
