private ProductFlavourDTO Map(tblProductFlavour tbl)
{
var dto = new ProductFlavourDTO
{
MasterId = tbl.id,
DateCreated = tbl.IM_DateCreated,
DateLastUpdated = tbl.IM_DateLastUpdated,
StatusId = tbl.IM_Status,
Name = tbl.name,
Code = tbl.code,
Description = tbl.description,
ProductBrandMasterId = tbl.BrandId ?? Guid.Empty
};
return dto;
}
/// <summary>
/// Deprecated Method for adding a new object to the tblProductFlavour EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotblProductFlavour(tblProductFlavour tblProductFlavour)
{
base.AddObject("tblProductFlavour", tblProductFlavour);
}
/// <summary>
/// Create a new tblProductFlavour 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 tblProductFlavour CreatetblProductFlavour(global::System.Guid id, global::System.String name, global::System.DateTime iM_DateCreated, global::System.DateTime iM_DateLastUpdated, global::System.Int32 iM_Status)
{
tblProductFlavour tblProductFlavour = new tblProductFlavour();
tblProductFlavour.id = id;
tblProductFlavour.name = name;
tblProductFlavour.IM_DateCreated = iM_DateCreated;
tblProductFlavour.IM_DateLastUpdated = iM_DateLastUpdated;
tblProductFlavour.IM_Status = iM_Status;
return tblProductFlavour;
}
private tblProductFlavour GetProductFlavour(string itemName,tblProductBrand brand)
{
using (var ctx = new CokeDataContext(Con))
{
tblProductFlavour pitem = null;
if (!string.IsNullOrEmpty(itemName))
{
pitem = ctx
.tblProductFlavour.FirstOrDefault(
p =>
p.name.ToLower() == itemName.ToLower() ||
p.code != null &&
p.code.ToLower() == itemName.ToLower()) ?? ctx.tblProductFlavour.FirstOrDefault(
p => p.name.ToLower() == "default");
}
if(pitem==null)
{
var date = DateTime.Now;
pitem = new tblProductFlavour()
{
BrandId = brand.id,
id = Guid.NewGuid(),
code = string.IsNullOrEmpty(itemName) ? "default" : itemName,
description = string.IsNullOrEmpty(itemName) ? "default" : itemName,
IM_DateCreated = date,
IM_DateLastUpdated = date,
name = string.IsNullOrEmpty(itemName) ? "default" : itemName,
};
ctx.tblProductFlavour.AddObject(pitem);
ctx.SaveChanges();
}
return pitem;
}
}