public Guid UploadPostCodeFiles(string FileNameWPC, string FileNameLA, string FileNameCty, string FileNameLEA, string FileNameNUTS1, string FileNameWD,
string FileNamePC)
{
UploadJobQueue JobEntryToAdd = new UploadJobQueue()
{
Code = Guid.NewGuid(),
JobData = FileNameWPC + "|" + FileNameLA + "|" + FileNameCty + "|" + FileNameLEA + "|" + FileNameNUTS1 + "|" + FileNameWD + "|" + FileNamePC,
JobDescription = "PostCode update",
Status = "Waiting",
TimeAdded = DateTime.Now,
UserId = this.ServiceContext.User.Identity.Name,
};
uploadJobQueueRepository.Add(JobEntryToAdd);
Alert alertToAdd = new Alert()
{
Code = Guid.NewGuid(),
CreatedBy = this.ServiceContext.User.Identity.Name,
CreatedDate = DateTime.Now,
Name = "Alert for" + JobEntryToAdd.JobDescription,
RelatedEntityCode = JobEntryToAdd.Code,
Status = "Waiting",
Type = "Job"
};
alertRepository.Add(alertToAdd);
alertUserRepository.Add(new AlertUser()
{
Code = Guid.NewGuid(),
AlertCode = alertToAdd.Code,
UserMessageStatus = "NotRead",
UserCode = userRepository.First(x => x.Name == this.ServiceContext.User.Identity.Name).Code
});
uow.Commit();
return(JobEntryToAdd.Code);
}
public Guid UploadFile(string ProviderKeyValue, string fileType, string FileName)
{
//_xmlFileLoad = new XmlSQLBulkUploadWrapper(KeyValue, _fileType, ConnectionString,
// FileToUploadTextBox.Text, Schema, MappingSchema, _providerOrganistaionCode);
UploadJobQueue JobEntryToAdd = new UploadJobQueue()
{
Code = Guid.NewGuid(),
JobDescription = "Bulk Load|" + ProviderKeyValue + @"|Participant|C:\MyUploads\" + FileName,
Status = "Waiting",
TimeAdded = DateTime.Now,
UserId = this.ServiceContext.User.Identity.Name,
};
uploadJobQueueRepository.Add(JobEntryToAdd);
Alert alertToAdd = new Alert()
{
Code = Guid.NewGuid(),
CreatedBy = this.ServiceContext.User.Identity.Name,
CreatedDate = DateTime.Now,
Name = "Alert for" + JobEntryToAdd.JobDescription.Substring(0, JobEntryToAdd.JobDescription.LastIndexOf("|")),
RelatedEntityCode = JobEntryToAdd.Code,
Status = "Waiting",
Type = "Job"
};
alertRepository.Add(alertToAdd);
alertUserRepository.Add(new AlertUser()
{
Code = Guid.NewGuid(),
AlertCode = alertToAdd.Code,
UserMessageStatus = "NotRead",
UserCode = userRepository.First(x => x.Name == this.ServiceContext.User.Identity.Name).Code
});
uow.Commit();
return(JobEntryToAdd.Code);
}
public Guid CancelUpload(Guid InputFileHistory, string ProviderKeyValue)
{
UploadJobQueue JobEntryToAdd = new UploadJobQueue()
{
Code = Guid.NewGuid(),
JobDescription = "Clear Area|" + ProviderKeyValue + @"|Participant|" + InputFileHistory,
Status = "Waiting",
TimeAdded = DateTime.Now,
UserId = this.ServiceContext.User.Identity.Name,
};
uploadJobQueueRepository.Add(JobEntryToAdd);
Alert alertToAdd = new Alert()
{
Code = Guid.NewGuid(),
CreatedBy = this.ServiceContext.User.Identity.Name,
CreatedDate = DateTime.Now,
Name = "Alert for" + JobEntryToAdd.JobDescription.Substring(0, JobEntryToAdd.JobDescription.LastIndexOf("|")),
RelatedEntityCode = JobEntryToAdd.Code,
Status = "Waiting",
Type = "Job"
};
alertRepository.Add(alertToAdd);
alertUserRepository.Add(new AlertUser()
{
Code = Guid.NewGuid(),
AlertCode = alertToAdd.Code,
UserMessageStatus = "NotRead",
UserCode = userRepository.First(x => x.Name == this.ServiceContext.User.Identity.Name).Code
});
uow.Commit();
return(JobEntryToAdd.Code);
}
public static JobStep WithUploadJobQueue(this JobStep jobStep, UploadJobQueue uploadJobQueue)
{
jobStep.UploadJobQueue = uploadJobQueue;
return(jobStep);
}
public static UploadJobQueue WithJobData(this UploadJobQueue uploadJobQueue, String jobData)
{
uploadJobQueue.JobData = jobData;
return(uploadJobQueue);
}
public static UploadJobQueue WithJobSteps(this UploadJobQueue uploadJobQueue, ICollection <JobStep> jobSteps)
{
uploadJobQueue.JobSteps = jobSteps;
return(uploadJobQueue);
}
public static UploadJobQueue WithUserId(this UploadJobQueue uploadJobQueue, String userId)
{
uploadJobQueue.UserId = userId;
return(uploadJobQueue);
}
public static UploadJobQueue WithEndTime(this UploadJobQueue uploadJobQueue, DateTime endTime)
{
uploadJobQueue.EndTime = endTime;
return(uploadJobQueue);
}
public static UploadJobQueue WithJobDescription(this UploadJobQueue uploadJobQueue, String jobDescription)
{
uploadJobQueue.JobDescription = jobDescription;
return(uploadJobQueue);
}
public static UploadJobQueue WithTimeStarted(this UploadJobQueue uploadJobQueue, DateTime timeStarted)
{
uploadJobQueue.TimeStarted = timeStarted;
return(uploadJobQueue);
}
public static UploadJobQueue WithStatus(this UploadJobQueue uploadJobQueue, String status)
{
uploadJobQueue.Status = status;
return(uploadJobQueue);
}
public static UploadJobQueue WithPosition(this UploadJobQueue uploadJobQueue, Int32 position)
{
uploadJobQueue.Position = position;
return(uploadJobQueue);
}
public static UploadJobQueue WithCode(this UploadJobQueue uploadJobQueue, Guid code)
{
uploadJobQueue.Code = code;
return(uploadJobQueue);
}
