private CommodityDTO Map(tblCommodity tbl,DateTime from)
{
var dto = new CommodityDTO
{
MasterId = tbl.Id,
DateCreated = tbl.IM_DateCreated,
DateLastUpdated = tbl.IM_DateLastUpdated,
StatusId = tbl.IM_Status,
Name = tbl.Name,
CommodityTypeId = tbl.CommodityTypeId,
Code = tbl.Code,
Description = tbl.Description,
CommodityGrades = new List<CommodityGradeDTO>(),
};
var items = tbl.tblCommodityGrade.Where(s =>
s.IM_Status == (int)EntityStatus.Active && s.CommodityId == dto.MasterId);
foreach( var item in items)
{
var grade = new CommodityGradeDTO
{
MasterId = item.Id,
DateCreated = item.IM_DateCreated,
DateLastUpdated = item.IM_DateLastUpdated,
StatusId = item.IM_Status,
Name = item.Name,
UsageTypeId = item.UsageTypeId,
Code = item.Code,
Description = item.Description,
CommodityId = item.CommodityId
};
dto.CommodityGrades.Add(grade);
}
dto.DeletedCommodityGradesItem = tbl.tblCommodityGrade.Where(n => n.IM_Status == (int)EntityStatus.Deleted && n.CommodityId==tbl.Id && n.IM_DateLastUpdated > from).Select(s => s.Id).ToList();
return dto;
}
/// <summary>
/// Create a new tblCommodity object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="name">Initial value of the Name property.</param>
/// <param name="commodityTypeId">Initial value of the CommodityTypeId property.</param>
/// <param name="iM_DateCreated">Initial value of the IM_DateCreated property.</param>
/// <param name="iM_DateLastUpdated">Initial value of the IM_DateLastUpdated property.</param>
/// <param name="iM_Status">Initial value of the IM_Status property.</param>
public static tblCommodity CreatetblCommodity(global::System.Guid id, global::System.String name, global::System.Guid commodityTypeId, global::System.DateTime iM_DateCreated, global::System.DateTime iM_DateLastUpdated, global::System.Int32 iM_Status)
{
tblCommodity tblCommodity = new tblCommodity();
tblCommodity.Id = id;
tblCommodity.Name = name;
tblCommodity.CommodityTypeId = commodityTypeId;
tblCommodity.IM_DateCreated = iM_DateCreated;
tblCommodity.IM_DateLastUpdated = iM_DateLastUpdated;
tblCommodity.IM_Status = iM_Status;
return tblCommodity;
}
/// <summary>
/// Deprecated Method for adding a new object to the tblCommodity EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotblCommodity(tblCommodity tblCommodity)
{
base.AddObject("tblCommodity", tblCommodity);
}