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