public List <BrokerColumnsViewModel> GetBrokerColumn()
{
return((from c in DB.BrokerColumnNames
join m in DB.BrokerColumnMappingMsts on c.ColumnId equals m.ColumnId into Col
from Column in Col.DefaultIfEmpty()
select new BrokerColumnsViewModel()
{
BrokerName = Column.AspNetUser.FirstName + " " + Column.AspNetUser.LastName,
ColumnName = Column.BrokerColumnName.ColumnName,
IsDisplay = Column != null ? true : false,
UserId = Column.UserId
}).ToList());
}
