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_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";
}
//---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");
}
}