public ActionResult Save(StudentResult studentResult) { try { ViewBag.Message = studentManager.Save(studentResult); IEnumerable<Student> students = studentManager.GetAll; IEnumerable<Course> courses = courseManager.GetAll; ViewBag.Students = students; ViewBag.Courses = courses; return View(); //return RedirectToAction("Index"); } catch (Exception exception) { ViewBag.Message = exception.InnerException.Message; return View(); } }
public int UpdateStudentResult(StudentResult studentResult) { CommandObj.CommandText = "UPDATE t_StudentResult SET IsStudentActive=1,Grade='"+studentResult.Grade+"' WHERE StudentId='" + studentResult.StudentId + "' AND CourseId='" + studentResult.CourseId + "'"; ConnectionObj.Open(); int i= CommandObj.ExecuteNonQuery(); ConnectionObj.Close(); return i; }
public int Insert(StudentResult studentResult) { try { CommandObj.CommandText = "INSERT INTO t_StudentResult VALUES(@stId,@courseId,@grade,@isStudentActive)"; CommandObj.Parameters.Clear(); CommandObj.Parameters.AddWithValue("@stId", studentResult.StudentId); CommandObj.Parameters.AddWithValue("@courseId", studentResult.CourseId); CommandObj.Parameters.AddWithValue("@grade", studentResult.Grade); CommandObj.Parameters.AddWithValue("@isStudentActive", 1); ConnectionObj.Open(); int rowAffected = CommandObj.ExecuteNonQuery(); return rowAffected; } catch (Exception exception) { throw new Exception("Could not save",exception); } finally { ConnectionObj.Close(); CommandObj.Dispose(); } }
private bool IsResulExits(StudentResult studentResult) { StudentResult result = GetAllResult.ToList() .Find(st => st.StudentId == studentResult.StudentId && st.CourseId == studentResult.CourseId); if (result != null) { bool st = result.Status; if (st) { return true; } } return false; }
public string Save(StudentResult studentResult) { StudentResult result = GetAllResult.ToList() .Find(st => st.StudentId == studentResult.StudentId && st.CourseId == studentResult.CourseId); if (result==null) { if (studentGateway.Insert(studentResult) > 0) { return "Saved sucessfull!"; } return "Failed to save"; } if (result.Status) { return "This course result already saved"; } if (studentGateway.UpdateStudentResult(studentResult) > 0) { return "Saved sucessfull!"; } return "This course result already saved"; }