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