public FixedBug getFixedBugByID(int id) { String sql = "SELECT code,fixed_code FROM tbl_bug AS b,tbl_fixed_bug AS f WHERE f.bug_id=b.id AND f.id=@id"; try { conn.Open(); MySqlCommand sqlCommand = new MySqlCommand(sql, conn); sqlCommand.Parameters.AddWithValue("@id", id); MySqlDataReader result = sqlCommand.ExecuteReader(); while (result.Read()) { fixedBug = new FixedBug(); fixedBug.CodeBlock = result.GetString(result.GetOrdinal("code")); fixedBug.FixedCode = result.GetString(result.GetOrdinal("fixed_code")); return(fixedBug); // project.Id = result.GetInt32(result.GetOrdinal("id")); } } catch (Exception e) { MessageBox.Show(" project bug" + e.Message); } return(null); }
public bool insertFixedBug(FixedBug fixedBug) { this.fixedBug = fixedBug; String sql = "INSERT INTO tbl_fixed_bug (bug_id,fixed_code,fixed_by,fixed_date) VALUES(@bug_id,@fixed_code,@fixed_by,@fixed_date)"; try { conn.Open(); MySqlCommand sqlCommand = new MySqlCommand(sql, conn); sqlCommand.Parameters.AddWithValue("@bug_id", fixedBug.Bug_id); sqlCommand.Parameters.AddWithValue("@fixed_code", fixedBug.FixedCode); sqlCommand.Parameters.AddWithValue("@fixed_by", fixedBug.BugFixedBy); sqlCommand.Parameters.AddWithValue("@fixed_date", fixedBug.FixedDate); int rowUpdate = sqlCommand.ExecuteNonQuery();//non query is for such query which is not responsible for fetching data from database. bool statusUpdated = updateBugStatus(fixedBug.Bug_id); conn.Close(); if (rowUpdate > 0 && statusUpdated == true) { conn.Close(); return(true); } else { conn.Close(); return(false); } } catch (Exception e) { } return(false); }
public FixedBug getFixedBugById(int id) { BugDao daobug = new BugDao(); try { fixedBug = daobug.getFixedBugByID(id); return(fixedBug); } catch (Exception e) { } return(null); }
public bool InsertFixedBug(int bugID, String fixedCode, String fixedBy, DateTime fixedDate) { BugDao daoBug = new BugDao(); fixedBug = new FixedBug(); fixedBug.Bug_id = bugID; fixedBug.FixedCode = fixedCode; fixedBug.BugFixedBy = fixedBy; fixedBug.FixedDate = fixedDate; bool status = daoBug.insertFixedBug(fixedBug); if (status == true) { return(true); } else { return(false); } }
public List <FixedBug> getAllFixedBug() { String sql = "SELECT f.id,f.Fixed_by,f.fixed_date,b.name FROM tbl_fixed_bug AS f,tbl_bug AS b WHERE f.bug_id=b.id"; try { conn.Open(); List <FixedBug> allFixedBug = new List <FixedBug>(); MySqlCommand sqlCommand = new MySqlCommand(sql, conn); MySqlDataReader result = sqlCommand.ExecuteReader(); while (result.Read()) { fixedBug = new FixedBug(); fixedBug.FixedBugId = result.GetInt32(result.GetOrdinal("id")); fixedBug.BugName = result.GetString(result.GetOrdinal("name")); fixedBug.BugFixedBy = result.GetString(result.GetOrdinal("Fixed_by")); fixedBug.FixedDate = result.GetDateTime(result.GetOrdinal("fixed_date")); allFixedBug.Add(fixedBug); // project.Id = result.GetInt32(result.GetOrdinal("id")); } return(allFixedBug); } catch (Exception e) { MessageBox.Show(" project bug" + e.Message); } return(null); }
private void btnViewFixedBug_Click(object sender, EventArgs e) { Int32 selectedRowCount = dataGridView1.Rows.GetRowCount(DataGridViewElementStates.Selected); if (selectedRowCount > 0) { DataGridViewRow rowIndex = dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex]; // FormFixBug fixBug = new FormFixBug(Convert.ToInt32(rowIndex.Cells["bug_id"].Value), user); /// fixBug.Show(); bugController = new BugController(); fixedBug = bugController.getFixedBugById((Convert.ToInt32(rowIndex.Cells["fixed ID"].Value))); FormViewFixedBug viewFixedBug = new FormViewFixedBug(fixedBug); viewFixedBug.Show(); // label1.Text = "" + myDataGrid.CurrentCell.RowIndex + Convert.ToString(rowIndex.Cells["bug_id"].Value); } else { MessageBox.Show("Select a row to fix bug"); } }
public FormViewFixedBug(FixedBug fixedBug) { this.fixedBug = fixedBug; InitializeComponent(); }
private void button_bughis_Click(object sender, EventArgs e) { FixedBug fix = new FixedBug(); fix.Show(); }