public static void AddQuestion(Questionnaire Questionnaire) { DataBase.Questions Questions = new DataBase.Questions(""); DataBase.QuestionStructure Qs = new DataBase.QuestionStructure(); DataBase.Questions.ObjectivesContent Oc; Qs.QuestionNumber = Questionnaire.QuestionNumber; Qs.Question = Questionnaire.QuestionData; Qs.QuestionType = Questionnaire.SetType; List <Objective> ols = Questionnaire.Objectives; List <DataBase.Questions.ObjectivesContent> Ocl = new List <DataBase.Questions.ObjectivesContent>(); foreach (Objective Obj in ols) { Oc = new DataBase.Questions.ObjectivesContent(); Oc.Detail = Obj.ObjectiveData; Oc.validity = Obj.ObjectiveValidity; Ocl.Add(Oc); } Qs.Objectives = Ocl.ToArray(); try { Questions.CaptureQuestionData(Qs); } catch { } }
public static bool CheckForExistance(string TestCode, int QuestionNumber, int Section) { DataBase.Questions Questions = new DataBase.Questions(TestCode); bool rets = Questions.CheckForQuestionExistance(TestCode, QuestionNumber, Section); return(rets); }
protected void Page_Load(object sender, EventArgs e) { DataBase.Exams DbExams = new DataBase.Exams(); DbExams.RetrieveExams(Convert.ToInt32(Session["IncomingPaper"])); string path = String.Format("C://Cosmo//Teachers/QuestionPaper/Exams/Config/{0}", DbExams.ExamData); ConfigFile.Sections ConfigSections = new ConfigFile.Sections(path); Secs.Add(ConfigSections.SectionCount, ConfigSections.SectionWeight, QuestionPanel); DataBase.Questions Quests = new DataBase.Questions(DbExams.ExamCode); Quests.RetrieveData(); foreach (DataRow Row in Quests.DataSet.Tables[0].Rows) { List <string> ls = new List <string>(); if (Row["Objective Data"] != DBNull.Value) { ls = ((string[])Row["Objective Data"]).ToList(); } else { ls = null; } AddQuestion(Convert.ToInt32(Row["Section"]), Convert.ToInt32(Row["Question Type"]), Convert.ToInt32(Row["Question Number"]), Row["Question"].ToString(), null, ls); } }
public static DataBase.QuestionStructure RetrieveData(int QuestionNumber, int Section) { DataBase.Questions Questions = new DataBase.Questions("TST008/005"); DataBase.Questions.ObjectivesContent ObjCont = new DataBase.Questions.ObjectivesContent(); DataBase.QuestionStructure Qs = new DataBase.QuestionStructure(); Questions.RetrieveData(QuestionNumber, Section); Qs.QuestionNumber = Questions.QuestionSructure.QuestionNumber; Qs.Question = Questions.QuestionSructure.Question; Qs.QuestionType = Questions.QuestionSructure.QuestionType; Qs.Objectives = Questions.QuestionSructure.Objectives; return(Qs); }
public DataBase.QuestionStructure GetQuestionData(string TestCode, int QuestionNumber, int Section) { Questions = new DataBase.Questions(TestCode); Qs = new DataBase.QuestionStructure(); if (Questions.CheckForQuestionExistance(TestCode, QuestionNumber, Section)) { Questions.RetrieveData(QuestionNumber, Section); Qs.QuestionNumber = Questions.QuestionSructure.QuestionNumber; Qs.Question = Questions.QuestionSructure.Question; Qs.QuestionType = Questions.QuestionSructure.QuestionType; Qs.Objectives = Questions.QuestionSructure.Objectives; } else { } return(Qs); }
protected void Page_Load(object sender, EventArgs e) { GenerateOptionFigureTypes(false); Bcode.Type = BarcodeLib.Barcode.BarcodeType.CODE39; Bcode.ShowStartStopChar = false; Bcode.BarWidth = 1; Bcode.BarHeight = 50; Bcode.LeftMargin = 5; Bcode.RightMargin = 5; Bcode.TopMargin = 5; Bcode.BottomMargin = 5; Bcode.Data = TestCodeData; using (Bitmap bitMap = Bcode.drawBarcode()) { using (MemoryStream ms = new MemoryStream()) { bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png); byte[] byteImage = ms.ToArray(); //barcode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage); } } Questions = new DataBase.Questions(TestCodeData); // Objectives = new DataBase.ObjectivesObj(TestCode); if (ViewState["Questionaire"] == null) { ViewState["Questionaire"] = "none"; } if (ViewState["QuestObjectives"] == null) { ViewState["QuestObjectives"] = new object[] { }; } if (ViewState["Section"] == null) { ViewState.Add("Section", 0); } CurrentNumber = Convert.ToInt32(ViewState["QNumber"]); if (IsPostBack) { if (ViewState["ObjectivesCount"] == null) { ViewState.Add("ObjectivesCount", 1); } CurrentNumber = Convert.ToInt32(ViewState["QNumber"]); if (Convert.ToInt32(ViewState["Section"]) == 0) { SectionNumber = 1; } else { SectionNumber = 2; } System.Diagnostics.Debug.WriteLine(ViewState["Section"]); } else { if (ViewState["QNumber"] == null) { ViewState["QNumber"] = 1; CurrentNumber = Convert.ToInt32(ViewState["QNumber"]); } if (Convert.ToInt32(ViewState["Section"]) == 0) { SectionNumber = 1; } else { SectionNumber = 2; } LoadData(CurrentNumber, SectionNumber); } }
public void CaptureQuestionData(DataBase.QuestionStructure QStruct) { Questions = new DataBase.Questions(this.TestCode); Questions.CaptureQuestionData(QStruct); }
protected void Page_Load(object sender, EventArgs e) { ExData = (Exams)Session["ExamData"]; try { TestCode = ExData.ExamCode; // TestCode = "TST0041/005"; MyBank.TestCodeData = this.TestCode; DbExams = new DataBase.Exams(); DbExams.RetrieveExams(TestCode); PaperHeader.InnerText = DbExams.ExamName; string path = String.Format("C://Cosmo//Teachers/QuestionPaper/Exams/Config/{0}", DbExams.ExamData); System.Diagnostics.Debug.WriteLine("There is sec " + ExData.Sections); DropDownList SectionSelector = (DropDownList)MyBank.FindControl("SectionSelection"); ConfigFile MyConfigurations = new ConfigFile(path, ExData.Sections); ConfigFile.Sections ConfigSections = new ConfigFile.Sections(path); Secs.Add(ConfigSections.SectionCount, ConfigSections.SectionWeight, QuestionPanel); DataBase.Questions Qs = new DataBase.Questions(TestCode); if (ConfigSections.SectionCount > 1) { SectionSelector.Visible = true; } else { SectionSelector.Visible = false; } /*Retrieve Question Paper Data from DataSet and Pass it into Table*/ foreach (int Weight in ConfigSections.SectionWeight) { System.Diagnostics.Debug.WriteLine("The Ratio is: " + Weight.ToString()); } Qs.RetrieveData(); DataSet Ds = new DataSet(); Ds = Qs.DataSet; /*Instance of Table Holding Question Data for The Exam Selected*/ DataTable dt = new DataTable(); dt = Ds.Tables[0]; if (dt.Rows.Count > 0) { QuestionPanel.Style.Add(HtmlTextWriterStyle.BackgroundImage, "url(QuestionPaper/Images/CosmoPaperBackground.png)"); } foreach (DataRow Dr in dt.Rows) { List <string> ls = new List <string>(); if (Dr[3] != DBNull.Value) { ls = ((string[])Dr[3]).ToList(); } else { ls = null; } AddQuestion(Convert.ToInt32(Dr[4]), Convert.ToInt32(Dr[2]), Convert.ToInt32(Dr[0]), Dr[1].ToString(), ls, null); } } catch { Response.Redirect("Tests.aspx"); } }