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(); }