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