//spCloseClientActivity //@FAId int, //@success bit, //@comments varchar(max), //@activityEndDate datetime, //@userId varchar(50), //@newReportSuccess bit = 0, //@newReportComments varchar(max) = NULL public static void CloseClientActivity(CloseClientActivity closeClientActivity) { using (SSCTechImp.CreateInstance()) { using (var db = new SSCTechClientDbCntx()) { SqlParameter p1 = new SqlParameter("@FAId", closeClientActivity.FAId); SqlParameter p2 = new SqlParameter("@success", closeClientActivity.Success); SqlParameter p3 = new SqlParameter("@comments", closeClientActivity.Comment); SqlParameter p4 = new SqlParameter("@activityEndDate", closeClientActivity.ActivityEndDate); SqlParameter p5 = new SqlParameter("@userId", closeClientActivity.UserName); SqlParameter p6 = new SqlParameter("@newReportSuccess", closeClientActivity.NewReportSuccess); SqlParameter p7 = new SqlParameter("@newReportComments", closeClientActivity.NewReportComment); db.Database.ExecuteSqlCommand("EXEC spCloseClientActivity @FAId, @success, @comments, @activityEndDate, @userId, @newReportSuccess, @newReportComments" , p1, p2, p3, p4, p5, p6, p7); } } }
public void OnBtnSuccessClick() { if (ValidateUpload()) { IsUploadInProgress = true; using (BackgroundWorker worker = new BackgroundWorker()) { var uploadFileSize = FileUtility.GetUploadSize(new List<KeyValuePair<string, List<FileDetail>>> {new KeyValuePair<string, List<FileDetail>>(this.OutputViewModel.DirPath, this.OutputViewModel.File), new KeyValuePair<string, List<FileDetail>>(this.ReportsViewModel.DirPath, this.ReportsViewModel.File) //, //new KeyValuePair<string, List<FileDetail>>(this.XMLInvitationViewModel.DirPath, this.XMLInvitationViewModel.File) , new KeyValuePair<string, List<FileDetail>>(this.XMLInvitationViewModel_GDC.DirPath, this.XMLInvitationViewModel_GDC.File) , new KeyValuePair<string, List<FileDetail>>(this.XMLInvitationViewModel_Owners.DirPath, this.XMLInvitationViewModel_Owners.File) }); ProgressBarMsg = string.Format("Please wait while files is being uploaded to K-Drive. Do not close the window or the files movement will be interrupted. Size to upload {0}", uploadFileSize.ToFileSize() ); SSCTechInfo.UploadFileSize = uploadFileSize; var dt = ProgressTimmer(); worker.DoWork += (s, e) => { IsProgressBarVisible = true; this.XMLInvitationViewModel.File.ForEach(x => { var match = this.InvitationViewModel.SSCUsers.Where(y => y.GetUserAlias.Equals(x.GetUserAlias, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (match == null) x.InvitationUserType = InvitationUserType.None; else x.InvitationUserType = (InvitationUserType)Enum.Parse(typeof(InvitationUserType), match.SSCInvitationUserType.ToString()); } ); this.XMLInvitationViewModel_GDC.File.ForEach(x => { var match = this.InvitationViewModel.SSCUsers.Where(y => y.GetUserAlias.Equals(x.GetUserAlias, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (match == null) x.InvitationUserType = InvitationUserType.None; else x.InvitationUserType = (InvitationUserType)Enum.Parse(typeof(InvitationUserType), match.SSCInvitationUserType.ToString()); } ); this.XMLInvitationViewModel_Owners.File.ForEach(x => { var match = this.InvitationViewModel.SSCUsers.Where(y => y.GetUserAlias.Equals(x.GetUserAlias, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (match == null) x.InvitationUserType = InvitationUserType.None; else x.InvitationUserType = (InvitationUserType)Enum.Parse(typeof(InvitationUserType), match.SSCInvitationUserType.ToString()); } ); SSCTechInfo.OutputCount = this.OutputViewModel.File.Count; SSCTechInfo.ReportsCount = this.ReportsViewModel.File.Count; SSCTechInfo.ReportsFileName = string.Join(",", this.ReportsViewModel.File.Select(x => x.Name)); SSCTechInfo.InvitationsCount = this.XMLInvitationViewModel.File.Count; SSCTechInfo.InvitationsFileName = string.Join(",", this.XMLInvitationViewModel.File.Select(x => x.Name)); SSCTechInfo.InvitationsCount_GDC = this.XMLInvitationViewModel_GDC.File.Count; SSCTechInfo.InvitationsFileName_GDC = string.Join(",", this.XMLInvitationViewModel_GDC.File.Select(x => x.Name)); SSCTechInfo.InvitationsCount_Owners = this.XMLInvitationViewModel_Owners.File.Count; SSCTechInfo.InvitationsFileName_Owners = string.Join(",", this.XMLInvitationViewModel_Owners.File.Select(x => x.Name)); var uploadZipName = FileUtility.MoveFile( new KeyValuePair<string, List<FileDetail>>(this.OutputViewModel.DirPath, this.OutputViewModel.File), new KeyValuePair<string, List<FileDetail>>(this.ReportsViewModel.DirPath, this.ReportsViewModel.File), new KeyValuePair<string, List<FileDetail>>(this.XMLInvitationViewModel.DirPath, this.XMLInvitationViewModel.File), new KeyValuePair<string, List<FileDetail>>(this.XMLInvitationViewModel_GDC.DirPath, this.XMLInvitationViewModel_GDC.File), new KeyValuePair<string, List<FileDetail>>(this.XMLInvitationViewModel_Owners.DirPath, this.XMLInvitationViewModel_Owners.File), RequestInfo.SSCTechActivity.IsGDC, RequestInfo.SSCTechActivity.RootUploadKDrivePath, RequestInfo.SSCTechActivity.SurveyRowID, RequestInfo.SSCTechActivity.FAId, RequestInfo.SSCTechActivity.IsRFRequest, RequestInfo.SSCTechActivity.OutputFileName, RequestInfo.SSCTechActivity.IsProjectCodeAvailable, RequestInfo.SSCTechActivity.IsEngPreservation, RequestInfo.SSCTechActivity.EngagementNumber ); SSCTechInfo.UploadFileName = uploadZipName; var closeClientActivity = new CloseClientActivity { FAId = RequestInfo.SSCTechActivity.FAId, Success = true, Comment = "", ActivityEndDate = DateTime.Now.ToUniversalTime(), NewReportComment = "", NewReportSuccess = RequestInfo.IsReportGenerated }; if (!IsDemo) { if (!AppNEnvConfig.IsDebug) RepOperation.CloseClientActivity(closeClientActivity); if (RequestInfo.SSCTechActivity.IsRFRequest) RepOperation.UpdateRollForwardTransactions(this.RequestInfo); } }; worker.RunWorkerCompleted += (s, e) => { dt.Stop(); IsUploadInProgress = false; if (e.Error != null) { IsProgressBarVisible = false; IsBusy = false; SSCLog.HandleError(e.Error); } else { SSCTechInfo.TimeInSecToUploadToKDrive = currentStartTimmer; SSCTechInfo.Result = "Success"; RefreshFileView(); IsProgressBarVisible = false; IsBusy = false; MsgUtility.ShowMessageBox("Files uploaded successfully.", MessageType.Info); } }; IsBusy = true; worker.RunWorkerAsync(); } } }
private void SaveFailure() { if (string.IsNullOrWhiteSpace(RequestInfo.FailureComment)) { MsgUtility.ShowMessageBox("Please enter the reason for failure.", MessageType.Warning); return; } using (BackgroundWorker worker = new BackgroundWorker()) { worker.DoWork += (s, e) => { var closeClientActivity = new CloseClientActivity { FAId = RequestInfo.SSCTechActivity.FAId, Success = false, Comment = RequestInfo.FailureComment, ActivityEndDate = DateTime.Now.ToUniversalTime(), NewReportComment = "", NewReportSuccess = false }; if (!IsDemo) RepOperation.CloseClientActivity(closeClientActivity); }; worker.RunWorkerCompleted += (s, e) => { if (e.Error != null) { IsBusy = false; SSCLog.HandleError(e.Error); } else { ToSkip = false; RequestInfo.IsFailure = false; SSCTechInfo.Result = "Fail"; SSCTechInfo.Comment = RequestInfo.FailureComment; RefreshFileView(); IsBusy = false; MsgUtility.ShowMessageBox("Request failed.", MessageType.Info); } }; IsBusy = true; worker.RunWorkerAsync(); } }
public static void CloseClientActivity(CloseClientActivity closeClientActivity) { TechOperation.CloseClientActivity(closeClientActivity); }