public void Add(BusinessObjects.GroupRelation entity)
{
//Add GroupRelation
using (_GroupRelationRepository = new GenericRepository<DAL.DataEntities.GroupRelation>())
{
_GroupRelationRepository.Add((DAL.DataEntities.GroupRelation)entity.InnerEntity);
_GroupRelationRepository.SaveChanges();
}
//Add GroupRelations_To_Features
using (_GroupRelationsToFeaturesRepository = new GenericRepository<DAL.DataEntities.GroupRelation_To_Feature>())
{
foreach (int childFeatureID in entity.ChildFeatureIDs)
{
DAL.DataEntities.GroupRelation_To_Feature grToFeature = new DAL.DataEntities.GroupRelation_To_Feature();
grToFeature.GroupRelationID = entity.ID;
grToFeature.ParentFeatureID = entity.ParentFeatureID;
grToFeature.ChildFeatureID = childFeatureID;
_GroupRelationsToFeaturesRepository.Add(grToFeature);
}
_GroupRelationsToFeaturesRepository.SaveChanges();
}
}
public void Add(BusinessObjects.FeatureSelection entity)
{
using (_FeatureSelectionRepository = new GenericRepository<DAL.DataEntities.FeatureSelection>())
{
//Add the FeatureSelection
_FeatureSelectionRepository.Add((DAL.DataEntities.FeatureSelection)entity.InnerEntity);
_FeatureSelectionRepository.SaveChanges();
//Add AttributeValues
using (_AttributeValuesRepository = new GenericRepository<DAL.DataEntities.AttributeValue>())
{
for (int i = entity.AttributeValues.Count - 1; i >= 0; i--)
{
BLL.BusinessObjects.AttributeValue BLLAttributeValue = entity.AttributeValues[i];
BLLAttributeValue.FeatureSelectionID = entity.ID;
//Add
if (BLLAttributeValue.ToBeDeleted == false && BLLAttributeValue.ID == 0)
{
_AttributeValuesRepository.Add((DAL.DataEntities.AttributeValue)BLLAttributeValue.InnerEntity);
}
}
_AttributeValuesRepository.SaveChanges();
}
}
}
private void DropFileInCategory(object sender, DragEventArgs e)
{
ImageService imgService = new ImageService();
string[] fileList = e.Data.GetData(DataFormats.FileDrop) as string[];
string fileextension = Path.GetExtension(fileList[0]);
if (fileextension != ".pdf")
{
MessageBox.Show("Not allowed Drag'n'Drop for this file type");
}
else
{
string filename = Path.GetFileNameWithoutExtension(fileList[0]);
string pathtofile = Path.GetFullPath(fileList[0]);
string pathtobookimage = imgService.GenerateImage(pathtofile);
FileInfo fileToAdd = new FileInfo(pathtofile);
int size = (int)fileToAdd.Length;
var book = new Book()
{
Name = filename,
FileType = fileextension,
Path = pathtofile,
PathToBookImg = pathtobookimage,
Author = "Unknown Author",
Size = size
};
Debug.WriteLine(book.Name);
_categoriesRepository = IoCManager.Kernel.Get<IRepository<Category>>();
var concreteCategory = _categoriesRepository.GetByQery(q => q.Name == "Foreign Literature");
concreteCategory.FirstOrDefault().Books.Add(book);
_categoriesRepository.SaveChanges();
MessageBox.Show("Book was added");
}
}
public void Add(BusinessObjects.CustomRule entity)
{
using (_CustomRuleRepository = new GenericRepository<DAL.DataEntities.CustomRule>())
{
_CustomRuleRepository.Add((DAL.DataEntities.CustomRule)entity.InnerEntity);
_CustomRuleRepository.SaveChanges();
}
}
public void Add(BusinessObjects.Model entity)
{
using (_ModelRepository = new GenericRepository<DAL.DataEntities.Model>())
{
_ModelRepository.Add((DAL.DataEntities.Model)entity.InnerEntity);
_ModelRepository.SaveChanges();
}
}
public void Add(BusinessObjects.Constraint entity)
{
using (_ConstraintRepository = new GenericRepository<DAL.DataEntities.Constraint>())
{
_ConstraintRepository.Add((DAL.DataEntities.Constraint)entity.InnerEntity);
_ConstraintRepository.SaveChanges();
}
}
public void Add(BLL.BusinessObjects.UITemplate entity)
{
using (_UITemplateRepository = new GenericRepository<DAL.DataEntities.UITemplate>())
{
_UITemplateRepository.Add((DAL.DataEntities.UITemplate)entity.InnerEntity);
_UITemplateRepository.SaveChanges();
}
}
public void Add(BusinessObjects.Relation entity)
{
using (_RelationRepository = new GenericRepository<DAL.DataEntities.Relation>())
{
_RelationRepository.Add((DAL.DataEntities.Relation)entity.InnerEntity);
_RelationRepository.SaveChanges();
}
}
public void Add(BusinessObjects.Feature entity)
{
using (_FeatureRepository = new GenericRepository<DAL.DataEntities.Feature>())
{
//Add the Feature
_FeatureRepository.Add((DAL.DataEntities.Feature)entity.InnerEntity);
_FeatureRepository.SaveChanges();
}
}
public void Add(BusinessObjects.Attribute entity)
{
using (_AttributeRepository = new GenericRepository<DAL.DataEntities.Attribute>())
{
//Add the Attribute
_AttributeRepository.Add((DAL.DataEntities.Attribute)entity.InnerEntity);
_AttributeRepository.SaveChanges();
}
}
public void Delete(int id)
{
DAL.DataEntities.Configuration DALConfiguration;
using (_ConfigurationRepository = new GenericRepository<DAL.DataEntities.Configuration>())
{
DALConfiguration = _ConfigurationRepository.SingleOrDefault(m => m.ID == id);
_ConfigurationRepository.Delete(DALConfiguration);
_ConfigurationRepository.SaveChanges();
}
}
public void Delete(int id)
{
DAL.DataEntities.Model model;
using (_ModelRepository = new GenericRepository<DAL.DataEntities.Model>())
{
model = _ModelRepository.SingleOrDefault(m => m.ID == id);
_ModelRepository.Delete(model);
_ModelRepository.SaveChanges();
}
}
public void Delete(int id)
{
DAL.DataEntities.UITemplate template;
using (_UITemplateRepository = new GenericRepository<DAL.DataEntities.UITemplate>())
{
template = _UITemplateRepository.SingleOrDefault(m => m.ID == id);
_UITemplateRepository.Delete(template);
_UITemplateRepository.SaveChanges();
}
}
private static void EnsureMember(IRepository<Member> memberRepository)
{
if (!memberRepository.GetAll().Any(m => m.Name == "Sherlock Holmes"))
{
memberRepository.Add(new Member
{
Name = "Sherlock Holmes"
});
memberRepository.SaveChanges();
}
}
private static void EnsureProduct(Rebate rebate, IRepository<Product> productRepository)
{
if (!productRepository.GetAll().Any(p => p.ProductNumber == 11190))
{
productRepository.Add(new Product
{
ProductNumber = 11190,
Name = "Procrit",
Rebate = rebate
});
productRepository.SaveChanges();
}
}
private static Rebate EnsureRebate(IRepository<Rebate> rebateRepository)
{
Rebate rebate = rebateRepository.GetAll().FirstOrDefault(r => r.Name == "Procrit Rebate");
if (rebate == null)
{
rebate = rebateRepository.Add(new Rebate
{
Name = "Procrit Rebate"
});
rebateRepository.SaveChanges();
}
return rebate;
}
public void MyTestInitialize()
{
var context = GetProfileContext();
ContextSession.Current = context;
//CallContext.SetData(ServiceContextManager<ServiceContext>.SESSIONCOTEXTKEY, context);
_repository = RepositoryContext.GetRepository();
//清理垃圾数据
var rubbish = _repository.GetAll<Category>();
if (rubbish == null || rubbish.Count() <= 0) return;
foreach (var item in rubbish)
this._repository.Remove(item);
_repository.SaveChanges();
}
public static ApplicationSetting AddTo(this ApplicationSetting item, IRepository repository)
{
repository.Add(item);
repository.SaveChanges();
return item;
}
public void MyTestInitialize()
{
ObjectContext edmContext = new DemoEntities();
_repository = EDMRepositoryContext.GetCurrentContext(edmContext).GetRepository<SysParam>();
//清理垃圾数据
var rubbish = _repository.GetFilteredElements(x => x.sysparamName.StartsWith("ParamName"));
if (rubbish == null || rubbish.Count() <= 0) return;
foreach (var item in rubbish)
this._repository.Remove(item);
_repository.SaveChanges();
}
public void UpdateName(int modelID, string newName)
{
using (_ModelRepository = new GenericRepository<DAL.DataEntities.Model>())
{
DAL.DataEntities.Model model = _ModelRepository.SingleOrDefault(m => m.ID == modelID);
model.LastModifiedDate = DateTime.Now;
model.Name = newName;
//_ModelRepository.Attach(model);
_ModelRepository.SaveChanges();
}
}
internal static void SeedData(IRepository repository)
{
Console.WriteLine("Seeding data...");
// Seed Persons
var persons = new List<Person>
{
new Person {FirstName = "Arthur", LastName = "Smith", Gender = "M"},
new Person {FirstName = "Bert", LastName = "Jones", Gender = "M"},
new Person {FirstName = "Charlie", LastName = "Robertson", Gender = "M"}
};
persons.ForEach(p => repository.Insert(p));
// Seed Regions
var regions = new List<Region>
{
new Region {Name = "Banff National Park - South", Description = "Banff National Park"},
new Region {Name = "Jasper National Park"},
new Region {Name = "Kootenay National Park"},
new Region {Name = "Banff National Park - North"},
new Region {Name = "Kananaskis Country"}
};
regions.ForEach(r => repository.Insert(r));
// Seed Locations
var locations = new List<Location>
{
new Location
{
Name = "Bow Valley Parkway",
Description = "Road from Banff to Lake Louise",
Directions = "Turn left off main highway 2km north of Banff",
Region = regions[0]
},
new Location {Name = "Banff Townsite area", Region = regions[0]},
new Location
{
Name = "Bow Lake area",
Description = "20 minutes north of Lake Louise on IceField Parkway",
Region = regions[3]
},
new Location {Name = "Smith Dorrien Highway", Region = regions[4]}
};
locations.ForEach(l => repository.Insert(l));
// Seed Difficulty Levels
var difficulties = new List<Difficulty>
{
new Difficulty {DifficultyType = "Easy"},
new Difficulty {DifficultyType = "Moderate"},
new Difficulty {DifficultyType = "Challenging"},
new Difficulty {DifficultyType = "Difficult"}
};
difficulties.ForEach(d => repository.Insert(d));
// Seed TrailType Levels
var trailTypes = new List<TrailType>
{
new TrailType {TrailTypeName = "Land"},
new TrailType {TrailTypeName = "Air"},
new TrailType {TrailTypeName = "Water"}
};
trailTypes.ForEach(t => repository.Insert(t));
// Seed TransportType Levels
var transportTypes = new List<TransportType>
{
new TransportType {TransportTypeName = "Hike"},
new TransportType {TransportTypeName = "Cycle"},
new TransportType {TransportTypeName = "Canoe"},
new TransportType {TransportTypeName = "Ski"},
new TransportType {TransportTypeName = "Snowshoe"},
new TransportType {TransportTypeName = "Aeroplane"}
};
transportTypes.ForEach(t => repository.Insert(t));
// Seed Trails
var trails = new List<Trail>
{
new Trail
{
Name = "Johnstone Canyon",
Description = "Johnstone Canyon",
Distance = 4.8M,
ElevationGain = 200,
EstimatedTime = 2,
Location = locations[0],
TrailType = trailTypes[0],
Difficulty = difficulties[0],
ReturnOnEffort = 9.2M,
OverallGrade = 7.2M,
Notes =
"Good Waterfalls scenery. Good in all seasons. Take crampons in winter/spring",
Longitude = -102,
Latitude = 50
},
new Trail
{
Name = "Burstall Pass",
Description = "Burstall Pass",
Distance = 8.53M,
ElevationGain = 390,
EstimatedTime = 4,
Location = locations[1],
TrailType = trailTypes[0],
Difficulty = difficulties[0],
ReturnOnEffort = 8.1M,
OverallGrade = 8.1M,
Notes = "Excellent view from the pass"
},
new Trail
{
Name = "Helen Lake",
Description = "Helen Lake",
Distance = 8M,
ElevationGain = 480,
EstimatedTime = 4.5M,
Location = locations[2],
TrailType = trailTypes[0],
Difficulty = difficulties[3],
ReturnOnEffort = 7.8M,
OverallGrade = 7.8M,
Notes = "Views across to the Dolomite range."
},
new Trail
{
Name = "Chester Lake",
Description = "Chester Lake",
Distance = 8.11M,
ElevationGain = 520,
EstimatedTime = 4.5M,
Location = locations[2],
TrailType = trailTypes[0],
Difficulty = difficulties[1],
ReturnOnEffort = 6.9M,
OverallGrade = 6.9M,
Notes = "Don't stop at Chester Lake - go on to Three Lake Valley"
}
};
trails.ForEach(t => repository.Insert(t));
// Seed Trips
var trips = new List<Trip>
{
new Trip
{
Date = new DateTime(2001, 9, 1),
TransportType = transportTypes[0],
Trail = trails[0],
Weather = "Cloudy",
TimeTaken = 3.3M,
Notes = "Very slippery - cramps needed.",
Persons = new List<Person>
{
persons[0], persons[1],persons[2]
}
},
new Trip
{
Date = new DateTime(2004, 7, 31),
TransportType = transportTypes[1],
Trail = trails[0],
Weather = "Sunny",
TimeTaken = 2.3M,
Notes = "First time on this trail."
}
};
trips.ForEach(t => repository.Insert(t));
repository.SaveChanges();
}
public void Delete(int id)
{
DAL.DataEntities.Attribute attribute;
using (_AttributeRepository = new GenericRepository<DAL.DataEntities.Attribute>())
{
attribute = _AttributeRepository.SingleOrDefault(m => m.ID == id);
_AttributeRepository.Delete(attribute);
_AttributeRepository.SaveChanges();
}
}
public void Update(BusinessObjects.Model entity)
{
using (_ModelRepository = new GenericRepository<DAL.DataEntities.Model>())
{
entity.LastModifiedDate = DateTime.Now;
//
_ModelRepository.Attach((DAL.DataEntities.Model)entity.InnerEntity);
_ModelRepository.SaveChanges();
}
}
private static void SeedNews(IRepository<News> repository)
{
var newsList = ListOfNews;
foreach (var news in newsList)
{
repository.Add(news);
}
repository.SaveChanges();
}
private static void ClearDatabase(IRepository<News> repository)
{
foreach (var news in repository.All())
{
repository.Delete(news.Id);
}
repository.SaveChanges();
}
public void Update(BusinessObjects.Configuration entity)
{
using (_ConfigurationRepository = new GenericRepository<DAL.DataEntities.Configuration>())
{
entity.LastModifiedDate = DateTime.Now;
//
_ConfigurationRepository.Attach((DAL.DataEntities.Configuration)entity.InnerEntity);
_ConfigurationRepository.SaveChanges();
}
}
public void UpdateName(int configurationID, string newName)
{
using (_ConfigurationRepository = new GenericRepository<DAL.DataEntities.Configuration>())
{
DAL.DataEntities.Configuration model = _ConfigurationRepository.SingleOrDefault(m => m.ID == configurationID);
model.LastModifiedDate = DateTime.Now;
model.Name = newName;
_ConfigurationRepository.SaveChanges();
}
}
public void Delete(int id)
{
DAL.DataEntities.CustomRule customRule;
using (_CustomRuleRepository = new GenericRepository<DAL.DataEntities.CustomRule>())
{
customRule = _CustomRuleRepository.SingleOrDefault(m => m.ID == id);
_CustomRuleRepository.Delete(customRule);
_CustomRuleRepository.SaveChanges();
}
}
public void Delete(int id)
{
DAL.DataEntities.Feature feature;
using (_FeatureRepository = new GenericRepository<DAL.DataEntities.Feature>())
{
feature = _FeatureRepository.SingleOrDefault(m => m.ID == id);
//Cascade delete on all related FeatureSelections
using (_FeatureSelectionRepository = new GenericRepository<DAL.DataEntities.FeatureSelection>())
{
IEnumerable<DAL.DataEntities.FeatureSelection> featureSelections = _FeatureSelectionRepository.Find(k => k.FeatureID == feature.ID);
foreach (DAL.DataEntities.FeatureSelection featureSelection in featureSelections)
{
_FeatureSelectionRepository.Delete(featureSelection);
}
_FeatureSelectionRepository.SaveChanges();
}
//
_FeatureRepository.Delete(feature);
_FeatureRepository.SaveChanges();
}
}
public void Delete(int id)
{
DAL.DataEntities.Relation relation;
using (_RelationRepository = new GenericRepository<DAL.DataEntities.Relation>())
{
relation = _RelationRepository.SingleOrDefault(m => m.ID == id);
_RelationRepository.Delete(relation);
_RelationRepository.SaveChanges();
}
}
