public List<Dataformat> GetAllDataFormats() { using (var db = new TSPDSContext()) { var dataformats = from b in db.Dataformat select b; if (dataformats.Any()) { return dataformats.ToList(); } return new List<Dataformat>(); } }
public List<Method> GetAllMethods() { using (var db = new TSPDSContext()) { var methods = from b in db.Method select b; if (methods.Any()) { return methods.ToList(); } return new List<Method>(); } }
public List<ArticleReferences> GetAllArticleReferenceses() { using (var db = new TSPDSContext()) { var query = from b in db.ArticleReferences select b; if (query.Any()) { return query.ToList(); } return new List<ArticleReferences>(); } }
public void DeleteUser(User user) { if (user.Id == 0) return; user.FirstName = "DeletedUser" + user.Id.ToString(); user.LastName = null; user.Institute = null; user.Password = Encryption.EncryptPassword(DateTime.Now.ToString()); var perm = new Permission {Id = 1}; user.Permission = perm; user.PermissionPermissionId = perm.Id; user.Picture = null; user.PhoneNumber = null; user.Email = null; using (var db = new TSPDSContext()) { db.Entry(user).State = EntityState.Modified; db.User.AddOrUpdate(user); db.SaveChanges(); } }
public List<ArticleReferences> GetArticleReferences(ParametersForArticelreferences parameters) { using (var db = new TSPDSContext()) { var query = db.ArticleReferences.AsQueryable(); if (!string.IsNullOrWhiteSpace(parameters.FirstName)) query = query.Where(x => x.Firstname == parameters.FirstName); if (!string.IsNullOrWhiteSpace(parameters.LastName)) query = query.Where(x => x.Lastname == parameters.LastName); if (parameters.Year.HasValue) query = query.Where(x => x.Year == parameters.Year); if (!string.IsNullOrWhiteSpace(parameters.DOINumber)) query = query.Where(x => x.DOINumber == parameters.DOINumber); return query.ToList(); } }
private void InsertDataPoint(List<DataPoint> dataPoints, Dataset dataset, Dataformat originalFormat, Dataformat convertedFormat) { using (var db = new TSPDSContext()) { var query = from b in db.Dataformat where b.Id == originalFormat.Id where b.Id == convertedFormat.Id select b; if (query.Any()) { foreach (var dataPoint in dataPoints) { dataPoint.DataformatForConverted_Id = convertedFormat.Id; dataPoint.DataformatForOriginal_Id = originalFormat.Id; dataPoint.ConvertedDataformat = convertedFormat; dataPoint.OriginalDataformat = originalFormat; dataPoint.Dataset = dataset; dataPoint.DatasetDatasetId = dataset.Id; db.Entry(dataPoint).State = EntityState.Modified; db.DataPoint.Add(dataPoint); } db.SaveChanges(); } } }
public void UpdateUserPermission(User user, Permission perm) { ValidateUser(user); ValidatePermission(perm); if (perm == null) throw new DALInfoNotSpecifiedException("User permission was not specified"); if (perm.Id == 0) throw new DALInfoNotSpecifiedException("Permission id was not speciified"); if (user.Id == 0) throw new DALInfoNotSpecifiedException("User id was not speciified"); var param = new ParametersForUsers(); param.Email = user.Email; var temp = GetUsers(param)[0]; if (temp.Email != user.Email) { throw new DALInfoNotSpecifiedException("The user was not found in the databse"); } using (var db = new TSPDSContext()) { user.Permission = perm; user.PermissionPermissionId = perm.Id; db.User.AddOrUpdate(user); db.SaveChanges(); } }
public void InsertTargetMaterial(TargetMaterial material) { if (material.Name == null) { throw new DALInfoNotSpecifiedException("Material name was not specified"); } using (var db = new TSPDSContext()) { var query = from m in db.TargetMaterial where m.Name.ToLower() == material.Name.ToLower() select m; if (query.Any()) { throw new DALAlreadyExistsException("Material already excist"); } db.TargetMaterial.Add(material); db.SaveChanges(); } }
public Permission GetPermByAccessLevel(AccessLevel accessLevel) { using (var db = new TSPDSContext()) { var query = from b in db.Permission where b.Id == (int) accessLevel select b; if (query.Any()) { Permission perm = query.ToList()[0]; return perm; } throw new DALOutOfRangeException("Perm id was out of range"); } }
public Revision GetNewestRevisionByDataset(Dataset dataset) { using (var db = new TSPDSContext()) { var query = from b in db.Revision where b.Dataset_Id == dataset.Id select b; if (query.Any()) { query = query.Include(m => m.Dataset.Projectile); query = query.Include(m => m.Dataset.Method); query = query.Include(m => m.Dataset.TargetMaterial); query = query.Include(m => m.Dataset.StateOfAggregation); query = query.Include(m => m.Dataset.ArticleReferences); query = query.Include(m => m.Dataset.DataPoint); query = query.Include(m => m.Dataset.Revision); return query.ToList().Last(); } return new Revision(); } }
public Method GetMethodByName(string name) { using (var db = new TSPDSContext()) { var query = from b in db.Method where b.Name == name select b; if (query.Any()) { return query.Single(); } return new Method(); } }
public List<Dataset> GetDatasets(ParametersForDataset parameters) { using (var db = new TSPDSContext()) { var query = db.Dataset.AsQueryable(); if (!string.IsNullOrWhiteSpace(parameters.ProjectileName)) query = query.Where(x => x.Projectile.Name == parameters.ProjectileName); if (parameters.MethodId.HasValue) query = query.Where(x => x.Method_Id == parameters.MethodId); if (parameters.ArticleReferencesId.HasValue) query = query.Where(x => x.ArticleReferences_Id == parameters.ArticleReferencesId); if (parameters.StateOfAggregationId.HasValue) query = query.Where(x => x.StateOfAggregation_Id == parameters.StateOfAggregationId); if (!string.IsNullOrWhiteSpace(parameters.FirstName)) query = query.Where(x => x.Revision.Any(s => s.User.FirstName == parameters.FirstName)); if (!string.IsNullOrWhiteSpace(parameters.LastName)) query = query.Where(x => x.Revision.Any(s => s.User.LastName == parameters.LastName)); if (!string.IsNullOrWhiteSpace(parameters.Institute)) query = query.Where(x => x.Revision.Any(s => s.User.Institute == parameters.Institute)); if (parameters.RevId.HasValue) query = query.Where(x => x.Revision.Any(s => s.Id == parameters.RevId)); if (parameters.Approved.HasValue) query = query.Where(x => x.Revision.Any(s => s.Approved == parameters.Approved)); //TargetMaterial search options if (!string.IsNullOrWhiteSpace(parameters.TargetMaterialName)) query = query.Where(x => x.TargetMaterial.Name == parameters.TargetMaterialName); if (!string.IsNullOrWhiteSpace(parameters.TargetMaterialChemicalFormula)) query = query.Where(x => x.TargetMaterial.ChemicalFormula == parameters.TargetMaterialChemicalFormula); if (!string.IsNullOrWhiteSpace(parameters.TargetMaterialICRUId)) query = query.Where(x => x.TargetMaterial.ICRUId == parameters.TargetMaterialICRUId); if (!string.IsNullOrWhiteSpace(parameters.TargetMaterialZCharge)) query = query.Where(x => x.TargetMaterial.ZCharge == parameters.TargetMaterialZCharge); if (parameters.TargetMaterialMass.HasValue) query = query.Where(x => x.TargetMaterial.Mass == parameters.TargetMaterialMass); if (parameters.TargetMaterialMolarMass.HasValue) query = query.Where(x => x.TargetMaterial.MolarMass == parameters.TargetMaterialMolarMass); if (parameters.ProjectileMass.HasValue) query = query.Where(x => x.Projectile.Mass == parameters.ProjectileMass); if (!string.IsNullOrEmpty(parameters.ProjectilePDGNumber)) query = query.Where(x => x.Projectile.PDGNumber == parameters.ProjectilePDGNumber); if (parameters.ProjectilezCharge.HasValue) query = query.Where(x => x.Projectile.zCharge == parameters.ProjectilezCharge); query = query.Include(m => m.Projectile); query = query.Include(m => m.Method); query = query.Include(m => m.TargetMaterial); query = query.Include(m => m.StateOfAggregation); query = query.Include(m => m.ArticleReferences); query = query.Include(m => m.DataPoint); query = query.Include(m => m.Revision); return query.ToList(); } }
/// <summary> /// /// </summary> /// <param name="dataset"></param> /// <returns></returns> public List<DataPoint> GetDataPointsByDataSet(Dataset dataset) { var datapointsList = new List<DataPoint>(); using (var db = new TSPDSContext()) { var dataPoints = from b in db.Dataset where b.Id == dataset.Id select b.DataPoint; if (dataPoints.Any()) { return dataPoints.ToList()[0].ToList(); } return new List<DataPoint>(); } }
public Dataformat GetDataformatByNotation(string notation) { using (var db = new TSPDSContext()) { var query = from b in db.Dataformat where b.DataNotiation.ToLower() == notation.ToLower() select b; if (query.Any()) { return query.Single(); } return new Dataformat(); } }
public void InsertMethod(Method method) { if (method.Name == null) throw new DALInfoNotSpecifiedException("Method name was not specified"); using (var db = new TSPDSContext()) { var query = from s in db.Method where s.Name.ToLower() == method.Name.ToLower() select s; if (query.Any()) throw new DALAlreadyExistsException("Mehod already exists"); db.Method.Add(method); db.SaveChanges(); } }
public Projectile GetProjectileByName(string name) { using (var db = new TSPDSContext()) { var query = from b in db.Projectile where b.Name.ToLower() == name.ToLower() select b; if (query.Any()) { return query.Single(); } return new Projectile(); } }
public void InsertProjectile(Projectile projectile) { if (projectile.Name == null) { throw new DALInfoNotSpecifiedException("projectile name was not specified"); } using (var db = new TSPDSContext()) { var query = from m in db.Projectile where m.Name.ToLower() == projectile.Name.ToLower() select m; if (query.Any()) { throw new DALAlreadyExistsException("projectile already excist"); } db.Projectile.Add(projectile); db.SaveChanges(); } }
public StateOfAggregation GetStateOfAggregationByForm(string form) { using (var db = new TSPDSContext()) { var query = from b in db.StateOfAggregation where b.Form.ToLower() == form.ToLower() select b; if (query.Any()) { return query.Single(); } return new StateOfAggregation(); } }
public void InsertStateOfAggregation(StateOfAggregation AG) { if (AG.Form == null) { throw new DALInfoNotSpecifiedException("state of aggregation Form was not specified"); } using (var db = new TSPDSContext()) { var query = from s in db.StateOfAggregation where s.Form.ToLower() == AG.Form.ToLower() select s; if (query.Any()) throw new DALAlreadyExistsException("state of aggregation already exists"); db.StateOfAggregation.Add(AG); db.SaveChanges(); } }
public TargetMaterial GetTargetMaterialByName(string name) { using (var db = new TSPDSContext()) { var query = from b in db.TargetMaterial where b.Name.ToLower() == name.ToLower() select b; if (query.Any()) { return query.Single(); } return new TargetMaterial(); } }
public void InsertUser(User user, Permission perm) { ValidateUser(user); ValidatePermission(perm); using (var db = new TSPDSContext()) { var query = from s in db.User where s.Email.ToLower() == user.Email.ToLower() select s; if (query.Any()) throw new DALAlreadyExistsException("User already exists"); user.Permission = perm; user.PermissionPermissionId = perm.Id; db.Entry(user).State = EntityState.Modified; db.User.Add(user); db.SaveChanges(); } }
public List<User> GetUsers(ParametersForUsers parameters) { using (var db = new TSPDSContext()) { var query = db.User.AsQueryable(); if (!string.IsNullOrWhiteSpace(parameters.FirstName)) query = query.Where(x => x.FirstName.ToLower() == parameters.FirstName.ToLower()); if (!string.IsNullOrWhiteSpace(parameters.LastName)) query = query.Where(x => x.LastName.ToLower() == parameters.LastName.ToLower()); if (!string.IsNullOrWhiteSpace(parameters.Institute)) query = query.Where(x => x.Institute.ToLower() == parameters.Institute.ToLower()); if (!string.IsNullOrWhiteSpace(parameters.Email)) query = query.Where(x => x.Email.ToLower() == parameters.Email.ToLower()); if (!string.IsNullOrWhiteSpace(parameters.PhoneNumber)) query = query.Where(x => x.PhoneNumber == parameters.PhoneNumber); if (parameters.WaitingOnPromotion == true) query = query.Where(x => x.Permission.Id == 2); query = query.Include(x => x.Permission); return query.ToList(); } }
private ArticleReferences GetArticleReferenceByDOI(string DOI) { using (var db = new TSPDSContext()) { var query = from b in db.ArticleReferences where b.DOINumber == DOI select b; if (query.Any()) { return query.Single(); } return new ArticleReferences(); } }
public void InsertArticleReference(ArticleReferences articleReference) { using (var db = new TSPDSContext()) { var query = from b in db.ArticleReferences where b.DOINumber == articleReference.DOINumber select b; if (query.Any()) { throw new DALAlreadyExistsException("The DOI number already exists"); } db.ArticleReferences.Add(articleReference); db.SaveChanges(); } }
private void InsertRevision(Dataset dataset, Revision rev, User user, Revision prevRevision = null) { using (var db = new TSPDSContext()) { if (user.Id == 0) throw new DALInfoNotSpecifiedException("User id was not specified"); if (dataset.Id == 0) throw new DALInfoNotSpecifiedException("Dataset id was not specified"); if (rev.Id != 0) rev.Id = 0; ValidateUser(user); var query = from b in db.Revision where b.Dataset.Id == dataset.Id select b; if (query.Any()) throw new DALAlreadyExistsException("Dataset already exists"); rev.User = user; rev.Dataset = dataset; rev.UserUserId = user.Id; rev.Dataset_Id = dataset.Id; if (prevRevision != null) { if (prevRevision.Id == 0) throw new DALInfoNotSpecifiedException("Previous revision was not null, but the id was not specified"); prevRevision.HeadRevision = rev; prevRevision.HeadRevision_Id = rev.Id; rev.HeadRevision_Id = prevRevision.Id; db.Entry(prevRevision).State = EntityState.Modified; } db.Entry(dataset).State = EntityState.Modified; db.Entry(user).State = EntityState.Modified;; db.Revision.Add(rev); db.SaveChanges(); } }
public void InsertDataFormat(Dataformat dataformat) { if (dataformat.DataNotiation == null) throw new DALInfoNotSpecifiedException("DataFormat notation was not specified"); using (var db = new TSPDSContext()) { var query = from m in db.Dataformat where m.DataNotiation.ToLower() == dataformat.DataNotiation.ToLower() select m; if (query.Any()) { throw new DALAlreadyExistsException("Dataformat already excist"); } db.Dataformat.Add(dataformat); db.SaveChanges(); } }
private void ValidatePermission(Permission perm) { using (var db = new TSPDSContext()) { var query = from b in db.Permission where b.Id == perm.Id select b; if (!query.Any()) throw new DALOutOfRangeException("Permission id is out of range"); } }
public void InsertDataset(List<DataPoint> dataPoints, TargetMaterial impactMaterial, Projectile projectile, Dataformat orginalDataformat, Dataformat converteDataformat, Revision rev, User user, Revision prevRevision = null, ArticleReferences AR = null, Method method = null, StateOfAggregation stateOfAggregation = null) { if (impactMaterial.Id == 0) throw new DALInfoNotSpecifiedException("impactmaterial id was not specified"); if (projectile.Id == 0) throw new DALInfoNotSpecifiedException("Projectile id was not specified"); if (AR != null) { if (AR.Id == 0) throw new DALInfoNotSpecifiedException("ArtivleReference id was not specified"); } if (method != null) { if (method.Id == 0) throw new DALInfoNotSpecifiedException("Method id was not specified"); } if (stateOfAggregation != null) { if (stateOfAggregation.Id == 0) { throw new DALInfoNotSpecifiedException("State Of Aggregation Id was not specified"); } } foreach (var item in dataPoints) { if (item.ConvertetData == null) { throw new DALInfoNotSpecifiedException( "One or more DataPoints had unspecificed converted data"); } if (item.EqEnergy == null) { throw new DALInfoNotSpecifiedException("One or more DataPoints had unspecificed eqEnergy"); } if (item.StoppingPower == null) { throw new DALInfoNotSpecifiedException("One or more DataPoints had unspecificed StoppingPower"); } } var tempCollection = new List<ArticleReferences>(); tempCollection.Add(AR); var dataset = new Dataset() { Projectile_Id = projectile.Id, TargetMaterial_Id = impactMaterial.Id, ArticleReferences = AR, Projectile = projectile, Method = method, StateOfAggregation = stateOfAggregation, TargetMaterial = impactMaterial, }; if (AR != null) dataset.ArticleReferences_Id = AR.Id; if (method != null) dataset.Method_Id = method.Id; if (stateOfAggregation != null) dataset.StateOfAggregation_Id = stateOfAggregation.Id; using (var db = new TSPDSContext()) { db.Entry(dataset).State = EntityState.Modified; db.Dataset.Add(dataset); db.SaveChanges(); } InsertDataPoint(dataPoints, dataset, orginalDataformat, converteDataformat); InsertRevision(dataset, rev, user, prevRevision); }
public List<Permission> GetAllPermissions() { using (var db = new TSPDSContext()) { var perms = from b in db.Permission select b; if (perms.Any()) { return perms.ToList(); } return new List<Permission>(); } }
public List<TargetMaterial> GetAllTargetMaterials() { using (var db = new TSPDSContext()) { var query = from b in db.TargetMaterial select b; if (query.Any()) { return query.ToList(); } return new List<TargetMaterial>(); } }