public bool AddStudioManager(StudioManager sm) { bool result = false; query = "INSERT INTO game (game_title, slot_type, upd_n, platform, local_producer, hq_prod, local_deadline, ios_deadline) VALUES('" + sm.m_GameTitle + "','" + sm.m_ProjectType + "','" + sm.m_EvolutionUpdate + "','" + sm.m_PlatformType + "','" + sm.m_LocalProducer + "','" + sm.m_HqProducer + "','" + sm.m_LocalDeadline + "','" + sm.m_IosDeadline + "')"; try { connect.Open(); cmd = new MySqlCommand(query, connect); cmd.ExecuteNonQuery(); result = true; } catch (MySqlException ex) { MessageBox.Show(ex.Message.ToString()); result = false; } finally { connect.Close(); } return result; }
public bool AddResourceAllocation(StudioManager sm) { bool result = false; query = "INSERT INTO resources (prod_id, prg_alloc, qa_alloc, gd_alloc, gfx_alloc) VALUES('" + sm.m_ProdId + "'," + sm.m_PrgAlloc + "," + sm.m_QaAlloc + "," + sm.m_GdAlloc + "," + sm.m_GfxAlloc + ")"; try { connect.Open(); cmd = new MySqlCommand(query, connect); cmd.ExecuteNonQuery(); result = true; } catch (MySqlException ex) { MessageBox.Show(ex.Message.ToString()); result = false; } finally { connect.Close(); } return result; }
private void btn_AddAlloc_Click(object sender, EventArgs e) { s_StudioManager = new StudioManager(cmb_Producer.SelectedValue.ToString(), int.Parse(txt_PrgAlloc.Text.ToString()), int.Parse(txt_QaAlloc.Text.ToString()), int.Parse(txt_GdAlloc.Text.ToString()), int.Parse(txt_GfxAlloc.Text.ToString())); if (s_SMManager.AddResourceAllocation(s_StudioManager)) { MessageBox.Show("Succesfully added", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearFieldRes(); } else { MessageBox.Show("Failed to add", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSMSubmit_Click(object sender, EventArgs e) { s_StudioManager = new StudioManager(txtSM_GameTitle.Text.ToString(), isClickProject(), isClickPlatform(), int.Parse(txtSM_EvolutionUpd.Text.ToString()), cmbSM_LocalProd.SelectedItem.ToString(), txtSM_HQProd.Text.ToString(), dtp_LocalDeadline.Text.ToString(), dtp_iOSDeadline.Text.ToString()); if (s_SMManager.AddStudioManager(s_StudioManager)) { MessageBox.Show("Succesfully added", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearField(); } else { MessageBox.Show("Failed to add", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); } }