public ActionResult viewdiscussion()
{
if (Session["Teacher"] == null)
{
return(RedirectToAction("login", "Home", new { area = "" }));
}
int teacherid = Convert.ToInt32(Session["Teacher"]);
int tempclassid;
int originalclassid;
var getteacherid = dbContext.Teachers.Find(teacherid);
tempclassid = getteacherid.Class_Id;
var classid = dbContext.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
CourseDBHandle gc = new CourseDBHandle();
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherAssignedCourse(teacherid, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
return(View());
}
public ActionResult viewonlinetest()
{
if (Session["Student"] == null)
{
return(RedirectToAction("Login", "Account", new { area = "" }));
}
int studentid = Convert.ToInt32(Session["Student"]);
int tempclassid;
int originalclassid;
string Regno;
var getstudentid = db.Students.Find(studentid);
tempclassid = getstudentid.Class_Id;
Regno = getstudentid.RegNo;
var classid = db.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
//AB enroll course wala dropdown ajayega
CourseDBHandle gc = new CourseDBHandle();
List <tblEnrollStudentInCourseValidation> list = gc.GetSudentEnrollCourse(Regno, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
return(View());
}
public ActionResult result(string RegNo)
{
if (Session["Teacher"] == null)
{
return(RedirectToAction("Login", "Account", new { area = "" }));
}
int teacherid = Convert.ToInt32(Session["Teacher"]);
Session["Regno"] = RegNo;
CourseDBHandle gc = new CourseDBHandle();
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherStudentSimilarCourse(teacherid, RegNo);
ViewBag.course = new SelectList(list, "courseId", "courseName");
List <Exam> examlist = db.Exams.ToList();
ViewBag.exam = new SelectList(examlist, "ExamId", "ExamName");
var query = (from s in db.Students
join c in db.Tbl_Class on s.Class_Id equals c.Class_Id
join cs in db.Sections on s.Section_Id equals cs.SectionID
where s.RegNo == RegNo
select new StudentMasterViewModel()
{
RegNo = s.RegNo,
StudentIdtable = s.Id,
ClassId = s.Class_Id,
SectionId = s.Section_Id,
Name = s.Name,
ClassName = c.Name,
SectionName = cs.SectionName
}).FirstOrDefault();
//ViewData["query"] = query;
//StudentMasterViewModel objstudentMasterViewModel = new StudentMasterViewModel();
//List<StudentModel> listOfStudentModel =
//(
// from objStu in db.StudentMasters
// join objExam in db.Exams on objStu.Exam_Id equals objExam.ExamId
// join objclass in db.Tbl_Class on objStu.Id equals objclass.Class_Id
// join objReg in db.Students on objStu.Id equals objReg.Id
// select new StudentModel()
// {
// StudentId=objStu.Id,
// ClassName = objclass.Name,
// RegNumer = objReg.RegNo,
// ExamName = objExam.ExamName,
// Name = objStu.Name,
// }
//).ToList();
return(View(query));
}
public ActionResult viewtest(tblEnrollStudentInCourseValidation testing)
{
try
{
int studentid = Convert.ToInt32(Session["Student"]);
int tempclassid;
int originalclassid;
string Regno;
var getstudentid = db.Students.Find(studentid);
tempclassid = getstudentid.Class_Id;
Regno = getstudentid.RegNo;
var classid = db.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
CourseDBHandle gc = new CourseDBHandle();
List <tblEnrollStudentInCourseValidation> list = gc.GetSudentEnrollCourse(Regno, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
return(RedirectToAction("viewuploadedtest", new { courseid = testing.courseId }));
}
catch (Exception ex)
{
ViewBag.Message = "Please try later";
return(View());
}
}
public ActionResult viewdiscussion(tblEnrollStudentInCourseValidation testing)
{
try
{
int studentid = Convert.ToInt32(Session["Student"]);
int tempclassid;
int originalclassid;
string Regno;
var getstudentid = dbContext.Students.Find(studentid);
tempclassid = getstudentid.Class_Id;
Regno = getstudentid.RegNo;
var classid = dbContext.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
//AB enroll course wala dropdown ajayega
CourseDBHandle gc = new CourseDBHandle();
List <tblEnrollStudentInCourseValidation> list = gc.GetSudentEnrollCourse(Regno, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
//TempData["course"] = testing.courseId;
//var data = db.SchoolAssignments.ToList();
return(RedirectToAction("Index", new { courseid = testing.courseId }));
}
catch (Exception ex)
{
ViewBag.Message = "Please try later";
return(View());
}
}
public ActionResult addfeedback()
{
if (Session["Student"] == null)
{
return(RedirectToAction("Login", "Account", new { area = "" }));
}
try
{
int studentid = Convert.ToInt32(Session["Student"]);
int tempclassid;
int schoolid;
int originalclassid;
string Regno;
var getstudentid = db.Students.Find(studentid);
tempclassid = getstudentid.Class_Id;
schoolid = getstudentid.School_Id;
Regno = getstudentid.RegNo;
var classid = db.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
CourseDBHandle gc = new CourseDBHandle();
List <tblEnrollStudentInCourseValidation> list = gc.GetSudentEnrollCourse(Regno, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
//ViewBag.Product_CategoryID = new SelectList(db.Courses, "courseId", "courseName");
return(View());
}
catch (Exception ex)
{
ViewBag.Message = "There is some error in processing";
return(View());
}
}
public ActionResult viewdiscussion(tbl_CourseAssigntoTeacherValidation testing)
{
try
{
int teacherid = Convert.ToInt32(Session["Teacher"]);
int tempclassid;
int originalclassid;
var getteacherid = dbContext.Teachers.Find(teacherid);
tempclassid = getteacherid.Class_Id;
var classid = dbContext.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
CourseDBHandle gc = new CourseDBHandle();
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherAssignedCourse(teacherid, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
return(RedirectToAction("Index", new { courseid = testing.courseId }));
}
catch (Exception ex)
{
ViewBag.Message = "Please try later";
return(View());
}
}
public ActionResult PostMessage(MessageReplyViewModel vm)
{
//var username = User.Identity.Name;
//string fullName = "";
int msgid = 0;
int teacherid = Convert.ToInt32(Session["Student"]);
int tempclassid;
int originalclassid;
string Regno;
var getteacherid = dbContext.Students.Find(teacherid);
tempclassid = getteacherid.Class_Id;
Regno = getteacherid.RegNo;
var classid1 = dbContext.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid1.Class_Id;
//AB enroll course wala dropdown ajayega
CourseDBHandle gc = new CourseDBHandle();
List <tblEnrollStudentInCourseValidation> list = gc.GetSudentEnrollCourse(Regno, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
int schoolid;
int classid;
schoolid = getteacherid.School_Id;
classid = getteacherid.Class_Id;
//if (!string.IsNullOrEmpty(username))
//{
// var user = dbContext.loginTables.SingleOrDefault(u => u.Name == username);
// fullName = string.Concat(new string[] { user.Name });
//}
Message messagetoPost = new Message();
if (vm.Message.Subject != string.Empty && vm.Message.MessageToPost != string.Empty)
{
messagetoPost.DatePosted = DateTime.Now;
messagetoPost.Subject = vm.Message.Subject;
messagetoPost.MessageToPost = vm.Message.MessageToPost;
messagetoPost.From = Session["StudentName"].ToString();
messagetoPost.Class_Id = classid;
messagetoPost.Role_ID = 4;
messagetoPost.UserId = teacherid;
messagetoPost.courseId = vm.Message.courseId;
messagetoPost.SchoolId = schoolid;
dbContext.Messages.Add(messagetoPost);
dbContext.SaveChanges();
msgid = messagetoPost.Id;
}
return(RedirectToAction("Index", "Message", new { Id = msgid, courseid = vm.Message.courseId }));
}
public ActionResult result(tbl_StudentView objstudentViewModel)
{
int teacherid = Convert.ToInt32(Session["Teacher"]);
int schoolid;
var data = db.Teachers.Find(teacherid);
schoolid = data.School_Id;
string RegNo = Session["Regno"].ToString();
CourseDBHandle gc = new CourseDBHandle();
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherStudentSimilarCourse(teacherid, RegNo);
ViewBag.course = new SelectList(list, "courseId", "courseName");
StudentMaster objStudentMaster = new StudentMaster()
{
Name = objstudentViewModel.Name,
ClassName = objstudentViewModel.ClassName,
CreatedBy = teacherid,
SectionName = objstudentViewModel.SectionName,
Exam_Id = Convert.ToInt32(objstudentViewModel.Exam_Id),
RegNo = objstudentViewModel.RegNo
};
db.StudentMasters.Add(objStudentMaster);
db.SaveChanges();
foreach (var item in objstudentViewModel.ListofStudentMarks)
{
StudentResult objstudentResult = new StudentResult()
{
CourseId = item.CourseId,
TotalMarks = item.TotalMarks,
MarksObtained = item.MarksObtained,
SchoolId = schoolid,
Percentage = item.Percentage,
Exam_Id = Convert.ToInt32(objstudentViewModel.Exam_Id),
ClassId = objstudentViewModel.ClassId,
CreatedDate = DateTime.Now,
StudentMasterId = objStudentMaster.Id,
StudentId = objstudentViewModel.StudentIdtable,
SectionId = objstudentViewModel.SectionId
};
db.StudentResults.Add(objstudentResult);
db.SaveChanges();
}
return(Json(new { message = "Data Successfully Added", status = true }, JsonRequestBehavior.AllowGet));
}
// GET: Teacher/Result
public ActionResult GetStudentRegno()
{
if (Session["Teacher"] == null)
{
return(RedirectToAction("Login", "Account", new { area = "" }));
}
int teacherid = Convert.ToInt32(Session["Teacher"]);
CourseDBHandle gc = new CourseDBHandle();
List <Tbl_UserEnrollInCourseValidation> Regnolist = gc.GetStudentRegisterationNoSimilarCourse(teacherid);
ViewBag.Regno = new SelectList(Regnolist, "EnrollmentId", "RegistrationId");
return(View());
}
public ActionResult course(int PageNumber = 1)
{
if (Session["Cliente"] == null)
{
return(RedirectToAction("login", "Home", new { area = "" }));
}
CourseDBHandle gc = new CourseDBHandle();
List <tbl_coursevalidation> list = gc.GetCourseClient();
ViewBag.TotalPages = Math.Ceiling(list.Count() / 12.0);
ViewBag.PageNumber = PageNumber;
list = list.Skip((PageNumber - 1) * 12).Take(5).ToList();
ViewBag.course = list;
return(View());
}
public ActionResult PostMessage(MessageReplyViewModel vm)
{
int msgid = 0;
int teacherid = Convert.ToInt32(Session["Teacher"]);
int schoolid;
int classid;
var getteacherid = dbContext.Teachers.Find(teacherid);
schoolid = getteacherid.School_Id;
classid = getteacherid.Class_Id;
CourseDBHandle gc = new CourseDBHandle();
int tempclassid;
int originalclassid;
tempclassid = getteacherid.Class_Id;
var classid1 = dbContext.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid1.Class_Id;
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherAssignedCourse(teacherid, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
Message messagetoPost = new Message();
if (vm.Message.Subject != string.Empty && vm.Message.MessageToPost != string.Empty)
{
messagetoPost.DatePosted = DateTime.Now;
messagetoPost.Subject = vm.Message.Subject;
messagetoPost.courseId = vm.Message.courseId;
messagetoPost.MessageToPost = vm.Message.MessageToPost;
messagetoPost.From = Session["TeacherName"].ToString();
messagetoPost.Class_Id = classid;
messagetoPost.Role_ID = 3;
messagetoPost.UserId = teacherid;
messagetoPost.courseId = vm.Message.courseId;
messagetoPost.SchoolId = schoolid;
dbContext.Messages.Add(messagetoPost);
dbContext.SaveChanges();
msgid = messagetoPost.Id;
}
return(RedirectToAction("Index", "Message", new { Id = msgid, courseid = vm.Message.courseId }));
}
public ActionResult Create()
{
int teacherid = Convert.ToInt32(Session["Teacher"]);
MessageReplyViewModel vm = new MessageReplyViewModel();
CourseDBHandle gc = new CourseDBHandle();
int tempclassid;
int originalclassid;
var getteacherid = dbContext.Teachers.Find(teacherid);
tempclassid = getteacherid.Class_Id;
var classid = dbContext.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherAssignedCourse(teacherid, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
return(View(vm));
}
public ActionResult GetStudentRegno(FormCollection formcollection)
{
try
{
int teacherid = Convert.ToInt32(Session["Teacher"]);
CourseDBHandle gc = new CourseDBHandle();
List <Tbl_UserEnrollInCourseValidation> Regnolist = gc.GetStudentRegisterationNoSimilarCourse(teacherid);
ViewBag.Regno = new SelectList(Regnolist, "EnrollmentId", "RegistrationId");
var text = formcollection["hidText"];
return(RedirectToAction("result", new { RegNo = text }));
}
catch (Exception ex)
{
ViewBag.Message = "There is some problem in processing";
return(View());
}
}
public ActionResult addfeedback(tbl_FeedbackValidation fv)
{
try
{
int studentid = Convert.ToInt32(Session["Student"]);
int tempclassid;
int schoolid;
int originalclassid;
string Regno;
var getstudentid = db.Students.Find(studentid);
tempclassid = getstudentid.Class_Id;
schoolid = getstudentid.School_Id;
Regno = getstudentid.RegNo;
var classid = db.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
fv.SchoolId = schoolid;
CourseDBHandle gc = new CourseDBHandle();
List <tblEnrollStudentInCourseValidation> list = gc.GetSudentEnrollCourse(Regno, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
UserFeedback f = new UserFeedback();
f.CourseId = fv.CourseId;
f.Description = fv.Description;
f.CreatedDate = DateTime.Now;
f.UserId = Convert.ToInt32(Session["Student"]);
f.RoleId = 4;
f.SchoolId = fv.SchoolId;
db.UserFeedbacks.Add(f);
db.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Data Submitted";
}
catch (Exception ex)
{
ViewBag.Message = "Not Submitted";
return(View());
}
return(View());
}
public ActionResult Create()
{
MessageReplyViewModel vm = new MessageReplyViewModel();
int teacherid = Convert.ToInt32(Session["Student"]);
int tempclassid;
int originalclassid;
string Regno;
var getteacherid = dbContext.Students.Find(teacherid);
tempclassid = getteacherid.Class_Id;
Regno = getteacherid.RegNo;
var classid1 = dbContext.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid1.Class_Id;
//AB enroll course wala dropdown ajayega
CourseDBHandle gc = new CourseDBHandle();
List <tblEnrollStudentInCourseValidation> list = gc.GetSudentEnrollCourse(Regno, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
return(View(vm));
}
public ActionResult notesviewer(tblEnrollStudentInCourseValidation testing)
{
int studentid = Convert.ToInt32(Session["Student"]);
int tempclassid;
int originalclassid;
string Regno;
var getstudentid = db.Students.Find(studentid);
tempclassid = getstudentid.Class_Id;
Regno = getstudentid.RegNo;
var classid = db.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
CourseDBHandle gc = new CourseDBHandle();
List <tblEnrollStudentInCourseValidation> list = gc.GetSudentEnrollCourse(Regno, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
return(RedirectToAction("notesview", new { courseid = testing.courseId }));
}
public ActionResult Enrollment()
{
if (Session["school"] == null)
{
return(RedirectToAction("Login", "Account", new { area = "" }));
}
//ViewBag.CourseId = new SelectList(db.Courses, "courseId", "Code");
//ViewBag.StudentList = db.Students.ToList();
int schoolid = Convert.ToInt32(Session["school"]);
int RoleID = 2;
StudentDBHandle gc = new StudentDBHandle();
List <tbl_StudentValidation> list = gc.GetSchoolStudent(schoolid);
ViewData["student_name"] = new SelectList(list, "RegNo", "RegNo");
CourseDBHandle gc1 = new CourseDBHandle();
List <tbl_OnlineTestValidation> courselist = gc1.GetSchoolCourse(schoolid, RoleID);
ViewData["course_name"] = new SelectList(courselist, "courseId", "courseName");
return(View());
}
public ActionResult assignment(tbl_AssignmentValidation a)
{
int teacherid = Convert.ToInt32(Session["Teacher"]);
int tempclassid;
int schoolid;
int originalclassid;
var getteacherid = db.Teachers.Find(teacherid);
tempclassid = getteacherid.Class_Id;
schoolid = getteacherid.School_Id;
var classid = db.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
a.SchoolId = schoolid;
a.ClassId = originalclassid;
CourseDBHandle gc = new CourseDBHandle();
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherAssignedCourse(teacherid, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
if (a.UserdocFIle == null)
{
ModelState.AddModelError("CustomError", "Please Select File");
return(View());
}
if (!(a.UserdocFIle.ContentType == "application/pdf" || a.UserdocFIle.ContentType == "application/pdf"))
{
ModelState.AddModelError("CustomError", "Select Doc or Pdf extention file only ");
return(View());
}
try
{
SchoolAssignment scassignemnt = new SchoolAssignment();
string fileName = Guid.NewGuid() + Path.GetExtension(a.UserdocFIle.FileName);
a.UserdocFIle.SaveAs(Path.Combine(Server.MapPath("~/FrontEnd/File_Upload/Assignment/"), fileName));
scassignemnt.AssignmentUrl = fileName;
scassignemnt.AssignmentName = a.AssignmentName;
scassignemnt.CourseId = a.CourseId;
scassignemnt.ClassId = a.ClassId;
scassignemnt.CreatedDate = DateTime.Now;
scassignemnt.Duration = a.Duration;
scassignemnt.SchoolId = a.SchoolId;
scassignemnt.UserId = Convert.ToInt32(Session["Teacher"]);
db.SchoolAssignments.Add(scassignemnt);
db.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Data Submitted";
}
catch (Exception ex)
{
ViewBag.Message = "Not Submitted";
return(View());
}
return(View());
}
public ActionResult uploadLecture(tbl_LectureValidation lec)
{
int teacherid = Convert.ToInt32(Session["Teacher"]);
int tempclassid;
int schoolid;
int originalclassid;
var getteacherid = db.Teachers.Find(teacherid);
tempclassid = getteacherid.Class_Id;
schoolid = getteacherid.School_Id;
var classid = db.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
lec.SchoolId = schoolid;
lec.ClassId = originalclassid;
CourseDBHandle gc = new CourseDBHandle();
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherAssignedCourse(teacherid, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
if (lec.UserdocFIle == null)
{
ModelState.AddModelError("CustomError", "Please Select File");
return(View());
}
if (!(lec.UserdocFIle.ContentType == "application/pdf" || lec.UserdocFIle.ContentType == "application/pdf"))
{
ModelState.AddModelError("CustomError", "Select Doc or Pdf extention file only ");
return(View());
}
try
{
Lecture teaclecture = new Lecture();
string fileName = Guid.NewGuid() + Path.GetExtension(lec.UserdocFIle.FileName);
lec.UserdocFIle.SaveAs(Path.Combine(Server.MapPath("~/FrontEnd/File_upload/Lecture/"), fileName));
teaclecture.LectureUrl = fileName;
teaclecture.Lecturename = lec.Lecturename;
teaclecture.CourseId = lec.CourseId;
teaclecture.ClassId = lec.ClassId;
teaclecture.CreatedDate = DateTime.Now;
teaclecture.Lecture_Description = lec.Lecture_Description;
teaclecture.SchoolId = lec.SchoolId;
teaclecture.VideoLink = lec.VideoLink;
teaclecture.UserId = Convert.ToInt32(Session["Teacher"]);
db.Lectures.Add(teaclecture);
db.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Data Submitted";
}
catch (Exception ex)
{
ViewBag.Message = "Not Submitted";
return(View());
}
return(View());
}
public JsonResult addonlinetest(QuestionOptionViewModel QuestionOption)
{
int teacherid = Convert.ToInt32(Session["Teacher"]);
int tempclassid;
int schoolid;
int originalclassid;
var getteacherid = db.Teachers.Find(teacherid);
tempclassid = getteacherid.Class_Id;
var classid = db.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
CourseDBHandle gc = new CourseDBHandle();
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherAssignedCourse(teacherid, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
OnlineTest q = new OnlineTest();
q.Role_Id = Convert.ToInt32(Session["RoleId"]);
q.UserId = Convert.ToInt32(Session["Teacher"]);
var getteachid = db.Teachers.Find(teacherid);
schoolid = getteachid.School_Id;
q.SchoolId = schoolid;
//OnlineTest test = new OnlineTest();
q.CourseId = QuestionOption.CourseId;
q.QuestionName = QuestionOption.QuestionName;
q.IsActive = true;
q.ClassId = originalclassid;
q.CreatedDate = DateTime.Now;
q.Duration = "1 hour";
q.IsMultiple = false;
db.OnlineTests.Add(q);
db.SaveChanges();
int questionId = q.QuestionId;
foreach (var item in QuestionOption.ListOfOptions)
{
OnlineTestQuestionOption objoption = new OnlineTestQuestionOption();
objoption.OptionName = item;
objoption.QuestionId = questionId;
db.OnlineTestQuestionOptions.Add(objoption);
db.SaveChanges();
}
OnlineTestAnswer objanswer = new OnlineTestAnswer();
objanswer.AnswerText = QuestionOption.AnswerText;
objanswer.RoleId = Convert.ToInt32(Session["RoleId"]);
objanswer.UserId = Convert.ToInt32(Session["Teacher"]);
objanswer.SchoolId = schoolid;
objanswer.QuestionId = questionId;
db.OnlineTestAnswers.Add(objanswer);
db.SaveChanges();
return(Json(new { message = "Data Successfully Added", success = true }, JsonRequestBehavior.AllowGet));
}
public ActionResult addtestfile(tbl_TestFileValidation tfile)
{
int teacherid = Convert.ToInt32(Session["Teacher"]);
int tempclassid;
int schoolid;
int originalclassid;
var getteacherid = db.Teachers.Find(teacherid);
tempclassid = getteacherid.Class_Id;
schoolid = getteacherid.School_Id;
var classid = db.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
CourseDBHandle gc = new CourseDBHandle();
tfile.SchoolId = schoolid;
tfile.ClassId = originalclassid;
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherAssignedCourse(teacherid, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
if (tfile.UserdocFIle == null)
{
ModelState.AddModelError("CustomError", "Please Select File");
return(View());
}
if (!(tfile.UserdocFIle.ContentType == "application/msword" || tfile.UserdocFIle.ContentType == "application/vnd.openxmlformats-officedocument.wordprocessingml.document" || tfile.UserdocFIle.ContentType == "application/pdf"))
{
ViewBag.Message = "Select doc or Docx Pdf extention file only ";
return(View());
}
try
{
ManualTest mantestfile = new ManualTest();
string fileName = Guid.NewGuid() + Path.GetExtension(tfile.UserdocFIle.FileName);
tfile.UserdocFIle.SaveAs(Path.Combine(Server.MapPath("~/FrontEnd/File_Upload/ManualTest/"), fileName));
mantestfile.TestUrl = fileName;
mantestfile.CourseId = tfile.CourseId;
mantestfile.ClassId = tfile.ClassId;
mantestfile.CreatedDate = DateTime.Now;
mantestfile.Duration = tfile.Duration;
mantestfile.SchoolId = tfile.SchoolId;
mantestfile.UserId = Convert.ToInt32(Session["Teacher"]);
db.ManualTests.Add(mantestfile);
db.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Data Submitted";
}
catch (Exception ex)
{
ViewBag.Message = "Not Submitted";
return(View());
}
return(View());
}
