public int deleteRetroType(RetroType retroType) { int ret = -1; using (var conn = new MySqlConnection("server=" + ip + ";database=SSG_POD;userid=" + username + ";password="******";")) using (var command = conn.CreateCommand()) { command.CommandText = "DELETE FROM Retrospective_Type " + "WHERE ID = @id;"; conn.Open(); command.Parameters.AddWithValue("@id", retroType.id); try { ret = command.ExecuteNonQuery(); } catch (InvalidOperationException) { ret = -1; } conn.Close(); } return(ret); }
private void retroTypeRenameBtn_Click(object sender, EventArgs e) { if (retroTypeLB.SelectedItem != null) { RetroType selRetroType = (RetroType)retroTypeLB.SelectedItem; selRetroType.title = retroTypeNameTB.Text; selRetroType.code = retroTypeCodeTB.Text; if (!(tableData.updateRetroType(selRetroType) > 0)) { errorDynLabel.Text = "Error saving Retrospective Type"; } } else { // adding a new retrospective type RetroType retroType = new RetroType(); retroType.code = retroTypeCodeTB.Text; retroType.title = retroTypeNameTB.Text; if ((tableData.addRetroType(retroType) == null)) { errorDynLabel.Text = "Error saving Retrospective Type"; } else { loadRetroTypes(); retroTypeCodeTB.Enabled = false; } } }
//TODO - convert to Using public int insertRetroType(RetroType retroType) { int ret = 0; MySqlCommand command = conn2.CreateCommand(); conn2.Open(); command.CommandText = "INSERT INTO Retrospective_Type " + "VALUES (@id, @title, @code);"; command.Parameters.AddWithValue("@id", retroType.id); command.Parameters.AddWithValue("@title", retroType.title); command.Parameters.AddWithValue("@code", retroType.code); try { ret = command.ExecuteNonQuery(); } catch (InvalidOperationException) { ret = -1; } conn2.Close(); return(ret); }
public ArrayList getAllRetroTypes() { RetroType retroType; ArrayList retroTypes = new ArrayList(); using (var conn = new MySqlConnection("server=" + ip + ";database=SSG_POD;userid=" + username + ";password="******";")) using (var command = conn.CreateCommand()) { command.CommandText = "SELECT * from Retrospective_Type;"; conn.Open(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { retroType = new RetroType(); retroType.id = int.Parse(reader[0].ToString()); retroType.title = reader[1].ToString(); retroType.code = reader[2].ToString(); retroTypes.Add(retroType); } } } return(retroTypes); }
public int removeRetroType(RetroType retroType) { int ret = query.deleteRetroType(retroType); if (ret > 0) { retroTypes.Remove(retroType); } return(ret); }
public RetroType addRetroType(RetroType retroType) { retroType.id = getNextRetroTypeId(); int ret = query.insertRetroType(retroType); if (ret > 0) { retroTypes.Add(retroType); return(retroType); } return(null); }
public int updateRetroType(RetroType updRetroType) { int ret = query.updateRetroType(updRetroType); if (ret > 0) { for (int i = 0; i < retroTypes.Count; i++) { if (((RetroType)retroTypes[i]).id == updRetroType.id) { retroTypes[i] = updRetroType; } } } return(ret); }
private void retroTypeRemBtn_Click(object sender, EventArgs e) { if (((RetroType)retroTypeLB.SelectedItem).id == 0) { errorDynLabel.Text = "Cannot delete type uncategorized"; } else if (retroTypeLB.SelectedItem != null && !(retroTypesAssignLB.Items.Count > 0)) { RetroType remRetroType = (RetroType)retroTypeLB.SelectedItem; if (tableData.removeRetroType(remRetroType) > 0) { loadRetroTypes(); retroTypeNameTB.Text = ""; retroTypeCodeTB.Text = ""; } } else { errorDynLabel.Text = "Cannot remove type with retrospectives still assigned to it."; } }