internal bool IsCourseResultExists(ResultSave aResultSave) { string query = "Select * from Result where StudentId = @id and CourseId = @courseId"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Clear(); command.Parameters.Add("id", SqlDbType.Int); command.Parameters["id"].Value = aResultSave.RegistrationNo; command.Parameters.Add("courseId", SqlDbType.Int); command.Parameters["courseId"].Value = aResultSave.CourseId; connection.Open(); SqlDataReader reader = command.ExecuteReader(); bool hasRow = false; if (reader.HasRows) { hasRow = true; } reader.Close(); connection.Close(); return(hasRow); }
public ActionResult ResultSave(ResultSave aResultSave) { RegistratiuonNoBind(); ViewBag.Grades = aResultSaveManager.GetAllGrades(); ViewBag.Message = aResultSaveManager.Save(aResultSave); return(View()); }
public string SaveStudentResult(ResultSave resultSave) { int row = resultsGateway.SaveStudentResult(resultSave); if (row > 0) { return("Save Successfully"); } else { return("Something went wrong"); } }
public int SaveStudentResult(ResultSave resultSave) { string query = "INSERT INTO ResultSave(StudentID, CourseId, GradeId) VALUES(@studentid, @courseid, @gradeid)"; SqlCommand = new SqlCommand(query, SqlConnection); SqlCommand.Parameters.AddWithValue("@studentid", resultSave.StudentId); SqlCommand.Parameters.AddWithValue("@courseid", resultSave.CourseId); SqlCommand.Parameters.AddWithValue("@gradeid", resultSave.GradeId); //SqlCommand.Parameters.AddWithValue("@action", "insert"); SqlConnection.Open(); int rowAffected = SqlCommand.ExecuteNonQuery(); SqlConnection.Close(); return(rowAffected); }
public ActionResult SaveResult(ResultSave resultSave) { ViewBag.RegList = StudentManager.GetAllStudentRegNo(); ViewBag.allGradelist = ResultManager.GetAllGradeList(); if (ModelState.IsValid) { ViewBag.Message = ResultManager.SaveStudentResult(resultSave); } else { string message = "Validation error"; ViewBag.Message = message; } return(View()); }
public string Save(ResultSave aResultSave) { if (aResultSaveGateway.IsCourseResultExists(aResultSave)) { return("Result Allready Saved "); } else { int rowAffected = aResultSaveGateway.Save(aResultSave); if (rowAffected > 0) { return("Save Successfull"); } else { return("Save Failed"); } } }
public int Save(ResultSave aResultSave) { string query = "INSERT INTO Result VALUES(@id,@name,@email,@departmentName,@courseId,@grade);Update EnrollCourse set Result = @result where StudentId=@student and CourseId =@course; "; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Clear(); command.Parameters.Add("id", SqlDbType.Int); command.Parameters["id"].Value = aResultSave.RegistrationNo; command.Parameters.Add("name", SqlDbType.VarChar); command.Parameters["name"].Value = aResultSave.StudentName; command.Parameters.Add("email", SqlDbType.VarChar); command.Parameters["email"].Value = aResultSave.Email; command.Parameters.Add("departmentName", SqlDbType.VarChar); command.Parameters["departmentName"].Value = aResultSave.DepartmentName; command.Parameters.Add("courseId", SqlDbType.Int); command.Parameters["courseId"].Value = aResultSave.CourseId; command.Parameters.Add("grade", SqlDbType.VarChar); command.Parameters["grade"].Value = aResultSave.Grade; command.Parameters.Add("result", SqlDbType.VarChar); command.Parameters["result"].Value = aResultSave.Grade; command.Parameters.Add("student", SqlDbType.Int); command.Parameters["student"].Value = aResultSave.RegistrationNo; command.Parameters.Add("course", SqlDbType.Int); command.Parameters["course"].Value = aResultSave.CourseId; connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return(rowAffected); }