public void Init()
{
var db = new CdnLinkDataContext(Settings.GetConnectionString());
db.CdnSendVehicles.DeleteAllOnSubmit(db.CdnSendVehicles);
db.SubmitChanges();
db.CdnSends.DeleteAllOnSubmit(db.CdnSends);
db.SubmitChanges();
db.CdnSendLoads.DeleteAllOnSubmit(db.CdnSendLoads);
db.SubmitChanges();
}
public void Init()
{
var db = new CdnLinkDataContext(Settings.GetConnectionString());
db.CdnSendVehicles.DeleteAllOnSubmit(db.CdnSendVehicles);
db.SubmitChanges();
db.CdnSends.DeleteAllOnSubmit(db.CdnSends);
db.SubmitChanges();
db.CdnSendLoads.DeleteAllOnSubmit(db.CdnSendLoads);
db.SubmitChanges();
}
public void Init()
{
var db = new CdnLinkDataContext(Settings.GetConnectionString());
db.CdnReceivedDamages.DeleteAllOnSubmit(db.CdnReceivedDamages);
db.SubmitChanges();
db.CdnReceivedVehicles.DeleteAllOnSubmit(db.CdnReceivedVehicles);
db.SubmitChanges();
db.CdnReceivedDocuments.DeleteAllOnSubmit(db.CdnReceivedDocuments);
db.SubmitChanges();
db.CdnReceives.DeleteAllOnSubmit(db.CdnReceives);
db.SubmitChanges();
db.CdnReceivedLoads.DeleteAllOnSubmit(db.CdnReceivedLoads);
db.SubmitChanges();
db.CdnReceivedFtpFiles.DeleteAllOnSubmit(db.CdnReceivedFtpFiles);
db.SubmitChanges();
}
public void Init()
{
var db = new CdnLinkDataContext(Settings.GetConnectionString());
db.CdnReceivedDamages.DeleteAllOnSubmit(db.CdnReceivedDamages);
db.SubmitChanges();
db.CdnReceivedVehicles.DeleteAllOnSubmit(db.CdnReceivedVehicles);
db.SubmitChanges();
db.CdnReceivedDocuments.DeleteAllOnSubmit(db.CdnReceivedDocuments);
db.SubmitChanges();
db.CdnReceives.DeleteAllOnSubmit(db.CdnReceives);
db.SubmitChanges();
db.CdnReceivedLoads.DeleteAllOnSubmit(db.CdnReceivedLoads);
db.SubmitChanges();
db.CdnReceivedFtpFiles.DeleteAllOnSubmit(db.CdnReceivedFtpFiles);
db.SubmitChanges();
}
public int Send()
{
var db = new CdnLinkDataContext(ConnectionString);
var sends = from send in db.CdnSends
where send.Status == (int)CdnSend.SendStatus.Queued
select send;
var sendCount = sends.Count();
Log.InfoFormat("Send: Processing {0} record{1}.", sendCount, sendCount == 1 ? "" : "s");
if (sendCount > 0)
{
foreach (var send in sends)
{
try
{
// Set the send as in process
send.ProcessingDate = DateTime.Now;
send.Status = (int)CdnSend.SendStatus.Processing;
db.SubmitChanges();
// Get the job and set it's prefixed LoadId prior to send
var theJob = send.CdnSendLoad.ToCdnJob();
theJob.LoadId = PrepareApiForSend(send);
switch (send.Action)
{
case null:
case (int)CdnSend.SendAction.Create:
Log.InfoFormat("Creating Job with LoadId: {0} ...", theJob.LoadId ?? "");
var createdJob = Api.CreateJob(theJob);
if (createdJob != null)
{
Log.InfoFormat("Created Job with LoadId: {0} ({1})", theJob.LoadId ?? "", createdJob.JobNumber);
}
break;
case (int)CdnSend.SendAction.Cancel:
Log.InfoFormat("Cancelling Job with LoadId: {0} ...", theJob.LoadId ?? "");
Api.CancelJob(theJob.LoadId, send.ActionMessage);
break;
case (int)CdnSend.SendAction.Update:
Log.InfoFormat("Updating Job with LoadId: {0} ...", theJob.LoadId ?? "");
Api.UpdateJob(theJob.LoadId, theJob);
break;
default:
throw new ArgumentException(string.Format("Action {0} is not supported", send.Action), "Action");
}
// Set the send as sent
send.SentDate = DateTime.Now;
send.Status = (int)CdnSend.SendStatus.Sent;
}
catch (HttpResourceFaultException ex)
{
send.SetAsError(ex.Message, ex.StatusCode.ToString());
throw;
}
catch (Exception ex)
{
send.SetAsError(ex.Message);
throw;
}
finally
{
db.SubmitChanges();
}
}
}
return(sendCount);
}
public int Receive()
{
var files = FtpBox.GetFileList();
var fileCount = files.Count;
Log.InfoFormat("Receive: Processing {0} file{1}.", fileCount, fileCount == 1 ? "" : "s");
if (fileCount > 0)
{
var db = new CdnLinkDataContext(ConnectionString);
var index = 1;
foreach (var file in files.ToArray())
{
Log.DebugFormat("Receive: Checking file {0} for already processed.", file);
var seenFile = db.CdnReceivedFtpFiles.Count(f => f.Filename.Contains(file)) > 0;
if (!seenFile)
{
Log.InfoFormat("Receive: Processing file {0} of {1}: {2}", index++, fileCount, file);
var json = FtpBox.GetFileContents(file);
var job = Job.FromString(json);
if (job == null)
{
throw new Exception(string.Format("JSON produced a null job: {0}", json));
}
// Check that this isn't a test hook message generated by CDN
if (job.Id != -1)
{
// If we have a loadId prefix, strip it now
job.LoadId = StripLoadIdPrefix(job.LoadId);
var receivedFile = new CdnReceivedFtpFile
{
Filename = file,
JsonMessage = json,
CdnReceive = new CdnReceive
{
FetchedDate = DateTime.Now,
Status = (int)CdnReceive.ReceiveStatus.Processing
}
};
db.CdnReceivedFtpFiles.InsertOnSubmit(receivedFile);
db.SubmitChanges();
try
{
Log.Debug("Receive: Setting the received load");
receivedFile.CdnReceivedLoads.Add(new CdnReceivedLoad(job));
receivedFile.CdnReceive.Status = (int)CdnReceive.ReceiveStatus.Queued;
db.SubmitChanges();
Log.Debug("Receive: Done.");
}
catch (Exception ex)
{
Log.Debug("Receive: Error: Writing error info to DB...");
receivedFile.CdnReceive.SetAsError(ex.Message);
db.SubmitChanges();
throw;
}
}
}
else
{
Log.DebugFormat("Receive: File {0} was already processed. Skipping.", file);
}
// Delete file from FTP server
Log.DebugFormat("Receive: Deleting FTP file: {0} ...", file);
FtpBox.DeleteFile(file);
Log.DebugFormat("Receive: Deleting FTP file: {0} succeeded.", file);
}
}
return(fileCount);
}