public void StoreSearchFiles(SearchParametersDto param)
{
using (var db = new PerceptronDatabaseEntities())
{
db.SaveChanges();
}
}
//Store Query Parameters
public void StoreSearchParameters(SearchParametersDto param)
{
using (var db = new PerceptronDatabaseEntities())
{
db.SearchQueries.Add(param.SearchQuerry);
db.SearchParameters.Add(param.SearchParameters);
db.SearchFiles.AddRange(param.SearchFiles);
//db.PtmFixedModifications.AddRange(param.FixedMods);
//db.PtmVariableModifications.AddRange(param.VarMods);
db.SaveChanges();
}
}
public int Set_Progress(string qid, int progress)
{
using (var db = new PerceptronDatabaseEntities())
{
var result = db.SearchQueries.SingleOrDefault(b => b.QueryId == qid);
if (result != null)
{
result.Progress = progress.ToString();
db.SaveChanges();
}
}
return(1);
}
//public string GetEmailFromUserId(string id)
//{
// string email;
// using (var db = new PerceptronContext())
// {
// var query = from b in db.SearchQueryTable
// where b.UserId == id
// select b.Email;
// email = query.Any() ? query.First() : Constants.EmailNotFound;
// }
// return email;
//}
public string StoreResults(SearchResultsDto res, string fileName, int fileId)
{
string message = Constants.ResultsSotredSuccessfully; //Spelling mistake?#PROBLEM_DETECTED
using (var db = new PerceptronDatabaseEntities())
{
var executionTime = GetExecutionTimeModel(res, fileName);
db.ExecutionTimes.Add(executionTime);
//db.SaveChanges();
foreach (ProteinDto protein in res.FinalProt)
{
var resId = Guid.NewGuid();
var headerTag = GetHeaderTag(protein.Header);
var searchResult = GetSearchResultModel(res.QueryId, fileId, headerTag, protein, resId);
db.SearchResults.Add(searchResult);
//db.SaveChanges();
if (protein.PtmParticulars == null)
{
continue;
}
foreach (var ptmSite in protein.PtmParticulars)
{
var resultPtmSites = GetResultPtmSitesModel(resId, ptmSite);
db.ResultPtmSites.Add(resultPtmSites);
//db.SaveChanges();
}
var resultInsilicoMatchLeft = GetResultInsilicoMatchLeftModel(resId, protein.InsilicoDetails.PeaklistMassLeft);
db.ResultInsilicoMatchLefts.Add(resultInsilicoMatchLeft);
//db.SaveChanges();
var resultInsilicoMatchRight = GetResultInsilicoMatchLeftModel(resId, protein.InsilicoDetails.PeaklistMassRight);
db.ResultInsilicoMatchLefts.Add(resultInsilicoMatchRight); //#PROBLEM_DETECTED??? Why this-->ResultInsilicoMatchLeftTable WHy not ResultInsilicoMatchRights
//db.SaveChanges();
}
db.SaveChanges();
}
return(message);
}