public List <SearchObject> ObjectIndexFindAllInList(List <long> ids)
{
var result = new List <SearchObject>();
try
{
var o = (from ob in objects
where ids.Contains(ob.Id)
select ob).ToList();
if (o != null)
{
foreach (var ob in o)
{
var so = new SearchObject();
so.Id = ob.Id;
so.ObjectId = ob.ObjectId;
so.ObjectType = ob.ObjectType;
so.Title = ob.Title;
so.SiteId = ob.SiteId;
result.Add(so);
}
}
}
catch
{
result = null;
}
return(result);
}
public long ObjectIndexAddOrUpdate(SearchObject s)
{
var existing = provider.ObjectIndexFindByTypeAndId(s.SiteId, s.ObjectType, s.ObjectId);
if (existing != null)
{
var existingId = existing.Id;
ObjectIndexDelete(existingId);
return(provider.ObjectIndexInsert(s));
}
return(provider.ObjectIndexInsert(s));
}
public SearchObject ObjectIndexFind(long id)
{
SearchObject result = null;
var o = (from ob in objects
where ob.Id == id
select ob).FirstOrDefault();
if (o != null)
{
return(o);
}
return(result);
}
public long ObjectIndexInsert(SearchObject s)
{
using (var context = CreateHccDbContext())
{
var dataObject = new hcc_SearchObject();
dataObject.ObjectId = s.ObjectId;
dataObject.ObjectType = s.ObjectType;
dataObject.Title = s.Title;
dataObject.SiteId = s.SiteId;
dataObject.LastIndexUtc = DateTime.UtcNow;
context.hcc_SearchObjects.Add(dataObject);
context.SaveChanges();
s.Id = dataObject.Id;
return(s.Id);
}
}
public long ObjectIndexInsert(SearchObject s)
{
long max = 0;
if (objects.Count > 0)
{
var max2 = (from o in objects
select o.Id).Max();
max = max2;
max += 1;
}
else
{
max = 1;
}
s.Id = max;
objects.Add(s);
return(max);
}
public SearchObject ObjectIndexFindByTypeAndId(long siteId, int type, Guid objectId)
{
using (var context = CreateHccDbContext())
{
var o = context.hcc_SearchObjects
.Where(so => so.ObjectType == type)
.Where(so => so.ObjectId == objectId)
.Where(so => so.SiteId == siteId)
.FirstOrDefault();
if (o != null)
{
var result = new SearchObject();
result.Id = o.Id;
result.ObjectId = o.ObjectId;
result.ObjectType = o.ObjectType;
result.Title = o.Title;
result.SiteId = o.SiteId;
result.LastIndexUtc = o.LastIndexUtc;
return(result);
}
return(null);
}
}
public List <SearchObject> ObjectIndexFindAllInList(List <long> ids)
{
using (var context = CreateHccDbContext())
{
var objects = context.hcc_SearchObjects
.Where(o => ids.Contains(o.Id))
.ToList();
var result = new List <SearchObject>();
foreach (var obj in objects)
{
var so = new SearchObject();
so.Id = obj.Id;
so.ObjectId = obj.ObjectId;
so.ObjectType = obj.ObjectType;
so.Title = obj.Title;
so.SiteId = obj.SiteId;
so.LastIndexUtc = obj.LastIndexUtc;
result.Add(so);
}
return(result);
}
}
public SearchObject ObjectIndexFind(long id)
{
using (var context = CreateHccDbContext())
{
var obj = context.hcc_SearchObjects
.Where(so => so.Id == id)
.FirstOrDefault();
if (obj != null)
{
var result = new SearchObject();
result.Id = obj.Id;
result.ObjectId = obj.ObjectId;
result.ObjectType = obj.ObjectType;
result.Title = obj.Title;
result.SiteId = obj.SiteId;
result.LastIndexUtc = obj.LastIndexUtc;
return(result);
}
return(null);
}
}
