public ActionResult SaveStudentResult(SaveStudentResult saveStudentResult)
{
ViewBag.students = aStudentManager.GetAllStudent();
ViewBag.grades = aStudentManager.GetGrages();
ViewBag.message = aStudentManager.SaveResult(saveStudentResult);
return(View());
}
public ActionResult SaveStudentResult(SaveStudentResult saveStudentResult)
{
var SSFmessage = "";
if (ModelState.IsValid)
{
//var course = Mapper.Map<Course>(model);
bool isSavedSSR = studentManager.Add(saveStudentResult);
if (isSavedSSR)
{
ViewBag.SSRmessage = "Student Result Information Saved Successfully!";
ModelState.Clear();
}
else
{
ViewBag.SSFmessage = "This Course Result Already Saved Under This Student";
}
}
else
{
ViewBag.SSFmessage = "Failed";
}
var model = new SaveStudentResultViewModel();
var result = studentDAL.StudentEnrollListGetAll().Select(c => new { StudentId = c.StudentId, RegistrationNumber = c.Student.RegistrationNumber }).Distinct().ToList();
model.RegistrationNumberList = result.Select(c => new SelectListItem()
{
Value = c.StudentId.ToString(), Text = c.RegistrationNumber
});
model.CoursetSelectListItems = GetDefaultSelectListItem();
ViewBag.FMessage = SSFmessage;
return(View(model));
}
public string SaveStudentResultData(SaveStudentResult saveStudentResult)
{
List <SaveStudentResult> studentResults = studentResultGateway.GetAllStudentResult();
int count = 0;
foreach (var result in studentResults)
{
if (result.StudentId == saveStudentResult.StudentId)
{
if (result.CourseId == saveStudentResult.CourseId)
{
count = 1;
break;
}
}
}
if (count > 0)
{
if (studentResultGateway.UpdateStudentResultData(saveStudentResult) > 0)
{
return("Student Result Updated Successfully.");
}
return("Student Result Update Failed.");
}
else
{
if (studentResultGateway.SaveStudentResultData(saveStudentResult) > 0)
{
return("Student Result Saved Successfully.");
}
return("Student Result Saving Failed.");
}
}
public ActionResult Create(SaveStudentResult model)
{
if (ModelState.IsValid)
{
db.SaveStudentResults.Add(model);
db.SaveChanges();
}
return(RedirectToAction("Create"));
}
public ActionResult SaveStudentResult(SaveStudentResult saveStudentResult)
{
saveStudentResult.RegNo = studentManager.GetStudentRegNoById(saveStudentResult.StudentId);
ViewBag.students = studentManager.GetAllStudents();
ViewBag.grades = studentResultManager.GetAllResultGrades();
if (ModelState.IsValid)
{
ViewBag.Message = studentResultManager.SaveStudentResultData(saveStudentResult);
}
return(View());
}
public int UpdateStudentResultData(SaveStudentResult saveStudentResult)
{
Qurey = "UPDATE studentResult SET gradeId = @gradeId WHERE studentId = @studentId";
Command = new SqlCommand(Qurey, Connection);
Command.Parameters.AddWithValue("@gradeId", saveStudentResult.GradeId);
Command.Parameters.AddWithValue("@studentId", saveStudentResult.StudentId);
Connection.Open();
RowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(RowAffected);
}
public int SaveResult(SaveStudentResult saveStudentResult)
{
Query = " INSERT INTO StudentResult_tb(StudentId,CourseId,Grade) VALUES(@StudentId,@CourseId,@Grade)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.AddWithValue("StudentId", saveStudentResult.StudentId);
Command.Parameters.AddWithValue("CourseId", saveStudentResult.CourseId);
Command.Parameters.AddWithValue("Grade", saveStudentResult.Grade);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public int SaveStudentResultData(SaveStudentResult saveStudentResult)
{
Qurey = "INSERT INTO studentResult VALUES(@studentId, @regNo, @courseId, @gradeId)";
Command = new SqlCommand(Qurey, Connection);
Command.Parameters.AddWithValue("@studentId", saveStudentResult.StudentId);
Command.Parameters.AddWithValue("@regNo", saveStudentResult.RegNo);
Command.Parameters.AddWithValue("@courseId", saveStudentResult.CourseId);
Command.Parameters.AddWithValue("@gradeId", saveStudentResult.GradeId);
Connection.Open();
RowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(RowAffected);
}
///---Student Enroll End---///
///-----Save Student result---////
public bool Add(SaveStudentResult saveStudentResult)
{
if (db.SaveStudentResults.Any(c => c.StudentId == saveStudentResult.StudentId && c.CourseId == saveStudentResult.CourseId))
{
return(false);
//db.StudentEnrolls.Add(studentEnroll);
//return db.SaveChanges() > 0;
}
else if (db.SaveStudentResults.Any(c => c.StudentId == saveStudentResult.StudentId && c.CourseId != saveStudentResult.CourseId))
{
db.SaveStudentResults.Add(saveStudentResult);
return(db.SaveChanges() > 0);
}
else
{
db.SaveStudentResults.Add(saveStudentResult);
return(db.SaveChanges() > 0);
}
}
public int Save(SaveStudentResult saveStudentResult)
{
string query = "INSERT INTO Result(CourseId,GradeId,StudentId) VALUES(@CourseId,@GradeId,@StudentId)";
SqlCommand command = new SqlCommand(query, Connection);
command.Parameters.Clear();
command.Parameters.Add("@CourseId", SqlDbType.Int);
command.Parameters["@CourseId"].Value = saveStudentResult.CourseId;
command.Parameters.Add("@GradeId", SqlDbType.Int);
command.Parameters["@GradeId"].Value = saveStudentResult.GradeId;
command.Parameters.Add("@StudentId", SqlDbType.Int);
command.Parameters["@StudentId"].Value = saveStudentResult.StudentId;
Connection.Open();
int rowsAffected = command.ExecuteNonQuery();
Connection.Close();
return(rowsAffected);
}
public int Save(SaveStudentResult saveStudentResult)
{
if (saveStudentResult.StudentId != 0 && saveStudentResult.CourseId != 0)
{
if (IsCourseExist(saveStudentResult.StudentId, saveStudentResult.CourseId))
{
throw new Exception("Grade already given");
}
if (IsCourseEnrolled(saveStudentResult.StudentId, saveStudentResult.CourseId))
{
return(saveStudentResultGateway.Save(saveStudentResult));
}
else
{
throw new Exception("This Course has not been enrolled by this student!");
}
}
else
{
throw new Exception("Please Select Student and Course");
}
}
public string SaveResult(SaveStudentResult saveStudentResult)
{
if (IsCourseResultExist(saveStudentResult.StudentId, saveStudentResult.CourseId))
{
if (aStudentGateway.UpdateResult(saveStudentResult.StudentId, saveStudentResult.Grade) > 0)
{
return("Course result Updated.");
}
else
{
return("Not updated");
}
}
else
{
if (aStudentGateway.SaveResult(saveStudentResult) > 0)
{
return("Result saved.");
}
return("Result save failed!");
}
}
public ActionResult Save(SaveStudentResult saveStudentResult)
{
try
{
int rowsAffected = saveStudentResultManager.Save(saveStudentResult);
if (rowsAffected > 0)
{
ViewBag.Message = "Saved";
}
else
{
ViewBag.Message = "Fail";
}
}
catch (Exception exception)
{
ViewBag.Message = exception.Message;
}
ViewBag.Student = GetAllstudents();
ViewBag.Grade = GetAllGrades();
return(View());
}
public List <SaveStudentResult> GetAllStudentResult()
{
Qurey = "SELECT * FROM studentResult";
Command = new SqlCommand(Qurey, Connection);
List <SaveStudentResult> studentResults = new List <SaveStudentResult>();
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
SaveStudentResult studentResult = new SaveStudentResult();
studentResult.Id = Convert.ToInt32(Reader["id"]);
studentResult.StudentId = Convert.ToInt32(Reader["studentId"]);
studentResult.RegNo = Reader["regNo"].ToString();
studentResult.CourseId = Convert.ToInt32(Reader["courseId"]);
studentResult.GradeId = Convert.ToInt32(Reader["gradeId"]);
studentResults.Add(studentResult);
}
Reader.Close();
Connection.Close();
return(studentResults);
}
///---- Student Enroll End----///
///----- Save student result---///
public bool Add(SaveStudentResult saveStudentResult)
{
bool isSavedSSR = studentDAL.Add(saveStudentResult);
return(isSavedSSR);
}
