private void UpdateAssessmentClassScore(AssessmentClassScore assessmentScoreObj) { using (var context = new dbTIREntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { var data = context.tblAssessmentScores .Where(x => x.AssessmentScoreId == assessmentScoreObj.AssessmentScoreId) .FirstOrDefault(); if (assessmentScoreObj.Score != EDS.Constants.SystemParameter.ScoreTargetDefaultValue.DefaultValue) { data.Score = assessmentScoreObj.Score; } if (assessmentScoreObj.Target != EDS.Constants.SystemParameter.ScoreTargetDefaultValue.DefaultValue) { data.Projection = assessmentScoreObj.Target; } data.ChangeDatetime = DateTime.UtcNow; context.tblAssessmentScores.Add(data); context.Entry(data).State = EntityState.Modified; context.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } } }
private void SaveAssessmentClassScore(AssessmentClassScore assessmentScoreObj) { using (var context = new dbTIREntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { int defaultValue = EDS.Constants.SystemParameter.ScoreTargetDefaultValue.DefaultValue; int?score = assessmentScoreObj.Score != defaultValue ? assessmentScoreObj.Score : null; int?projection = assessmentScoreObj.Target != defaultValue ? assessmentScoreObj.Target : null; tblAssessmentScore tblAssessmentScore = new tblAssessmentScore() { AssessmentId = assessmentScoreObj.AssessmentId, StudentId = assessmentScoreObj.StudentId, Score = score, Projection = projection, GradeLevel = assessmentScoreObj.GradeLevel, SchoolID = assessmentScoreObj.SchoolId, CreateDatetime = DateTime.UtcNow }; context.tblAssessmentScores.Add(tblAssessmentScore); context.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } } }
private void AddClassAssessmentScoreScore(AssessmentClassScore assessmentScoreObj, out string result) { using (var context = new dbTIREntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { //Update existing score if (assessmentScoreObj.AssessmentScoreId != 0) { UpdateAssessmentClassScore(assessmentScoreObj); } // Save new Score else { if (assessmentScoreObj.AssessmentScoreId == 0 && assessmentScoreObj.AssessmentId != 0) { SaveAssessmentClassScore(assessmentScoreObj); } } result = "Records Saved Scuccessfully."; } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } } }