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);
}
private static IEnumerable <IMachineTag> ToMTags(IReadOnlyList <EntityAnnotation> labels, WebDetection webInfos)
{
foreach (var x in labels)
{
if (string.IsNullOrEmpty(x.Description))
{
continue;
}
var mtag = new MachineTag {
Name = x.Description, Score = x.Score, Source = KeyLabel
};
yield return(mtag);
}
foreach (var x in webInfos.WebEntities)
{
if (string.IsNullOrEmpty(x.Description))
{
continue;
}
var mtag = new MachineTag {
Name = x.Description, Score = x.Score, Source = KeyWeb
};
yield return(mtag);
}
}
//2.ดึงชื่อ tag ทุกชื่อจาก DB ----- ไปที่ method CollectJsonToDB
public static JObject getAllMachineTagValue(String url)
{
List <MachineTag> listMachineTag = MachineTag.getAll();
WebClient webClient = new WebClient();
DupeNVC dnvc = new DupeNVC("ids");
foreach (MachineTag matchineTag in listMachineTag)
{
dnvc.Add("ids", matchineTag.TagName);
}
webClient.QueryString = dnvc;
string respones = webClient.DownloadString(url); // get json string from URL
JObject jsonObject = JObject.Parse(respones); //Parse json string to jsonObject
return(jsonObject); // return json object for use in other method
}
