private void frm_create_test_Load(object sender, EventArgs e)
{
s=null;
ob=new class_Application();
s = "select exam_code,exam_name from exam_master;";
ob.fill_combo_box(comboBox1, s, "exam_name");
}
private void frm_SelectStudent_Load(object sender, EventArgs e)
{
ob = new class_Application();
s = "select user_id,user_name from user_access";
ds = ob.fill_data_set(s);
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
dataGridView1.Columns.Add("user_id", "USER ID");
dataGridView1.Columns.Add("user_name", "USER NAME");
dataGridView1.Columns.Add(chk);
dataGridView1.Columns[2].HeaderText = "SELECT";
dataGridView1.Columns[2].Name = "select";
dataGridView1.RowHeadersVisible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[1].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[2].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Rows.Add(ds.Tables[0].Rows.Count);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{ dataGridView1.Rows[i].Cells["user_id"].Value = ds.Tables[0].Rows[i]["user_id"];
dataGridView1.Rows[i].Cells["user_name"].Value = ds.Tables[0].Rows[i]["user_name"];
}
}
//----form load event--->
private void frm_create_questions_Load(object sender, EventArgs e)
{
ob = new class_Application();
refresh_me();
}
private void frm_experimemnt_Load(object sender, EventArgs e)
{
seconds = Duration * 60;
ob = new class_Application();
count = 0;
MyTabs();
}
//---form load event-------->
private void frm_select_exam_Load(object sender, EventArgs e)
{
ob = new class_Application();
s = null;
s="SELECT Test_Master.Exam_code, Test_Master.Test_code, Exam_Master.Exam_Name, Test_Master.Test_Name,"+
" Test_Master.Test_Duration FROM (Exam_Master INNER JOIN Test_Master ON"+
" Exam_Master.Exam_Code = Test_Master.Exam_code) INNER JOIN Questions_Master "+
"ON (Exam_Master.Exam_Code = Questions_Master.Exam_code) AND (Test_Master.Test_code = Questions_Master.Test_code)"+
" AND (Test_Master.Exam_code = Questions_Master.Exam_code);";
ds = ob.fill_data_set(s);
var query = from p in ds.Tables[0].AsEnumerable()
group p by new
{
ExamCode=p.Field<string>(0),
TestCode=p.Field<string>(1),
ExamNmae=p.Field<string>(2),
TestName=p.Field<string>(3),
Duration=p.Field<int>(4)
} into grp
select new
{
ExamCode = grp.Key.ExamCode,
TestCode = grp.Key.TestCode,
ExamNmae = grp.Key.ExamNmae,
TestName = grp.Key.TestName,
Duration = grp.Key.Duration
};
DataTable dt_table = new DataTable();
dt_table.Columns.Add("ExamCode", typeof(string));
dt_table.Columns.Add("TestCode", typeof(string));
dt_table.Columns.Add("ExamName", typeof(string));
dt_table.Columns.Add("TestName", typeof(string));
dt_table.Columns.Add("Duration", typeof(int));
DataRow combo_row;
foreach (var grp in query)
{ combo_row = dt_table.NewRow();
combo_row["ExamCode"] = grp.ExamCode;
combo_row["TestCode"] = grp.TestCode;
combo_row["ExamName"] = grp.ExamNmae;
combo_row["TestName"] = grp.TestName;
combo_row["Duration"] = grp.Duration;
dt_table.Rows.Add(combo_row);
}
comboBox1.DataSource = dt_table;
comboBox1.DisplayMember = "ExamName";
}
private void frm_subject_master_Load(object sender, EventArgs e)
{
exam_code = null;
ob = new class_Application();
//---filling the combobox1-->
s = "select exam_code,exam_name from exam_master;";
ob.fill_combo_box(comboBox1, s, "exam_name");
}
private void Form1_Load(object sender, EventArgs e)
{
//--instantiating the parent form-->
class_Application.parent_form = this;
//--instantiating the object ob of the class application--->
ob = new class_Application();
frm_login frm_login = new frm_login();
frm_login.MdiParent = this;
frm_login.StartPosition = FormStartPosition.CenterScreen;
frm_login.Show();
}
private void frm_subject_master_Load(object sender, EventArgs e)
{
exam_code = null;
group_code = null;
ob = new class_Application();
s = "select exam_code,exam_name from exam_master;";
ob.fill_combo_box(comboBox1, s, "exam_name");
s = "select group_code,group_name from group_master";
ob.fill_combo_box(comboBox2, s, "group_name");
}
//---button click event for successful login--->
private void button1_Click(object sender, EventArgs e)
{
string s;
s = null;
DataSet ds = new DataSet();
ob = new class_Application();
s = "SELECT User_Access.User_ID,user_name,user_role FROM User_Access where user_name='"+ textBox1.Text.ToUpper() +"' and user_password='******' and is_active=1;";
ds = ob.fill_data_set(s);
//---elaborate login code will go in here----->
if (ds.Tables[0].Rows.Count>0 && Convert.ToString(ds.Tables[0].Rows[0][2]).Equals("ADMIN"))
{ class_Application.user_id = Convert.ToString(ds.Tables[0].Rows[0][0]);
class_Application.user_name = Convert.ToString(ds.Tables[0].Rows[0][1]);
class_Application.parent_form.enable_admin_menu();
this.Close();
}
else if (ds.Tables[0].Rows.Count > 0 && Convert.ToString(ds.Tables[0].Rows[0][2]).Equals("USER"))
{
class_Application.user_id = Convert.ToString(ds.Tables[0].Rows[0][0]);
class_Application.user_name = Convert.ToString(ds.Tables[0].Rows[0][1]);
class_Application.parent_form.enable_user_menu();
this.Close();
}
else
{
MessageBox.Show("Please check your login id or password");
}
}
private void frm_QuestionAddEdit_Load(object sender, EventArgs e)
{ s = null;
ob = new class_Application();
s = "SELECT Exam_Master.Exam_Code, Test_Master.Test_code, Subject_Master.Sub_code, Exam_Master.Exam_Name, " +
"Test_Master.Test_Name, Subject_Master.Sub_Name FROM (Exam_Master INNER JOIN Test_Master ON " +
"Exam_Master.Exam_Code = Test_Master.Exam_code) INNER JOIN Subject_Master ON Exam_Master.Exam_Code = " +
"Subject_Master.Exam_code;";
dt = new DataTable();
dt = ob.fill_data_table(s);
var query = from p in dt.AsEnumerable()
group p by new
{ ExamCode = p.Field<string>("Exam_Code"),
ExamName = p.Field<string>("Exam_Name")
} into grp
select new
{ ExamCode = grp.Key.ExamCode,
ExamName = grp.Key.ExamName
};
DataTable ExamTable = new DataTable("Exam_Master");
ExamTable.Columns.Add("ExamCode", typeof(string));
ExamTable.Columns.Add("ExamName", typeof(string));
foreach (var grp in query)
{ DataRow dr = ExamTable.NewRow();
dr["ExamCode"] = grp.ExamCode;
dr["ExamName"] = grp.ExamName;
ExamTable.Rows.Add(dr);
}
comboBox1.DataSource = ExamTable;
comboBox1.DisplayMember = "ExamName";
}
//-----form load event---->
private void Frm_test_type_Load(object sender, EventArgs e)
{
ob = new class_Application();
fill_grid();
}
//--form load event---->
private void frm_exam_Load(object sender, EventArgs e)
{
count = 0;
ob = new class_Application();
if (class_Application.REVIEW == 0)
{
timer1.Enabled = true;
lbl_timer.Visible = true;
string s = "SELECT Exam_Master.Exam_Code, Subject_Master.Sub_code, Test_Master.Test_code, Exam_Master.Exam_Name," +
" Subject_Master.Sub_Name, Test_Master.Test_Name, Questions_Master.Q_No, Questions_Master.Q_Name, " +
"Questions_Master.Answer1, Questions_Master.Answer2, Questions_Master.Answer3, Questions_Master.Answer4, " +
"Questions_Master.Answer5, Questions_Master.Answer6, Questions_Master.Answer7, Questions_Master.Answer8, " +
"Questions_Master.Answer9, Questions_Master.Answer10, Questions_Master.Answer11, Questions_Master.Answer12, " +
"Questions_Master.Answer13, Questions_Master.Answer14, Questions_Master.Answer15, Questions_Master.Answer16," +
" Questions_Master.Answer17, Questions_Master.Answer18, Questions_Master.Qname_HasImage,"+
"Questions_Master.Q_type,Exam_Master.Can_Skip,sub_duration FROM ((Exam_Master INNER JOIN Subject_Master ON " +
"Exam_Master.Exam_Code = Subject_Master.Exam_code) INNER JOIN Test_Master ON Exam_Master.Exam_Code = " +
"Test_Master.Exam_code) INNER JOIN Questions_Master ON (Exam_Master.Exam_Code = Questions_Master.Exam_code) AND " +
"(Test_Master.Test_code = Questions_Master.Test_code) AND (Test_Master.Exam_code = Questions_Master.Exam_code)" +
" AND (Subject_Master.Exam_code = Questions_Master.Exam_code) AND (Subject_Master.Sub_code = Questions_Master.Sub_code) " +
"WHERE (((Exam_Master.Exam_Code)='" + ExamCode + "') AND ((Test_Master.Test_code)='" + TestCode + "'));";
init_datatable = ob.fill_data_table(s);
collection = new DataTable();
collection = init_datatable.Clone();
collection.Columns.Add("option1", typeof(int));
collection.Columns.Add("option2", typeof(int));
collection.Columns.Add("option3", typeof(int));
collection.Columns.Add("option4", typeof(int));
collection.Columns.Add("option5", typeof(int));
collection.Columns.Add("option6", typeof(int));
collection.Columns.Add("option7", typeof(int));
collection.Columns.Add("option8", typeof(int));
collection.Columns.Add("option9", typeof(int));
collection.Columns.Add("option10", typeof(int));
collection.Columns.Add("option11", typeof(int));
collection.Columns.Add("option12", typeof(int));
collection.Columns.Add("option13", typeof(int));
collection.Columns.Add("option14", typeof(int));
collection.Columns.Add("option15", typeof(int));
collection.Columns.Add("option16", typeof(int));
collection.Columns.Add("option17", typeof(int));
collection.Columns.Add("option18", typeof(int));
collection.Columns.Add("essay_answer", typeof(string));
var query = from p in init_datatable.AsEnumerable()
group p by new
{
SubjectCode = p.Field<string>("Sub_code"),
SubjectName = p.Field<string>("Sub_Name"),
time = p.Field<int>("sub_duration"),
CanSkip = p.Field<int>("Can_Skip")
} into grp
select new
{
SubjectCode = grp.Key.SubjectCode,
SubjectName = grp.Key.SubjectName,
time = grp.Key.time,
CanSkip = grp.Key.CanSkip
};
Subject = new DataTable("Subject");
Subject.Columns.Add("SubjectCode", typeof(string));
Subject.Columns.Add("SubjectName", typeof(string));
Subject.Columns.Add("time", typeof(int));
Subject.Columns.Add("CanSkip", typeof(int));
foreach (var grp in query)
{
DataRow dr = Subject.NewRow();
dr["SubjectCode"] = grp.SubjectCode;
dr["SubjectName"] = grp.SubjectName;
dr["time"] = grp.time;
dr["CanSkip"] = grp.CanSkip;
Subject.Rows.Add(dr);
}
lbl_exam.Text = ExamName;
lbl_test.Text = TestName;
string sub_code = Convert.ToString(Subject.Rows[count]["SubjectCode"]);
time = Convert.ToInt32(Subject.Rows[count]["time"]) * 60;
bind_data(sub_code);
}
else
{
timer1.Enabled = false;
lbl_timer.Visible = false;
string s = "SELECT Exam_Master.Exam_Code, Subject_Master.Sub_code, Test_Master.Test_code, Exam_Master.Exam_Name, "+
"Subject_Master.Sub_Name, Test_Master.Test_Name, Questions_Master.Q_No, Questions_Master.Q_Name, Questions_Master.Answer1, "+
"Questions_Master.Answer2, Questions_Master.Answer3, Questions_Master.Answer4, Questions_Master.Answer5, "+
"Questions_Master.Answer6, Questions_Master.Answer7, Questions_Master.Answer8, Questions_Master.Answer9, "+
"Questions_Master.Answer10, Questions_Master.Answer11, Questions_Master.Answer12, Questions_Master.Answer13, "+
"Questions_Master.Answer14, Questions_Master.Answer15, Questions_Master.Answer16, Questions_Master.Answer17, "+
"Questions_Master.Answer18, Questions_Master.Qname_HasImage, Questions_Master.Correct_Option, Questions_Master.Q_type, "+
"User_Exam_Dtl.Option1, User_Exam_Dtl.Option2, User_Exam_Dtl.Option3, User_Exam_Dtl.Option4, User_Exam_Dtl.Option5, "+
"User_Exam_Dtl.Option6, User_Exam_Dtl.Option7, User_Exam_Dtl.Option8, User_Exam_Dtl.Option9, User_Exam_Dtl.Option10, "+
"User_Exam_Dtl.Option11, User_Exam_Dtl.Option12, User_Exam_Dtl.Option13, User_Exam_Dtl.Option14, User_Exam_Dtl.Option15, "+
"User_Exam_Dtl.Option16, User_Exam_Dtl.Option17, User_Exam_Dtl.Option18, User_Exam_Dtl.Essay_Answer FROM (((Exam_Master INNER "+
"JOIN Test_Master ON Exam_Master.Exam_Code = Test_Master.Exam_code) INNER JOIN Subject_Master ON Exam_Master.Exam_Code = "+
"Subject_Master.Exam_code) INNER JOIN Questions_Master ON (Exam_Master.Exam_Code = Questions_Master.Exam_code) AND "+
"(Test_Master.Test_code = Questions_Master.Test_code) AND (Test_Master.Exam_code = Questions_Master.Exam_code) AND "+
"(Subject_Master.Exam_code = Questions_Master.Exam_code) AND (Subject_Master.Sub_code = Questions_Master.Sub_code)) "+
"INNER JOIN User_Exam_Dtl ON (Exam_Master.Exam_Code = User_Exam_Dtl.Exam_code) AND (Questions_Master.Q_No = User_Exam_Dtl.Q_No) "+
"AND (Questions_Master.Test_code = User_Exam_Dtl.Test_code) AND (Questions_Master.Sub_code = User_Exam_Dtl.Sub_code) AND "+
"(Questions_Master.Exam_code = User_Exam_Dtl.Exam_code) WHERE (((Exam_Master.Exam_Code)='"+ ExamCode +"') AND "+
"((Test_Master.Test_code)='"+ TestCode +"') AND ((User_Exam_Dtl.User_ID)='"+ class_Application.user_id +"'));";
init_datatable = ob.fill_data_table(s);
var query = from p in init_datatable.AsEnumerable()
group p by new
{
SubjectCode = p.Field<string>("Sub_code"),
SubjectName = p.Field<string>("Sub_Name"),
} into grp
select new
{
SubjectCode = grp.Key.SubjectCode,
SubjectName = grp.Key.SubjectName,
};
Subject = new DataTable("Subject");
Subject.Columns.Add("SubjectCode", typeof(string));
Subject.Columns.Add("SubjectName", typeof(string));
foreach (var grp in query)
{
DataRow dr = Subject.NewRow();
dr["SubjectCode"] = grp.SubjectCode;
dr["SubjectName"] = grp.SubjectName;
Subject.Rows.Add(dr);
}
lbl_exam.Text = ExamName;
lbl_test.Text = TestName;
string sub_code = Convert.ToString(Subject.Rows[count]["SubjectCode"]);
bind_data_for_review(sub_code);
}
}
private void Form1_Load(object sender, EventArgs e)
{
ob = new class_Application();
MyTabs();
}
//---load event for organisation master--->
private void frm_mater_organisation_Load(object sender, EventArgs e)
{
ob = new class_Application();
fill_grid();
}
private void frm_sub_group_Load(object sender, EventArgs e)
{
ob = new class_Application();
fill_grid();
}
private void frm_create_user_Load(object sender, EventArgs e)
{
ob = new class_Application();
fill_grid();
}
