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