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; }