/// <summary> /// Get History for Audit /// </summary> /// <param name="bug"></param> public bool setHistory(BugModel bug) { bool flag = false; try { String sql = "INSERT INTO `tbl_history`( `bug_id`,`version`, `updatedate`, `updatedby`, `code`, `status`, `remarks`) " + "VALUES (@bug_id,@version,@updatedate,@updatedby,@code,@status,@remarks)"; MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Parameters.AddWithValue("@bug_id", bug.getBUGID()); cmd.Parameters.AddWithValue("@version", bug.getVersion()); cmd.Parameters.AddWithValue("@updatedate", DateTime.Now.ToString("yyyy-MM-dd H:mm:ss")); cmd.Parameters.AddWithValue("@updatedby", bug.getUsername()); cmd.Parameters.AddWithValue("@code", bug.getCode()); cmd.Parameters.AddWithValue("@status", bug.getStatus()); cmd.Parameters.AddWithValue("@remarks", bug.getRemarks()); Debug.WriteLine("setHistory Called"); cmd.Connection = conn; cmd.CommandText = sql; int rowCount = cmd.ExecuteNonQuery(); if (rowCount > 0) { flag = true; } else { flag = false; } } catch (Exception e) { Debug.WriteLine("Error Message: " + e); Debug.WriteLine(e.StackTrace); } return(flag); }