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