public void SqlServerInsertQuery_ShouldGenQuery() { // Arrange var command = new System.Data.SqlClient.SqlCommand(); ColumnMapCollection columns = MapRepository.Instance.GetColumns(typeof(Person)); MappingHelper mappingHelper = new MappingHelper(command); Person person = new Person(); person.ID = 1; person.Name = "Jordan"; person.Age = 33; person.IsHappy = true; person.BirthDate = new DateTime(1977, 1, 22); mappingHelper.CreateParameters<Person>(person, columns, false, true); IQuery query = new SqlServerInsertQuery(columns, command, "dbo.People"); // Act string queryText = query.Generate(); // Assert Assert.IsNotNull(queryText); Assert.IsTrue(queryText.Contains("INSERT INTO dbo.People")); Assert.IsFalse(queryText.Contains("[ID]"), "Should not contain [ID] column since it is marked as AutoIncrement"); Assert.IsTrue(queryText.Contains("[Name]"), "Should contain the name column"); }
/// <summary> /// Creates the NHibernare session factory. /// </summary> private void CreateNHibernateSessionFactory() { if (DefaultSessionFactory == null) { var mappingHelper = new MappingHelper<ApplicationUser, string, ApplicationLogin, ApplicationRole, string, ApplicationClaim, int>(); _configuration.AddMapping(mappingHelper.GetMappingsToMatchEfIdentity()); DefaultSessionFactory = _configuration.BuildSessionFactory(); } }
private void btnModify_Click(object sender, EventArgs e) { int emplpyeeId = Convert.ToInt32(dgvEmployees.CurrentRow.Cells["colId"].Value); int selectedRowIndex = dgvEmployees.CurrentRow.Index; EmployeeEditForm frm = new EmployeeEditForm(emplpyeeId); frm.ReloadEmployees += (s, ea) => { EmployeeEventArgs eventArgs = ea as EmployeeEventArgs; if (eventArgs != null) { EmployeeViewModel employee = MappingHelper.MapEmployeeModelToEmployeeViewModel(eventArgs.Employee); bsEmployees[selectedRowIndex] = employee; } }; frm.ShowDialog(); }
private void btnCreate_Click(object sender, EventArgs e) { DepartmentAddForm frm = new DepartmentAddForm(); frm.ReloadDepartment += (s, ea) => { DepartmentsEventArgs eventArgs = ea as DepartmentsEventArgs; if (eventArgs != null) { DepartmentViewModel department = MappingHelper.MapDepartmentModelToDepartmentViewModel(eventArgs.department); bsDepartment.Add(department); dgvDepartments.ClearSelection(); dgvDepartments.Rows[dgvDepartments.Rows.Count - 1].Selected = true; } }; frm.ShowDialog(); }
public SnapshotPoint?GetTriggerPoint(ITextSnapshot textSnapshot) { var triggerSnapshotPoint = this.triggerPoint.GetPoint(this.TextView.TextSnapshot); var triggerSpan = new SnapshotSpan(triggerSnapshotPoint, 0); var mappedSpans = new FrugalList <SnapshotSpan>(); MappingHelper.MapDownToBufferNoTrack(triggerSpan, textSnapshot.TextBuffer, mappedSpans); if (mappedSpans.Count == 0) { return(null); } else { return(mappedSpans[0].Start); } }
//-> GetLineItems private async Task <List <SaleOrderItemViewDTO> > GetLineItems(int masterID) { var items = new List <SaleOrderItemViewDTO>(); IQueryable <tblSaleOrderItem> records = from x in db.tblSaleOrderItems where x.deleted == null && x.saleOrderID == masterID orderby x.id ascending select x; var listing = await records.ToListAsync(); foreach (var item in listing) { var mappingDTO = MappingHelper.MapDBClassToDTO <tblSaleOrderItem, SaleOrderItemViewDTO>(item); mappingDTO.item = await(new ItemHandler().SelectByID(int.Parse(item.itemID.ToString()))); items.Add(mappingDTO); } return(items); }
public static ISession getSession(string connectionString) { var myEntities = new[] { typeof(UserEntity), typeof(Role) }; ISessionFactory sessionFactory = Fluently.Configure() .Database(MsSqlConfiguration.MsSql2008.ConnectionString(connectionString) .ShowSql()) .Mappings(m => m.FluentMappings.AddFromAssemblyOf <Position>()) .ExposeConfiguration(cfg => { cfg.AddDeserializedMapping( MappingHelper.GetIdentityMappings(myEntities), null); new SchemaUpdate(cfg).Execute(false, true); }) .BuildSessionFactory(); return(sessionFactory.OpenSession()); }
private void btnModify_Click(object sender, EventArgs e) { int positionId = Convert.ToInt32(dgvPositions.CurrentRow.Cells["colId"].Value); int selectedRowIndex = dgvPositions.CurrentRow.Index; PositionModifyForm frm = new PositionModifyForm(); frm.ReloadPositions += (s, ea) => { PositionsEventArgs eventArgs = ea as PositionsEventArgs; if (eventArgs != null) { PositionViewModel position = MappingHelper.MapPositionModelToPositionViewModel(eventArgs.position); bsPositions[selectedRowIndex] = position; } }; frm.ShowDialog(); }
public static void Configure(ISessionStorage storage) { var internalTypes = new[] { typeof(ApplicationUser), typeof(ApplicationRole) //typeof(ApplicationRoleGroup), //typeof(Group), //typeof(ApplicationUserGroup) //typeof(ApplicationPet) }; var mapping = MappingHelper.GetIdentityMappings(internalTypes); System.Diagnostics.Debug.WriteLine(mapping.AsString()); var configuration = NHibernateSession.Init(storage, mapping); //BuildSchema(configuration); }
private void btnCreate_Click(object sender, EventArgs e) { PositionAddForm frm = new PositionAddForm(); frm.ReloadPositions += (s, ea) => { PositionsEventArgs eventArgs = ea as PositionsEventArgs; if (eventArgs != null) { PositionViewModel position = MappingHelper.MapPositionModelToPositionViewModel(eventArgs.position); bsPositions.Add(position); dgvPositions.ClearSelection(); dgvPositions.Rows[dgvPositions.Rows.Count - 1].Selected = true; } }; frm.ShowDialog(); }
/// <summary> /// Получить список всех сущностей /// </summary> /// <returns></returns> public static List <T> GetAll() { List <T> result = new List <T>(); using (Database db = Database.CreateFirebirdDatabase()) { DbCommand command = db.GetCommandWhere <T>(); IDataReader reader = db.ExecuteReader(command); while (reader.Read()) { T entity = MappingHelper.GetEntity <T>(reader); result.Add(entity); } } return(result); }
private void btnCreate_Click(object sender, EventArgs e) { ContractAddForm frm = new ContractAddForm(); frm.ReloadContracts += (s, ea) => { ContractEventArgs eventArgs = ea as ContractEventArgs; if (eventArgs != null) { ContractViewModel contracts = MappingHelper.MapContractModelToContractViewModel(eventArgs.contract); bsContracts.Add(contracts); dgvContracts.ClearSelection(); dgvContracts.Rows[dgvContracts.Rows.Count - 1].Selected = true; } }; frm.ShowDialog(); }
public void TestMap_TestWmsIWB2IWB(ISession session) { var source = session.Query <WmsIWB>().First(i => i.IWBID == 7505); var target = MappingHelper.DynamicMap <IWB>(source); target.ID.ShouldBeEquivalentTo(source.IWBID); target.MandantCode.ShouldBeEquivalentTo(source.Partner.PartnerCode); target.Name.ShouldBeEquivalentTo(source.IWBName); target.Description.ShouldBeEquivalentTo(source.IWBDesc); target.Priority.ShouldBeEquivalentTo(source.IWBPriority); target.StatusCode.ShouldBeEquivalentTo(source.Status.StatusCode); target.InDatePlan.ShouldBeEquivalentTo(source.IWBInDatePlan); target.SenderHostRef.ShouldBeEquivalentTo(source.IWBSender?.PartnerHostRef); target.PayerHostRef.ShouldBeEquivalentTo(source.IWBPayer?.PartnerHostRef); target.Recipient.ShouldBeEquivalentTo(source.IWBRecipient?.PartnerHostRef); target.CMRNumber.ShouldBeEquivalentTo(source.IWBCMRNumber); target.CMRDate.ShouldBeEquivalentTo(source.IWBCMRDate); target.FactoryHostRef.ShouldBeEquivalentTo(source.Factory?.FactoryHostRef); target.TypeCode.ShouldBeEquivalentTo(source.IWBType); target.HostRef.ShouldBeEquivalentTo(source.IWBHostRef); target.Group.ShouldBeEquivalentTo(source.IWBGroup); // TODO нет аналога в WMS //target.OrderReturn.ShouldBeEquivalentTo(source.OrderReturn); if (source.IWB_WmsIWBPos_List == null) { target.IWBPosList.Should().NotBeNull(); } else { source.IWB_WmsIWBPos_List.Count.ShouldBeEquivalentTo(target.IWBPosList.Count); foreach (var pos in source.IWB_WmsIWBPos_List) { TestWmsIWBPos2IWBPos(pos, target.IWBPosList.First(i => i.ID == pos.IWBPosID)); } } if (source.CPV_List == null) { target.CPVList.Should().NotBeNull(); } else { TestWmsCPVList2CPVList(source.CPV_List.Select(c => (WmsCustomParamValue)c).ToList(), target.CPVList); } }
//-> SelectByID public async Task <ItemViewDTO> SelectByID(int id) { /* * var items = await (from i in db.tblItems * join g in db.tblItemGroups.Where(x => x.itmg_Deleted == null) * on i.itemGroupID equals g.id * join d in db.sm_doc.Where(x => x.docs_Deleted == null && x.tableID == Helper.Helper.document_ItemTableID) * on i.id.ToString() equals d.value into document * where i.item_Deleted == null && i.id == id * orderby i.name ascending * select new { item = i, document = document, itemGroup = g } * ).ToListAsync(); * * if (items.Count == 0) * throw new HttpException((int)HttpStatusCode.NotFound, "NotFound"); * * var itemGroupView = new ItemGroupBase(); * itemGroupView = Helper.Helper.MapDBClassToDTO<tblItemGroup, ItemGroupBase>(items[0].itemGroup); * var itemView = new ItemViewDTO(); * itemView = Helper.Helper.MapDBClassToDTO<tblItem, ItemViewDTO>(items[0].item); * itemView.documents = Helper.Helper.GetDocuments(items[0].document.ToList()); * itemView.itemGroup = itemGroupView; * * return itemView; */ //--i want use like this, but seem getting error with ayn var item = await db.tblItems.FirstOrDefaultAsync(r => r.item_Deleted == null && r.id == id); if (item == null) { throw new HttpException((int)HttpStatusCode.NotFound, "NotFound"); } var itemView = new ItemViewDTO(); itemView = MappingHelper.MapDBClassToDTO <tblItem, ItemViewDTO>(item); itemView.documents = DocumentHelper.GetDocuments(db, ConstantHelper.document_ItemTableID, item.id); itemView.itemGroup = await new ItemGroupRepository().SelectByID(int.Parse(item.itemGroupID.ToString())); //itemView = MappingHelper.MapDBClassToDTO<tblItem, ItemViewDTO>(item); //if map at last like this , document & and item group will be null return(itemView); }
public void SqlServerUpdateQuery_ShouldGenQuery() { // Arrange var command = new System.Data.SqlClient.SqlCommand(); var db = MockRepository.GenerateStub<IDataMapper>(); db.Expect(d => d.Command).Return(command); ColumnMapCollection columns = MapRepository.Instance.GetColumns(typeof(Person)); MappingHelper mappingHelper = new MappingHelper(db); Person person = new Person(); person.ID = 1; person.Name = "Jordan"; person.Age = 33; person.IsHappy = true; person.BirthDate = new DateTime(1977, 1, 22); mappingHelper.CreateParameters<Person>(person, columns, true); int idValue = 7; TableCollection tables = new TableCollection { new Table(typeof(Person)) }; Expression<Func<Person, bool>> filter = p => p.ID == person.ID || p.ID == idValue || p.Name == person.Name && p.Name == "Bob"; var where = new WhereBuilder<Person>(command, new SqlServerDialect(), filter, tables, false, true); IQuery query = new UpdateQuery(new SqlServerDialect(), columns, command, "dbo.People", where.ToString()); // Act string queryText = query.Generate(); // Assert Assert.IsNotNull(queryText); Assert.IsTrue(queryText.Contains("UPDATE [dbo].[People]")); Assert.IsTrue(queryText.Contains("[Name]")); Assert.IsTrue(queryText.Contains("[Age]")); Assert.IsTrue(queryText.Contains("[IsHappy]")); Assert.IsTrue(queryText.Contains("[BirthDate]")); Assert.IsTrue(queryText.Contains("[ID] = @P4")); Assert.IsTrue(queryText.Contains("[ID] = @P5")); Assert.IsTrue(queryText.Contains("[Name] = @P6")); Assert.IsTrue(queryText.Contains("[Name] = @P7")); Assert.AreEqual(command.Parameters["@P4"].Value, 1); Assert.AreEqual(command.Parameters["@P5"].Value, 7); Assert.AreEqual(command.Parameters["@P6"].Value, "Jordan"); Assert.AreEqual(command.Parameters["@P7"].Value, "Bob"); }
private void GenerateStringListFromMappedFields(GenericUnknownStruct.BaseClassEntry cls, ref HashSet <string> strings) { var props = new List <KeyValuePair <PropertyInfo, object> >(); foreach (var prop in cls.GetType().GetProperties()) { var propValue = MappingHelper.GetPropertyHelper(prop).Get(cls); if (CanBeIgnored(cls, prop, propValue)) { continue; } props.Add(new KeyValuePair <PropertyInfo, object>(prop, propValue)); } props = props .GroupBy(p => p.Key.DeclaringType) .Reverse() .SelectMany(g => g) .ToList(); for (int i = 0; i < props.Count; i++) { var prop = props[i].Key; var propValue = props[i].Value; var(typeString, baseType) = GetTypeStringFromProperty(prop, propValue); strings.Add(GetRealName(prop)); strings.Add(typeString); if (prop.PropertyType.IsArray) { var eleType = prop.PropertyType.GetElementType(); foreach (var val in (IList)propValue) { GetStringValueFromPropValue(eleType, val, baseType, ref strings); } } else { GetStringValueFromPropValue(prop.PropertyType, propValue, baseType, ref strings); } } }
public void SqlServerSelectQuery_ShouldGenQuery() { // Arrange var command = new System.Data.SqlClient.SqlCommand(); var db = MockRepository.GenerateStub <IDataMapper>(); db.Expect(d => d.Command).Return(command); ColumnMapCollection columns = MapRepository.Instance.GetColumns(typeof(Person)); MappingHelper mappingHelper = new MappingHelper(db); var orderBy = MockRepository.GenerateStub <ISortQueryBuilder>(); orderBy.Expect(o => o.BuildQuery()).Return(""); Person person = new Person(); person.ID = 1; person.Name = "Jordan"; person.Age = 33; person.IsHappy = true; person.BirthDate = new DateTime(1977, 1, 22); List <Person> list = new List <Person>(); TableCollection tables = new TableCollection { new Table(typeof(Person)) }; Expression <Func <Person, bool> > filter = p => p.Name == "John" && p.Age > 15 || p.Age < 5 && p.Age > 1; var where = new WhereBuilder <Person>(command, new SqlServerDialect(), filter, tables, false, true); IQuery query = new SelectQuery(new SqlServerDialect(), tables, where.ToString(), orderBy, false); // Act string queryText = query.Generate(); // Assert Assert.IsNotNull(queryText); Assert.AreEqual(command.Parameters["@P0"].Value, "John"); Assert.AreEqual(command.Parameters["@P1"].Value, 15); Assert.AreEqual(command.Parameters["@P2"].Value, 5); Assert.AreEqual(command.Parameters["@P3"].Value, 1); Assert.IsTrue(queryText.Contains("([t0].[Name] = @P0) AND ([t0].[Age] > @P1))")); Assert.IsTrue(queryText.Contains("([t0].[Age] < @P2) AND ([t0].[Age] > @P3))")); }
private void btnModify_Click(object sender, EventArgs e) { int departmentId = Convert.ToInt32(dgvDepartments.CurrentRow.Cells["colId"].Value); int selectedRowIdex = dgvDepartments.CurrentRow.Index; DepartmentModifyForm frm = new DepartmentModifyForm(departmentId); frm.ReloadDepartment += (s, ea) => { DepartmentsEventArgs eventArgs = ea as DepartmentsEventArgs; if (eventArgs != null) { DepartmentViewModel department = MappingHelper.MapDepartmentModelToDepartmentViewModel(eventArgs.department); bsDepartment[selectedRowIdex] = department; } }; frm.ShowDialog(); }
public void Configure(EntityTypeBuilder <UserEntity> builder) { builder.ToTable("User"); // table name MappingHelper.MapAuditableEntity(builder); builder.Property(x => x.PublicId).HasColumnName("PublicId").HasMaxLength(38).IsRequired().ValueGeneratedOnAdd(); builder.Property(x => x.Email).HasColumnName("Email").IsRequired().HasMaxLength(256); builder.Property(x => x.PasswordHash).HasColumnName("PasswordHash").IsRequired().HasMaxLength(1000); builder.Property(x => x.Email).HasColumnName("FirstName").IsRequired().HasMaxLength(256); builder.Property(x => x.PasswordHash).HasColumnName("MiddleName").IsRequired().HasMaxLength(256); builder.Property(x => x.Email).HasColumnName("LastName").IsRequired().HasMaxLength(256); builder.Property(x => x.Email).HasColumnName("Suffix").IsRequired().HasMaxLength(5); builder.Property(x => x.IsEnabled).HasColumnName("IsEnabled").IsRequired().HasDefaultValue(true); builder.Property(x => x.IsLocked).HasColumnName("IsLocked").IsRequired().HasDefaultValue(false); builder.Property(x => x.ConcurrencyStamp).HasColumnName("ConcurrencyStamp").IsConcurrencyToken().ValueGeneratedOnAddOrUpdate(); }
public void MappingHelperTest() { var source = new MockClassOne { boolType = true, intType = 2, longType = 100, stringType = "string" }; var target = new MockClassOne(); MappingHelper.MapMatchingProperties(target, source); Assert.That(target.boolType, Is.EqualTo(source.boolType)); Assert.That(target.stringType, Is.EqualTo(source.stringType)); Assert.That(target.longType, Is.EqualTo(source.longType)); Assert.That(target.intType, Is.EqualTo(source.intType)); }
public static MiddlerRule ToMiddlerRule(this EndpointRuleEntity entity) { if (entity == null) { return(null); } var mRule = new MiddlerRule(); mRule.Name = entity.Name; mRule.Hostname = entity.Hostname; mRule.Path = entity.Path; mRule.Scheme = MappingHelper.Split(entity.Scheme); mRule.HttpMethods = MappingHelper.Split(entity.HttpMethods); mRule.Actions = entity.Actions.OrderBy(p => p.Order).Select(ToMiddlerAction).ToList(); mRule.Permissions = entity.Permissions.OrderBy(p => p.Order).Select(ToMiddlerPermissionRule).ToList(); return(mRule); }
public async Task PerformSearchDatasetVersion_GivenClientReturnsEmptyResult_ShouldReturnCorrectlyMappedResult() { // Arrange IDatasetsApiClient mockDatasetsApiClient = Substitute.For <IDatasetsApiClient>(); ILogger mockLogger = Substitute.For <ILogger>(); IMapper mockMapper = MappingHelper.CreateFrontEndMapper(); IDatasetSearchService datasetSearchService = new DatasetSearchService(mockDatasetsApiClient, mockMapper, mockLogger); mockDatasetsApiClient .SearchDatasets(Arg.Any <SearchModel>()) .Returns((ApiResponse <SearchResults <DatasetIndex> >)null); // Act DatasetVersionSearchResultViewModel datasetVersionSearchResultViewModel = await datasetSearchService.PerformSearchDatasetVersion(new SearchRequestViewModel()); // Assert datasetVersionSearchResultViewModel.Should().BeNull(); }
private static ISessionFactory GetNHibernateSessionFactory() { var connString = ConfigurationManager.ConnectionStrings["IdSvr3Config"]; var sessionFactory = Fluently.Configure() .Database(MsSqlConfiguration.MsSql2012.ConnectionString(connString.ToString()) .ShowSql() .FormatSql()) .Mappings( m => m.AutoMappings.Add(MappingHelper.GetNhibernateServicesMappings(true, true))) .ExposeConfiguration(cfg => { SchemaMetadataUpdater.QuoteTableAndColumns(cfg); BuildSchema(cfg); }) .BuildSessionFactory(); return(sessionFactory); }
/// <summary> /// 获取请求消息列表(分页) /// </summary> /// <param name="con"></param> /// <returns></returns> public List <NotifyMessageModel> GetNotifyMessageList(NotifyMessageCondition con) { NotifyMessageBusiness business = new NotifyMessageBusiness(); var messageTypeList = business.GetNotifyMessageTypeListFromCache(new NotifyMessageTypeCondition()); List <NotifyMessageEntity> entityList = JinRiNotifyFacade.Instance.GetNotifyMessageList(con); List <NotifyMessageModel> list = new List <NotifyMessageModel>(); entityList.ForEach(x => { var model = MappingHelper.From <NotifyMessageModel, NotifyMessageEntity>(x); var messageType = messageTypeList.Where(t => t.MessageType.ToString().Equals(model.MessageType, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (messageType != null) { model.MessageTypeCName = messageType.Remark; } list.Add(model); }); return(list); }
public static ApplicationUserManager Create(IdentityFactoryOptions <ApplicationUserManager> options, IOwinContext context) // ??? { var entities = new[] { typeof(ApplicationUser) }; var configuration = Fluently.Configure() .Database(MsSqlConfiguration .MsSql2008 //.ConnectionString(x => x.FromConnectionStringWithKey("Identity")) .ConnectionString(x => x.FromConnectionStringWithKey(EasyLOB.Library.App.MultiTenantHelper.GetConnectionName("Identity"))) // !?! Multi-Tenant .Driver <SqlClientDriverEasyLOB> ) .ExposeConfiguration(x => { x.AddDeserializedMapping(MappingHelper.GetIdentityMappings(entities), null); }) ; ISessionFactory factory = configuration.BuildSessionFactory(); ISession session = factory.OpenSession(); ApplicationUserManager manager = new ApplicationUserManager(new UserStore <ApplicationUser>(session)); manager.PasswordValidator = new CustomPasswordValidator { RequiredLength = 6, RequireNonLetterOrDigit = false, RequireDigit = false, RequireLowercase = true, RequireUppercase = true }; manager.UserValidator = new CustomUserValidator(manager) { AllowOnlyAlphanumericUserNames = true, RequireUniqueEmail = true }; manager.EmailService = new EmailService(); manager.SmsService = new SmsService(); return(manager); }
private static ISessionFactory CreateSessionFactory() { var myEntities = new[] { typeof(ApplicationUser) }; var configuration = new Configuration(); configuration.Configure(); configuration.AddDeserializedMapping(MappingHelper.GetIdentityMappings(myEntities), null); configuration.AddMapping(getDomainMapping()); new SchemaExport(configuration).Execute(true, true, false); var sessionFactory = configuration.BuildSessionFactory(); Seed(sessionFactory); return(sessionFactory); }
/// <summary> /// Stuurt de gegeven <paramref name="communicatieVorm"/> naar Kipadmin. Om te weten welk de /// originele communicatievorm is, kijken we naar de gekoppelde persoon, en gebruiken we /// het oorspronkelijke nummer (<paramref name="origineelNummer"/>) /// </summary> /// <param name="communicatieVorm">Te updaten communicatievorm</param> /// <param name="origineelNummer">Oorspronkelijk nummer van die communicatievorm</param> /// <remarks>Het is best mogelijk dat het 'nummer' niet is veranderd, maar bijv. enkel de vlag /// 'opt-in'</remarks> public void Bijwerken(CommunicatieVorm communicatieVorm, string origineelNummer) { Debug.Assert(communicatieVorm.GelieerdePersoon != null); Debug.Assert(communicatieVorm.GelieerdePersoon.Persoon != null); Debug.Assert(communicatieVorm.GelieerdePersoon.Persoon.InSync); ServiceHelper.CallService <ISyncPersoonService>( svc => svc.CommunicatieBijwerken( MappingHelper.Map <Persoon, Kip.ServiceContracts.DataContracts.Persoon>( communicatieVorm.GelieerdePersoon.Persoon), origineelNummer, new CommunicatieMiddel { Type = (CommunicatieType)communicatieVorm.CommunicatieType.ID, Waarde = communicatieVorm.Nummer, IsBulk = communicatieVorm.Voorkeur })); }
private void btnCreate_Click(object sender, EventArgs e) { EmployeeAddForm frm = new EmployeeAddForm(); frm.ReloadEmployees += (s, ea) => { EmployeeEventArgs evetArgs = ea as EmployeeEventArgs; if (evetArgs != null) { EmployeeViewModel employee = MappingHelper.MapEmployeeModelToEmployeeViewModel(evetArgs.Employee); bsEmployees.Add(employee); dgvEmployees.ClearSelection(); dgvEmployees.Rows[dgvEmployees.Rows.Count - 1].Selected = true; } }; frm.ShowDialog(); }
public async Task PerformSearch_GivenIsSearchModeAllEnabledFeatureToggleIdTurnedOn_SearchModeIsAll() { // Arrange IDatasetsApiClient mockDatasetsApiClient = Substitute.For <IDatasetsApiClient>(); ILogger mockLogger = Substitute.For <ILogger>(); IMapper mockMapper = MappingHelper.CreateFrontEndMapper(); IFeatureToggle featureToggle = CreateFeatureToggle(true); IDatasetSearchService datasetSearchService = new DatasetSearchService(mockDatasetsApiClient, mockMapper, mockLogger, featureToggle); // Act DatasetSearchResultViewModel datasetVersionSearchResultViewModel = await datasetSearchService.PerformSearch(new SearchRequestViewModel()); // Assert await mockDatasetsApiClient .Received(1) .FindDatasets(Arg.Is <SearchFilterRequest>(m => m.SearchMode == SearchMode.All)); }
/// <summary> /// 请求并接收指令中心的数据 /// </summary> /// <param name="beatMessage"></param> /// <returns></returns> public BeatResult HeartBeat(BeatMessage beatMessage) { lock (_lockObj) { BeatResult beatResult = new BeatResult(); beatResult.TaskList = new List <TaskMessage>(); var tempList = _taskList.Where(t => t.TaskExecutor.Equals(beatMessage.HostIP) && t.Status == TaskMessageStatusEnum.None); foreach (var item in tempList) { var msg = MappingHelper.From <TaskMessage, TaskMessage>(item); beatResult.TaskList.Add(msg); } beatResult.Result = BeatResultEnum.Success; _taskList.Where(t => t.TaskExecutor.Equals(beatMessage.HostIP)).ToList() .ForEach(t => t.Status = TaskMessageStatusEnum.Executed); DistributedCache.Add(CacheKeys.InstuctionTaskListCacheKey, _taskList, DateTime.Now.AddYears(1)); return(beatResult); } }
public void TestSendPushMessage() { SendMessageBusiness sendBus = new SendMessageBusiness(); PushMessageBusiness pushBus = new PushMessageBusiness(); List <PushMessageModel> list = new List <PushMessageModel>(); list.Add(pushBus.GetFromCache("0907396caecb4ce9be68362b07276e64")); foreach (PushMessageModel m in list) { if (m.NextPushTime <= DateTime.Now) { PushMessage pushDTO = MappingHelper.From <PushMessage, PushMessageModel>(m); //notifyBus.SendPushMessage(pushDTO); sendBus.Send(pushDTO, sendBus.Callback); } } Thread.Sleep(100000); }
public async Task <bool> AddAsync(TBusiness business) { try { var entity = MappingHelper.ConvertToEntity(business, new TEntity()); int id = await _dataService.Add(entity); if (id == 1) { business.SetId(entity.Id); return(true); } } catch (Exception ex) { LogOrThrow(ex); } return(false); }
public void TestMap_TestWmsProduct2Product(ISession session) { var source = session.Query <WmsProduct>().First(); var target = MappingHelper.DynamicMap <Product>(source); target.ID.ShouldBeEquivalentTo(source.ProductID); target.TECode.ShouldBeEquivalentTo(source.TE.TECode); target.ArtHostRef.ShouldBeEquivalentTo(source.Art.ArtHostRef); target.MeasureCode.ShouldBeEquivalentTo(source.SKU.Measure.MeasureCode); target.Count.ShouldBeEquivalentTo(source.ProductCountSKU); target.Count2SKU.ShouldBeEquivalentTo(source.ProductCount); target.TTEQuantity.ShouldBeEquivalentTo(source.ProductTTEQuantity); target.QLFCode.ShouldBeEquivalentTo(source.QLF?.QLFCode); target.QLFDetailCode.ShouldBeEquivalentTo(source.QLFDetail?.QLFDetailCode); target.InputDate.ShouldBeEquivalentTo(source.ProductInputDate); target.ProductDate.ShouldBeEquivalentTo(source.ProductDate); target.Pack.ShouldBeEquivalentTo(source.ProductPack); target.PackCountSKU.ShouldBeEquivalentTo(source.ProductPackCountSKU); target.ExpiryDate.ShouldBeEquivalentTo(source.ProductExpiryDate); target.Batch.ShouldBeEquivalentTo(source.ProductBatch); target.Lot.ShouldBeEquivalentTo(source.ProductLot); target.SerialNumber.ShouldBeEquivalentTo(source.ProductSerialNumber); target.Color.ShouldBeEquivalentTo(source.ProductColor); target.Tone.ShouldBeEquivalentTo(source.ProductTone); target.Size.ShouldBeEquivalentTo(source.ProductSize); target.ArtName.ShouldBeEquivalentTo(source.Art.ArtName); target.MandantCode.ShouldBeEquivalentTo(source.Partner.PartnerCode); target.FactoryHostRef.ShouldBeEquivalentTo(source.Factory?.FactoryHostRef); target.StatusCode.ShouldBeEquivalentTo(source.Status.StatusCode); target.BatchCode.ShouldBeEquivalentTo(source.ProductBatchCode); target.BoxNumber.ShouldBeEquivalentTo(source.ProductBoxNumber); target.HostRef.ShouldBeEquivalentTo(source.ProductHostRef); target.KitArtName.ShouldBeEquivalentTo(source.ProductKitArtName); target.OwnerCode.ShouldBeEquivalentTo(source.ProductOwner.PartnerCode); target.Priority.ShouldBeEquivalentTo(source.ProductPriority); target.CountryCode.ShouldBeEquivalentTo(source.Country?.CountryCode); target.GTD.ShouldBeEquivalentTo(source.ProductGTD); // TODO до выхода нового релиза AutoMapper //target.Line.ShouldBeEquivalentTo(source.OWBPos?.OWBPosNumber); //target.IWBPosID.ShouldBeEquivalentTo(source.IWBPos?.IWBPosID); //target.OWBPosID.ShouldBeEquivalentTo(source.OWBPos?.OWBPosID); }
public void SqlServerUpdateQuery_ShouldGenQuery() { // Arrange var command = new System.Data.SqlClient.SqlCommand(); ColumnMapCollection columns = MapRepository.Instance.GetColumns(typeof(Person)); MappingHelper mappingHelper = new MappingHelper(command); Person person = new Person(); person.ID = 1; person.Name = "Jordan"; person.Age = 33; person.IsHappy = true; person.BirthDate = new DateTime(1977, 1, 22); mappingHelper.CreateParameters<Person>(person, columns, false, true); int idValue = 7; var where = new WhereBuilder<Person>(command, p => p.ID == person.ID || p.ID == idValue || p.Name == person.Name && p.Name == "Bob", false); IQuery query = new UpdateQuery(columns, command, "dbo.People", where.ToString()); // Act string queryText = query.Generate(); // Assert Assert.IsNotNull(queryText); Assert.IsTrue(queryText.Contains("UPDATE dbo.People")); Assert.IsTrue(queryText.Contains("[Name]")); Assert.IsTrue(queryText.Contains("[Age]")); Assert.IsTrue(queryText.Contains("[IsHappy]")); Assert.IsTrue(queryText.Contains("[BirthDate]")); Assert.IsTrue(queryText.Contains("[ID] = @P5")); Assert.IsTrue(queryText.Contains("[ID] = @P6")); Assert.IsTrue(queryText.Contains("[Name] = @P7")); Assert.IsTrue(queryText.Contains("[Name] = @P8")); Assert.AreEqual(command.Parameters["@P5"].Value, 1); Assert.AreEqual(command.Parameters["@P6"].Value, 7); Assert.AreEqual(command.Parameters["@P7"].Value, "Jordan"); Assert.AreEqual(command.Parameters["@P8"].Value, "Bob"); }
/// <summary> /// Creates the NHibernare session factory. /// </summary> private void CreateNHibernateSessionFactory() { if (DefaultSessionFactory == null) { // Build and add the mappings for the test domain entities. var domainTypes = new[] { typeof(TestAddress), typeof(TestCar) }; var domainMapper = new DefaultModelMapper(); _configuration.AddMapping(domainMapper.CompileMappingFor(domainTypes)); // Build and add the mappings for ASP.Net Identity entities. var mappingHelper = new MappingHelper<TestUser, string, TestLogin, TestRole, string, TestClaim, int>(); // Customise the ASP.Net Identity User mapping before adding the mappings to the configuration. mappingHelper.Mapper.Class<TestUser>(u => { u.Bag(x => x.CarsAvailable, c => { c.Inverse(true); }, r => r.ManyToMany()); }); _configuration.AddMapping(mappingHelper.GetMappingsToMatchEfIdentity()); DefaultSessionFactory = _configuration.BuildSessionFactory(); } }
public void SqlServerSelectQuery_MethodExpression_BinaryExpression() { // Arrange var command = new System.Data.SqlClient.SqlCommand(); ColumnMapCollection columns = MapRepository.Instance.GetColumns(typeof(Person)); MappingHelper mappingHelper = new MappingHelper(command); Person person = new Person(); person.ID = 1; person.Name = "Jordan"; person.Age = 33; person.IsHappy = true; person.BirthDate = new DateTime(1977, 1, 22); List<Person> list = new List<Person>(); var where = new WhereBuilder<Person>(command, p => p.Name.Contains("John") && p.Age > 5, false); IQuery query = new SelectQuery(columns, "dbo.People", where.ToString(), "", false); // Act string queryText = query.Generate(); // Assert Assert.IsNotNull(queryText); Assert.AreEqual(command.Parameters["@P0"].Value, "John"); Assert.AreEqual(command.Parameters["@P1"].Value, 5); Assert.IsTrue(queryText.Contains("[Name] LIKE '%' + @P0 + '%'")); Assert.IsTrue(queryText.Contains("[Age] > @P1")); }
public void WhenColumnNameDiffersFromProperty_InsertQueryShouldUseColumnName() { // Arrange Person2 person = new Person2 { Name = "Bob", Age = 40, BirthDate = DateTime.Now }; Dialect dialect = new SqlServerDialect(); ColumnMapCollection mappings = MapRepository.Instance.GetColumns(typeof(Person2)); var command = new System.Data.SqlClient.SqlCommand(); var db = MockRepository.GenerateStub<IDataMapper>(); db.Expect(d => d.Command).Return(command); var mappingHelper = new MappingHelper(db); mappingHelper.CreateParameters<Person2>(person, mappings, true); string targetTable = "PersonTable"; InsertQuery query = new InsertQuery(dialect, mappings, command, targetTable); // Act string queryText = query.Generate(); // Assert Assert.IsTrue(queryText.Contains("[PersonName]"), "Query should contain column name"); Assert.IsTrue(queryText.Contains("[PersonAge]"), "Query should contain column name"); Assert.IsTrue(queryText.Contains("[BirthDate]"), "Query should contain property name"); Assert.IsTrue(queryText.Contains("[IsHappy]"), "Query should contain property name"); }
public void SqlServerSelectQuery_MethodExpression_BinaryExpression() { // Arrange var command = new System.Data.SqlClient.SqlCommand(); var db = MockRepository.GenerateStub<IDataMapper>(); db.Expect(d => d.Command).Return(command); ColumnMapCollection columns = MapRepository.Instance.GetColumns(typeof(Person)); MappingHelper mappingHelper = new MappingHelper(db); var orderBy = MockRepository.GenerateStub<ISortQueryBuilder>(); orderBy.Expect(o => o.BuildQuery()).Return(""); Person person = new Person(); person.ID = 1; person.Name = "Jordan"; person.Age = 33; person.IsHappy = true; person.BirthDate = new DateTime(1977, 1, 22); List<Person> list = new List<Person>(); TableCollection tables = new TableCollection { new Table(typeof(Person)) }; Expression<Func<Person, bool>> filter = p => p.Name.Contains("John") && p.Age > 5; var where = new WhereBuilder<Person>(command, new SqlServerDialect(), filter, tables, false, true); IQuery query = new SelectQuery(new SqlServerDialect(), tables, where.ToString(), orderBy, false); // Act string queryText = query.Generate(); // Assert Assert.IsNotNull(queryText); Assert.AreEqual(command.Parameters["@P0"].Value, "John"); Assert.AreEqual(command.Parameters["@P1"].Value, 5); Assert.IsTrue(queryText.Contains("[Name] LIKE '%' + @P0 + '%'")); Assert.IsTrue(queryText.Contains("[Age] > @P1")); }