public List <QuestionGroupList> GetQuestionGroupId() { List <QuestionGroupList> questionGroup = new List <QuestionGroupList>(); try { using (var academyEntity = new ATCACADEMYEntities()) { // academyEntity LogWrite("entity open"); questionGroup = (from quesgroup in academyEntity.QuestionGroups where quesgroup.IsValid == true select new QuestionGroupList { QuestionGroupId = quesgroup.QuestionGroupID, QuestionGroupname = quesgroup.QuestionGroupName }).ToList(); LogWrite("fetched data"); } } catch (Exception ex) { questionGroup = null; LogWrite(ex.Message); LogWrite(ex.InnerException.ToString()); LogWrite(ex.StackTrace.ToString()); } return(questionGroup); }
public string StudentRegister(Students studentDetails) { string isRegisterSuccess = "false"; try { using (var academyEntity = new ATCACADEMYEntities()) { bool isALreadyRegistered = (from stu in academyEntity.Students where stu.IsActive == true && stu.Email == studentDetails.UserName select stu.StudentID).Any(); if (isALreadyRegistered) { isRegisterSuccess = "false"; } else { Student student = new Student(); student.Email = studentDetails.UserName; student.Password = studentDetails.PassWord; student.StudentName = studentDetails.StudentName; student.CreatedDate = DateTime.Now; student.IsActive = true; academyEntity.Students.Add(student); academyEntity.SaveChanges(); isRegisterSuccess = "true"; } } } catch (Exception ex) { isRegisterSuccess = "dberror"; } return(isRegisterSuccess); }
public JsonResult QuestionsSubmit(int questionGroup, int questionType, string question, HttpPostedFileBase[] uploadQuestion, string option1, HttpPostedFileBase[] uploadOption1, string option2, HttpPostedFileBase[] uploadOption2, string option3, HttpPostedFileBase[] uploadOption3, string option4, HttpPostedFileBase[] uploadOption4, int correctAnswer) { int insertCheck = 0; try { string questionPath = "~/Images/Questions/"; if (!System.IO.Directory.Exists(questionPath)) { System.IO.Directory.CreateDirectory(Server.MapPath(questionPath)); } if (uploadQuestion != null) { uploadQuestion[0].SaveAs(Server.MapPath(questionPath + uploadQuestion[0].FileName)); } string optionsPath = "~/Images/Options/"; if (!System.IO.Directory.Exists(optionsPath)) { System.IO.Directory.CreateDirectory(Server.MapPath(optionsPath)); } if (uploadOption1 != null) { uploadOption1[0].SaveAs(Server.MapPath(optionsPath + uploadOption1[0].FileName)); } if (uploadOption2 != null) { uploadOption2[0].SaveAs(Server.MapPath(optionsPath + uploadOption2[0].FileName)); } if (uploadOption3 != null) { uploadOption3[0].SaveAs(Server.MapPath(optionsPath + uploadOption3[0].FileName)); } if (uploadOption4 != null) { uploadOption4[0].SaveAs(Server.MapPath(optionsPath + uploadOption4[0].FileName)); } question = question + (uploadQuestion != null ? " ImageName: " + uploadQuestion[0].FileName : ""); option1 = option1 + (uploadOption1 != null ? " ImageName: " + uploadOption1[0].FileName : ""); option2 = option2 + (uploadOption2 != null ? " ImageName: " + uploadOption2[0].FileName : ""); option3 = option3 + (uploadOption3 != null ? " ImageName: " + uploadOption3[0].FileName : ""); option4 = option4 + (uploadOption4 != null ? " ImageName: " + uploadOption4[0].FileName : ""); using (ATCACADEMYEntities db = new ATCACADEMYEntities()) { db.Database.Connection.Open(); insertCheck = db.PROC_InsertQuestions(questionGroup, questionType, question, option1, option2, option3, option4, correctAnswer); db.Database.Connection.Close(); } return(Json(insertCheck, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(insertCheck, JsonRequestBehavior.AllowGet)); } }
public int?CheckQuestionAnswers(SubmittedAnswers answerSheet) { int?result = 0; int resultVlue = 0; List <GetQuestionAnswers> questionandanswers = new List <GetQuestionAnswers>(); try { using (var academyEntity = new ATCACADEMYEntities()) { questionandanswers = (from ques in academyEntity.Questions where ques.IsValid == true select new GetQuestionAnswers { QuestionsList = ques.QuestionID, AnswersList = ques.Answer }).ToList(); for (int i = 0; i < questionandanswers.Count; i++) { if (questionandanswers[i].AnswersList == answerSheet.AnswersList[i]) { result += 1; resultVlue += 1; } } int? minusValue = questionandanswers.Count - result; double?modulateValue = minusValue * 0.33; result = result - ((int)modulateValue); int minusValueOne = questionandanswers.Count - resultVlue; double modulateValueOne = minusValueOne * 0.33; resultVlue = resultVlue - ((int)modulateValueOne); Result res = new Result(); res.StudentID = int.Parse(System.Web.HttpContext.Current.Request.Cookies["UserCookie"]["UserId"]); res.QuestionGroupID = answerSheet.QuestionGroupId; res.Marks = resultVlue; res.wronganswers = minusValue; academyEntity.Results.Add(res); academyEntity.SaveChanges(); } } catch (Exception ex) { result = null; } return(result); }
public ActionResult QuestionsCreation() { try { using (ATCACADEMYEntities academyEntity = new ATCACADEMYEntities()) { academyEntity.Database.Connection.Open(); ViewBag.QuestionGroup = new SelectList(academyEntity.PROC_GetQuestionGroup().ToList(), "QuestionGroupID", "QuestionGroupName"); ViewBag.QuestionType = new SelectList(academyEntity.PROC_GetQuestionType().ToList(), "QuestionTypeID", "QuestionTypeName"); academyEntity.Database.Connection.Close(); } } catch { } return(View()); }
public string StudenLogin(Students student) { string isLogginSuccess = "false"; try { using (var academyEntity = new ATCACADEMYEntities()) { var studentDetails = (from userdetails in academyEntity.Students where userdetails.Email == student.UserName && userdetails.Password == student.PassWord select userdetails.StudentID).FirstOrDefault(); if (studentDetails != 0) { isLogginSuccess = "true"; var userId = (from user in academyEntity.Students where user.IsActive == true && user.Email == student.UserName select user.StudentID).FirstOrDefault(); HttpCookie userInfo = new HttpCookie("UserCookie"); userInfo["UserId"] = userId.ToString(); userInfo.Expires.Add(new TimeSpan(24, 0, 0)); System.Web.HttpContext.Current.Response.Cookies.Add(userInfo); var isAdmin = (from user in academyEntity.Students where user.IsActive == true && user.Email == student.UserName select user.isAdmin).FirstOrDefault(); HttpCookie userInfoone = new HttpCookie("AdminCookie"); userInfoone["IsAdmin"] = isAdmin.ToString(); userInfoone.Expires.Add(new TimeSpan(24, 0, 0)); System.Web.HttpContext.Current.Response.Cookies.Add(userInfoone); } else { isLogginSuccess = "false"; } } } catch (Exception ex) { isLogginSuccess = "dberror"; } return(isLogginSuccess); }
public int?GetTestResult(int groupId) { int?result = 0; try { using (var academyEntity = new ATCACADEMYEntities()) { int userId = int.Parse(System.Web.HttpContext.Current.Request.Cookies["UserCookie"]["UserId"]); result = (from res in academyEntity.Results where res.StudentID == userId && res.QuestionGroupID == groupId select res.Marks).FirstOrDefault(); } } catch (Exception ex) { result = null; } return(result); }
public bool IsStudentAlreadyTestDone() { bool isTestDone = false; int userId = int.Parse(System.Web.HttpContext.Current.Request.Cookies["UserCookie"]["UserId"]); try { using (var academyEntity = new ATCACADEMYEntities()) { isTestDone = (from result in academyEntity.Results where userId == result.StudentID select result.ResultID).Any(); } } catch (Exception ex) { isTestDone = false; } return(isTestDone); }
public JsonResult QuestionGroupSubmit(string questionGroup) { int insertCheck = 0; try { using (ATCACADEMYEntities db = new ATCACADEMYEntities()) { db.Database.Connection.Open(); insertCheck = db.PROC_InsertQuestionGroup(questionGroup); db.Database.Connection.Close(); } return(Json(insertCheck, JsonRequestBehavior.AllowGet)); } catch { return(Json(insertCheck, JsonRequestBehavior.AllowGet)); } }
public List <QuestionList> GetQuestionList(int groupId) { //List<QuestionList> questionList = new List<QuestionList>(); try { using (var academyEntity = new ATCACADEMYEntities()) { allQuestions = (from questions in academyEntity.Questions from questiongroup in academyEntity.QuestionGroups where questions.IsValid == true && questions.QuestionGroupID == groupId select new QuestionList { questionId = questions.QuestionID, question = questions.Question1, questionType = questions.QuestionTypeID, testGroupName = questiongroup.QuestionGroupName, isHaveImage = questions.IsHaveImage // OptionAnswers = suggested.OptionAnswer.Where(suggested.QuestionID => suggested.QuestionID == questions.QuestionID) }).ToList(); foreach (var x in allQuestions) { x.OptionAnswers = (from suggested in academyEntity.Options where suggested.QuestionID == x.questionId select new OptionalAnswers { sequence = suggested.Sequence, optionList = suggested.OptionAnswer, isHaveImage = suggested.IsHaveImage }).ToList(); } } } catch (Exception ex) { allQuestions = null; } return(allQuestions); }
public string AddContactUsValues(ContactFormValues contactForm) { string isContactAdded = string.Empty; try { using (var academyEntity = new ATCACADEMYEntities()) { Contactu contactus = new Contactu(); contactus.ContactName = contactForm.Name; contactus.ContactEmail = contactForm.Email; contactus.ContactPhone = contactForm.Phone; contactus.ContactInformation = contactForm.Info; academyEntity.Contactus.Add(contactus); academyEntity.SaveChanges(); isContactAdded = "saved"; } } catch (Exception ex) { isContactAdded = null; } return(isContactAdded); }
public string GeneratePDF(int groupId) { string isPdfWrited = "false"; try { int studentId = int.Parse(System.Web.HttpContext.Current.Request.Cookies["UserCookie"]["UserId"]); using (var academyEntity = new ATCACADEMYEntities()) { var pdfDocumentDetails = (from res in academyEntity.Results from stu in academyEntity.Students from questionGroup in academyEntity.QuestionGroups where res.StudentID == studentId && stu.StudentID == studentId && questionGroup.QuestionGroupID == groupId select new PdfWritterDetails { testGroupname = questionGroup.QuestionGroupName, studentName = stu.StudentName, studentId = studentId, WrongAnswers = res.wronganswers, resultMark = res.Marks }).ToList(); using (System.IO.MemoryStream memoryStream = new System.IO.MemoryStream()) { Document document = new Document(PageSize.A4, 10, 10, 10, 10); PdfWriter writer = PdfWriter.GetInstance(document, memoryStream); document.Open(); string imageURL = System.Configuration.ConfigurationManager.AppSettings["imglocation"] + "\\atclogo.jpg"; LogWrite(imageURL); iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(imageURL); //Resize image depend upon your need jpg.ScaleToFit(140f, 120f); //Give space before image jpg.SpacingBefore = 10f; //Give some space after the image jpg.SpacingAfter = 1f; jpg.Alignment = Element.ALIGN_CENTER; document.Add(jpg); string text = @"ATC Educational Institution"; Paragraph paragraph = new Paragraph(); paragraph.SpacingBefore = 30; paragraph.SpacingAfter = 10; paragraph.Alignment = Element.ALIGN_CENTER; paragraph.Font = FontFactory.GetFont(FontFactory.HELVETICA, 20f, BaseColor.BLACK); paragraph.Add(text); document.Add(paragraph); string text1 = pdfDocumentDetails[0].testGroupname; Paragraph paragraph1 = new Paragraph(); paragraph1.SpacingBefore = 10; paragraph1.SpacingAfter = 50; paragraph1.Alignment = Element.ALIGN_CENTER; paragraph1.Font = FontFactory.GetFont(FontFactory.HELVETICA, 20f, BaseColor.BLACK); paragraph1.Add(text1); document.Add(paragraph1); string text2 = "Student ID : " + pdfDocumentDetails[0].studentId.ToString(); Paragraph paragraph2 = new Paragraph(); paragraph2.SpacingBefore = 10; paragraph2.SpacingAfter = 20; paragraph2.Alignment = Element.ALIGN_CENTER; paragraph2.Font = FontFactory.GetFont(FontFactory.HELVETICA, 20f, BaseColor.BLACK); paragraph2.Add(text2); document.Add(paragraph2); string text3 = "Student Name : " + pdfDocumentDetails[0].studentName; Paragraph paragraph3 = new Paragraph(); paragraph3.SpacingBefore = 10; paragraph3.SpacingAfter = 20; paragraph3.Alignment = Element.ALIGN_CENTER; paragraph3.Font = FontFactory.GetFont(FontFactory.HELVETICA, 20f, BaseColor.BLACK); paragraph3.Add(text3); document.Add(paragraph3); string text4 = "Wrong Answers : " + pdfDocumentDetails[0].WrongAnswers.ToString(); Paragraph paragraph4 = new Paragraph(); paragraph4.SpacingBefore = 10; paragraph4.SpacingAfter = 20; paragraph4.Alignment = Element.ALIGN_CENTER; paragraph4.Font = FontFactory.GetFont(FontFactory.HELVETICA, 20f, BaseColor.BLACK); paragraph4.Add(text4); document.Add(paragraph4); string text5 = "Result : " + pdfDocumentDetails[0].resultMark.ToString(); Paragraph paragraph5 = new Paragraph(); paragraph5.SpacingBefore = 10; paragraph5.SpacingAfter = 20; paragraph5.Alignment = Element.ALIGN_CENTER; paragraph5.Font = FontFactory.GetFont(FontFactory.HELVETICA, 20f, BaseColor.BLACK); paragraph5.Add(text5); document.Add(paragraph5); document.Close(); byte[] bytes = memoryStream.ToArray(); memoryStream.Close(); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.ContentType = "application/pdf"; string pdfName = pdfDocumentDetails[0].studentName + "_score"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + pdfName + ".pdf"); HttpContext.Current.Response.ContentType = "application/pdf"; HttpContext.Current.Response.Buffer = true; HttpContext.Current.Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache); HttpContext.Current.Response.BinaryWrite(bytes); HttpContext.Current.Response.End(); HttpContext.Current.Response.Close(); isPdfWrited = "true"; } } } catch (Exception ex) { LogWrite(ex.Message); LogWrite(ex.StackTrace.ToString()); isPdfWrited = "error"; } return(isPdfWrited); }