private void linkLabel10_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { CreateGroup g = new CreateGroup(); this.Hide(); g.Show(); }
private void groupBox1_Enter(object sender, EventArgs e) { CreateGroup frm = new CreateGroup(); this.Hide(); frm.Show(); }
public void Addstudentinexistinggroup(ComboBox comboBox2, DataGridView dataGridView1, Label labelerror, Label lblerror) { if (comboBox2.Text != "") { string cmd = "select GroupId from GroupProject where ProjectId = (Select Id from Project where Title = '" + comboBox2.Text + "')"; int h = dbConnection.getInstance().getScalerData(cmd); string co = "Select count(StudentId) from GroupStudent where GroupId = '" + h + "'"; int ho = dbConnection.getInstance().getScalerData(co); bool iss = false; int count = 0; List <int> indexes = new List <int>(); foreach (DataGridViewRow r in dataGridView1.Rows) { if (Convert.ToBoolean(r.Cells["ADD"].Value) == true) { count++; iss = true; int com = r.Index; indexes.Add(com); } } if (count == 0) { labelerror.Text = "Select the student first"; labelerror.Visible = true; } if (ho + count <= 4 && comboBox2.Text != "") { foreach (int i in indexes) { foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Index == i) { string Reg = row.Cells["RegistrationNo"].Value.ToString(); string cd = "Select Id from Student where RegistrationNo ='" + Reg + "'"; int q = dbConnection.getInstance().getScalerData(cd); string final = "Insert into GroupStudent (GroupId, StudentId,Status,AssignmentDate) values ('" + h + "','" + q + "','" + 4 + "','" + DateTime.Now.Date + "')"; dbConnection.getInstance().exectuteQuery(final); } } } MessageBox.Show("Student has been added"); // CreateGroup.Hide(); CreateGroup frm = new CreateGroup(); frm.Hide(); CreateGroup frmo = new CreateGroup(); frmo.Show(); } else if (comboBox2.Text == "") { lblerror.Text = "Select Title for project"; lblerror.Visible = true; } else if (ho + count > 4) { labelerror.Text = "Only 4 students are allowed in each group"; labelerror.Visible = true; } } else { lblerror.Text = "Select Title for project"; lblerror.Visible = true; } }
private void button1_Click(object sender, EventArgs e) { Group g = new Group(); bool iss = g.checkboxchech(dataGridView1); int count = g.NoOfSt(dataGridView1); if (iss == true && comboBox1.Text != "" && count <= 4) { List <int> indexess = new List <int>(); string cmd2 = "Insert into [Group] (Created_On) Values ('" + DateTime.Now.Date + "')"; dbConnection.getInstance().exectuteQuery(cmd2); string cmd3 = "Select max(Id) from [Group]"; int gh = dbConnection.getInstance().getScalerData(cmd3); string cmdt = "Select Id from Project where Title = '" + comboBox1.Text + "'"; int yu = dbConnection.getInstance().getScalerData(cmdt); string vb = "Insert into GroupProject (ProjectId,GroupId,AssignmentDate) values ('" + yu + "','" + gh + "','" + DateTime.Now + "')"; dbConnection.getInstance().exectuteQuery(vb); //List of those row indexes having add checkbox checked List <int> indexes = g.ListOfindexes(indexess, dataGridView1); foreach (int i in indexes) { foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Index == i) { string Reg = row.Cells["RegistrationNo"].Value.ToString(); string cmd = "Select Id from Student where RegistrationNo ='" + Reg + "'"; int q = dbConnection.getInstance().getScalerData(cmd); string s = "Select Id from Lookup where Category = 'STATUS' and Value = 'InActive'"; int qo = dbConnection.getInstance().getScalerData(s); string final = "Insert into GroupStudent (GroupId, StudentId,Status,AssignmentDate) values ('" + gh + "','" + q + "','" + qo + "','" + DateTime.Now.Date + "')"; dbConnection.getInstance().exectuteQuery(final); } } } MessageBox.Show("Group has been Created"); this.Hide(); CreateGroup gm = new CreateGroup(); gm.Show(); } else if (count > 4) { labelerror.Text = "Only 4 students are allowed in a group"; labelerror.Visible = true; } else if (comboBox1.Text == "") { lblerror.Text = "Please Select a Title"; lblerror.Visible = true; } else if (iss == false) { lblerror.Text = "Select Student First"; lblerror.Visible = true; } }