private void FixupD_ATTRIBUTE(D_ATTRIBUTE previousValue)
{
if (previousValue != null && previousValue.D_ATTRIBUTE_VALUE.Contains(this))
{
previousValue.D_ATTRIBUTE_VALUE.Remove(this);
}
if (D_ATTRIBUTE != null)
{
if (!D_ATTRIBUTE.D_ATTRIBUTE_VALUE.Contains(this))
{
D_ATTRIBUTE.D_ATTRIBUTE_VALUE.Add(this);
}
if (AttributeID != D_ATTRIBUTE.ID)
{
AttributeID = D_ATTRIBUTE.ID;
}
}
}
public List<D_ATTRIBUTE> Search(D_ATTRIBUTE Attribute, int PageSize, int PageIndex, out int TotalRecords, string OrderExp, SortDirection SortDirection)
{
var result = Context.D_ATTRIBUTE.AsQueryable();
if (Attribute != null)
{
if (!String.IsNullOrWhiteSpace(Attribute.Name))
{
result = result.Where(p => p.Name.Contains(Attribute.Name));
}
}
TotalRecords = result.Count();
GenericSorterCaller<D_ATTRIBUTE> sorter = new GenericSorterCaller<D_ATTRIBUTE>();
result = sorter.Sort(result, String.IsNullOrEmpty(OrderExp) ? "Name" : OrderExp, SortDirection);
result = result.Skip(PageIndex * PageSize).Take(PageSize);
var SQL = (result as ObjectQuery).ToTraceString();
return result.ToList();
}
private void FixupD_ATTRIBUTE(D_ATTRIBUTE previousValue)
{
if (previousValue != null && previousValue.CATEGORY.Contains(this))
{
previousValue.CATEGORY.Remove(this);
}
if (D_ATTRIBUTE != null)
{
if (!D_ATTRIBUTE.CATEGORY.Contains(this))
{
D_ATTRIBUTE.CATEGORY.Add(this);
}
if (AttributeID != D_ATTRIBUTE.ID)
{
AttributeID = D_ATTRIBUTE.ID;
}
}
else if (!_settingFK)
{
AttributeID = null;
}
}
private void FixupD_ATTRIBUTE(D_ATTRIBUTE previousValue)
{
if (previousValue != null && previousValue.CATEGORY.Contains(this))
{
previousValue.CATEGORY.Remove(this);
}
if (D_ATTRIBUTE != null)
{
if (!D_ATTRIBUTE.CATEGORY.Contains(this))
{
D_ATTRIBUTE.CATEGORY.Add(this);
}
if (AttributeID != D_ATTRIBUTE.ID)
{
AttributeID = D_ATTRIBUTE.ID;
}
}
else if (!_settingFK)
{
AttributeID = null;
}
}
public void Delete(D_ATTRIBUTE Entity)
{
_attributeDAO.Delete(Entity);
Context.SaveChanges();
}
public void Insert(D_ATTRIBUTE Entity)
{
_attributeDAO.Insert(Entity);
Context.SaveChanges();
}
public List<D_ATTRIBUTE> Search(D_ATTRIBUTE Entity, int PageSize, int PageIndex, out int TotalRecords, string OrderExp, Util.SortDirection SortDirection)
{
return _attributeDAO.Search(Entity, PageSize, PageIndex, out TotalRecords, OrderExp, SortDirection);
}
private void FixupD_ATTRIBUTE(D_ATTRIBUTE previousValue)
{
if (previousValue != null && previousValue.D_ATTRIBUTE_VALUE.Contains(this))
{
previousValue.D_ATTRIBUTE_VALUE.Remove(this);
}
if (D_ATTRIBUTE != null)
{
if (!D_ATTRIBUTE.D_ATTRIBUTE_VALUE.Contains(this))
{
D_ATTRIBUTE.D_ATTRIBUTE_VALUE.Add(this);
}
if (AttributeID != D_ATTRIBUTE.ID)
{
AttributeID = D_ATTRIBUTE.ID;
}
}
}
public void DeleteById(int id)
{
D_ATTRIBUTE obj = new D_ATTRIBUTE() { ID = id };
Delete(obj);
}
public void Update(D_ATTRIBUTE Attribute)
{
Context.D_ATTRIBUTE.Attach(Attribute);
Context.ObjectStateManager.ChangeObjectState(Attribute, EntityState.Modified);
//Context.SaveChanges();
}
public void Delete(D_ATTRIBUTE Attribute)
{
Context.D_ATTRIBUTE.Attach(Attribute);
Context.D_ATTRIBUTE.DeleteObject(Attribute);
//Context.SaveChanges();
}
public void Insert(D_ATTRIBUTE Attribute)
{
Context.D_ATTRIBUTE.AddObject(Attribute);
//Context.SaveChanges();
}
