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);
}
}
