protected void Map(IDataRecord record, ResearchAreaSurvey survey)
{
survey.SurveyId = (int)record["kysely_id"];
survey.ResearchAreaId = (int)record["tutkimusalue_id"];
survey.StartDate = DateTime.Parse(record["alkupvm"].ToString());
survey.EndDate = DateTime.Parse(record["loppupvm"].ToString());
survey.Name = record["nimi"].ToString() + " (" + survey.StartDate.ToString("dd.MM.yyyy") +
" - " + survey.EndDate.ToString("dd.MM.yyyy") + ")";
}
public void RemoveFromResearchArea(ResearchAreaSurvey rsa)
{
using (MySqlCommand cmd = Connection.CreateCommand()) {
cmd.CommandText = "DELETE FROM tutkimusalue_kyselyt WHERE kysely_id = @surveyId AND tutkimusalue_id = @researchAreaId";
cmd.Parameters.AddWithValue("surveyId", rsa.SurveyId);
cmd.Parameters.AddWithValue("researchAreaId", rsa.ResearchAreaId);
cmd.ExecuteNonQuery();
}
}
private void btnDeleteSurveyFromResearchArea_Click(object sender, EventArgs e)
{
if (lbvResearchAreaSurveys.SelectedItem != null && cboResearchArea.SelectedItem != null)
{
ResearchAreaSurvey rsa = lbvResearchAreaSurveys.SelectedItem as ResearchAreaSurvey;
ResearchArea ra = cboResearchArea.SelectedItem as ResearchArea;
if (lbvSurveys.SelectedItem != null)
{
DialogResult dr = MessageBox.Show("Kyselyn yhteys tutkimusalueeseen poistetaan, eikä siihen voi enää vastata." +
" Jos haluat säilyttää kyselyyn liittyvät vastaukset, tuo ne exceliin ennen poistoa.\n\nHaluatko jatkaa?",
"Huomio", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
sRepository.RemoveFromResearchArea(rsa);
lbvResearchAreaSurveys.DataSource = sRepository.GetResearchAreaSurveys(ra);
}
}
}
}
public IEnumerable <ResearchAreaSurvey> GetResearchAreaSurveys(ResearchArea rs)
{
using (MySqlCommand cmd = Connection.CreateCommand()) {
cmd.CommandText = "SELECT tk.kysely_id, tk.tutkimusalue_id, tk.alkupvm, tk.loppupvm, k.nimi " +
"FROM tutkimusalue_kyselyt tk INNER JOIN kyselyt k ON k.id = tk.kysely_id WHERE tk.tutkimusalue_id = @id";
cmd.Parameters.AddWithValue("id", rs.Id);
using (MySqlDataReader reader = cmd.ExecuteReader()) {
List <ResearchAreaSurvey> items = new List <ResearchAreaSurvey>();
while (reader.Read())
{
ResearchAreaSurvey item = new ResearchAreaSurvey();
Map(reader, item);
items.Add(item);
}
return(items);
}
}
}
