/// <summary> /// Create a new ProductionJobAttachment object. /// </summary> /// <param name="id">Initial value of the ID property.</param> /// <param name="jobID">Initial value of the JobID property.</param> public static ProductionJobAttachment CreateProductionJobAttachment(global::System.Decimal id, global::System.Decimal jobID) { ProductionJobAttachment productionJobAttachment = new ProductionJobAttachment(); productionJobAttachment.ID = id; productionJobAttachment.JobID = jobID; return productionJobAttachment; }
protected void UpdateJobAttachments(ProductionJob editJob, FileAttacher attacher) { if (attacher != null) { List<string> delIDS = attacher.DelFileIDs(); if (delIDS.IsAny()) { string sql = "DELETE FROM FG_PRDN_JOB_ATTACHMENT WHERE FG_PRDN_JOB_ATT_ID IN (" + PrdnDataHelper.ParmFormatList(delIDS.Count()) + ")"; PrdnDBContext.ExecuteStoreCommand(sql, delIDS.Cast<object>().ToArray()); } if (attacher.NotNullAny(a => a.ExtantFiles)) { foreach (var dbFile in attacher.ExtantFiles) { var mods = editJob.Attachments.Where(a => (a.ID == dbFile.DecimalID) && ((a.AttachmentTypeID != dbFile.AttTypeID) && (dbFile.AttTypeID != null) || a.Description != dbFile.Description) ); foreach (var modFile in mods) { modFile.AttachmentTypeID = (decimal)dbFile.AttTypeID; modFile.Description = dbFile.Description; } } }; if (attacher.NotNullAny(a => a.CachedFiles)) { foreach (var newFile in attacher.CachedFiles) { CST.Prdn.Data.ProductionJobAttachment newAttachment = new CST.Prdn.Data.ProductionJobAttachment { //JobID = editJob.ID, FileName = newFile.FileName, MimeType = newFile.MimeType, Description = newFile.Description, Attachment = newFile.FileData }; if (newFile.AttTypeID != null) { newAttachment.AttachmentTypeID = (decimal)newFile.AttTypeID; } editJob.Attachments.Add(newAttachment); } } } }
/// <summary> /// Deprecated Method for adding a new object to the ProductionJobAttachments EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToProductionJobAttachments(ProductionJobAttachment productionJobAttachment) { base.AddObject("ProductionJobAttachments", productionJobAttachment); }
//[HttpPost] //public ActionResult RequestRun() //{ // RequestScheduleViewModel model = null; // if (TryValidateModel(model)) { // return RedirectToAction(actionName: model.RouteAction, controllerName: model.RouteController, // routeValues: new // { // requestID = model.RequestID, // urlReturn = model.UrlReturn, // runID = model.RunID // }); // } // else { // model.LookupRunModel = new PrdnRunLookupModel(); // model.NewRunModel = new NewPrdnRunViewModel(Session, model.RouteController, model.RouteAction, // new RequestCreateRunActionParm { RequestID = model.RequestID, UrlReturn = model.UrlReturn }); // return View(model); // } //} protected void UpdateScheduledRequest(EditPrdnJobViewModel newViewJob, ProductionJob job) { if (job.CstRequestID == null) { return; } var request = (from r in PrdnDBContext.Requests where r.ID == job.CstRequestID select r).FirstOrDefault(); if (request != null) { CST.Prdn.Data.ProductionJobAttachment newAttachment = null; request.Status = RequestStatus.SCHEDULED; request.ScheduledJobID = job.ID; request.ScheduledDt = DateTime.Now; request.ScheduledUserID = GetCurrentUserID(); var reqAtt = (from a in PrdnDBContext.RequestAttachments where a.ID == job.CstRequestID && a.Attachment != null select new { a.ID, a.FileName, MimeContentType = a.MimeType.ContentType, MimeSubType = a.MimeTypeCD, a.MimeType, }).FirstOrDefault(); if (reqAtt != null) { string requestAttachmentTypeID = WebConfigurationManager.AppSettings["RequestAttachmentTypeID"]; decimal attTypeID = Convert.ToDecimal(requestAttachmentTypeID); newAttachment = new CST.Prdn.Data.ProductionJobAttachment { //JobID = editJob.ID, FileName = reqAtt.FileName, MimeType = CST.ISIS.Data.Attachment.ConcatMimeType(reqAtt.MimeContentType, reqAtt.MimeSubType), Description = "Original Request Attachment", Attachment = null, AttachmentTypeID = attTypeID }; job.Attachments.Add(newAttachment); } PrdnDBContext.SaveChanges(); if (newAttachment != null) { PrdnDBContext.ExecuteStoreCommand( @"UPDATE FG_PRDN_JOB_ATTACHMENT J SET J.FG_ATTACH_DATA = (SELECT R.FG_ATTACHMENT FROM FG_REQ_PART R WHERE R.FG_REQUEST_ID = :p0) WHERE J.FG_PRDN_JOB_ATT_ID = :p1" , reqAtt.ID, newAttachment.ID); } } }