public IActionResult AddScore(Student_ModuleModel model)
{
ViewData["Message"] = "Add Score";
StudentProcessor.AddScore(model.User_Id, model.Title_id, model.Score, DateTime.Now);
string url = $"AddModule/{model.User_Id}";
return(Redirect(url));
}
public static int AddModuleToStudent(int TraineeId, int TitleId)
{
Student_ModuleModel data = new Student_ModuleModel
{
User_Id = TraineeId,
Title_id = TitleId
};
string sql = @"dbo.[SPStudent_Module] @Title_id='" + data.Title_id + "', @Trainee_id='" + data.User_Id + "'";
return(SqlDataAccess.SaveData(sql));
}
public static int AddScore(int TraineeId, int TitleId, int Score, DateTime dateTime)
{
Student_ModuleModel data = new Student_ModuleModel
{
User_Id = TraineeId,
Title_id = TitleId,
Score = Score
};
string sql = @"dbo.[SPAddScore] @Title_id='" + data.Title_id + "', @Trainee_id='" + data.User_Id + "', @Score='" + data.Score + "', @Date='" + dateTime + "'";
return(SqlDataAccess.SaveData(sql));
}
public IActionResult AddScore(int User_Id, int Title_id, Student_ModuleModel student_)
{
ViewData["Message"] = "Add Score";
return(View(student_));
}