public async Task <ActionResult> Create([Bind(Include = "AdminID,Name,Email,PhoneNumber")] Admin admin)
{
if (ModelState.IsValid)
{
admin.AdminID = Guid.NewGuid();
db.Admins.Add(admin);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(admin));
}
public async Task <ActionResult> Create([Bind(Include = "SubjectID,SubjectName,TeacherID")] Subject subject)
{
if (ModelState.IsValid)
{
subject.SubjectID = Guid.NewGuid();
db.Subjects.Add(subject);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(subject));
}
public async Task <ActionResult> Create([Bind(Include = "ParentID,FirstName,LastName,PhoneNumber,Addres,Email")] Parent parent)
{
if (ModelState.IsValid)
{
parent.ParentID = Guid.NewGuid();
db.Parents.Add(parent);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(parent));
}
public async Task <ActionResult> Create([Bind(Include = "TeacherID,FirstName,LastName,PhoneNumber,Address,Email")] Teacher teacher)
{
if (ModelState.IsValid)
{
teacher.TeacherID = Guid.NewGuid();
db.Teachers.Add(teacher);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(teacher));
}
public async Task <ActionResult> Create([Bind(Include = "StudentID,FirstName,LastName,DateOfBirth,Email,ParentID")] Student student)
{
if (ModelState.IsValid)
{
student.StudentID = Guid.NewGuid();
db.Students.Add(student);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.ParentID = new SelectList(db.Parents, "ParentID", "FirstName", student.ParentID);
return(View(student));
}
public async Task <ActionResult> Create([Bind(Include = "LessionID,LessonName,IssueDate,SubjectID")] Lesson lesson)
{
if (ModelState.IsValid)
{
lesson.LessionID = Guid.NewGuid();
db.Lessons.Add(lesson);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.SubjectID = new SelectList(db.Subjects, "SubjectID", "SubjectName", lesson.SubjectID);
return(View(lesson));
}
public async Task <ActionResult> Create([Bind(Include = "ResultID,ScoreObtained,QuizID,StudentID,AssessmentDate")] QuizResult quizResult)
{
if (ModelState.IsValid)
{
quizResult.ResultID = Guid.NewGuid();
db.QuizResults.Add(quizResult);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.QuizID = new SelectList(db.Quizzes, "QuizID", "QuizName", quizResult.QuizID);
ViewBag.StudentID = new SelectList(db.Students, "StudentID", "FirstName", quizResult.StudentID);
return(View(quizResult));
}
public async Task <ActionResult> Create(TutorialUploadModel file)
{
string FileName = Path.GetFileNameWithoutExtension(file.FileContent.FileName);
string FileExtension = Path.GetExtension(file.FileContent.FileName);
FileName = FileName.Trim() + FileExtension;
byte[] Bytes = new byte[file.FileContent.ContentLength];
file.FileContent.InputStream.Read(Bytes, 0, Bytes.Length);
//upload to blob
CloudStorageAccount cloudStorageAccount = CloudStorageAccount.Parse("DefaultEndpointsProtocol=https;AccountName=ibmhackathonblobstorage;AccountKey=UXNuGcVonynbneCODLG/DLzXh9qeO2T7Ws3l0Fr4/G7l1wQHXmX71rKyvf/oMJLgHhHSlzI03fHAreitXt9TyA==;EndpointSuffix=core.windows.net");
CloudBlobClient cloudBlobClient = cloudStorageAccount.CreateCloudBlobClient();
CloudBlobContainer cloudBlobContainer = cloudBlobClient.GetContainerReference("tutorialvideos");
CloudBlockBlob cloudBlockBlob = cloudBlobContainer.GetBlockBlobReference(FileName);
cloudBlockBlob.Properties.ContentType = file.FileContent.ContentType;
await cloudBlockBlob.UploadFromByteArrayAsync(Bytes, 0, Bytes.Length);
Models.File _file = new Models.File();
_file.FileName = FileName;
_file.FileType = file.FileType;
_file.LessionID = file.LessionID;
_file.Lesson = await db.Lessons.FindAsync(file.LessionID);
_file.UploadDate = DateTime.Now;
_file.ContentURL = cloudBlockBlob.Uri.AbsoluteUri;
_file.ContentDetails = "";
_file.FileID = Guid.NewGuid();
db.Files.Add(_file);
await db.SaveChangesAsync();
if (_file.FileType == "Video")
{
MethodHelpers methodHelper = new MethodHelpers();
methodHelper.TriggerTranscribe(_file.FileID.ToString());
}
return(RedirectToAction("Index", "Lessons"));
}
public async Task <ActionResult> UploadQuestionDetails(string quizID)
{
bool upload = false;
foreach (string file in Request.Files)
{
var fileContent = Request.Files[file];
if (fileContent.ContentType == "application/vnd.ms-excel" || fileContent.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
if (fileContent.FileName.Contains(".xlsx") || fileContent.FileName.Contains(".xls"))
{
if (fileContent != null && fileContent.ContentLength > 0 && fileContent.ContentLength < (100 * 1024 * 1024))
{
string filename = fileContent.FileName;
string targetpath = Server.MapPath("~/QuestionFormatInExcel/");
if (!Directory.Exists(targetpath))
{
Directory.CreateDirectory(targetpath);
}
fileContent.SaveAs(targetpath + filename);
string pathToExcelFile = targetpath + filename;
string sheetName = "Sheet1";
var excelFile = new ExcelQueryFactory(pathToExcelFile);
var questionDetails = from a in excelFile.Worksheet <CustomQuestionModel>(sheetName) select a;
List <Question> questions = new List <Question>();
foreach (var a in questionDetails)
{
questions.Add(new Question()
{
QuiestionID = Guid.NewGuid(),
Question1 = a.Question,
DifficultyLevel = a.DifficultyLevel,
Answer = a.Answer,
Choices = a.Choices,
QuizID = Guid.Parse(quizID),
Quizze = await db.Quizzes.FindAsync(Guid.Parse(quizID))
});
}
foreach (var item in questions)
{
if (item.Answer != null && item.Question1 != null && item.Choices != null && item.DifficultyLevel > 0)
{
db.Questions.Add(new Question()
{
QuiestionID = item.QuiestionID,
Question1 = item.Question1,
DifficultyLevel = item.DifficultyLevel,
Answer = item.Answer,
Choices = item.Choices,
QuizID = item.QuizID,
Quizze = item.Quizze
});
}
}
await db.SaveChangesAsync();
upload = true;
}
}
}
}
if (upload)
{
Dictionary <string, dynamic> response = new Dictionary <string, dynamic>();
response.Add("Success", true);
response.Add("QuizID", quizID);
return(Json(response, JsonRequestBehavior.AllowGet));
}
else
{
Dictionary <string, dynamic> response = new Dictionary <string, dynamic>();
response.Add("Success", false);
return(Json(response, JsonRequestBehavior.AllowGet));
}
}