public static void ModifyResourceTranslationDescription(ResourceTranslatedCategoryItem resource)
{
using (var context = Exigo.Sql())
{
context.Execute(@"
UPDATE ExigoWebContext.ResourceTranslatedCategoryItems
SET TranslatedCategoryDescription = @description
WHERE TranslatedCategoryID = @id
", new { description = resource.TranslatedCategoryDescription, id = resource.TranslatedCategoryID });
}
}
public static void AddCategoryTranslation(ResourceTranslatedCategoryItem rtcItems)
{
using (var context = Exigo.Sql())
{
context.Execute(@"
INSERT
ExigoWebContext.ResourceTranslatedCategoryItems
(TranslatedCategoryID, CategoryID, Language, TranslatedCategoryDescription)
VALUES
(@translatedcategoryid, @categoryid, @language, @categorydescription)
", new { translatedcategoryid = rtcItems.TranslatedCategoryID, categoryid = rtcItems.CategoryID, language = rtcItems.Language, categorydescription = rtcItems.TranslatedCategoryDescription });
}
}
