void SaveAbandonedReason(zfcs_nsiAbandonedReasonType[] nsiAbandonedReason) { using (var db = _govDb.GetContext()) { foreach (var ar in nsiAbandonedReason) { NsiAbandonedReason NsiAReason = new NsiAbandonedReason() { Code = ar.code, Name = ar.name, docType = JsonConvert.SerializeObject(ar.docType), objectName = ar.objectName, PlacingWay = JsonConvert.SerializeObject(ar.placingWay), Type = ar.type.ToString(), Fz_type = FLType.Fl44, Actual = ar.actual, OosId = ar.id }; try { var find = db.NsiAReasons.Where(x => x.Code == NsiAReason.Code && x.OosId == ar.id && x.Fz_type == FLType.Fl44).FirstOrDefault(); if (find == null) { db.NsiAReasons.Add(NsiAReason); db.SaveChanges(); } else { //find.objectName = NsiAReason.objectName; find.Actual = NsiAReason.Actual; //find.docType= NsiAReason.docType; //find.objectName = NsiAReason.objectName; db.NsiAReasons.Update(find); db.SaveChanges(); } } catch (Exception ex) { _logger.LogError(ex, ex.Message); } } } }
bool GetDBfile(string FullPath) { NsiFileCashes find = null; using (var db = _govDb.GetContext()) { find = db.NsiFileCashes .AsNoTracking() .Where(x => x.Full_path == FullPath) .OrderByDescending(x => x.Date) .FirstOrDefault(); } if (find == null) { return(false); } else { return(true); } }
private void SavePath(FileCashes item) { try { using (var db = _govDb.GetContext()) { db.FileCashes.Add(item); db.SaveChanges(); } } catch (Exception ex) { _logger.LogError(ex, ex.Message); } }
/// <summary> /// Получение списка файлов из кэша. /// </summary> /// <param name="lim"></param> /// <param name="status"></param> /// <param name="fz_type"></param> /// <param name="basepath"></param> /// <param name="dirtype"></param> /// <returns></returns> public List <NsiFileCashes> GetNsiDBList(int lim, Status status, FLType fz_type, string basepath, string dirtype) { //throw new NotImplementedException(); List <NsiFileCashes> data = new List <NsiFileCashes>(); using (var db = _govDb.GetContext()) { data = db.NsiFileCashes .AsNoTracking() .Where(x => x.Status == status && x.Fz_type == fz_type && x.BaseDir == basepath && x.Dirtype == dirtype) .OrderBy(x => x.Date) //.OrderByDescending(x => x.Date) .Take(lim) .ToList(); } return(data); }