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(); } }
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(); } }
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 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 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 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 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 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 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 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(); } }
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(); } }