TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Alex Lonyay
NA
123
9.5k
Issue in mapping property from excel data table to list
Jun 28 2020 8:02 AM
I have testdata model, and I want to map the column values to existing class hierarchy property's and currently it is not mapping the values and shows NULL value
For instance in test data model i have field paymentOptions and in excel sheet the value is KlarnaOptions but after the map of datatable to list - the value of paymentOptions is showing NULL
Test Data Model:
using
AutoFramework.Constants;
using
AutoFramework.Model;
using
AutoFramework.Model.PaymentOptions;
using
Framework.Model.Excel;
using
System.Collections.Generic;
namespace
AutoFramework.Model.Excel
{
public
partial
class
TestDataModel
{
public
TestDataModel() {
}
[DataNames(
"TestName"
)]
public
string
TestName {
get
;
set
; }
[DataNames(
"productId"
)]
public
int
productId {
get
;
set
; }
[DataNames(
"orderId"
)]
public
int
orderId {
get
;
set
; }
[DataNames(
"designMethod"
)]
public
DesignMethod designMethod {
get
;
set
; }
[DataNames(
"signedIn"
)]
public
bool
signedIn {
get
;
set
; }
[DataNames(
"increaseBasketQty"
)]
public
bool
increaseBasketQty {
get
;
set
; }
[DataNames(
"signedInCMS"
)]
public
bool
signedInCMS {
get
;
set
; }
[DataNames(
"editable"
)]
public
bool
editable {
get
;
set
; }
[DataNames(
"paymentOptions"
)]
public
PaymentOptions paymentOptions {
get
;
set
; }
[DataNames(
"checkInVoice"
)]
public
bool
checkInVoice {
get
;
set
; }
[DataNames(
"navigateToDesign"
)]
public
bool
navigateToDesign {
get
;
set
; }
[DataNames(
"checkOrderAuthorsie"
)]
public
bool
checkOrderAuthorsie {
get
;
set
; }
[DataNames(
"checkSplitOrder"
)]
public
bool
checkSplitOrder {
get
;
set
; }
[DataNames(
"SiteId"
)]
public
string
SiteId {
get
;
set
; }
[DataNames(
"SiteUrl"
)]
public
string
SiteUrl {
get
;
set
; }
[DataNames(
"CultureCode"
)]
public
string
CultureCode {
get
;
set
; }
[DataNames(
"SiteGroupId"
)]
public
string
SiteGroupId {
get
;
set
; }
[DataNames(
"NickName"
)]
public
string
NickName {
get
;
set
; }
[DataNames(
"byCard"
)]
public
KlarnaOptions byCard {
get
;
set
; }
[DataNames(
"payLater"
)]
public
bool
payLater {
get
;
set
; }
[DataNames(
"sliceIt"
)]
public
bool
sliceIt {
get
;
set
; }
[DataNames(
"portal"
)]
public
PaymentPortal portal {
get
;
set
; }
[DataNames(
"delivery"
)]
public
DeliveryMethod delivery{
get
;
set
;}
}
}
Mapper Class
using
System;
using
System.Collections.Generic;
using
System.Data;
using
System.Linq;
using
System.Text;
using
System.Threading.Tasks;
namespace
Framework.Model.Excel
{
public
class
DataNamesMapper
where TEntity :
class
,
new
()
{
public
TEntity Map(DataRow row)
{
TEntity entity =
new
TEntity();
return
Map(row, entity);
}
public
TEntity Map(DataRow row, TEntity entity)
{
var columnNames = row.Table.Columns.Cast
().Select(x => x.ColumnName).ToList();
var properties = (
typeof
(TEntity)).GetProperties()
.Where(x => x.GetCustomAttributes(
typeof
(DataNamesAttribute),
true
).Any())
.ToList();
foreach
(var prop
in
properties)
{
PropertyMapHelper.Map(
typeof
(TEntity), row, prop, entity);
}
return
entity;
}
public
IEnumerable
Map(DataTable table)
{
List
entities =
new
List
();
var columnNames = table.Columns.Cast
().Select(x => x.ColumnName).ToList();
var properties = (
typeof
(TEntity)).GetProperties()
.Where(x => x.GetCustomAttributes(
typeof
(DataNamesAttribute),
true
).Any())
.ToList();
foreach
(DataRow row
in
table.Rows)
{
TEntity entity =
new
TEntity();
foreach
(var prop
in
properties)
{
PropertyMapHelper.Map(
typeof
(TEntity), row, prop, entity);
}
entities.Add(entity);
}
return
entities;
}
}
}
Data Name Attribute class
using
System;
using
System.Collections.Generic;
using
System.Linq;
using
System.Text;
using
System.Threading.Tasks;
namespace
Framework.Model.Excel
{
[AttributeUsage(AttributeTargets.Property)]
public
class
DataNamesAttribute : Attribute
{
protected
List<
string
> _valueNames {
get
;
set
; }
public
List<
string
> ValueNames
{
get
{
return
_valueNames;
}
set
{
_valueNames = value;
}
}
public
DataNamesAttribute()
{
_valueNames =
new
List<
string
>();
}
public
DataNamesAttribute(
params
string
[] valueNames)
{
_valueNames = valueNames.ToList();
}
}
}
Property Map Helper
using
System;
using
System.Collections.Generic;
using
System.Data;
using
System.Globalization;
using
System.Linq;
using
System.Reflection;
using
System.Text;
using
System.Threading.Tasks;
namespace
Framework.Model.Excel
{
public
static
class
PropertyMapHelper
{
public
static
void
Map(Type type, DataRow row, PropertyInfo prop,
object
entity)
{
List<
string
> columnNames = AttributeHelper.GetDataNames(type, prop.Name);
foreach
(var columnName
in
columnNames)
{
if
(!String.IsNullOrWhiteSpace(columnName) && row.Table.Columns.Contains(columnName))
{
var propertyValue = row[columnName];
if
(propertyValue != DBNull.Value)
{
ParsePrimitive(prop, entity, row[columnName]);
break
;
}
}
}
}
private
static
void
ParsePrimitive(PropertyInfo prop,
object
entity,
object
value)
{
if
(prop.PropertyType ==
typeof
(
string
))
{
prop.SetValue(entity, value.ToString().Trim(),
null
);
}
else
if
(prop.PropertyType ==
typeof
(
bool
) || prop.PropertyType ==
typeof
(
bool
?))
{
if
(value ==
null
)
{
prop.SetValue(entity,
null
,
null
);
}
else
{
prop.SetValue(entity, ParseBoolean(value.ToString()),
null
);
}
}
else
if
(prop.PropertyType ==
typeof
(
long
))
{
prop.SetValue(entity,
long
.Parse(value.ToString()),
null
);
}
else
if
(prop.PropertyType ==
typeof
(
int
) || prop.PropertyType ==
typeof
(
int
?))
{
if
(value ==
null
)
{
prop.SetValue(entity,
null
,
null
);
}
else
{
prop.SetValue(entity,
int
.Parse(value.ToString()),
null
);
}
}
else
if
(prop.PropertyType ==
typeof
(
decimal
))
{
prop.SetValue(entity,
decimal
.Parse(value.ToString()),
null
);
}
else
if
(prop.PropertyType ==
typeof
(
double
) || prop.PropertyType ==
typeof
(
double
?))
{
double
number;
bool
isValid =
double
.TryParse(value.ToString(),
out
number);
if
(isValid)
{
prop.SetValue(entity,
double
.Parse(value.ToString()),
null
);
}
}
else
if
(prop.PropertyType ==
typeof
(DateTime) || prop.PropertyType ==
typeof
(Nullable<DateTime>))
{
DateTime date;
bool
isValid = DateTime.TryParse(value.ToString(),
out
date);
if
(isValid)
{
prop.SetValue(entity, date,
null
);
}
else
{
isValid = DateTime.TryParseExact(value.ToString(),
"MMddyyyy"
,
new
CultureInfo(
"en-US"
), DateTimeStyles.AssumeLocal,
out
date);
if
(isValid)
{
prop.SetValue(entity, date,
null
);
}
}
}
else
if
(prop.PropertyType ==
typeof
(Guid))
{
Guid guid;
bool
isValid = Guid.TryParse(value.ToString(),
out
guid);
if
(isValid)
{
prop.SetValue(entity, guid,
null
);
}
else
{
isValid = Guid.TryParseExact(value.ToString(),
"B"
,
out
guid);
if
(isValid)
{
prop.SetValue(entity, guid,
null
);
}
}
}
}
public
static
bool
ParseBoolean(
object
value)
{
if
(value ==
null
|| value == DBNull.Value)
return
false
;
switch
(value.ToString().ToLowerInvariant())
{
case
"1"
:
case
"y"
:
case
"yes"
:
case
"true"
:
return
true
;
case
"0"
:
case
"n"
:
case
"no"
:
case
"false"
:
default
:
return
false
;
}
}
}
}
Custom Property Type to which I want to map column values
using
AutoFramework.Entities;
namespace
AutoFramework.Model.PaymentOptions
{
public
class
PaymentOptions
{
public
PaymentPortal portal;
public
DeliveryMethod delivery = DeliveryMethod.Billing;
public
PaymentOptions()
{
}
public
PaymentOptions(Site site)
{
}
}
}
namespace
AutoFramework.Model.PaymentOptions
{
public
class
KlarnaOptions : PaymentOptions
{
//default - don't use card payment by deffault
public
bool
byCard =
false
;
public
bool
payLater =
false
;
public
bool
sliceIt =
false
;
public
KlarnaOptions()
{
portal = PaymentPortal.Klarna;
}
}
}
Reply
Answers (
0
)
Printing Charts
button event in datalist according to letter wise