//returns "MODEL.Submission" object if successful/found //returns "null" if not internal Submission findSubmissionBySubmissionId(int submissionId) { int result = (int)CODE.MINUS_ONE; Submission submission = null; //validate submissionId if ( result == (int)CODE.ZERO || string.IsNullOrWhiteSpace(submissionId.ToString()) || !Validate.isAllNumbers(submissionId.ToString()) || !Validate.integerIsBiggerThan(submissionId, (int)CODE.TRANSLATO_DATABASE_SEED - 1) ) { result = (int)CODE.ZERO; } if (result != (int)CODE.ZERO)//safe to proceed { ISubmissions _DbSubmission = new DbSubmissions(); try { using (var trScope = TransactionScopeBuilder.CreateSerializable()) { submission = _DbSubmission.findSubmissionBySubmissionId(submissionId); trScope.Complete(); } } catch (TransactionAbortedException taEx) { result = (int)CODE.ZERO; Log.Add(taEx.ToString()); } catch (ApplicationException aEx) { result = (int)CODE.ZERO; Log.Add(aEx.ToString()); } catch (Exception ex) { result = (int)CODE.ZERO; Log.Add(ex.ToString()); } } else { result = (int)CODE.ZERO; } if (result == (int)CODE.ZERO || submission == null) { return(null); } else { return(submission); } }
//returns [int >= TRANSLATO_DATABASE_SEED] if successful //returns [int < TRANSLATO_DATABASE_SEED] if not private int insertSubmission(Submission submission, bool isText, bool isFile) { if ((isText && isFile) || (!isText && !isFile)) { return((int)CODE.CTRSUBMISSION_INSERTSUBMISSION_ISBOTHORNEITHER); //means the functions was called wrong } int returnCode = (int)CODE.ZERO; int result = (int)CODE.MINUS_ONE; //validate dateSubmitted if ( result == (int)CODE.ZERO || returnCode != (int)CODE.ZERO //nothing to validate here at this point ) { if (isText) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONTEXT_INVALID_DATESUBMITTED; } result = (int)CODE.ZERO; if (isFile) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONFILE_INVALID_DATESUBMITTED; } result = (int)CODE.ZERO; } //validate isAwarded if ( result == (int)CODE.ZERO || returnCode != (int)CODE.ZERO //nothing to validate here at this point ) { if (isText) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONTEXT_INVALID_ISAWARDED; } result = (int)CODE.ZERO; if (isFile) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONFILE_INVALID_ISAWARDED; } result = (int)CODE.ZERO; } //validate user //has to exist CtrUser _CtrUser = new CtrUser(); if ( result == (int)CODE.ZERO || returnCode != (int)CODE.ZERO || submission.user.Equals(null) || _CtrUser.findUserByUserId(submission.user.userId) == null ) { if (isText) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONTEXT_INVALID_USER; } result = (int)CODE.ZERO; if (isFile) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONFILE_INVALID_USER; } result = (int)CODE.ZERO; } //validate upload //does not have to exist; will be created if ( result == (int)CODE.ZERO || returnCode != (int)CODE.ZERO || submission.upload.Equals(null) ) { if (isText) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONTEXT_INVALID_UPLOAD; } result = (int)CODE.ZERO; if (isFile) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONFILE_INVALID_UPLOAD; } result = (int)CODE.ZERO; } //validate job //has to exist CtrJob _CtrJob = new CtrJob(); if ( result == (int)CODE.ZERO || returnCode != (int)CODE.ZERO || submission.job.Equals(null) || _CtrJob.findJobByJobId(submission.job.jobId) == null ) { if (isText) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONTEXT_INVALID_JOB; } result = (int)CODE.ZERO; if (isFile) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONFILE_INVALID_JOB; } result = (int)CODE.ZERO; } if (returnCode == (int)CODE.ZERO && result != (int)CODE.ZERO)//safe to proceed { submission.dateSubmitted = DateTimeOffset.Now; submission.isAwarded = false; submission.user = submission.user; submission.upload = submission.upload; submission.job = submission.job; CtrUpload _CtrUpload = new CtrUpload(); ISubmissions _DbSubmissions = new DbSubmissions(); try { using (var trScope = TransactionScopeBuilder.CreateSerializable()) { if (isText) { returnCode = _CtrUpload.insertUploadText(submission.upload); } if (isFile) { returnCode = _CtrUpload.insertUploadFile(submission.upload); } if (returnCode >= (int)CODE.TRANSLATO_DATABASE_SEED)//means upload was inserted successfully { submission.upload.uploadId = returnCode; returnCode = _DbSubmissions.insertSubmission(submission); } else {//means upload failed to be inserted trScope.Dispose(); } trScope.Complete(); } } catch (TransactionAbortedException taEx) { if (isText) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONTEXT_EXCEPTION; } if (isFile) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONFILE_EXCEPTION; } Log.Add(taEx.ToString()); } catch (ApplicationException aEx) { if (isText) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONTEXT_EXCEPTION; } if (isFile) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONFILE_EXCEPTION; } Log.Add(aEx.ToString()); } catch (Exception ex) { if (isText) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONTEXT_EXCEPTION; } if (isFile) { returnCode = (int)CODE.CTRSUBMISSION_INSERTSUBMISSIONFILE_EXCEPTION; } Log.Add(ex.ToString()); } } else { } return(returnCode); }