/// <summary>
/// Create a new tblOutletCategory 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 tblOutletCategory CreatetblOutletCategory(global::System.Guid id, global::System.String name, global::System.DateTime iM_DateCreated, global::System.DateTime iM_DateLastUpdated, global::System.Int32 iM_Status)
{
tblOutletCategory tblOutletCategory = new tblOutletCategory();
tblOutletCategory.id = id;
tblOutletCategory.Name = name;
tblOutletCategory.IM_DateCreated = iM_DateCreated;
tblOutletCategory.IM_DateLastUpdated = iM_DateLastUpdated;
tblOutletCategory.IM_Status = iM_Status;
return tblOutletCategory;
}
/// <summary>
/// Deprecated Method for adding a new object to the tblOutletCategory EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotblOutletCategory(tblOutletCategory tblOutletCategory)
{
base.AddObject("tblOutletCategory", tblOutletCategory);
}
private tblOutletCategory GetOutletCategory(string outletcategorycode)
{
using (var ctx = new CokeDataContext(Con))
{
tblOutletCategory outletcategory = null;
if (!string.IsNullOrEmpty(outletcategorycode))
{
outletcategory = ctx
.tblOutletCategory.FirstOrDefault(
p => p.Code != null &&
p.Code.ToLower() == outletcategorycode.ToLower() ||
p.Name != null && p.Name.ToLower() == outletcategorycode.ToLower());
}
if (outletcategory == null)
outletcategory = ctx.tblOutletCategory.FirstOrDefault(p => p.Code == "default");
if (outletcategory == null)
{
var item = new tblOutletCategory()
{
Code = "default",
Name = "default",
id = Guid.NewGuid(),
Description = "default",
IM_DateCreated = DateTime.Now,
IM_DateLastUpdated = DateTime.Now,
IM_Status = (int)EntityStatus.Active
};
ctx.tblOutletCategory.AddObject(item);
ctx.SaveChanges();
}
return outletcategory;
}
}