public Response Insert(SpaceTraining space)
{
Response response = new Response();
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConnectionHelper.GetConnectionString();
SqlCommand command = new SqlCommand();
command.CommandText = "INSERT INTO SPACETRAINING (NAME, MAXCAPACITY) VALUES(@NAME, @MAXCAPACITY)";
command.Parameters.AddWithValue("@NAME", space.Name);
command.Parameters.AddWithValue("@MAXCAPACITY", (int)space.MaxCapacity);
command.Connection = connection;
try
{
connection.Open();
command.ExecuteNonQuery();
response.Success = true;
response.Message = "Dados inseridos com sucesso.";
}
catch (Exception ex)
{
response.Success = false;
response.Message = "Erro no banco de dados, contate o administrador.";
response.StackTrace = ex.StackTrace;
response.ExeptionMessage = ex.Message;
}
finally
{
connection.Close();
}
return(response);
} //test
} //test
public Response UpdateStage2ID(SpaceTraining _space, Person _person) //test
{
Response response = new Response();
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConnectionHelper.GetConnectionString();
SqlCommand command = new SqlCommand();
command.CommandText = "UPDATE PERSONS SET STAGE2ID = @STAGE2ID WHERE ID LIKE @ID";
command.Parameters.AddWithValue("@STAGE2ID", _space.ID);
command.Parameters.AddWithValue("@ID", _person.ID);
command.Connection = connection;
try
{
connection.Open();
command.ExecuteNonQuery();
response.Success = true;
response.Message = "Dados inseridos com sucesso.";
}
catch (Exception ex)
{
response.Success = false;
response.Message = "Erro no banco de dados, contate o administrador.";
response.StackTrace = ex.StackTrace;
response.ExeptionMessage = ex.Message;
}
finally
{
connection.Close();
}
return(response);
}
public void TestUpdateMaxCapacity()
{
SpaceTraining s2 = new SpaceTraining();
s2.ID = 1;
s2.MaxCapacity = 6;
Response response = spaceTBLL.UpdateMaxCapacity(s2);
}
public void TestGetPeopleByStage1ID()
{
SpaceTraining spaceT3 = new SpaceTraining();
spaceT3.ID = 1;
QueryResponse <Person> response = personBLL.GetPeopleByStage1ID(spaceT3);
Assert.AreEqual(true, response.Success);
}
public void TestGetByName()
{
SpaceTraining s1 = new SpaceTraining();
s1.Name = "Sala";
TableResponse response = spaceTBLL.GetByName(s1);
Assert.AreEqual(true, response.Success);
}
public void TestGetByStage2ID()
{
SpaceTraining spaceT5 = new SpaceTraining();
spaceT5.ID = 1;
TableResponse response = personBLL.GetAllByStage2ID(spaceT5);
Assert.AreEqual(true, response.Success);
}
public void TestInsert()
{
SpaceTraining space3 = new SpaceTraining();
space3.Name = "Sala três";
space3.MaxCapacity = 6;
Response response = spaceTBLL.Insert(space3);
Assert.AreEqual(true, response.Success);
}
public void TestGet()
{
SpaceTraining space4 = new SpaceTraining();
space4.Name = "Sala quatro";
space4.MaxCapacity = 6;
spaceTBLL.Insert(space4);
SingleResponse <SpaceTraining> response = spaceTBLL.Get(space4);
Assert.AreEqual(true, response.Success);
}
public void TestCheckHowToCreate()
{
SpaceTraining spaceT = new SpaceTraining();
spaceT.Name = "Sala teste";
spaceT.MaxCapacity = 6;
spaceTBLL.Insert(spaceT);
SingleResponse <Operator> response = spaceTBLL.CheckHowToCreate(spaceT);
Assert.AreEqual(true, response.Success);
}
public void TestUpdateStage1ID()
{
Person p2 = new Person();
p2.ID = 1;
SpaceTraining spaceT1 = new SpaceTraining();
spaceT1.ID = 1;
Response response = personBLL.UpdateStage1ID(spaceT1, p2);
Assert.AreEqual(true, response.Success);
}
public void TestUpdateStage2()
{
Person p3 = new Person();
p3.ID = 1;
SpaceTraining spaceT2 = new SpaceTraining();
spaceT2.ID = 1;
Response response = personBLL.UpdateStage2ID(spaceT2, p3);
Assert.AreEqual(true, response.Success);
}
public QueryResponse <Person> GetPeopleByStage1ID(SpaceTraining _space)
{
QueryResponse <Person> response = new QueryResponse <Person>();
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConnectionHelper.GetConnectionString();
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT * FROM PERSONS WHERE STAGE1ID LIKE @VALUE";
command.Parameters.AddWithValue("@VALUE", _space.ID);
command.Connection = connection;
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <Person> persons = new List <Person>();
while (reader.Read())
{
Person person = new Person();
person.ID = (int)reader["ID"];
person.Name = (string)reader["NAME"];
person.Surname = (string)reader["SURNAME"];
person.FullName = (string)reader["FULLNAME"];
person.Event1ID = (int)reader["STAGE1ID"];
persons.Add(person);
}
response.Success = true;
response.Message = "Dados selecionados com sucesso.";
response.Data = persons;
return(response);
}
catch (Exception ex)
{
response.Success = false;
response.Message = "Erro no banco de dados contate o administrador.";
response.ExeptionMessage = ex.Message;
response.StackTrace = ex.StackTrace;
return(response);
}
finally
{
connection.Close();
}
} //test
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (cboxFilter.Text == "Treinamento")
{
//chamar método para pegar o ID da sala: id
SpaceTraining space = new SpaceTraining();
space.Name = dataGridView1.Rows[e.RowIndex].Cells["Nome"].Value.ToString();
space.MaxCapacity = int.Parse(dataGridView1.Rows[e.RowIndex].Cells["LotaçãoMáxima"].Value.ToString());
SpaceTrainingBLL spaceBLL = new SpaceTrainingBLL();
SingleResponse <SpaceTraining> r = spaceBLL.Get(space);
SpaceTraining newSpace = r.Data;
//chamar método para apresentar participantes da etapa 1 e 2
PersonBLL personBLL = new PersonBLL();
TableResponse r1 = personBLL.GetAllByStage1ID(newSpace);
TableResponse r2 = personBLL.GetAllByStage2ID(newSpace);
//list1:
listBoxStage1.DataSource = null;
listBoxStage1.DataSource = r1.DataTable;
listBoxStage1.DisplayMember = "Nome";
//list2:
listBoxStage2.DataSource = null;
listBoxStage2.DataSource = r2.DataTable;
listBoxStage2.DisplayMember = "Nome";
lblTitle.Text = "Mostrando participantes da sala de treinamento: " + space.Name;
}
else
{
//chamar método para pegar o ID do espaço de café: id
SpaceCoffee space = new SpaceCoffee();
space.Name = dataGridView1.Rows[e.RowIndex].Cells["Nome"].Value.ToString();
SpaceCoffeeBLL spaceBLL = new SpaceCoffeeBLL();
SingleResponse <SpaceCoffee> r = spaceBLL.Get(space);
SpaceCoffee newSpace = r.Data;
//chamar método para apresentar participantes do intervalo para café
PersonBLL personBLL = new PersonBLL();
TableResponse r1 = personBLL.GetAllByCoffeeID(newSpace);
//list1: select * from persons where coffeeid1 = id
listBoxStage1.DataSource = null;
listBoxStage1.DataSource = r1.DataTable;
listBoxStage1.DisplayMember = "Nome";
lblTitle.Text = "Mostrando participantes do espaço para café: " + space.Name;
}
}
} //test
public QueryResponse <SpaceTraining> GetSpaceWithEmptySeat(int personsPerRoom)
{
QueryResponse <SpaceTraining> response = new QueryResponse <SpaceTraining>();
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConnectionHelper.GetConnectionString();
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT * FROM SPACETRAINING WHERE MAXCAPACITY > @VALUE";
command.Parameters.AddWithValue("@VALUE", personsPerRoom);
command.Parameters.AddWithValue("@TYPE", 0);
command.Connection = connection;
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <SpaceTraining> spaces = new List <SpaceTraining>();
while (reader.Read())
{
SpaceTraining space = new SpaceTraining();
space.ID = (int)reader["ID"];
space.Name = (string)reader["NAME"];
space.MaxCapacity = (int)reader["MAXCAPACITY"];
spaces.Add(space);
}
response.Success = true;
response.Message = "Dados selecionados com sucesso.";
response.Data = spaces;
return(response);
}
catch (Exception ex)
{
response.Success = false;
response.Message = "Erro no banco de dados contate o administrador.";
response.ExeptionMessage = ex.Message;
response.StackTrace = ex.StackTrace;
return(response);
}
finally
{
connection.Close();
}
} //test
public void TestGetSmallerSpace()
{
SpaceTraining space1 = new SpaceTraining();
space1.Name = "Sala um";
space1.MaxCapacity = 6;
spaceTBLL.Insert(space1);
SpaceTraining space2 = new SpaceTraining();
space2.Name = "Sala dois";
space2.MaxCapacity = 6;
spaceTBLL.Insert(space2);
SingleResponse <SpaceTraining> response = spaceTBLL.GetSmallerSpace();
Assert.AreEqual(true, response.Success);
}
} //test
public SingleResponse <SpaceTraining> Get(SpaceTraining _space)
{
SingleResponse <SpaceTraining> response = new SingleResponse <SpaceTraining>();
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConnectionHelper.GetConnectionString();
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT * FROM SPACETRAINING WHERE NAME LIKE @NAME AND MAXCAPACITY LIKE @MAXCAPACITY";
command.Parameters.AddWithValue("@NAME", _space.Name);
command.Parameters.AddWithValue("@MAXCAPACITY", _space.MaxCapacity);
command.Connection = connection;
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
SpaceTraining space = new SpaceTraining();
reader.Read();
space.ID = (int)reader["ID"];
space.Name = (string)reader["NAME"];
space.MaxCapacity = (int)reader["MAXCAPACITY"];
response.Success = true;
response.Message = "Dados selecionados com sucesso.";
response.Data = space;
return(response);
}
catch (Exception ex)
{
response.Success = false;
response.Message = "Erro no banco de dados, contate o administrador.";
response.ExeptionMessage = ex.Message;
response.StackTrace = ex.StackTrace;
return(response);
}
finally
{
connection.Close();
}
} //test
private void btnSearch_Click(object sender, EventArgs e)
{
listBoxStage1.DataSource = null;
listBoxStage2.DataSource = null;
if (cboxFilter.Text == "Treinamento")
{
SpaceTraining space = new SpaceTraining();
space.Name = txtSearch.Text;
SpaceTrainingBLL spaceBLL = new SpaceTrainingBLL();
TableResponse r = spaceBLL.GetByName(space);
dataGridView1.DataSource = r.DataTable;
}
else
{
SpaceCoffee space = new SpaceCoffee();
space.Name = txtSearch.Text;
SpaceCoffeeBLL spaceBLL = new SpaceCoffeeBLL();
TableResponse r = spaceBLL.GetByName(space);
dataGridView1.DataSource = r.DataTable;
}
txtSearch.Clear();
}
} //test
public TableResponse GetByName(SpaceTraining _space)
{
TableResponse tableResponse = new TableResponse();
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConnectionHelper.GetConnectionString();
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT NAME as Nome, MAXCAPACITY as LotaçãoMáxima FROM SPACETRAINING WHERE NAME LIKE @NAME";
command.Parameters.AddWithValue("@NAME", "%" + _space.Name + "%");
command.Connection = connection;
try
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable data = new DataTable();
adapter.Fill(data);
tableResponse.Success = true;
tableResponse.Message = "Dados selecionados com sucesso.";
tableResponse.DataTable = data;
return(tableResponse);
}
catch (Exception ex)
{
tableResponse.Success = false;
tableResponse.Message = "Erro no banco de dados, contate o administrador.";
tableResponse.ExeptionMessage = ex.Message;
tableResponse.StackTrace = ex.StackTrace;
return(tableResponse);
}
finally
{
connection.Close();
}
} //test
} //test
public TableResponse GetAllByStage2ID(SpaceTraining _space)
{
TableResponse tableResponse = new TableResponse();
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConnectionHelper.GetConnectionString();
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT FULLNAME as Nome FROM PERSONS WHERE STAGE2ID LIKE @STAGE2ID";
command.Parameters.AddWithValue("@STAGE2ID", _space.ID);
command.Connection = connection;
try
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable data = new DataTable();
adapter.Fill(data);
tableResponse.Success = true;
tableResponse.Message = "Dados selecionados com sucesso.";
tableResponse.DataTable = data;
return(tableResponse);
}
catch (Exception ex)
{
tableResponse.Success = false;
tableResponse.Message = "Erro no banco de dados, contate o administrador.";
tableResponse.ExeptionMessage = ex.Message;
tableResponse.StackTrace = ex.StackTrace;
return(tableResponse);
}
finally
{
connection.Close();
}
} //test
} //test
public Response UpdateMaxCapacity(SpaceTraining _space)
{
Response response = new Response();
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConnectionHelper.GetConnectionString();
SqlCommand command = new SqlCommand();
command.CommandText = "UPDATE SPACETRAINING SET MAXCAPACITY = @MAXCAPACITY WHERE ID LIKE @ID";
command.Parameters.AddWithValue("@MAXCAPACITY", _space.MaxCapacity);
command.Parameters.AddWithValue("@ID", _space.ID);
command.Connection = connection;
try
{
connection.Open();
command.ExecuteNonQuery();
response.Success = true;
response.Message = "O registro foi alterado com sucesso.";
}
catch (Exception ex)
{
response.Success = false;
response.Message = "Erro no banco de dados, contate o administrador.";
response.StackTrace = ex.StackTrace;
response.ExeptionMessage = ex.Message;
}
finally
{
connection.Close();
}
return(response);
} //test
private void btnInsert_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtName.Text) || string.IsNullOrWhiteSpace(txtMaxCapacity.Text))
{
MessageBox.Show("Preencha todos os campos.");
txtName.Clear();
txtMaxCapacity.Clear();
txtName.Focus();
}
else
{
SpaceTraining space = new SpaceTraining();
space.Name = txtName.Text;
space.MaxCapacity = Convert.ToInt32(txtMaxCapacity.Text);
SpaceTrainingBLL spaceBLL = new SpaceTrainingBLL();
spaceBLL.Insert(space);
SingleResponse <Operator> r0 = spaceBLL.CheckHowToCreate(space);
if (r0.Success)
{
Operator op = r0.Data;
if (op.IsAllFull)
{
int totalSpaces = op.TotalSpaceFull - 1;
int maxCapacity = op.PersonsPerFullRoom;
if (MessageBox.Show(lblTitle.Text = "Serão cadastradas " + op.TotalSpaceFull + " salas.\n\nCada sala terá uma capacidade para " + op.PersonsPerFullRoom + " pessoas.\n\nSe deseja prosseguir clique em sim, mas se deseja informar outra sala para melhorar a distribuição, clique em não.", "ATENÇÂO", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//chamar a tela de cadastro das salas restantes, conforme totalSpaces
for (int i = 1; i <= totalSpaces; i++)
{
frmNewSpaceTraining2 f = new frmNewSpaceTraining2(maxCapacity);
f.ShowDialog();
}
MessageBox.Show("Salas cadastradas com sucesso, siga para o próximo passo.");
this.Close();
}
else
{
spaceBLL.DeleteAll();
txtName.Clear();
txtMaxCapacity.Clear();
txtName.Focus();
return;
}
}
else
{
if (MessageBox.Show(lblTitle.Text = "Haverá um total de " + (op.TotalSpaceFull + op.TotalSpaceNotFull) + " salas.\n\n" + op.TotalSpaceFull + " salas com capacidade para " + op.PersonsPerFullRoom + " pessoas.\n\n" + op.TotalSpaceNotFull + " salas com capacidade para " + op.PersonsPerNotFullRoom + " pessoas.\n\nSe deseja prosseguir clique em sim, mas se deseja informar outra sala para melhorar a distribuição, clique em não", "ATENÇÂO", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int totalSpaceFull = op.TotalSpaceFull;
int maxCapacityFull = op.PersonsPerFullRoom;
//chamar a tela de cadastro das salas cheias
for (int i = 1; i < totalSpaceFull; i++)
{
frmNewSpaceTraining2 f = new frmNewSpaceTraining2(maxCapacityFull);
f.ShowDialog();
}
int totalSpaceNotFull = op.TotalSpaceNotFull;
int maxCapacityNotFull = op.PersonsPerNotFullRoom;
//chamar a tela de cadastro das salas não cheias
for (int i = 1; i <= totalSpaceNotFull; i++)
{
frmNewSpaceTraining2 f = new frmNewSpaceTraining2(maxCapacityNotFull);
f.ShowDialog();
}
MessageBox.Show("Salas cadastradas com sucesso, siga para o próximo passo.");
this.Close();
}
else
{
spaceBLL.DeleteAll();
txtName.Clear();
txtMaxCapacity.Clear();
txtName.Focus();
return;
}
}
}
else
{
MessageBox.Show("Erro, contate o administrador.");
}
}
}
public QueryResponse <Person> GetPeopleByStage1ID(SpaceTraining _space)
{
QueryResponse <Person> response = personDAL.GetPeopleByStage1ID(_space);
return(response);
}
public void TestOrganizeSecondStage()
{
Person p1 = new Person();
p1.Name = "Pessoa";
p1.Surname = "Ummm";
personBLL.Insert(p1);
Person p2 = new Person();
p2.Name = "Pessoa";
p2.Surname = "Doiss";
personBLL.Insert(p2);
Person p3 = new Person();
p3.Name = "Pessoa";
p3.Surname = "Trêss";
personBLL.Insert(p3);
Person p4 = new Person();
p4.Name = "Pessoa";
p4.Surname = "Quatro";
personBLL.Insert(p4);
Person p5 = new Person();
p5.Name = "Pessoa";
p5.Surname = "Cinco";
personBLL.Insert(p5);
Person p6 = new Person();
p6.Name = "Pessoa";
p6.Surname = "Seis";
personBLL.Insert(p6);
Person p7 = new Person();
p7.Name = "Pessoa";
p7.Surname = "Sete";
personBLL.Insert(p7);
Person p8 = new Person();
p8.Name = "Pessoa";
p8.Surname = "Oito";
personBLL.Insert(p8);
Person p9 = new Person();
p9.Name = "Pessoa";
p9.Surname = "Nove";
personBLL.Insert(p9);
Person p10 = new Person();
p10.Name = "Pessoa";
p10.Surname = "Dezz";
personBLL.Insert(p10);
Person p11 = new Person();
p11.Name = "Pessoa";
p11.Surname = "Onze";
personBLL.Insert(p11);
Person p12 = new Person();
p12.Name = "Pessoa";
p12.Surname = "Doze";
personBLL.Insert(p12);
Person p13 = new Person();
p13.Name = "Pessoa";
p13.Surname = "Treze";
personBLL.Insert(p13);
Person p14 = new Person();
p14.Name = "Pessoa";
p14.Surname = "Quatorze";
personBLL.Insert(p14);
Person p15 = new Person();
p15.Name = "Pessoa";
p15.Surname = "Quinze";
personBLL.Insert(p15);
Person p16 = new Person();
p16.Name = "Pessoa";
p16.Surname = "Dezesseis";
personBLL.Insert(p16);
Person p17 = new Person();
p17.Name = "Pessoa";
p17.Surname = "Dezesete";
personBLL.Insert(p17);
Person p18 = new Person();
p18.Name = "Pessoa";
p18.Surname = "Dezoito";
personBLL.Insert(p18);
SpaceTrainingBLL spaceBLL = new SpaceTrainingBLL();
SpaceTraining spaceT1 = new SpaceTraining();
spaceT1.Name = "Sala Um";
spaceT1.MaxCapacity = 6;
spaceBLL.Insert(spaceT1);
SpaceTraining spaceT2 = new SpaceTraining();
spaceT2.Name = "Sala Dois";
spaceT2.MaxCapacity = 6;
spaceBLL.Insert(spaceT2);
SpaceTraining spaceT3 = new SpaceTraining();
spaceT3.Name = "Sala Três";
spaceT3.MaxCapacity = 6;
spaceBLL.Insert(spaceT3);
personBLL.OrganizeFirstStage();
Response response = personBLL.OrganizeSecondStage();
Assert.AreEqual(true, response.Success);
}
public TableResponse GetAllByStage2ID(SpaceTraining _space)
{
TableResponse response = personDAL.GetAllByStage2ID(_space);
return(response);
}
public Response UpdateStage2ID(SpaceTraining _space, Person _person)
{
Response response = personDAL.UpdateStage2ID(_space, _person);
return(response);
}
