public aSite[] returnLocalResult(string callerID, string query, string queryType)
{
LocalPrecedentEntities _local = new LocalPrecedentEntities();
SES1 ses1 = new SES1();
var precedent = from p in _local.Precedent__case_.AsEnumerable()
where ses1.FindSES1(query.ToLower(), p.Query.ToLower()) > 80
select p;
if (precedent.Count() <= 0)
{
var iSites = this.getSitesFromDB(query, queryType);
return iSites;
}
else
{
var sites = new List
Precedent__case_ Pc = new Precedent__case_
{
CaseId = _local.Precedent__case_.Count() + 1,
Query = query,
Username="NEW"
};
_local.Precedent__case_.AddObject(Pc);
_local.SaveChanges();
foreach (var p in precedent)
{
var pRes = from res in _local.Result
where res.CaseId == p.CaseId
select res;
foreach (var si in pRes)
{
int i = _local.Result.Count();
i = i + 1;
Result pR = new Result
{
ResultId = i,
SiteId = si.SiteId,
CaseId = Pc.CaseId,
SES = si.SES*(float)ses1.FindSES1(query.ToLower(), p.Query.ToLower())/100
};
_local.Result.AddObject(pR);
}
var pSite = from r in _local.Result
where r.CaseId == p.CaseId
select r.SiteId;
sites.AddRange(pSite);
}
_local.SaveChanges();
abhishek trivediPosted Feb 13, 2015, 5:38 AM
FK DSPosted Jan 25, 2015, 12:33 AM
Please can you tell me how to correct it. Thank you!!
Vithal WadjePosted Jan 24, 2015, 11:52 PM