public List <UploadTracking> GetUploadedFiles(string machineName, string filePath)
{
List <UploadTracking> data = new List <UploadTracking>();
using (var dbContext = new imageuploaderEntities())
{
data = dbContext.GetUploadedFiles(machineName, filePath).Select
(
d => new UploadTracking
{
EndTimeUtc = d.EndTimeUtc,
ErrorMessage = d.ErrorMessage,
FileName = d.FileName,
Id = d.Id,
MachineName = d.MachineName,
SourceMachineName = d.SourceMachineName,
StartTimeUtc = d.StartTimeUtc,
Status = d.Status,
UploadEndPoint = d.UploadEndPoint,
FileCreationTimeUtc = d.FileCreationTimeUtc
}
).ToList();
}
return(data);
}
public void Update(List <UploadTracking> infoList)
{
using (var dbContext = new imageuploaderEntities())
{
foreach (var info in infoList)
{
var existing = dbContext.UploadTrackings.Where(i => i.Id == info.Id).FirstOrDefault();
if (existing == null)
{
dbContext.UploadTrackings.Add(new UploadTracking
{
Id = info.Id,
EndTimeUtc = info.EndTimeUtc,
ErrorMessage = info.ErrorMessage,
FileName = info.FileName,
MachineName = info.MachineName,
SourceMachineName = info.SourceMachineName,
StartTimeUtc = info.StartTimeUtc,
Status = info.Status,
UploadEndPoint = info.UploadEndPoint,
FileCreationTimeUtc = info.FileCreationTimeUtc,
IsRetake = info.IsRetake
});
}
else
{
existing.EndTimeUtc = info.EndTimeUtc;
existing.ErrorMessage = info.ErrorMessage;
existing.FileName = info.FileName;
existing.SourceMachineName = info.SourceMachineName;
existing.MachineName = info.MachineName;
existing.StartTimeUtc = info.StartTimeUtc;
existing.Status = info.Status;
existing.UploadEndPoint = info.UploadEndPoint;
existing.FileCreationTimeUtc = info.FileCreationTimeUtc;
existing.IsRetake = info.IsRetake;
}
}
dbContext.SaveChanges();
}
}
