public NAPClientPatch GetClientPatchDataById(int PatchId) { try { using (var dbContext = new NAPClientDbContext()) { return(dbContext.NAPClientPatches.FirstOrDefault(x => x.PatchScriptId == PatchId)); } } catch (Exception ex) { _log.Error(ex, "Failed to get client patch data by {0}.", PatchId); throw; } }
public IEnumerable <PatchClient.ClinentDbModel.DataModel.NAPClientPatch> GetAllClientPatchData() { try { using (var dbContext = new NAPClientDbContext()) { return(dbContext.NAPClientPatches.Select(x => x).OrderByDescending(y => y.DownloadDate)); } } catch (Exception ex) { _log.Error(ex, "Failed to get client patch data."); throw; } }
public NAPClientPatch AddClientPatchData(NAPClientPatch patchatClient) { try { using (var dbContext = new NAPClientDbContext()) { dbContext.Configuration.AutoDetectChangesEnabled = true; dbContext.Configuration.LazyLoadingEnabled = false; var result = dbContext.NAPClientPatches.Add(patchatClient); dbContext.SaveChanges(); return(result); } } catch (Exception ex) { _log.Error(ex, "Failed to get client patch data by{0}", patchatClient); throw; } }
public bool UpdateClientPatchData(NAPClientPatch patchatClient) { try { using (var dbContext = new NAPClientDbContext()) { //dbContext.Configuration.AutoDetectChangesEnabled = true; //dbContext.Configuration.LazyLoadingEnabled = false; var find = dbContext.NAPClientPatches.FirstOrDefault(x => x.PatchScriptId == patchatClient.PatchScriptId); if (find == null) { return(false); } dbContext.Set <NAPClientPatch>().AddOrUpdate(patchatClient); dbContext.SaveChanges(); return(true); } } catch (Exception ex) { _log.Error(ex, "Failed to get client patch data by{0}", patchatClient); throw; } }