private void btnlogin_Click_1(object sender, EventArgs e)
{
try
{
acc.Pro_id = Convert.ToInt32(txtidmain.Text);
acc.Password = txtpassmain.Text;
promng.verifyprogram(acc.Pro_id, acc.Password);
accmng.createkey(acc.Pro_id);
pro = promng.get(Convert.ToInt32(accmng.readkey()));
string[] a = accmng.annoucements().Split('\n');
foreach (string s in a)
{
listBox1.Items.Add(s);
}
panel6.Visible = false;
phome.Visible = true;
dataGridView1.DataSource = promng.getcourse(Convert.ToInt32(accmng.readkey()));
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dataGridView2.DataSource = promng.getAll(Convert.ToInt32(accmng.readkey()));
FillForm(pro, acc);
lblmsg.Text = "";
txtidmain.Text = "";
txtpassmain.Text = "";
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
public Addpro()
{
accmng = new Accmng();
pro = new Pro();
acc = new Account();
promng = new Progmng();
InitializeComponent();
if (accmng.readkey() != null)
{
pro = promng.get(Convert.ToInt32(accmng.readkey()));
if (pro.Program_id.Equals(Convert.ToInt32(accmng.readkey())))
{
string[] a = accmng.annoucements().Split('\n');
foreach (string s in a)
{
listBox1.Items.Add(s);
}
panel6.Visible = false;
phome.Visible = true;
pro = promng.get(Convert.ToInt32(accmng.readkey()));
acc = accmng.getpropass(Convert.ToInt32(accmng.readkey()));
dataGridView1.DataSource = promng.getcourse(Convert.ToInt32(accmng.readkey()));
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dataGridView2.DataSource = promng.getAll(Convert.ToInt32(accmng.readkey()));
FillForm(pro, acc);
}
else
{
throw new Exception("Access Denied");
}
}
}
public List <Pro> getprogram()
{
List <Pro> mylist = new List <Pro>();
Pro obj = null;
strQuery = "select pro_id,program_name,sem_num,sem_name from program,semester where semester.sem_id=program.sem_id;";
cmd = conobj.execute(this.strQuery);
SqlDataReader dr;
try
{
conobj.openconnect();
dr = cmd.ExecuteReader();
while (dr.Read())
{
obj = new Pro();
obj.Program_id = dr.GetInt32(0);
obj.Program_Name = dr.GetString(1);
obj.Semester_Number = dr.GetInt32(2);
obj.Semester_Name = dr.GetString(3);
mylist.Add(obj);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
conobj.closeconnect();
}
return(mylist);
}
private void FillForm(Pro pro, Account acc)
{
lblid.Text = accmng.readkey();
lblname.Text = pro.Program_Name;
txtpas.Text = acc.Password;
lblsemnum.Text = Convert.ToString(pro.Semester_Number);
lblsemname.Text = pro.Semester_Name;
}
