/// <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);
}
public bool addProjectComponent(BugModel bug)
{
bool flag = false;
try
{
String sql = "INSERT INTO `tbl_component`( `component_name`, `component_desc`, `project_id`, `developerusername`) VALUES (@component_name,@component_desc,@project_id,@developerusername)";
MySqlConnection conn = DBUtils.GetDBConnection();
conn.Open();
MySqlCommand cmd = new MySqlCommand();
Debug.WriteLine("addprojectcomponent Called");
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@component_name", bug.getComponentName());
cmd.Parameters.AddWithValue("@component_desc", bug.getcomponentdesc());
cmd.Parameters.AddWithValue("@project_id", bug.getprojectid());
cmd.Parameters.AddWithValue("@developerusername", bug.getUsername());
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);
}