using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace SimpleGUI
{
public partial class Sectionfrm : Form
{
string Connection = Global.ConnectionString;
public Sectionfrm()
{
InitializeComponent();
}
private void Sectionfrm_Load(object sender, EventArgs e)
{
//gendercmb.Items.Clear();
//gendercmb.Items.Add("All");
//gendercmb.Items.Add("Male");
//gendercmb.Items.Add("Female");
//gendercmb.SelectedIndex = 0;
//gradelevelcmb.Items.Clear();
//gradelevelcmb.Items.Add("All");
//gradelevelcmb.Items.Add("Grade 7");
//gradelevelcmb.Items.Add("Grade 8");
//gradelevelcmb.Items.Add("Grade 9");
//gradelevelcmb.Items.Add("Grade 10");
//gradelevelcmb.Items.Add("Grade 11");
//gradelevelcmb.Items.Add("Grade 12");
//gradelevelcmb.SelectedIndex = 0;
filter();
LoadSignupData();
}
public void filter()
{
gendercmb.Items.Clear();
gendercmb.Items.AddRange(new string[] { "All", "Male", "Female" });
gendercmb.SelectedIndex = 0;
gradelevelcmb.Items.Clear();
gradelevelcmb.Items.AddRange(new string[] { "All", "Grade 7", "Grade
8", "Grade 9", "Grade 10", "Grade 11", "Grade 12" });
gradelevelcmb.SelectedIndex = 0;
}
public void LoadSignupData()
{
string connectionStrings = Connection;
string selectedGender = gendercmb.Text.Trim();
string selectedGrade = gradelevelcmb.Text.Trim();
string query = @"
SELECT
ID,
FName,
MName,
LName,
Grade,
BDay,
Address,
Gender,
ContactNo,
Username,
Password
FROM SignupInformationTBL
WHERE (@Gender = 'All' OR Gender = @Gender)
AND (@Grade = 'All' OR Grade = @Grade)
ORDER BY LName, FName";
try
{
using (SqlConnection conn = new SqlConnection(connectionStrings))
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@Gender", selectedGender);
cmd.Parameters.AddWithValue("@Grade", selectedGrade);
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
Profileview.Rows.Clear();
Profileview.ClearSelection();
string resourcesPath = Path.Combine(Application.StartupPath,
"Resources");
foreach (DataRow row in dt.Rows)
{
int rowIndex = Profileview.Rows.Add();
Profileview.Rows[rowIndex].Cells["ID"].Value = row["ID"];
Profileview.Rows[rowIndex].Cells["FName"].Value =
row["FName"];
Profileview.Rows[rowIndex].Cells["MName"].Value =
row["MName"];
Profileview.Rows[rowIndex].Cells["LName"].Value =
row["LName"];
Profileview.Rows[rowIndex].Cells["Grade"].Value =
row["Grade"];
Profileview.Rows[rowIndex].Cells["BDay"].Value =
Convert.ToDateTime(row["BDay"]).ToString("yyyy-MM-dd");
Profileview.Rows[rowIndex].Cells["Address"].Value =
row["Address"];
Profileview.Rows[rowIndex].Cells["Gender"].Value =
row["Gender"];
Profileview.Rows[rowIndex].Cells["ContactNo"].Value =
row["ContactNo"];
Profileview.Rows[rowIndex].Cells["Username"].Value =
row["Username"];
Profileview.Rows[rowIndex].Cells["Password"].Value =
row["Password"];
try
{
Profileview.Rows[rowIndex].Cells["Icon"].Value =
Image.FromFile(Path.Combine(resourcesPath, "student2.png"));
}
catch
{
}
try { Profileview.Rows[rowIndex].Cells["Edit"].Value =
Image.FromFile(Path.Combine(resourcesPath, "eye.png"));
}
catch
{ }
try { Profileview.Rows[rowIndex].Cells["Delete"].Value =
Image.FromFile(Path.Combine(resourcesPath, "delete.png")); } catch { }
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error loading profile data: " + ex.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Profileview.CurrentCell = null;
Profileview.AllowUserToAddRows = false;
}
public void mdsldflk()
{
}
private void gendercmb_SelectedIndexChanged(object sender, EventArgs e)
{
LoadSignupData();
}
private void gradelevelcmb_SelectedIndexChanged(object sender, EventArgs e)
{
LoadSignupData();
}
private void Profileview_CellMouseEnter(object sender,
DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0 && (e.ColumnIndex == 12 || e.ColumnIndex == 13))
{
Profileview.Cursor = Cursors.Hand;
}
else
{
Profileview.Cursor = Cursors.Default;
}
}
}
}
