public static void KWSLogKFileActivity(FileActivity_UpdateModel activityUpdateModel) { var genericInfo = new { FileType = activityUpdateModel.WsFileType.ToString(), FileIn = activityUpdateModel.FileIn.ToString(), FileUniqueId = activityUpdateModel.FileUniqueId, NonAuditFlag = activityUpdateModel.NonAuditFlag, IsPage_Act = activityUpdateModel.IsPage_Act, }; var info = new { GenericInfo = JsonConvert.SerializeObject(genericInfo), }; var serInfo = JsonConvert.SerializeObject(info); using (var client = new WebClient()) { client.UseDefaultCredentials = true; var values = new NameValueCollection { { "EngNum", activityUpdateModel.EngNum }, { "FileNum", activityUpdateModel.FileNum.ToString() }, { "KFileActivityType", activityUpdateModel.WsActivityType.ToString().Replace("Activity_", "") }, { "Comment", activityUpdateModel.Comment }, { "Info", serInfo }, }; var result = client.UploadValues(string.Format("{0}{1}KWSLogKFileActivity", ConfigUtility.GetKWebAppBaseUrl, LogController), values); // TODO: do something with the results returned by the controller action } }
public string PostUpdateFileActivity([FromBody] FileActivity_UpdateModel activityUpdateModel) { //return "Activity-In-Progress"; var result = AuditManager.Rep.WsActivity.UpdateFileActivity(activityUpdateModel); ExtApi.KWSLogKFileActivity(activityUpdateModel); return(result ?? "Activity-In-Progress"); //return "Acknowledged"; //var result = AuditManager.Rep.WsActivity.UpdateFileActivity(activityUpdateModel); //var retModel = JArray.FromObject(result); //return retModel; }
public static string UpdateFileActivity(FileActivity_UpdateModel activityUpdateModel) { string returnStatus = null; if (activityUpdateModel.FileIn == FileIn.S2) { using (var db = new S2DbContext()) { if (activityUpdateModel.WsActivityType == WsActivityType.Activity_Reprocess) { WsActivity.CallEmailActivities("RepreocessServer2RETFile", "ReprocessRequested_14", activityUpdateModel.FileUniqueId, 0, activityUpdateModel.Comment); } if (activityUpdateModel.WsActivityType == WsActivityType.Activity_Acknowledge && activityUpdateModel.NonAuditFlag.HasValue ? activityUpdateModel.NonAuditFlag.Value : false) { var relatedEngFiles = WsOperation.GetRelated_S2_YrEnd_Audit_EngDoc_Num(activityUpdateModel.FileNum); relatedEngFiles.ForEach(x => Workspace.Move_YrEnd_Audit_RET_N_ENG_To_ElecWp(activityUpdateModel.FileNum, x, activityUpdateModel.EngNum)); } SqlParameter p1 = new SqlParameter("@WorkbookReviewId", activityUpdateModel.FileUniqueId); SqlParameter p2 = new SqlParameter("@Status", (activityUpdateModel.WsActivityType == WsActivityType.Activity_Acknowledge) ? "Acknowledged" : "Removed"); SqlParameter p3 = new SqlParameter("@UpdatedBy", string.IsNullOrWhiteSpace(activityUpdateModel.logAs) ? AmUtil.GetCurrentUser : activityUpdateModel.logAs); SqlParameter p4; if (activityUpdateModel.NonAuditFlag.HasValue) { p4 = new SqlParameter("@NonAuditFlag", activityUpdateModel.NonAuditFlag.Value); } else { p4 = new SqlParameter("@NonAuditFlag", DBNull.Value); } SqlParameter p5 = new SqlParameter("@docNum", activityUpdateModel.FileNum); db.Database.ExecuteSqlCommand("EXEC [S2CLR].spUpdateReviewStatus @WorkbookReviewId, @Status, @UpdatedBy, @NonAuditFlag, @docNum", p1, p2, p3, p4, p5); } var docStatus = AuditManager.Rep.Workspace.GetFileStatus_S2(new List <int> { (int)activityUpdateModel.FileNum }); returnStatus = docStatus.FirstOrDefault().Status; } else if (activityUpdateModel.FileIn == FileIn.SSC) { if (activityUpdateModel.WsActivityType == WsActivityType.Activity_Acknowledge || activityUpdateModel.WsActivityType == WsActivityType.Activity_Reprocess) { using (var db = new SSCDbContext()) { SqlParameter p1 = new SqlParameter("@FAId", activityUpdateModel.FileUniqueId); SqlParameter p2 = new SqlParameter("@success", (activityUpdateModel.WsActivityType == WsActivityType.Activity_Acknowledge)); SqlParameter p3; if (string.IsNullOrWhiteSpace(activityUpdateModel.Comment)) { p3 = new SqlParameter("@comments", DBNull.Value); } else { p3 = new SqlParameter("@comments", activityUpdateModel.Comment); } SqlParameter p4 = new SqlParameter("@activityEndDate", DateTime.Now.ToUniversalTime()); SqlParameter p5 = new SqlParameter("@userId", string.IsNullOrWhiteSpace(activityUpdateModel.logAs) ? AmUtil.GetCurrentUser : activityUpdateModel.logAs); SqlParameter p6 = new SqlParameter("@docNum", activityUpdateModel.FileNum); db.Database.ExecuteSqlCommand("spCloseActivity @FAId, @success, @comments, @activityEndDate, @userId", p1, p2, p3, p4, p5); } } else if (activityUpdateModel.WsActivityType == WsActivityType.Activity_Remove) { using (var db = new SSCDbContext()) { SqlParameter p1 = new SqlParameter("@FAId", activityUpdateModel.FileUniqueId); SqlParameter p2; if (string.IsNullOrWhiteSpace(activityUpdateModel.Comment)) { p2 = new SqlParameter("@comments", DBNull.Value); } else { p2 = new SqlParameter("@comments", activityUpdateModel.Comment); } SqlParameter p3 = new SqlParameter("@userId", string.IsNullOrWhiteSpace(activityUpdateModel.logAs) ? AmUtil.GetCurrentUser : activityUpdateModel.logAs); SqlParameter p4 = new SqlParameter("@docNum", activityUpdateModel.FileNum); db.Database.ExecuteSqlCommand("spRemoveActivity @FAId, @comments, @userId", p1, p2, p3); } } var docStatus = AuditManager.Rep.Workspace.GetFileStatus_SSC(new List <int> { (int)activityUpdateModel.FileNum }); returnStatus = docStatus.FirstOrDefault().Status; } IM.Mgr.WsUtility.SaveActivityInfo(activityUpdateModel, returnStatus); return(returnStatus); }