private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
//int i = 0;
if (dataGridView1.Columns[e.ColumnIndex].Name == "Add_to_group" && (e.RowIndex >= 0))
{
conn.Open();
try
{
if (MessageBox.Show("Are You Sure You Want to Add this?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);
string g = string.Format("Select MAX(Id) From [Group]");
SqlCommand f = new SqlCommand(g, conn);
int Grp_id = (int)f.ExecuteScalar();
string m1 = String.Format("INSERT INTO [GroupStudent](GroupId, StudentId, Status, AssignmentDate) values('{0}', '{1}', '{2}', '{3}' )", Grp_id, id, 3, DateTime.Now);
SqlCommand command1 = new SqlCommand(m1, conn);
//command1.Parameters.Add(new SqlParameter("@Id", id));
int rows1 = command1.ExecuteNonQuery();
if (rows1 != 0)
{
MessageBox.Show("Added");
//counter = counter + 1;
if (MessageBox.Show("Do you want to add another student?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
//MessageBox.Show("Assign at least two students to a group");
this.Close();
//Group1 b = new Group1();
}
else
{
Group1 b = new Group1();
b.Show();
}
}
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void button2_Click(object sender, EventArgs e)
{
if (conn.State == System.Data.ConnectionState.Open)
{
try
{
//conn.Open();
string k = String.Format("INSERT INTO [Group](Created_On) values('{0}')", DateTime.Now);
//String cmd3 = String.Format("INSERT INTO Student(Id, RegistrationNo) values('{0}', '{1}')", id2, C1.Get_Reg_No());
SqlCommand f = new SqlCommand(k, conn);
int Grp_id = f.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Group1 g = new Group1();
g.Show();
}
else
{
conn.Open();
try
{
//conn.Open();
string k = String.Format("INSERT INTO [Group](Created_On) values('{0}')", DateTime.Now);
//String cmd3 = String.Format("INSERT INTO Student(Id, RegistrationNo) values('{0}', '{1}')", id2, C1.Get_Reg_No());
SqlCommand f = new SqlCommand(k, conn);
int Grp_id = f.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Group1 g = new Group1();
g.Show();
}
}
private void label6_Click(object sender, EventArgs e)
{
Group1 g = new Group1();
g.Show();
}
