private void btnAddUser_Click(object sender, EventArgs e)
{
//does the username,password contain special character ???
if (cbxTypeUser.selectedIndex == -1)
{
MessBox.MessError("Please select type User !!!"); return;
}
if (!RgEx.isAlphanumericNotSpace(txtUsername.Text, "Username"))
{
return;
}
if (!RgEx.isAlphanumericNotSpace(txtPassword.Text, "Password"))
{
return;
}
//Compare Retype the password again
if (!txtPassword.Text.Equals(txtRqPw.Text))
{
MessBox.MessError("Retype the password incorrectly !!");
}
// insert into Database
int isadmin = 0;
if (cbxTypeUser.selectedValue.Equals("Admin"))
{
isadmin = 1;
}
string query = String.Format("insert into admin_athu values ('{0}','{1}',{2})", txtUsername.Text, txtPassword.Text, isadmin);
ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.insert);
}
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);
}
}
public void insertOption(string idQues)
{
string queryInsertOption = string.Format("insert into Options values(N'{0}',{1},{2},{3})",
RgEx.isNullOrEmpty(Contents), RgEx.isNullOrEmpty(idQues), RgEx.isNullOrEmpty(isImages), RgEx.isNullOrEmpty(isCorrect));
ReturnClass.ExcuteNonQuery(queryInsertOption);
}
private void setDataTable()
{
string query = "select q_id,ex_id,isImage,q_title,exam_name,ad_add,q_addeddate,explain from questions join exams on questions.q_fk_ex = exams.ex_id";
DataTable dt = new DataTable();
ReturnClass.FillAdapter(query, dt);
GridView.DataSource = dt;
SetHeader();
}
private void btnSaved_Click(object sender, EventArgs e)
{
if (!CheckContent())
{
return;
}
string query = string.Format("update exams set exam_name = '{0}' where ex_id = {1}", txtExams.Text, this.idEx);
ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.update);
}
private void setDataGridview(string exName)
{
string query = string.Format("select * from questions join exams on ex_id= q_fk_ex " + exName);
using (DataTable table = new DataTable())
{
ReturnClass.FillAdapter(query, table);
GridView.DataSource = table;
}
}
public void Update()
{
if (RgEx.isEmpty(exam_name))
{
MessBox.MessError("Empty Exams"); return;
}
string query = string.Format("update exams set exam_name = '{0}' where ex_id = {1}", exam_name, ex_id);
ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.update);
}
private void setDataSource()
{
string query = "select exam_name from exams";
DataTable dt = new DataTable();
ReturnClass.FillAdapter(query, dt);
GridView.DataSource = dt;
GridView.Columns[0].Width = GridView.Width;
GridView.Columns[0].HeaderText = "Tên Môn Học";
}
private void guna2ImageButton1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(oldUsername))
{
return;
}
string query = string.Format("update admin_athu set ad_user = '******',ad_password='******',FullName=N'{2}',Live =N'{3}',DateOfBirth = '{4}',PhoneNumber ='{5}',Images='{6}' where ad_user = '******'",
txtUsername.Text, txtPassword.Text, txtFullName.Text, txtLive.Text, txtDate.Value.ToShortDateString(), txtPhoneNum.Text, img, oldUsername);
ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.update);
}
private void InitRandomChoice()
{
////Random Choice
for (int i = 0; i < IdQuestions.Count; ++i)
{
string query = string.Format("select count(id) from Options where id_Qus ={0}", IdQuestions[i]);
optionMix.Add(new List <int>());
check.Add(new List <bool>());
FillOption(int.Parse(ReturnClass.scalarReturn(query)), optionMix[i], check[i]);
}
}
public static DataTable GetDataSource(string query)
{
try
{
DataTable dt = new DataTable();
ReturnClass.FillAdapter(query, dt);
return(dt);
}catch
{
return(null);
}
}
private void AddUsers_Load(object sender, EventArgs e)
{
Clear();
string query = string.Format("select * from admin_athu where isAd = 0 or ad_user ='******' order by isAd asc", FormLogin.username);
using (DataTable dt = new DataTable())
{
ReturnClass.FillAdapter(query, dt);
viewUser.DataSource = dt;
}
SetDataTable();
}
private void setDataSource()
{
string query = "select * from exams";
DataTable dt = new DataTable();
ReturnClass.FillAdapter(query, dt);
viewExams.DataSource = dt;
viewExams.Columns["ex_id"].Visible = false;
viewExams.Columns["exam_name"].Width = viewExams.Width;
viewExams.Columns["exam_name"].HeaderText = "Tên Môn Học";
}
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
}
public void updateOption()
{
if (string.IsNullOrEmpty(this.id))
{
insertOption(id_Qus); return;
}
if (RgEx.isEmpty(Contents))
{
DeleteOption(); return;
}
string queryInsertOption = string.Format("update Options set Contents = N'{0}', isImages = {1},isCorrect = {2} where id_Qus = {3} and id ={4}",
RgEx.isNullOrEmpty(Contents), RgEx.isNullOrEmpty(isImages), RgEx.isNullOrEmpty(isCorrect),
RgEx.isNullOrEmpty(id_Qus), RgEx.isNullOrEmpty(id));
ReturnClass.ExcuteNonQuery(queryInsertOption);
}
public void InsertQuestion()
{
string query = string.Format("insert into questions values (N'{0}','{1}',{2},'{3}',{4},'{5}')",
RgEx.isNullOrEmpty(q_title), RgEx.isNullOrEmpty(q_addeddate), RgEx.isNullOrEmpty(q_fk_ex),
RgEx.isNullOrEmpty(ad_add), RgEx.isNullOrEmpty(isImage), this.explain);
ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.insert);
query = string.Format("select top 1 q_id from questions order by q_id desc");
string id_Ques = ReturnClass.scalarReturn(query);
options.ForEach
(
x => x.insertOption(id_Ques)
);
}
private void WaitAdminForm_Load(object sender, EventArgs e)
{
eclipse.ApplyElipse(pictureBox1, 90);
string query = string.Format("select Images from admin_athu where ad_user = '******'", FormLogin.username);
string result = ReturnClass.scalarReturn(query);
if (!string.IsNullOrEmpty(result))
{
pictureBox1.Image = Image.FromFile(result);
}
txtName.Text = FormLogin.username + " Login";
this.Opacity = 0.9;
timer2.Start();
timer1.Start();
}
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 void UpdateQuestion()
{
if (RgEx.isEmpty(q_title))
{
MessBox.MessWarning("Chưa nhập câu hỏi !!"); return;
}
string query = string.Format("update questions set q_title = N'{0}',isImage = {1},explain ='{2}' where q_id = {3}",
q_title, isImage, explain, q_id);
ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.update);
//for (int i = 0; i < options.Count; ++i)
foreach (var dt in options)
{
dt.id_Qus = dt.id_Qus ?? this.q_id;
dt.updateOption();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (RgEx.isNonCharSpecialAndNonEmpty(txtExams.Text, "Exam name "))
{
string query = string.Format("insert into exams values(N'{0}')", txtExams.Text);
try
{
ReturnClass.ExcuteNonQuery(query, ReturnClass.Status.insert);
//MessBox.MessInf()
RefeshForm();
setDataSource();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
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 btnLogin_Click(object sender, EventArgs e)
{
string user = txtUsername.Text;
string pass = txtPassword.Text;
if (user.Equals("Username") || pass.Equals("Password"))
{
MessBox.MessError("Username or Password is Empty !!"); return;
}
if (!RgEx.isAlphanumericNotSpace(user, "Username"))
{
return;
}
if (!RgEx.isAlphanumericNotSpace(pass, "Password"))
{
return;
}
//MessBox.MessInf(isAd);
string query = string.Format("select isAd from admin_athu where ad_user='******' and ad_password='******'", user, pass);
string isAd = ReturnClass.scalarReturn(query);
//Check invalid User or password
if (isAd.Equals(""))
{
MessBox.MessError("Invalid Input User or Password"); return;
}
//Hide old form login and show form Admin or Students
try
{
this.Hide();
if (isAd.Equals("True"))
{
username = user;
formAdmin.ShowDialog();
}
else
{
formStudents.ShowDialog();
}
this.Show();
}catch
{
}
}
public bool setQuestions(int numQues, int exId, int timePer)
{
string query = string.Format("select count(q_id) from questions where q_fk_ex ={0}", exId);
string IdQuestions = ReturnClass.scalarReturn(query);
if (string.IsNullOrEmpty(IdQuestions) || int.Parse(IdQuestions) < numQues)
{
MessBox.Warning("Num Question or Name Exams invalid "); return(false);
}
this.numQues = numQues;
this.exId = exId;
this.timePer = timePer;
optionMix.Clear();
check.Clear();
RandomNumberQs();
InitRandomChoice();
currentIndex = -1;
return(true);
}
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 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 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 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);
}
public static bool CheckTextQs(int qs)
{
string query = string.Format("select isImage from questions where q_id = {0}", qs);
return(ReturnClass.scalarReturn(query).Equals("True") ? false : true);
}
