private void AssignProjectButton_Click(object sender, EventArgs e)
{
try
{
string projectTitle = ProjectsComboBox.Text.ToString();
string groupId = GroupsComboBox.Text.ToString();
SqlConnection conn = new SqlConnection(connString);
conn.Open();
string query1 = string.Format("SELECT Id FROM Project WHERE Title = '{0}'", projectTitle);
SqlCommand cmd = new SqlCommand(query1, conn);
int id = (Int32)cmd.ExecuteScalar();
if (value != "edit")
{
string query = string.Format("INSERT INTO GroupProject(ProjectId, GroupId, AssignmentDate) Values('{0}', '{1}', '{2}')", id, groupId, DateTime.Now);
cmd.CommandText = query;
cmd.ExecuteNonQuery();
}
else if (value == "edit")
{
string query = string.Format("UPDATE GroupProject SET ProjectId = '{0}', AssignmentDate = '{2}' WHERE GroupId = '{1}'", id, GroupId, DateTime.Now);
cmd.CommandText = query;
cmd.ExecuteNonQuery();
}
}
catch (Exception)
{
MessageBox.Show("Please select a group and project from the list");
}
GroupProjects form = new GroupProjects();
form.Show();
this.Close();
}
private void AssignProject_Click(object sender, EventArgs e)
{
GroupProjects form = new GroupProjects();
form.Show();
this.Hide();
}
private void BackButton_Click(object sender, EventArgs e)
{
GroupProjects form = new GroupProjects();
form.Show();
this.Close();
}
