public JsonResult GetSelectedYearResults(TranscriptRequestViewModel transcriptModel, string classStatus) { try { var YearResults = studentCredential.GetYearResults(transcriptModel, classStatus); return(Json(YearResults)); } catch (Exception ex) { return(Json(new ReturnData <string> { Success = false, Message = "Oops, something went wrong while retrieving your results, please try again" })); } }
public JsonResult GetStudentsResults([FromBody] TranscriptRequestViewModel transcriptModel, string classStatus) { try { var currentYearResults = studentCredentials.GetYearResults(transcriptModel, classStatus); return(Json(currentYearResults)); } catch (Exception ex) { return(Json(new ReturnData <List <bool> > { Success = false, Message = "Oops,an error occured.Please contact administrator " + ErrorMessangesHandler.ExceptionMessage(ex) })); } }
public JsonResult GetStudentProvisionalTranscript(TranscriptRequestViewModel transcriptRequestViewModel) { var token = _tokenValidator.Validate(HttpContext); if (!token.Success) { return(Json(new ReturnData <string> { Success = false, NotAuthenticated = true, Message = $"Unauthorized:-{token.Message}", })); } var result = _unisolApiProxy.GetStudentProvisionalTranscript(transcriptRequestViewModel, classStatus).Result; var response = new ProcessJsonReturnResults <dynamic>(result).UnisolApiData; return(Json(response)); }
public IEnumerable <MarksheetResults> GetStudentResults(TranscriptRequestViewModel transcriptModel, string institutionInitials, IConfiguration configuration) { var sysSetup = _context.SysSetup.FirstOrDefault(); var results = _context.MarkSheet.Join(_context.Subjects, m => m.Subject, s => s.Code, (m, s) => new MarksheetResults { AdmnNo = m.AdmnNo, Term = m.Term, Code = m.Subject, Title = s.Names, Exam = m.Exam, Cat = m.Cat }).Where(r => r.AdmnNo == transcriptModel.Usercode).ToList(); if (institutionInitials.ToUpper().Equals("KCNP") || institutionInitials.ToUpper().Equals("NTTI")) { string connetionString = DbSetting.ConnectionString(configuration, "Unisol"); SqlConnection connection = new SqlConnection(connetionString); if (connection.State == ConnectionState.Closed) { connection.Open(); } var marks = "SELECT m.admnno, m.term, m.subject, s.names, m.exam, m.[cat1], m.[cat2] FROM MarkSheet m INNER JOIN Subjects s ON m.subject = s.code " + "WHERE m.admnno = '" + transcriptModel.Usercode + "'"; if (institutionInitials.ToUpper().Equals("NTTI")) { marks = "SELECT m.admnno, m.term, m.subject, s.names, m.exam, m.[cat 1], m.[cat 2] FROM MarkSheet m INNER JOIN Subjects s ON m.subject = s.code " + "WHERE m.admnno = '" + transcriptModel.Usercode + "'"; } var sqlCommand = new SqlCommand(marks, connection); var reader = sqlCommand.ExecuteReader(); results = new List <MarksheetResults>(); while (reader.Read()) { decimal cat1 = 0, cat2 = 0, exam = 0; decimal.TryParse(reader[5].ToString(), out cat1); decimal.TryParse(reader[6].ToString(), out cat2); decimal.TryParse(reader[4].ToString(), out exam); var cat = (cat1 + cat2) * 0.5m; if (institutionInitials.ToUpper().Equals("NTTI")) { cat = (sysSetup.OtherTests / 100) * cat1 ?? 0; exam = (sysSetup.Exam / 100) * exam ?? 0; } results.Add(new MarksheetResults { AdmnNo = reader[0].ToString(), Term = reader[1].ToString(), Code = reader[2].ToString(), Title = reader[3].ToString(), Exam = Math.Round(exam, MidpointRounding.AwayFromZero), Cat = Math.Round(cat, MidpointRounding.AwayFromZero) }); } sqlCommand.Dispose(); connection.Close(); } return(results); }
public Task <string> GetStudentProvisionalTranscript(TranscriptRequestViewModel transcriptRequestViewModel, string classStatus) { var response = Post("transcript/GetSelectedYearResults/?classStatus=" + classStatus, transcriptRequestViewModel); return(response); }