public IEnumerable <SqlDataRecord> ConvertToEMBDataRecord(IEnumerable <EBMModel> parameters)
{
var sqlMetaData = new SqlMetaData[] {
new SqlMetaData("RID", SqlDbType.VarChar, 50),
new SqlMetaData("ChartNo", SqlDbType.VarChar, 50),
new SqlMetaData("STATUS", SqlDbType.VarChar, 5),
};
var mappingDictionarys = sqlMetaData.ToMappingDictionary();
var records = new List <SqlDataRecord>();
if (parameters != null)
{
foreach (var para in parameters)
{
var record = new SqlDataRecord(sqlMetaData);
record.SetStringOrNull(mappingDictionarys["RID"], para.RID);
record.SetStringOrNull(mappingDictionarys["ChartNo"], para.ChartNo);
record.SetStringOrNull(mappingDictionarys["STATUS"], para.Status);
records.Add(record);
}
}
return(records);
}
private IEnumerable <SqlDataRecord> ConvertToRidDataRecord(IEnumerable <string> parameters)
{
var sqlMetaData = new SqlMetaData[] {
new SqlMetaData("RID", SqlDbType.VarChar, 50),
};
var mappingDictionary = sqlMetaData.ToMappingDictionary();
var records = new List <SqlDataRecord>();
if (parameters != null)
{
foreach (var para in parameters)
{
var record = new SqlDataRecord(sqlMetaData);
record.SetStringOrNull(mappingDictionary["RID"], para);
records.Add(record);
}
}
return(records);
}
