public bool Insert(Files file) { using (FCNDBContext.DataAccessLayer.FCNDBContext context = new FCNDBContext.DataAccessLayer.FCNDBContext("SQLServerDBString")) { return(Insert(file, context)); } }
public int Insert(Check check) { using (FCNDBContext.DataAccessLayer.FCNDBContext context = new FCNDBContext.DataAccessLayer.FCNDBContext("SQLServerDBString")) { return(Insert(check, context)); } }
public async Task <bool> UpdateAsync(Files file) { using (FCNDBContext.DataAccessLayer.FCNDBContext context = new FCNDBContext.DataAccessLayer.FCNDBContext("SQLServerDBString")) { return(await UpdateAsync(file, context)); } }
public int GetSequence() { using (FCNDBContext.DataAccessLayer.FCNDBContext context = new FCNDBContext.DataAccessLayer.FCNDBContext("SQLServerDBString")) { return(GetSequence(context)); } }
public bool Update(Files file, FCNDBContext.DataAccessLayer.FCNDBContext context) { if (context == null) { return(false); } context.PDFFiles.Attach(file); context.Entry(file).Property(p => p.ModifyDate).IsModified = true; context.Entry(file).Property(p => p.Size).IsModified = true; context.Entry(file).Property(p => p.Size_Abbreviation).IsModified = true; context.Entry(file).Property(p => p.IsValid).IsModified = true; try { int amount = context.SaveChanges(); if (amount == 1) { return(true); } } catch (Exception ex) { return(false); } return(false); }
public int GetSequence(FCNDBContext.DataAccessLayer.FCNDBContext context) { try { int maxId = context.Set <Check>().Max(p => p.ID); return(maxId); } catch { return(-1); } }
public bool UpdateWithoutCommit(Files file, FCNDBContext.DataAccessLayer.FCNDBContext context) { if (context == null) { return(false); } context.PDFFiles.Attach(file); context.Entry(file).Property(p => p.ModifyDate).IsModified = true; context.Entry(file).Property(p => p.Size).IsModified = true; context.Entry(file).Property(p => p.Size_Abbreviation).IsModified = true; context.Entry(file).Property(p => p.IsValid).IsModified = true; return(true); }
public int Insert(string CheckDir, FCNDBContext.DataAccessLayer.FCNDBContext context) { if (context == null) { return(-1); } Check check = new Check(); check.CreateDate = System.DateTime.Now; check.CheckDirectory = CheckDir; check.Name = System.DateTime.Now.ToString("yyyyMMdd_HHmmdd.sss"); return(Insert(check, context)); }
public bool Update(Check check, FCNDBContext.DataAccessLayer.FCNDBContext context) { if (context == null) { return(false); } check.CreateDate = DateTime.Now;// no effect, but måste do it context.PDFCheck.Attach(check); context.Entry(check).Property(p => p.CheckDirectory).IsModified = true; context.Entry(check).Property(p => p.Total).IsModified = true; context.Entry(check).Property(p => p.Valid).IsModified = true; context.Entry(check).Property(p => p.Invalid).IsModified = true; return(SaveChange(context)); }
public bool InsertWithoutCommit(Files file, FCNDBContext.DataAccessLayer.FCNDBContext context) { try { if (context == null) { return(false); } context.PDFFiles.Add(file); return(true); } catch (Exception ex) { return(false); } }
public int Insert(Check check, FCNDBContext.DataAccessLayer.FCNDBContext context) { if (context == null) { return(-1); } context.PDFCheck.Add(check); try { int amount = context.SaveChanges(); return(amount); } catch (Exception ex) { return(-1); } }
public bool SaveChange(FCNDBContext.DataAccessLayer.FCNDBContext context) { if (context == null) { return(false); } try { int amount = context.SaveChanges(); if (amount >= 1) { return(true); } } catch (Exception ex) { return(false); } return(false); }
public async Task <bool> SaveChangeAsync(FCNDBContext.DataAccessLayer.FCNDBContext context) { if (context == null) { return(false); } try { int amount = await context.SaveChangesAsync(); if (amount >= 1) { return(true); } } catch (Exception ex) { return(false); } return(false); }
public bool Insert(Files file, FCNDBContext.DataAccessLayer.FCNDBContext context) { if (context == null) { return(false); } context.PDFFiles.Add(file); try { int amount = context.SaveChanges(); if (amount == 1) { return(true); } } catch (Exception ex) { return(false); } return(false); }
public async Task <bool> UpdateAsync(Files file, FCNDBContext.DataAccessLayer.FCNDBContext context) { if (context == null) { return(false); } context.PDFFiles.Attach(file); try { int amount = await context.SaveChangesAsync(); if (amount == 1) { return(true); } } catch { return(false); } return(false); }
public Files GetFileByFullName(int CheckID, string FullName, FCNDBContext.DataAccessLayer.FCNDBContext context) { return(context.Set <Files>().First(item => item.FileFullName == FullName && item.CheckID == CheckID)); }
public Check GetCheckByName(string name, FCNDBContext.DataAccessLayer.FCNDBContext context) { return(context.Set <Check>().First(item => (item.Name == name))); }
public Check GetCheckByID(int checkId, FCNDBContext.DataAccessLayer.FCNDBContext context) { return(context.Set <Check>().First(item => (item.ID == checkId))); }