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