public static int[] tagStringToId(string s, FUENMLEntities db)
{
//用於搜尋TAG
List <int> tag_id = new List <int>();
if (s != "" && (db.tags.Where(q => q.name.Contains(s))).Any())
{
var tagid = from p in db.tags
where (p.name.Contains(s))
select p;
foreach (tag t in tagid)
{
tag_id.Add(t.id);
}
}
return(tag_id.Distinct().ToArray());
}
public static int[] checktagString(tagString s, FUENMLEntities db)
{ //用於新增TAG
List <int> tag_id = new List <int>();
if (s.tag_str.Length > 0)
{
foreach (string item in s.tag_str)
{
string trimString = item.Trim();
if (!(db.tags.Where(q => q.name == trimString)).Any())
{
tag newtag = new tag();
newtag.name = trimString;
newtag.type = 2;
db.tags.Add(newtag);
db.SaveChanges();
tag_id.AddRange(db.tags.Where(p => p.name == trimString).Select(q => q.id).ToList());
}
}
}
return(tag_id.Distinct().ToArray());
}
public static void userEventRecord(int userlogin, int userEventNum, FUENMLEntities db)
{
try {
if (userEventNum == 1 || userEventNum == 2 || userEventNum == 3)
{
if (userlogin == 0)
{
userlogin = 2;
}
userEvent userEventobj = new userEvent();
userEventobj.user_id = userlogin;
userEventobj.userEvent1 = userEventNum;
userEventobj.created = DateTime.Now;
db.userEvents.Add(userEventobj);
db.SaveChanges();
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
}
public static List <int> searchTag(int userlogin, ref List <int> intersectResult, int i, FUENMLEntities db)
{
//用於自動完成 回傳相關tag autocomplete
var searchplacehastag = db.tagRelationships.Where(P => P.tag_id == i).Select(q => q.place_id).ToList();
if (userlogin != 0)
{
searchplacehastag = db.tagRelationships.Where(P => P.tag_id == i && P.user_id == userlogin).Select(q => q.place_id).ToList();
}
//searchplacehastag = searchplacehastag.Distinct().ToList();
intersectResult = intersectResult.Intersect(searchplacehastag).ToList();
return(intersectResult);
}
