public void DeleteById(int id)
{
D_ATTRIBUTE obj = new D_ATTRIBUTE()
{
ID = id
};
Delete(obj);
}
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());
}
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));
}
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();
}
public D_ATTRIBUTE GetById(int Id)
{
D_ATTRIBUTE attribute = Context.D_ATTRIBUTE.Include("D_ATTRIBUTE_VALUE").Where(a => a.ID == Id).FirstOrDefault();
return(attribute);
}
