public ActionResult <object> Save([FromBody] GradeMark gradeMark) { try { Init(); StringBuilder sbError = new StringBuilder(""); if (!ModelState.IsValid) { Response.StatusCode = 400; return(new string[] { "Failed getting gradeMark id" }); } else { var isSaved = _gradeMarkService.Save(gradeMark, ref sbError); if (isSaved == null) { Response.StatusCode = 400; return(new string[] { "gradeMark save failed " + sbError.ToString() }); } else { return(Ok(new { id = isSaved.GradeMarkID })); } } } catch (Exception er) { return(Error(er)); } }
public GradeMark Save(GradeMark gradeMark, ref StringBuilder sbError) { var dbFlag = false; var gradeDescription = _uofRepository.GradeRepository.GetGradeById(gradeMark.GradeID, ref dbFlag); var grades = _uofRepository.GradeMarkRepository.GetGradeMarkListByGradeId(gradeMark.GradeID, ref dbFlag); if (gradeDescription == null) { sbError.Append("Grade Mark does not exist"); return(null); } if (gradeMark.GradeMarkID == null) { if (grades.Count() > 12) { sbError.Append("Grade Mark should not be more than 12"); return(null); } } if (gradeMark.FromMark >= gradeMark.ToMark) { sbError.Append("From mark should be less than To mark"); return(null); } if (gradeMark.FromMark < 0) { sbError.Append("From mark should be greater than zero"); return(null); } if (gradeMark.ToMark > 100) { sbError.Append("To mark should be less than 100"); return(null); } if (string.IsNullOrEmpty(gradeMark.GradeValue)) { sbError.Append("Grade Default Percentage Value is required"); return(null); } if (gradeMark.GradeValue.Length == 1 || gradeMark.GradeValue.Length == 2) { } else { sbError.Append("Default value shoud not be 1 or 2 characters"); return(null); } var save = _uofRepository.GradeMarkRepository.Save(gradeMark, _user.Username, ref dbFlag); return(save); }
public GradeMark Save(GradeMark grade, string modifiedBy, ref bool dbError) { try { using (var connection = GetConnection()) { if (grade.GradeMarkID == null) { grade.GradeMarkID = Guid.NewGuid(); var update = @" INSERT INTO GradeMark (GradeMarkID ,GradeID ,FromMark ,ToMark ,GradeValue ,DefaultComment , LastmodifiedBy) VALUES (@id ,@GradeID ,@FromMark ,@ToMark ,@GradeValue , @DefaultComment , @modifiedBy) "; var id = connection.Execute(update, new { id = grade.GradeMarkID, GradeID = grade.GradeID, FromMark = grade.FromMark, ToMark = grade.ToMark, GradeValue = grade.GradeValue, DefaultComment = grade.DefaultComment, modifiedBy = @modifiedBy }); } else { var update = @" UPDATE GradeMark SET FromMark = @FromMark ,ToMark = @ToMark ,GradeValue = @GradeValue ,DefaultComment = @DefaultComment , lastmodifiedBy = @modifiedBy WHERE GradeMarkID = @GradeMarkID AND ISDELETED IS NULL "; var id = connection.Execute(update, new { FromMark = grade.FromMark, ToMark = grade.ToMark, GradeValue = grade.GradeValue, DefaultComment = grade.DefaultComment, GradeMarkID = grade.GradeMarkID, modifiedBy = modifiedBy }); } return(grade); } } catch (Exception er) { dbError = true; DbLog.Error(er); return(null); } }