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