public override List <Material> GetList()
{
List <Material> list = null;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
list = _uow.MaterialRepository.GetAll().ToList();
if (list != null)
{
foreach (Material item in list)
{
// get data of inside class
item.Group = _uow.MaterialGroupRepository.GetById(item.GroupId);
item.Unit = _uow.UnitRepository.GetById(item.UnitId);
//item.Unit.MarkOld();
//item.Group.MarkOld();
item.MarkOld();
}
}
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(list);
}
public override bool Update(User item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
bool result = false;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
_uow.UserRepository.Update(item);
_uow.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(result);
}
public override List <OrderItem> GetList()
{
List <OrderItem> list = null;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
list = _uow.OrderItemRepository.GetBy(o => o.IsAlwaysReady == false).ToList();
if (list != null)
{
foreach (OrderItem item in list)
{
item.ProductInfo = _uow.ProductRepository.GetById(item.ProductId);
//item.Location.MarkOld();
item.MarkOld();
}
}
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(list);
}
public List <Table> GetFreeTables()
{
List <Table> list = null;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
list = _uow.TableRepository.GetBy(o => o.State == TableState.Free).ToList();
//list = _uow.TableRepository.GetBy(o => o.State == 0).ToList();
/*if (list != null)
* {
* foreach (Table item in list)
* {
* item.Location = _uow.AreaRepository.GetById(item.LocationId);
* item.Location.MarkOld();
* item.MarkOld();
* }
* }*/
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(list);
}
public Material GetById(int id)
{
Material item = null;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
item = _uow.MaterialRepository.GetById(id);
if (item != null)
{
item.Group = _uow.MaterialGroupRepository.GetById(item.GroupId);
item.Unit = _uow.UnitRepository.GetById(item.UnitId);
//item.Unit.MarkOld();
//item.Group.MarkOld();
item.MarkOld();
}
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(item);
}
public Table GetById(int id)
{
Table item = null;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
item = _uow.TableRepository.GetById(id);
if (item != null)
{
// get data of inside class
item.Location = _uow.AreaRepository.GetById(item.LocationId);
item.Location.MarkOld();
item.MarkOld();
}
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(item);
}
public TopicsController()
{
var rf = new RepositoryFactories();
var rp = new RepositoryProvider(rf);
uow = new DTUoW(rp);
}
public override ReportOrderItemEdition GetByKey(ReportOrderItemEdition itemWithKeys)
{
ReportOrderItemEdition item = null;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
item = _uow.ReportOrderItemEditionRepository
.GetBy(o => o.ReportCounter == itemWithKeys.ReportCounter &&
o.EditionCounter == itemWithKeys.EditionCounter &&
o.Sequence == itemWithKeys.Sequence)
.FirstOrDefault();
if (item != null)
{
// get data of inside class
item.OrderEdition = _uow.ReportOrderEditionRepository
.GetBy(o => o.ReportCounter == item.ReportCounter && o.EditionCounter == item.EditionCounter)
.FirstOrDefault();;
item.MarkOld();
}
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(item);
}
public void SetOutOfKitchenProcess(OrderItem item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
// get order item
OrderItem orderItem = _uow.OrderItemRepository.GetBy(o => o.OrderId == item.OrderId && o.Sequence == item.Sequence).FirstOrDefault();
orderItem.IsKitchenProcessCompleted = true;
_uow.OrderItemRepository.Update(orderItem);
// commit
_uow.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
}
public void Unlock(Order item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
// get order
Order order = _uow.OrderRepository.GetById(item.Id);
order.LockState = false;
_uow.OrderRepository.Update(order);
// commit
_uow.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
}
public override OrderItem GetByKey(OrderItem itemWithKeys)
{
OrderItem item = null;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
item = _uow.OrderItemRepository
.GetBy(o => o.OrderId == itemWithKeys.OrderId &&
o.Sequence == itemWithKeys.Sequence)
.FirstOrDefault();
if (item != null)
{
// get data of inside class
item.ProductInfo = _uow.ProductRepository.GetById(item.ProductId);
//item.Location.MarkOld();
item.MarkOld();
}
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(item);
}
public override List <Order> GetList()
{
List <Order> list = null;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
//list = _uow.OrderRepository.GetAll().ToList();
list = _uow.OrderRepository.GetBy(o => o.State < OrderState.Finished && o.IsCancelled != true).ToList();
if (list != null)
{
foreach (Order item in list)
{
item.Table = _uow.TableRepository.GetById(item.TableId);
item.CreatorUser = _uow.UserRepository.GetById(item.CreatorId);
item.LockKeeper = _uow.UserRepository.GetById(item.LockKeeperId);
item.MarkOld();
}
}
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(list);
}
static void Main(string[] args)
{
var details = new Details();
var books = details.FindBookByIsbn("1451648553");
Database.SetInitializer(
new DropCreateDatabaseAlways<ReadgressDbContext>());
//Database.SetInitializer<ReadgressDbContext>(null);
var factories = new RepositoryFactories();
var repoistoryProvider = new RepositoryProvider(factories);
//var readgressUow = new ReadgressUow(repoistoryProvider);
using (var context = new ReadgressUow(repoistoryProvider))
//using (var context = new ReadgressDbContext())
{
//var progess = context.Progresses.GetById(1);
//progess.Bookmarks.Add(new Bookmark() { PageNumber = 30, CreatedOn = DateTime.Now });
//context.Progresses.Update(progess);
//context.Commit();
var reader = context.Readers.GetAll().First();
var progress = context.Progresses.GetByReaderId(1);
var bookmark = context.Bookmarks.GetAll();
Console.WriteLine(reader.FullName);
}
Console.WriteLine("Done");
}
public override bool Create(Product item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
bool result = false;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
Product resultItem = _uow.ProductRepository.Add(item);
foreach (RecipeItem recipeItem in item.Recipes)
{
// assign product id
recipeItem.ProductId = item.Id;
_uow.RecipeItemRepository.Add(recipeItem);
}
_uow.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(result);
}
public void TestService_Can_GetNextQuestion()
{
//Arrange
//Constructor args ICareUow uow, TestLogicFactory factory, IQuestionGenerator questionGenerator
//Method args Test test, Question prevQuestion
RepositoryFactories factory = new RepositoryFactories();
RepositoryProvider provider = new RepositoryProvider(factory);
CareUow uow = new CareUow(provider);
TestLogicFactory tFactory = new TestLogicFactory();
QuestionGenerator qGenerator = new QuestionGenerator(uow);
//TestService target = new TestService(uow, tFactory, qGenerator);
TestService target = new TestService(uow, tFactory);
Question q = new Question();
q.Id = 1;
Test t = new Test();
t.Type = "sysr";
t.Id = 1;
//Act
Question next = target.GetNextQuestion(t, q);
//Assert
Assert.IsNotNull(next);
Assert.AreEqual(next.Id, 2);
}
public override List <ProductGroup> GetList()
{
List <ProductGroup> list = null;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
list = _uow.ProductGroupRepository.GetAll().ToList();
if (list != null)
{
foreach (ProductGroup item in list)
{
item.MarkOld();
}
}
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(list);
}
public override List <User> GetList()
{
List <User> list = null;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
list = _uow.UserRepository.GetAll().ToList();
if (list != null)
{
foreach (User item in list)
{
item.Role = _uow.UserRoleRepository.GetBy(o => o.Id == item.RoleId).FirstOrDefault();
item.MarkOld();
}
}
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(list);
}
public static IToDoUnitOfWork Create()
{
var repositoryFactories = new RepositoryFactories(CustomFactories);
var repositoryProvider = new RepositoryProvider(repositoryFactories);
var contextFactory = new ToDoDbContextFactory();
return(new ToDoUnitOfWork(repositoryProvider, contextFactory));
}
public void CanGetAFactoryThatWillCreateARepositoryForAnEntityClass()
{
IRepositoryFactories repoFactories = new RepositoryFactories();
var factory = repoFactories.GetRepositoryFactoryForEntityType <Person>();
Assert.IsNotNull(factory);
}
public static IUnitOfWork Create()
{
var factories = new RepositoryFactories();
var provider = new RepositoryProvider(factories);
IUnitOfWork uow = new UnitOfWork(provider);
return uow;
}
public static IUnitOfWork Create()
{
var factories = new RepositoryFactories();
var provider = new RepositoryProvider(factories);
IUnitOfWork uow = new UnitOfWork(provider);
return(uow);
}
public DTView()
{
InitializeComponent();
var rf = new RepositoryFactories();
var rp = new RepositoryProvider(rf);
var uow = new DTUoW(rp);
DataContext = new DTViewModel(uow);
}
public void FetchOrderItems(Order item)
{
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
if (item != null)
{
// get order items
decimal subTotalPrice = 0;
using (BypassPropertyChecks(item))
{
var obj = (OrderItemList)MethodCaller.CreateInstance(typeof(OrderItemList));
//var obj = (OrderItemList) DataPortal.CreateChild<OrderItemList>();
MarkAsChild(obj);
var rlce = obj.RaiseListChangedEvents;
obj.RaiseListChangedEvents = false;
List <OrderItem> itemList = _uow.OrderItemRepository.GetBy(o => o.OrderId == item.Id).ToList();
// get material info of each orderItem item
foreach (OrderItem detail in itemList)
{
detail.ProductInfo = _uow.ProductRepository.GetById(detail.ProductId);
detail.ProductInfo.Unit = _uow.UnitRepository.GetById(detail.ProductInfo.UnitId);
detail.SetOldQuantity();
detail.EdittedQuantity = 0;
MarkOld(detail);
MarkAsChild(detail);
obj.Add(detail);
//item.Recipes.Add(detail);
if (detail.IsCancelled != true)
{
subTotalPrice += detail.ItemPrice;
}
}
obj.RaiseListChangedEvents = rlce;
LoadProperty(item, Order.OrderItemsProperty, obj);
//MarkAsChild(item.Recipes);
}
item.SubTotalPrice = subTotalPrice;
/*item.VatPrice = item.VatEnable ? (item.SubTotalPrice * 10 / 100) : 0;
* item.DiscountPrice = (-1) * (item.SubTotalPrice * item.DiscountPercent / 100);
* item.TotalPrice = item.SubTotalPrice + item.VatPrice + item.DiscountPrice + item.SpecialDiscount + item.ServiceCharge;
* item.Change = item.Cash - item.TotalPrice;*/
item.MarkOld();
}
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
}
public DTView()
{
InitializeComponent();
var rf = new RepositoryFactories();
var rp = new RepositoryProvider(rf);
var uow = new DTUoW(rp);
DataContext = new DTViewModel(uow);
}
public void CanGetAFactoryThatCanThenBeUsedToCreateARepositoryForAnEntityClass()
{
IRepositoryFactories repoFactories = new RepositoryFactories();
var repoFactory = repoFactories.GetRepositoryFactoryForEntityType <Person>();
var repositoryObject = repoFactory(new DbContext("Test"));
var repository = repositoryObject as IRepository <Person>;
Assert.IsNotNull(repository);
}
public void Setup()
{
this.Factories = new RepositoryFactories(this.Dbs.Object);
this.Dbs.Object.Add(new KeyValuePair <Type, Func <DbContext, object> >(typeof(IPersonsRepository),
dbContext => new PersonsRepository(dbContext)));
this.Dbs.Object.Add(new KeyValuePair <Type, Func <DbContext, object> > (typeof(IAgeGroupsRepository),
dbContext => new AgeGroupsRepository(dbContext)));
this.Dbs.Setup(s => s.TryGetValue(typeof(IPersonsRepository), out this.PersonRespository));
this.Dbs.Setup(s => s.TryGetValue(typeof(IAgeGroupsRepository), out this.AgeGroupRepository));
}
public CarsController(IJsonDataService service = null)
{
var dataProvider = ConfigurationManager.AppSettings["DataProvier"];
if (dataProvider.ToUpper() == DataProvier.JSON.ToString())
{
var carRepository = RepositoryFactories.GetRepositoryFactory(dataProvider, service).CarRepository;
_service = new CarSaleService(carRepository);
}
else
{
throw new Exception($"The data provide {dataProvider} has not been implemented");
}
}
public void CanProvideADictionaryOfBespokeFactoriesAndThenUseABespokeFactoryToGetARepository()
{
var factories = new Dictionary <Type, Func <DbContext, object> >
{
{ typeof(Person), dbContext => new PersonRepository(dbContext) }
};
IRepositoryFactories repoFactories = new RepositoryFactories(factories);
var repoFactory = repoFactories.GetRepositoryFactoryForEntityType <Person>();
var repository = repoFactory(new DbContext("Test")) as PersonRepository;
Assert.IsNotNull(repository);
}
public void Db_context_save_changes_is_called_on_commit()
{
var mockContext = new Mock<JetNettApiDbContext>();
var repoFactories = new RepositoryFactories();
var repoProvider = new RepositoryProvider(null);
var uow = new JetNettApiUow(repoProvider, mockContext.Object);
uow.Commit();
mockContext.Verify(x => x.SaveChanges());
}
public Product GetById(int id)
{
Product item = null;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
item = _uow.ProductRepository.GetById(id);
if (item != null)
{
item.Group = _uow.ProductGroupRepository.GetById(item.GroupId);
item.Unit = _uow.UnitRepository.GetById(item.UnitId);
item.Unit.MarkOld();
item.Group.MarkOld();
// get recipes
List <RecipeItem> itemList = _uow.RecipeItemRepository.GetBy(o => o.ProductId == item.Id).ToList();
// get material info of each recipe item
foreach (RecipeItem detail in itemList)
{
//RecipeItem newRecipeItem = item.Recipes.AddNew();
//RecipeItem newRecipeItem = RecipeItem.NewObject();
//newRecipeItem.MarkAsChild();
/*newRecipeItem.Sequence = detail.Sequence;
* newRecipeItem.ProductId = detail.ProductId;
* newRecipeItem.MaterialId = detail.MaterialId;
* newRecipeItem.UsedAmount = detail.UsedAmount;
* newRecipeItem.MaterialInfo = _uow.MaterialRepository.GetById(newRecipeItem.MaterialId);
* newRecipeItem.MaterialInfo.Unit = _uow.UnitRepository.GetById(newRecipeItem.MaterialInfo.UnitId);*/
detail.MaterialInfo = _uow.MaterialRepository.GetById(detail.MaterialId);
detail.MaterialInfo.Unit = _uow.UnitRepository.GetById(detail.MaterialInfo.UnitId);
MarkOld(detail);
MarkAsChild(detail);
item.Recipes.Add(detail);
}
item.MarkOld();
}
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(item);
}
public void TestFactory()
{
IRepositoryFactory factory;
Assert.IsNotNull(RepositoryFactories.Factory("Default"), "Default factory is not null");
Assert.IsInstanceOfType(typeof(IRepositoryFactory),
RepositoryFactories.Factory("Default"),
"Correct type");
factory = RepositoryFactories.Factory("Default");
Assert.AreEqual("Server=localhost;User=root",
((DatabaseRepositoryFactory)factory).ConnectionString,
"Correct connection string");
}
private void DoDataWork(Action <ISimpleCrmUow> operation, bool withAutoCommit = true)
{
var factories = new RepositoryFactories();
IRepositoryProvider provider = new RepositoryProvider(factories);
using (ISimpleCrmUow uow = new SimpleCrmUow(provider))
{
operation(uow);
if (withAutoCommit)
{
uow.Commit();
}
}
}
public override bool Update(Product item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
bool result = false;
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
_uow.ProductRepository.Update(item);
// process deleted list first
foreach (RecipeItem recipeItem in (List <RecipeItem>)(item.Recipes as IEditableCollection).GetDeletedList())
{
if (!recipeItem.IsNew)
{
_uow.RecipeItemRepository.Remove(recipeItem);
}
}
foreach (RecipeItem recipeItem in item.Recipes)
{
// assign product id
if (!recipeItem.IsNew)
{
if (recipeItem.IsDirty)
{
_uow.RecipeItemRepository.Update(recipeItem);
}
}
else
{
_uow.RecipeItemRepository.Add(recipeItem);
}
}
_uow.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
return(result);
}
/// <summary>
/// Print the order
/// </summary>
/// <param name="actor"></param>
/// <param name="item"></param>
public void UpdatePrintCount(User actor, Order item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
try
{
using (XRMSEntities context = new XRMSEntities())
{
_uow = new UnitOfWork(context, new RepositoryProvider(RepositoryFactories.Instance()));
Order order = _uow.OrderRepository.GetById(item.Id);
if (order.State > OrderState.Printed)
{
// update order
order.PrintCount++;
}
else
{
order.State = OrderState.Printed;
order.PrintCount++;
}
_uow.OrderRepository.Update(order);
// get order report, useful for writing report
ReportOrder report = _uow.ReportOrderRepository.GetByOrderCode(item.Code);
// add event report
ReportEvent reportEvent1 = new ReportEvent();
reportEvent1.ReportCounter = report.ReportCounter;
reportEvent1.EventClass = 0;
reportEvent1.EventDate = _uow.GetDbCurrentDatetime();
reportEvent1.Text = actor.Fullname + " printed order " + item.Code + " for table \"" + item.Table.Name + "\"";
reportEvent1 = _uow.ReportEventRepository.Add(reportEvent1);
// commit
_uow.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(this.GetType().FullName + System.Reflection.MethodBase.GetCurrentMethod().Name + ": " + ex.Message);
}
}
public void Setup()
{
//create repoFactoriesObject
_rf = new RepositoryFactories();
_mockDbContext = new Mock<JetNettApiDbContext>();
}
public TopicsController()
{
var rf = new RepositoryFactories();
var rp = new RepositoryProvider(rf);
uow = new DTUoW(rp);
}
public void Initialize()
{
factory = new RepositoryFactories();
provider = new RepositoryProvider(factory);
uow = new UnitOfWork(provider);
}