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> /// 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; }