private CommodityOwnerTypeDTO Map(tblCommodityOwnerType tbl)
{
var dto = new CommodityOwnerTypeDTO
{
MasterId = tbl.Id,
DateCreated = tbl.IM_DateCreated,
DateLastUpdated = tbl.IM_DateLastUpdated,
StatusId = tbl.IM_Status,
Name = tbl.Name,
Code = tbl.Code,
Description = tbl.Description
};
return dto;
}
/// <summary>
/// Deprecated Method for adding a new object to the tblCommodityOwnerType EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotblCommodityOwnerType(tblCommodityOwnerType tblCommodityOwnerType)
{
base.AddObject("tblCommodityOwnerType", tblCommodityOwnerType);
}
/// <summary>
/// Create a new tblCommodityOwnerType object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="name">Initial value of the Name 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 tblCommodityOwnerType CreatetblCommodityOwnerType(global::System.Guid id, global::System.String name, global::System.DateTime iM_DateCreated, global::System.DateTime iM_DateLastUpdated, global::System.Int32 iM_Status)
{
tblCommodityOwnerType tblCommodityOwnerType = new tblCommodityOwnerType();
tblCommodityOwnerType.Id = id;
tblCommodityOwnerType.Name = name;
tblCommodityOwnerType.IM_DateCreated = iM_DateCreated;
tblCommodityOwnerType.IM_DateLastUpdated = iM_DateLastUpdated;
tblCommodityOwnerType.IM_Status = iM_Status;
return tblCommodityOwnerType;
}
private tblCommodityOwnerType GetCommodityOwnerType(string name)
{
using (var ctx = new CokeDataContext(Con))
{
tblCommodityOwnerType ownerType = null;
if (!string.IsNullOrEmpty(name))
{
ownerType = ctx
.tblCommodityOwnerType.FirstOrDefault(
p =>
p.Name.ToLower() == name.ToLower() ||
p.Code != null &&
p.Code.ToLower() == name.ToLower());
}
if (ownerType == null)
{
ownerType = ctx.tblCommodityOwnerType.FirstOrDefault(p => p.Name.ToLower() == "default");
if (ownerType == null)
{
ownerType = new tblCommodityOwnerType()
{
Id = Guid.NewGuid(),
Name = string.IsNullOrEmpty(name) ? "default" : name,
Description = string.IsNullOrEmpty(name) ? "default" : name,
Code = string.IsNullOrEmpty(name) ? "default" : name,
IM_DateCreated = DateTime.Now,
IM_Status = (int)EntityStatus.Active,
IM_DateLastUpdated = DateTime.Now
};
ctx.tblCommodityOwnerType.AddObject(ownerType);
ctx.SaveChanges();
}
}
return ownerType;
}
}
