public static void Delete1(long id)
{
tblLogItem item = CurrDBContext.Get().tblLogItem.Where(x => x.Id == id).SingleOrDefault();
CurrDBContext.Get().tblLogItem.Remove(item);
CurrDBContext.Get().SaveChanges();
}
//private static IQueryable<tblLogItem> HasID(this IQueryable<tblLogItem> query, IFilterItem fi)
//{
// switch (fi.ItemType)
// {
// case enFilterItemTypes.SingleValue:
// var query1 = query.Where( x => x.)
// break;
// case enFilterItemTypes.RangeOfValues:
// break;
// case enFilterItemTypes.ListOfValues:
// break;
// default:
// throw new Exception("Wrong enFilterItemTypes value in LogItemTools.ReadWithFilterAndSort() !");
// }
// return id.HasValue ? query.Where(o => i.ID.Equals(id.Value)) : query;
//}
//public static ResponseRowsRange<LogItem> ReadWithFilterAndSort(
// List<IFilterItem> filterItemsList, List<String> sortingFields, RequestRowsRange range )
//{
// if (range.RowsCount > Constants.MaxListSize)
// {
// throw new Exception("Maximum list size is exceeded in LogItemTools.ReadWithFilter() !");
// }
// IQueryable<tblLogItem> query = CurrDBContext.Get().tblLogItem;
// foreach (IFilterItem currItem in filterItemsList)
// {
// switch( currItem.ItemType )
// {
// case enFilterItemTypes.SingleValue:
// var query1 = query.
// break;
// case enFilterItemTypes.RangeOfValues:
// break;
// case enFilterItemTypes.ListOfValues:
// break;
// default:
// throw new Exception("Wrong enFilterItemTypes value in LogItemTools.ReadWithFilterAndSort() !");
// }
// var query = query.Where
// }
// List<LogItem> result = CurrDBContext.Get().tblLogItem.Where(x => idList.Contains(x.Id)).
// Select
// (
// x =>
// new LogItem
// (
// x.Id,
// x.DateTime,
// x.Value,
// x.Comment,
// x.ApplicationId,
// x.LayerId,
// x.SubsystemId,
// x.MethodId,
// x.MethodName,
// x.StringNumber,
// x.SystemInfoId,
// x.ExceptionInfoId
// )
// ).ToList();
// return result;
//}
public static void Update1(LogItem item)
{
tblLogItem dataItem = CurrDBContext.Get().tblLogItem.Where(x => x.Id == item.Id).Single();
dataItem.Id = item.Id;
dataItem.DateTime = item.DateTime;
dataItem.Value = item.Value;
dataItem.Comment = item.Comment;
dataItem.ApplicationId = item.ApplicationId;
dataItem.LayerId = item.LayerId;
dataItem.SubsystemId = item.SubsystemId;
dataItem.MethodId = item.MethodId;
dataItem.MethodName = item.MethodName;
dataItem.StringNumber = item.StringNumber;
dataItem.SystemInfoId = item.SystemInfoId;
dataItem.ExceptionInfoId = item.ExceptionInfoId;
CurrDBContext.Get().SaveChanges();
}
public static void Create1(LogItem item)
{
tblLogItem currItem = new tblLogItem
{
DateTime = item.DateTime,
Value = item.Value,
Comment = item.Comment,
ApplicationId = item.ApplicationId,
LayerId = item.LayerId,
SubsystemId = item.SubsystemId,
MethodId = item.MethodId,
MethodName = item.MethodName,
StringNumber = item.StringNumber,
SystemInfoId = item.SystemInfoId,
ExceptionInfoId = item.ExceptionInfoId
};
CurrDBContext.Get().tblLogItem.Add(currItem);
CurrDBContext.Get().SaveChanges();
}
