public void Insert(BuiltOn builtOn)
{
if (!Exists(builtOn.ProjectId))
{
string query =
"INSERT INTO builtOn (ProjectId, TaskId)" +
" VALUES(@projectid, @taskid);";
List <MySqlParameter> parameters = new List <MySqlParameter>
{
new MySqlParameter("projectid", MySqlDbType.VarChar)
{
Value = builtOn.ProjectId
},
new MySqlParameter("taskid", MySqlDbType.VarChar)
{
Value = builtOn.TaskId
},
};
if (functions.ExecuteNonQuery(query, parameters))
{
Debug.WriteLine("InsertBuiltOn: The builtOn was added successfully.");
}
else
{
Debug.WriteLine("InsertBuiltOn: An error has occured.");
}
}
}
public void Delete(BuiltOn builtOn)
{
if (Exists(builtOn.ProjectId))
{
string query = "DELETE FROM builtOn WHERE ProjectId = @projectid;";
List <MySqlParameter> parameters = new List <MySqlParameter>
{
new MySqlParameter("projectid", MySqlDbType.VarChar)
{
Value = builtOn.ProjectId
}
};
if (functions.ExecuteNonQuery(query, parameters))
{
Debug.WriteLine("DeleteBuiltOn: The builtOn was deleted successfully.");
}
else
{
Debug.WriteLine("DeleteBuiltOn: An error has occured.");
}
}
else
{
Debug.WriteLine("DeleteBuiltOn: Cannot delete builtOn");
}
}
public BuiltOn Get(string projectid)
{
if (Exists(projectid))
{
string query =
"SELECT ProjectId, TaskId " +
"FROM builtOn WHERE(ProjectId = @projectid)";
List <MySqlParameter> parameters = new List <MySqlParameter>
{
new MySqlParameter("projectid", MySqlDbType.VarChar)
{
Value = projectid
}
};
if (functions.ExecuteReader(query, parameters, out DataTable dataTable))
{
DataRow row = dataTable.Rows[0];
BuiltOn builtOn = new BuiltOn
{
ProjectId = row["projectid"].ToString(),
TaskId = row["taskid"].ToString(),
};
return(builtOn);
}
else
{
Debug.WriteLine("GetBuiltOn: An error has occured while trying to get builtOn.");
return(null);
}
}
else
{
return(null);
}
}