public void GetDataUser() { /*Query Filter username in Login form into this Form*/ string query = string.Format("select * from admin_athu where ad_user ='******'", FormLogin.username); using (SqlDataReader reader = ReturnClass.readerReturn(query)) if (reader.Read()) { /*Username*/ setContentPanel(DataReader.GetDataReader(reader, 0) as string, pnUsername, lblUsername); /*Full Name*/ setContentPanel(DataReader.GetDataReader(reader, 3) as string, pnFullName, lblFullName); ////Get object int then compare with null if true then parameter is Empty else string in obj //object obj = DataReader.GetDataReader(reader, 4); //setContentPanel(obj.Equals(null)?"":obj.ToString(), pnAge, lblAge); /*Live*/ setContentPanel(DataReader.GetDataReader(reader, 4) as string, pnLive, lblLive); //Get object Date then compare with null if true then parameter is Empty else cast object into DateTime and // Pass parameter is ToShotDateString method object obj = DataReader.GetDataReader(reader, 5); setContentPanel(obj.Equals(null) ? "" : ((DateTime)obj).ToShortDateString(), pnDateOfBirth, lblDateOfBirth); /*Phone number*/ setContentPanel(DataReader.GetDataReader(reader, 6) as string, pnPhoneNum, lblPhoneNum); obj = DataReader.GetDataReader(reader, 7); pictureBox1.Image = ((obj is System.DBNull || string.IsNullOrEmpty((string)obj))) ? Properties.Resources.businesswoman : Image.FromFile((string)obj); } }
private void FormChooseExams_Load(object sender, EventArgs e) { string query = "select * from exams "; //Load eclipse Border in Form this.Eclipse.ApplyElipse(this, 20); this.Eclipse.ApplyElipse(bunifuGradientPanel1, 15); //Load Component in Combo box Name Exams using (SqlDataReader reader = ReturnClass.readerReturn(query)) { List <string> exName = new List <string>(); while (reader.Read()) { examsCode.Add(reader.GetInt32(0)); exName.Add(reader.GetString(1)); } cbxNameExams.Items = exName.ToArray(); } this.KeyPreview = true; /* SetCombo box Selected */ cbxNameExams.selectedIndex = 0; cbxSelectNumExams.SelectedIndex = 0; cbxTimes.SelectedIndex = 0; }
private void setDataCbxNameExams() { string query = string.Format("select exam_name from exams"); using (SqlDataReader reader = ReturnClass.readerReturn(query)) { while (reader.Read()) { string content = reader.GetString(0); //MessageBox.Show(content); comboBox1.Items.Add(content); } } //comboBox1.Items }
private void setItemCbbExams() { string query = string.Format("select * from exams"); List <string> nameExams = new List <string>(); using (SqlDataReader data = ReturnClass.readerReturn(query)) { while (data.Read()) { Examcode.Add(data.GetInt32(0)); nameExams.Add(data.GetString(1)); } } cbxNameExams.Items = nameExams.ToArray(); }
private void btnDel_Click(object sender, EventArgs e) { if (!CheckContent()) { return; } List <int> q_id = new List <int>(); string query = string.Format("select q_id from questions where q_fk_ex =2"); using (SqlDataReader reader = ReturnClass.readerReturn(query)) { while (reader.Read()) { q_id.Add(reader.GetInt32(0)); } } }
public static void Delete(int exId) { string query = string.Format("select count(q_id) from questions where q_fk_ex ={0}", exId); if (!MessBox.MessWarning(" Confirm deleted " + ReturnClass.scalarReturn(query) + " questions")) { return; } //Process Delete Exams query = string.Format("select q_id from questions where q_fk_ex ={0}", exId); using (SqlDataReader reader = ReturnClass.readerReturn(query)) { while (reader.Read()) { Questions.DeleteQuestion(reader.GetInt32(0)); } } }
private void AddQuestions_Load(object sender, EventArgs e) { SetZoomImage(); pnOps = new PnContentQs(pnOptions, animation, zoomImg); string query = string.Format("select * from exams"); List <string> nameExams = new List <string>(); using (SqlDataReader data = ReturnClass.readerReturn(query)) { while (data.Read()) { Examcode.Add(data.GetInt32(0)); nameExams.Add(data.GetString(1)); } } cbxNameExams.Items = nameExams.ToArray(); switchText_Click(null, null); pnOptions.Controls.SetChildIndex(pnExplain, 0); }
public static Questions GetQuestions(string idQues) { Questions question = new Questions(); try { string query = string.Format("select q_title,isImage from questions where q_id = {0}", idQues); using (SqlDataReader reader = ReturnClass.readerReturn(query)) if (reader.Read()) { question.q_id = idQues; question.q_title = DataReader.GetDataReader(reader, 0) as string; question.isImage = DataReader.getStringBitDb((bool)DataReader.GetDataReader(reader, 1)); } //question.getOption(); return(question); }catch { return(null); } }
public void RandomNumberQs() { List <int> idQuestions; string query = string.Format("select q_id from questions"); using (SqlDataReader reader = ReturnClass.readerReturn(query)) { idQuestions = (from IDataRecord r in reader select(int) r["q_id"]).ToList <int>(); } List <string> IdQuestions = new List <string>(); for (int index = 0; index < this.numQues; ++index) { int value = random.Next(idQuestions.Count); IdQuestions.Add(idQuestions[value].ToString()); idQuestions.RemoveAt(value); } //MessageBox.Show(string.Join("\n", IdQuestions)); this.IdQuestions = IdQuestions; }
public List <Options> getOption() { string query = string.Format("select * from Options where id_Qus ={0}", q_id); List <Options> options = new List <Options>(); using (SqlDataReader reader = ReturnClass.readerReturn(query)) { while (reader.Read()) { string id_Op = reader.GetInt32(0).ToString(); string Contents = reader.GetString(1); string id_ques = reader.GetInt32(2).ToString(); string isImage = DataReader.getStringBitDb(reader.GetBoolean(3)); string isCorrect = DataReader.getStringBitDb(reader.GetBoolean(4)); Options op = new Options(id_Op, Contents, isImage, isCorrect); op.id_Qus = id_ques; options.Add(op); } } setOption(options); return(options); }
public static List <string> getContentOption(string qs, List <string> Contents, List <bool> check) { string msg = "Contents"; if (check != null) { msg += ",isCorrect"; } string query = string.Format("select {0} from Options where id_Qus ={1}", msg, qs); using (SqlDataReader reader = ReturnClass.readerReturn(query)) { while (reader.Read()) { Contents.Add(reader.GetString(0)); if (check != null) { check.Add(reader.GetBoolean(1)); } } } return(Contents); }