public bool CreateTag(CatalogAppMVC.Models.Tag tagModel, int recordID) { try { CatalogDatabaseDataContext context = new WorkLinqToSql.CatalogDatabaseDataContext(); WorkLinqToSql.Tag tag = new WorkLinqToSql.Tag(); tag.Name = tagModel.Name; var tagsInBase = from t in context.Tags where t.Name == tagModel.Name select t; if (tagsInBase.Count() > 0) { tag = tagsInBase.First(); } else { context.Tags.InsertOnSubmit(tag); context.Tags.Context.SubmitChanges(); } WorkLinqToSql.MachineTag machineTag = new MachineTag(); machineTag.MachineID = recordID; machineTag.Tag = tag; context.MachineTags.InsertOnSubmit(machineTag); context.MachineTags.Context.SubmitChanges(); } catch { return(false); } return(true); }
public bool UpdateTag(CatalogAppMVC.Models.Tag tagModel) { try { CatalogDatabaseDataContext context = new WorkLinqToSql.CatalogDatabaseDataContext(); WorkLinqToSql.Tag tag = (from t in context.Tags where t.Id == tagModel.ID select t).Single <WorkLinqToSql.Tag>(); tag.Name = tagModel.Name; context.MachineTags.Context.SubmitChanges(); } catch { return(false); } return(true); }