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);
}
