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